select
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  TYPE,                                    -- TYPE VARCHAR2(26)
  OBJECT_RECID,                            -- OBJECT_RECID NUMBER
  OBJECT_STAMP,                            -- OBJECT_STAMP NUMBER
  OBJECT_DATA,                             -- OBJECT_DATA NUMBER
  SET_STAMP,                               -- SET_STAMP NUMBER
  SET_COUNT                                -- SET_COUNT NUMBER
from
  GV$DELETED_OBJECT
where
  inst_id = USERENV('Instance')