This 2 tables are v$flashback_database_log and v$flashback_database_stat.
select * from v$flashback_database_log;
OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TI RETENTION_TARGET FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE
-------------------- ------------------- ---------------- -------------- ------------------------
1148024 2008-06-19 10:36:06 360 44138496 47831040
OLDEST_FLASHBACK_SCN 保留的最低系统改变号
OLDEST_FLASHBACK_TIME 最低系统改变号的时间
RETENTION_TARGET 闪回日志保留时间(单位:时间)
FLASHBACK_SIZE 当前闪回日志的大小(单位:字节)
ESTIMATED_FLASHBACK_SIZE 预估满足保留时间所需要的空间大小(单位:字节)
V$FLASHBACK_DATABASE_STAT
select begin_time,end_time,flashback_data,db_data,redo_data,estimated_flashback_size
from v$flashback_database_stat;
BEGIN_TIME END_TIME FLASHBACK_DATA DB_DATA REDO_DATA ESTIMATED_FLASHBACK_SIZE
------------------- ------------------- -------------- ---------- ---------- ------------------------
2008-06-19 13:44:10 2008-06-19 14:33:39 5046272 9199616 2281984 0
2008-06-19 12:36:26 2008-06-19 13:44:10 8347648 35160064 4133376 49655808
监控各间隔时间内的输出闪回日志
BEGIN_TIME 一个时间间隔的开始
END_TIME 一个时间间隔的结束
FLASHBACK_DATA 在此时间间隔内写闪回日志大小(单位:字节)
DB_DATA 在此时间间隔内数据库读写大小(单位:字节)
REDO_DATA 在此时间间隔内输出在线日志的大小(单位:字节)
ESTIMATED_FLASHBACK_SIZE 在时间间隔的结束时预估满足保留时间所需要的空间大小(单位:字节)
官方文档解释如下:
V$FLASHBACK_DATABASE_STAT displays statistics for monitoring the I/O overhead of logging flashback data. This view also displays the estimated flashback space needed based on previous workloads.
Column Datatype Description
BEGIN_TIME DATE Beginning of the time interval
END_TIME DATE End of the time interval
FLASHBACK_DATA NUMBER Number of bytes of flashback data written during the interval
DB_DATA NUMBER Number of bytes of database data read and written during the interval
REDO_DATA NUMBER Number of bytes of redo data written during the interval
ESTIMATED_FLASHBACK_SIZE NUMBER
Value of ESTIMATED_FLASHBACK_SIZE in V$FLASHBACK_DATABASE_LOG at the end of the time interval
select * from v$flashback_database_log;
OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TI RETENTION_TARGET FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE
-------------------- ------------------- ---------------- -------------- ------------------------
1148024 2008-06-19 10:36:06 360 44138496 47831040
OLDEST_FLASHBACK_SCN 保留的最低系统改变号
OLDEST_FLASHBACK_TIME 最低系统改变号的时间
RETENTION_TARGET 闪回日志保留时间(单位:时间)
FLASHBACK_SIZE 当前闪回日志的大小(单位:字节)
ESTIMATED_FLASHBACK_SIZE 预估满足保留时间所需要的空间大小(单位:字节)
V$FLASHBACK_DATABASE_STAT
select begin_time,end_time,flashback_data,db_data,redo_data,estimated_flashback_size
from v$flashback_database_stat;
BEGIN_TIME END_TIME FLASHBACK_DATA DB_DATA REDO_DATA ESTIMATED_FLASHBACK_SIZE
------------------- ------------------- -------------- ---------- ---------- ------------------------
2008-06-19 13:44:10 2008-06-19 14:33:39 5046272 9199616 2281984 0
2008-06-19 12:36:26 2008-06-19 13:44:10 8347648 35160064 4133376 49655808
监控各间隔时间内的输出闪回日志
BEGIN_TIME 一个时间间隔的开始
END_TIME 一个时间间隔的结束
FLASHBACK_DATA 在此时间间隔内写闪回日志大小(单位:字节)
DB_DATA 在此时间间隔内数据库读写大小(单位:字节)
REDO_DATA 在此时间间隔内输出在线日志的大小(单位:字节)
ESTIMATED_FLASHBACK_SIZE 在时间间隔的结束时预估满足保留时间所需要的空间大小(单位:字节)
官方文档解释如下:
V$FLASHBACK_DATABASE_STAT displays statistics for monitoring the I/O overhead of logging flashback data. This view also displays the estimated flashback space needed based on previous workloads.
Column Datatype Description
BEGIN_TIME DATE Beginning of the time interval
END_TIME DATE End of the time interval
FLASHBACK_DATA NUMBER Number of bytes of flashback data written during the interval
DB_DATA NUMBER Number of bytes of database data read and written during the interval
REDO_DATA NUMBER Number of bytes of redo data written during the interval
ESTIMATED_FLASHBACK_SIZE NUMBER
Value of ESTIMATED_FLASHBACK_SIZE in V$FLASHBACK_DATABASE_LOG at the end of the time interval
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/628922/viewspace-714928/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/628922/viewspace-714928/