What is the
How can dba_flashback_view be used to monitor Oracle
Answer: The dba_flashback_archive
view contains the columns flashback_archive_name,
status to help the DBA
administer the flashback feature of Oracle.
For more details see my notes on
recall with flashback data archive.
Here is the query to show the
dba_flashback_archive describes all flashback
archives in the database and the status column of
dba_flashback_archive indicates whether the flashback archive
is a default archive for the database.
All DBA's will
enable a flashback_data_archive area that can then be seen by
Please note these limitations on using DDL with 11g
flashback data archive.
With a flashback data archive it is possible to view data as any
point in time since the flashback data archive was created.
However, attempting to view data as a timestamp before the data
archive is created causes the following
ORA-01466 flashback error:
ORA-01466: unable to read data -
table definition has changed
If you try to drop a flashback tablespace that is in-use you get
the ORA-55641 error:
SQL > alter flashback
flashback_archive_area_one archive remove tablespace
ORA-55641: Cannot drop
tablespace used by Flashback Data Archive
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.