Oracle Flashback Technologies - 估算不同时间段闪回日志的产生量
v$flashback_database_stat
监控闪回数据的i/o开销的统计信息，根据之前的系统负载估算闪回空间需求。时间间隔是一小时。
SQL> select * from v$flashback_database_stat order by begin_time; BEGIN_TIM END_TIME FLASHBACK_DATA DB_DATA REDO_DATA ESTIMATED_FLASHBACK_SIZE --------- --------- -------------- ---------- ---------- ------------------------ 23-JUN-15 23-JUN-15 5144576 26615808 1989120 268492800 23-JUN-15 23-JUN-15 8192 106496 1536 0 SQL>
v$flashback_database_stat说明
|
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 |
|
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
|
Oracle Flashback Technologies - 估算不同时间段闪回日志的产生量
原文：http://www.cnblogs.com/wangchaoyuana/p/7532005.html