select
  NAME,                                    -- NAME VARCHAR2(30)
  OBJECT_ID,                               -- OBJECT_ID NUMBER
  TYPE,                                    -- TYPE VARCHAR2(5)
  TABLE_NUM                                -- TABLE_NUM NUMBER
from
  GV$FIXED_TABLE
where
  inst_id = USERENV('Instance')