Thursday, June 21, 2007

Find out Rollback Segment with active transactions

Use this script to find out how many active transactions link with a rollback segment.

SELECT NAME, XACTS "ACTIVE TRANSACTIONS"
FROM V$ROLLNAME, V$ROLLSTAT
WHERE V$ROLLNAME.USN = V$ROLLSTAT.USN

No comments: