view about redo&undo

关于redo&undo的几个动态性能视图......

select a.value
from v$mystat a, v$statname b
where a.statistic# = b.statistic#
and b.name = 'redo size';

V$ROLLSTAT

USN: Rollback segment number
RSSIZE: Current size of the rollback segment
XACTS: Number of active transactions

V$TRANSACTION

ADDR Address of the transaction state object
XIDUSN Undo segment number

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/45259/viewspace-134867/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/45259/viewspace-134867/