Finding session using UNDO tablespace

Himanshu funoracleapps , Oracle Database , scripts 1 comment

The below query can be used to find the session which is consuming more UNDO tablespace.

Query:

SELECT s.sid, s.serial#, s.username, s.program,
t.used_ublk, t.used_urec
FROM v$session s, v$transaction t
WHERE s.taddr = t.addr
ORDER BY 5 desc;

1 comment :

brittanymlemayNovember 8, 2015 at 12:08 PM
This is a real good blog post from you, my friend. I am extremely thrilled that you uploaded this wonderful post today. Please keep this going on! perniagaan internet
ReplyDelete
Replies