Oracle: V$SYSAUX_OCCUPANTS

select
   occupant_name,
   occupant_desc,
   schema_name,
   move_procedure,
   move_procedure_desc,
   space_usage_kbytes
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';