Show usage of UNDO segment


select distinct a.USERNAME,
b.USED_UREC,
b.USED_UBLK,
c.sql_text,
b.START_TIME,
a.SID,
(select j.what
from dba_jobs_running jr, dba_jobs j
where jr.SID = a.sid
and jr.job = j.job) as job,
a.process,
a.program,
a.module,
a.machine,
SYSDATE AS AKTUAL_TIME
from v$sql c, v$session a, v$transaction b
where b.addr = a.taddr
and a.status = 'ACTIVE'
and a.sql_address = c.address(+)
and a.sql_hash_value = c.hash_value(+)
order by b.USED_UREC desc;

Leave a Reply

Your email address will not be published. Required fields are marked *