Search notes:

Oracle: PL/Scope

Dictionary views

The identifiers and SQL statements that were gathered with PL/Scope can be queried from the 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

The init parameter plscope_setting.
Base tables whose name start with plscope.

Index