Oracle Flashback Technologies - 估算不同時間段閃回日誌的產生量

標籤：app   tab   script   cell   ash   cin   add   idt   ima   

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                26849280023-JUN-15 23-JUN-15           8192     106496       1536                        0SQL>

 

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:   0: This value is used for rows   containing data that pertain to the entire CDB. This value is also used for   rows in non-CDBs.   1: This value is used for rows   containing data that pertain to only the root   n: Where n   is the applicable container ID for the rows containing data

Oracle Flashback Technologies - 估算不同時間段閃回日誌的產生量