GV$FIXED_TABLE

select
inst_id,                 -- INST_ID NUMBER
kqftanam,                -- NAME VARCHAR2(30)
kqftaobj,                -- OBJECT_ID NUMBER
'TABLE',                 -- TYPE VARCHAR2(5)
indx                     -- TABLE_NUM NUMBER
from
x$kqfta 
union all 
select
inst_id,                 -- INST_ID NUMBER
kqfvinam,                -- NAME VARCHAR2(30)
kqfviobj,                -- OBJECT_ID NUMBER
'VIEW',                  -- TYPE VARCHAR2(5)
65537                    -- TABLE_NUM NUMBER
from
x$kqfvi 
union all 
select
inst_id,                 -- INST_ID NUMBER
kqfdtnam,                -- NAME VARCHAR2(30)
kqfdtobj,                -- OBJECT_ID NUMBER
'TABLE',                 -- TYPE VARCHAR2(5)
65537                    -- TABLE_NUM NUMBER
from
x$kqfdt
home |  up  |  mailbox