Query v$db_object_cache : DB_OBJECT_CACHE « System Tables Data Dictionary « Oracle PL/SQL Tutorial






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

JAVA2S
ADJUST_SALARY
PROCEDURE                           22980 NO


OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                         SHARABLE_MEM KEP
---------------------------- ------------ ---
JAVA2S
CORE_PROCESS
PROCEDURE                            2499 NO

JAVA2S
DISPLAY_CUSTOMERS
PROCEDURE                            1432 NO

OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                         SHARABLE_MEM KEP
---------------------------- ------------ ---

JAVA2S
DO_QUERY
PROCEDURE                            1423 NO

JAVA2S
ERRORS

OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                         SHARABLE_MEM KEP
---------------------------- ------------ ---
PACKAGE                              9613 NO

JAVA2S
ERROR_TEST1
PROCEDURE                           14786 NO

JAVA2S

OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                         SHARABLE_MEM KEP
---------------------------- ------------ ---
HOCKEY_PASS
PROCEDURE                            2498 NO

JAVA2S
PROCESPRODUCTS
PROCEDURE                            1429 NO


OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                         SHARABLE_MEM KEP
---------------------------- ------------ ---
JAVA2S
SHOWVALS
PROCEDURE                            2495 NO

JAVA2S
SHOW_ORDERS
PROCEDURE                           21906 NO

OWNER
----------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
TYPE                         SHARABLE_MEM KEP
---------------------------- ------------ ---

JAVA2S
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>








30.24.DB_OBJECT_CACHE
30.24.1.Query v$db_object_cache
30.24.2.Union V$DB_OBJECT_CACHE and V$SQLAREA