Finding session using UNDO tablespace
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;
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