Oracle内部视图:x$targetrba
SQL> desc x$targetrba
Name
-----------------------------------------
ADDR N/A
INDX N/A
INST_ID N/A
TOTALLOGSZ select sum(bytes)/redo_standard_size from v$log
LGLOGSZ select bytes/512 from v$Log where status='CURRENT'
CUR_EST_RCV_READS Number of dirty buffers in the buffer cache.
In the Standard Edition, this column is always null.
ACTUAL_REDO_BLKS Current actual number of redo blocks required for recovery
TARGET_RBA_SEQ target redo block address log sequence
TARGET_RBA_BNO target redo block address block number
TARGET_RBA_BOF target redo block address offset
MIN_LAG Current target number of redo blocks that must be processed for recovery.
This value is the minimum value of the following 3 columns,
and identifies which of the 3 user-defined limits determines checkpointing.
LOGFILESZ Maximum number of redo blocks required to guarantee that a
log switch does not occur before the checkpoint completes.
CT_LAG Number of redo blocks that need to be processed during
recovery to satisfy the LOG_CHECKPOINT_TIMEOUT parameter.
The value displayed is not meaningful unless that parameter has been set.
CI_LAG Number of redo blocks that need to be processed during recovery to
satisfy the LOG_CHECKPOINT_INTERVAL parameter.
The value displayed is not meaningful unless that parameter has been set.
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,如需转载,请注明出处,否则将追究法律责任