Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query v$db_object_cache

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>