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.
Oracle内部视图:x$targetrba
原创
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
![](https://ucenter.51cto.com/images/noavatar_middle.gif)
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
如何在Odoo中利用SQL视图创建动态视图
odoo sql 视图
SQL 数据 菜单项 -
[转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP
[转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP
XKFFXP ide sed 映射关系 字段 -
内部视图:interval view x$kvii 介绍
内部视图x$kvii554078
Oracle sql 数据库 RAC ORA -
oracle 视图基础 - [ORACLE]
而补漏,不为晚矣;视图的概念视图是基...
Oracle 出版 SQL 数据结构 数据 -
oracle物化视图
一、oracle物化视图基本概念 物化视图首先需要创建物化视图日志, oracle依据用户创建的物化视图日志来创建物化视图日
oracle vector insert delete table