The very handy DICT view

I want to check my FRA usage, but forgot the precise view name:

SQL> select * from v$flash_recovery_area;

select * from v$flash_recovery_area

             *

ERROR at line 1:

ORA-00942: table or view does not exist

So using the DICT view:

SQL> select table_name from dict where table_name like '%FLASH%';

TABLE_NAME

---------------------------------------------------------------------------------------------------------------

DBA_FLASHBACK_ARCHIVE

DBA_FLASHBACK_ARCHIVE_TABLES

DBA_FLASHBACK_ARCHIVE_TS

DBA_FLASHBACK_TXN_REPORT

DBA_FLASHBACK_TXN_STATE

USER_FLASHBACK_ARCHIVE

USER_FLASHBACK_ARCHIVE_TABLES

USER_FLASHBACK_TXN_REPORT

USER_FLASHBACK_TXN_STATE

V$FLASHBACK_DATABASE_LOG

V$FLASHBACK_DATABASE_LOGFILE

V$FLASHBACK_DATABASE_STAT

V$FLASHBACK_TXN_GRAPH

V$FLASHBACK_TXN_MODS

V$FLASHFILESTAT

V$FLASH_RECOVERY_AREA_USAGE

GV$FLASHBACK_DATABASE_LOG

GV$FLASHBACK_DATABASE_LOGFILE

GV$FLASHBACK_DATABASE_STAT

GV$FLASHFILESTAT

20 rows selected.

I can see the correct name is v$flash_recovery_area_usage:

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID

----------------------- ------------------ ------------------------- --------------- ----------

CONTROL FILE 0   0   0      0

REDO LOG      2.19   0   3      0

ARCHIVED LOG .2  .2   1      0

BACKUP PIECE     61.25       21.32   6      0

IMAGE COPY 0   0   0      0

FLASHBACK LOG 0   0   0      0

FOREIGN ARCHIVED LOG 0   0   0      0

AUXILIARY DATAFILE COPY 0   0   0      0

8 rows selected.

NB Which curiously in 12c has a 'Container ID', although this does seem to be set?