Oracle: PL/Scope

Dictionary views

Show used settings for PL/SQL objects

select
   owner,
   name,
   type,
   plscope_settings
from
   dba_plsql_object_settings
where
   owner in (select username from dba_users where oracle_maintained = 'N')
order by
   owner,
   name,
   type;

Space usage

select
   space_usage_kbytes
from
   v$sysaux_occupants
where
   occupant_name = 'PL/SCOPE'
order by
   occupant_name;  

See also