NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Finding session using UNDO tablespace

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 :

  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

    ReplyDelete