How to Find x$ Table Name in Oracle Database

<<Back to DB Administration Main Page

How to list all x$ tables in oracle database

There are 2 ways to list down all the x$tables from oracle database.

SQL> select NAME from v$fixed_table where name like 'X$%'

OR 

SQL> select ADDR,KQFTANAM from  x$kqfta