Query undo ts use

--Query undo ts use
SELECT TO_CHAR(s.sid) || ',' || TO_CHAR(s.serial#) AS sid_serial,
       NVL(s.username, '(oracle)') AS username,
       s.program,
       r.name undoseg,
       t.used_ublk * TO_NUMBER(x.value) / 1024 || 'K' AS undo
  FROM v$rollname r, v$session s, v$transaction t, v$parameter x
 WHERE s.taddr = t.addr
   AND r.usn = t.xidusn(+)
   AND x.name = 'db_block_size';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26390465/viewspace-1853397/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26390465/viewspace-1853397/