Oracle Backup & Recovery Techniques - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 328

How to check if Flashback Database feature is ON or OFF?
Use the V$Database dynamic performance view as shown
below.
SQL> SELECT flashback_on FROM V$Database;
How to Monitor Flashback Database?
Following dynamic performance views help us monitor the
Flashback Database.
V$Database, V$FLASHBACK_DATABASE_LOG,
V$FLASHBACK_DATABASE_STAT
You can also use the EM Database control to perform the
Flashback Database recovery. To do this first you make sure the
FLASH RECOVERY AREA is enabled and then use the
Perform Recovery link under the Maintenance tab.
Flashback Drop
Flash back drop helps you to restore the dropped table without
using tablespace point in time recovery as it was in the case of
Oracle 9i. In Oracle 10g, each tablespace has its own recycle bin
which holds the dropped tables. The following SQL statement is
used to restore the table from the recycle bin.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
You can also rename the tables within one statement by
following the following syntax.
SQL> FLASHBACK TABLE <object_name> TO BEFORE
DROP {RENAME TO <new_table_name>};