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