GV$SYSAUX_OCCUPANTS

SELECT
inst_id,                 -- INST_ID NUMBER
occ_name_kewxocf,        -- OCCUPANT_NAME VARCHAR2(64)
occ_desc_kewxocf,        -- OCCUPANT_DESC VARCHAR2(64)
sch_name_kewxocf,        -- SCHEMA_NAME VARCHAR2(64)
move_proc_kewxocf,       -- MOVE_PROCEDURE VARCHAR2(64)
move_desc_kewxocf,       -- MOVE_PROCEDURE_DESC VARCHAR2(64)
space_usage_kewxocf      -- SPACE_USAGE_KBYTES NUMBER
FROM
x$kewxocf
home |  up  |  mailbox