SELECT
  occupant_name,                           -- OCCUPANT_NAME VARCHAR2(64)
  occupant_desc,                           -- OCCUPANT_DESC VARCHAR2(64)
  schema_name,                             -- SCHEMA_NAME VARCHAR2(64)
  move_procedure,                          -- MOVE_PROCEDURE VARCHAR2(64)
  move_procedure_desc,                     -- MOVE_PROCEDURE_DESC VARCHAR2(64)
  space_usage_kbytes                       -- SPACE_USAGE_KBYTES NUMBER
FROM
  gv$sysaux_occupants
WHERE
  inst_id = USERENV('INSTANCE')