Lookup v$ Views

It's often difficult to remember which v$ view contains information you might be after.

One way of quickly looking up the various views, is to run a query on the v$fixed_table view.

SQL> select name from v$fixed_table where name like '%FLASHBACK%';

NAME
------------------------------
GV$FLASHBACK_DATABASE_LOGFILE
V$FLASHBACK_DATABASE_LOGFILE
GV$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_LOG
GV$FLASHBACK_DATABASE_STAT
V$FLASHBACK_DATABASE_STAT
V$FLASHBACK_TXN_MODS
V$FLASHBACK_TXN_GRAPH

8 rows selected.