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.

Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *