SQL>
SQL> SELECT owner, name, type, sharable_mem, kept
2 FROM v$db_object_cache
3 WHERE type like 'P%'
4 and rownum < 50
5 ORDER BY owner, name;
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
CTXSYS
DRIIXS
PACKAGE BODY 25153 NO
CTXSYS
DRIREC
PACKAGE 5517 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
CTXSYS
DRISPL
PACKAGE 5517 NO
CTXSYS
DRISPL
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
PACKAGE BODY 25153 NO
CTXSYS
DRIUTL
PACKAGE 5517 NO
CTXSYS
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
DRIXMD
PACKAGE BODY 85629 NO
RNTSOFT
ADJUST_SALARY
PROCEDURE 22980 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
RNTSOFT
CORE_PROCESS
PROCEDURE 2499 NO
RNTSOFT
DISPLAY_CUSTOMERS
PROCEDURE 1432 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
RNTSOFT
DO_QUERY
PROCEDURE 1423 NO
RNTSOFT
ERRORS
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
PACKAGE 9613 NO
RNTSOFT
ERROR_TEST1
PROCEDURE 14786 NO
RNTSOFT
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
HOCKEY_PASS
PROCEDURE 2498 NO
RNTSOFT
PROCESPRODUCTS
PROCEDURE 1429 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
RNTSOFT
SHOWVALS
PROCEDURE 2495 NO
RNTSOFT
SHOW_ORDERS
PROCEDURE 21906 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
RNTSOFT
TEST_EMPLOYEE_CURSORS
PROCEDURE 21916 NO
SYS
AW_DROP_PROC
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
PROCEDURE 13712 NO
SYS
DBMS_ADVISOR
PACKAGE 1424 NO
SYS
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
DBMS_ALERT
PACKAGE BODY 18914 NO
SYS
DBMS_APPLICATION_INFO
PACKAGE 17817 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
SYS
DBMS_DEFER_IMPORT_INTERNAL
PACKAGE 13726 NO
SYS
DBMS_HA_ALERTS_PRVT
PACKAGE 5527 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
SYS
DBMS_IREFRESH
PACKAGE BODY 25181 NO
SYS
DBMS_IREFRESH
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
PACKAGE 30097 NO
SYS
DBMS_LOB
PACKAGE BODY 17832 NO
SYS
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
DBMS_LOB
PACKAGE 54668 NO
SYS
DBMS_OUTPUT
PACKAGE BODY 9615 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
SYS
DBMS_PIPE
PACKAGE 21901 NO
SYS
DBMS_PRVT_TRACE
PACKAGE BODY 13715 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
SYS
DBMS_REGISTRY_SYS
PACKAGE BODY 52641 NO
SYS
DBMS_REGISTRY_SYS
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
PACKAGE 17813 NO
SYS
DBMS_REPCAT_COMMON_UTL
PACKAGE BODY 23046 NO
SYS
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
DBMS_REPCAT_DECL
PACKAGE BODY 6596 NO
SYS
DBMS_REPCAT_INTERNAL
PACKAGE BODY 14792 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
SYS
DBMS_REPCAT_RGT_UTL
PACKAGE BODY 16935 NO
SYS
DBMS_REPCAT_UTL
PACKAGE BODY 231003 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
SYS
DBMS_REPUTIL
PACKAGE 5520 NO
SYS
DBMS_SPACE
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
PACKAGE 54670 NO
SYS
DBMS_SQL
PACKAGE 153016 NO
SYS
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
DBMS_SQLTUNE
PACKAGE 18880 NO
SYS
DBMS_STREAMS_ADM_UTL
PACKAGE 67000 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
SYS
DBMS_STREAMS_ADM_UTL
PACKAGE BODY 83392 NO
SYS
DBMS_SYSTEM
PACKAGE 5519 NO
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
SYS
DBMS_SYS_SQL
PACKAGE BODY 67200 NO
SYS
DBMS_TRANSACTION
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
PACKAGE 17812 NO
SYS
DBMS_UTILITY
PACKAGE BODY 41652 NO
SYS
OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE SHARABLE_MEM KEP
---------------------------- ------------ ---
HTP
PACKAGE 71047 NO
SYS
XML_SCHEMA_NAME_PRESENT
PACKAGE 13723 NO
49 rows selected.
SQL>