HOME > > Monitoring flashback Database (Part-3)

Monitoring flashback Database (Part-3)

Anup - Saturday, January 3, 2009
How to eastimating size of Flash Recovery Area for Flashback Logs?
SQL> SELECT ESTIMATED_FLASHBACK_SIZE FROM V$FLASHBACK_DATABASE_LOG;
This Query will return an estimate disk space (needed) for current flashback retation target.
This will be based on the database workload since Flashback Database was enabled.
How to determine earliest point in time to which can actually rewind your
database?
SQL>SELECT OLDEST_FLASHBACK_SCN,OLDEST_FLASHBACK_TIME FROM V$FLASHBACK_DATABASE_LOG;
Monitor logging in the Flashback Database logs?
SQL>select begin_time, flashback_data, db_data, redo_data, ESTIMATED_FLASHBACK_SIZE from v$flashback_database_stat;
Monitor the Flashback Database retention target?
select * from v$flashback_database_log;
Anonymous said...

Dear Sir,

I m planning to write oracle certification exam but confused to choose between 10g or 11g, please suggest me, which exam should i take...
i m also using certification dumps so please review the questions or provide me latest dumps...

1z0-054 dumps oracle database

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me