|
Code Listing 2: Estimating recovery area required
SQL> alter session set nls_date_format = 'hh24:mi:ss';
Session altered.
SQL> select * from v$flashback_database_stat;
BEGIN_TI END_TIME FLASHBACK_DATA DB_DATA REDO_DATA ESTIMATED_FLASHBACK_SIZE
------- ------- -------------- ------- -------- ---------------------
03:52:49 04:52:53 2957312 8765440 5298688 7538005333
02:52:42 03:52:49 2818048 8314880 5074432 8692565333
01:52:41 02:52:42 2998272 9158656 5268480 1.0306E+10
00:52:35 01:52:41 81412096 126599168 186665472 1.2694E+10
23:52:34 00:52:35 104513536 181256192 215500288 1.2419E+10
22:52:30 23:52:34 113377280 196091904 246842880 1.0046E+10
21:46:15 22:52:30 13524992 22134784 18869248 2041344000
...
| 
Bookmark
