Searching for X$ tables

You can query the names of X$ tables from X$KQFTA.

I was looking for the X$ tables related to Dynamic Remastering and found them from

SQL> select KQFTANAM from x$kqfta where KQFTANAM like 'X$KJDR%';

KQFTANAM
------------------------------
X$KJDRHV
X$KJDRPCMHV
X$KJDRPCMPF
X$KJDRMAFNSTATS
X$KJDRMHVSTATS
X$KJDRMREQ

6 rows selected.

Similary to look for dictionary tables I query from the public synonym DICT which is based on SYS.DICTIONARY.

For e.g
SQL> select table_name from dict where table_name like '%FILEST%';

TABLE_NAME
------------------------------
DBA_HIST_FILESTATXS
GV$FILESTAT
V$FILESTAT