Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select object_id
from all_objects
where object_name = 'DBMS_STATS'
and owner = 'SYS';


OBJECT_ID


14813


select distinct object_id
from all_procedures
where object_name = 'DBMS_STATS'
and owner = 'SYS';


OBJECT_ID


14812


select distinct object_id
from all_arguments
where package_name = 'DBMS_STATS'
and owner = 'SYS';


OBJECT_ID


14812


select owner, object_name, object_type
from all_objects
where object_id in (
  select object_id
  from all_procedures
  where object_name = 'DBMS_STATS'
  and owner = 'SYS'
);


OWNER
OBJECT_NAME
OBJECT_TYPE


PUBLIC
XS$ROLE_GRANT_LIST
SYNONYM