Search notes:

Oracle: V$SYSAUX_OCCUPANTS

v$sysaux_occupants shows the database components that occupy space in the SYSAUX tablespace.

select
   occupant_name,
   occupant_desc,
   schema_name,
   move_procedure
from
   v$sysaux_occupants
order by
   occupant_name;

select
   space_usage_kbytes / 1024 space_usage_mb
from
   v$sysaux_occupants
where
   occupant_name = 'PL/SCOPE';

See also