Oracle Technology Blog

OraTech Blog provides tips,tricks,scripts and how-to type answers for Oracle related technologies. I use these commands very often, so I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions.

Thursday, December 07, 2006

Rollback Monitoring

SELECT XIDUSN,USED_UREC FROM V$TRANSACTION
where addr=(select taddr from v$session where username='&uname');

select usn,RSSIZE,WRITES,STATUS from v$rollstat where usn=(select XIDUSN FROM V$TRANSACTION where addr=(select taddr from v$session where username='&uname'));

0 Comments:

Post a Comment

<< Home