Remote IT Support!! Please contact us

For Any Remote Support,Implementation/Upgrade Projects,Queries,Collaborations please mail us at

Finding session using UNDO tablespace

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


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 :

  1. 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