http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2FDB_OBJECT_CACHE Oracle PL/SQL Tutorial/System Tables Data Dictionary/DB OBJECT CACHE - История изменений 2026-05-24T23:26:01Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/DB_OBJECT_CACHE&diff=3887&oldid=prev в 13:45, 26 мая 2010 2010-05-26T13:45:46Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table> http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/DB_OBJECT_CACHE&diff=3888&oldid=prev Admin: 1 версия 2010-05-26T10:08:04Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== Query v$db_object_cache==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT owner, name, type, sharable_mem, kept<br /> 2 FROM v$db_object_cache<br /> 3 WHERE type like &quot;P%&quot;<br /> 4 and rownum &lt; 50<br /> 5 ORDER BY owner, name;<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> CTXSYS<br /> DRIIXS<br /> PACKAGE BODY 25153 NO<br /> CTXSYS<br /> DRIREC<br /> PACKAGE 5517 NO<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> CTXSYS<br /> DRISPL<br /> PACKAGE 5517 NO<br /> CTXSYS<br /> DRISPL<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> PACKAGE BODY 25153 NO<br /> CTXSYS<br /> DRIUTL<br /> PACKAGE 5517 NO<br /> CTXSYS<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> DRIXMD<br /> PACKAGE BODY 85629 NO<br /> sqle<br /> ADJUST_SALARY<br /> PROCEDURE 22980 NO<br /> <br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> sqle<br /> CORE_PROCESS<br /> PROCEDURE 2499 NO<br /> sqle<br /> DISPLAY_CUSTOMERS<br /> PROCEDURE 1432 NO<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> sqle<br /> DO_QUERY<br /> PROCEDURE 1423 NO<br /> sqle<br /> ERRORS<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> PACKAGE 9613 NO<br /> sqle<br /> ERROR_TEST1<br /> PROCEDURE 14786 NO<br /> sqle<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> HOCKEY_PASS<br /> PROCEDURE 2498 NO<br /> sqle<br /> PROCESPRODUCTS<br /> PROCEDURE 1429 NO<br /> <br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> sqle<br /> SHOWVALS<br /> PROCEDURE 2495 NO<br /> sqle<br /> SHOW_ORDERS<br /> PROCEDURE 21906 NO<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> sqle<br /> TEST_EMPLOYEE_CURSORS<br /> PROCEDURE 21916 NO<br /> SYS<br /> AW_DROP_PROC<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> PROCEDURE 13712 NO<br /> SYS<br /> DBMS_ADVISOR<br /> PACKAGE 1424 NO<br /> SYS<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> DBMS_ALERT<br /> PACKAGE BODY 18914 NO<br /> SYS<br /> DBMS_APPLICATION_INFO<br /> PACKAGE 17817 NO<br /> <br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> SYS<br /> DBMS_DEFER_IMPORT_INTERNAL<br /> PACKAGE 13726 NO<br /> SYS<br /> DBMS_HA_ALERTS_PRVT<br /> PACKAGE 5527 NO<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> SYS<br /> DBMS_IREFRESH<br /> PACKAGE BODY 25181 NO<br /> SYS<br /> DBMS_IREFRESH<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> PACKAGE 30097 NO<br /> SYS<br /> DBMS_LOB<br /> PACKAGE BODY 17832 NO<br /> SYS<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> DBMS_LOB<br /> PACKAGE 54668 NO<br /> SYS<br /> DBMS_OUTPUT<br /> PACKAGE BODY 9615 NO<br /> <br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> SYS<br /> DBMS_PIPE<br /> PACKAGE 21901 NO<br /> SYS<br /> DBMS_PRVT_TRACE<br /> PACKAGE BODY 13715 NO<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> SYS<br /> DBMS_REGISTRY_SYS<br /> PACKAGE BODY 52641 NO<br /> SYS<br /> DBMS_REGISTRY_SYS<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> PACKAGE 17813 NO<br /> SYS<br /> DBMS_REPCAT_COMMON_UTL<br /> PACKAGE BODY 23046 NO<br /> SYS<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> DBMS_REPCAT_DECL<br /> PACKAGE BODY 6596 NO<br /> SYS<br /> DBMS_REPCAT_INTERNAL<br /> PACKAGE BODY 14792 NO<br /> <br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> SYS<br /> DBMS_REPCAT_RGT_UTL<br /> PACKAGE BODY 16935 NO<br /> SYS<br /> DBMS_REPCAT_UTL<br /> PACKAGE BODY 231003 NO<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> SYS<br /> DBMS_REPUTIL<br /> PACKAGE 5520 NO<br /> SYS<br /> DBMS_SPACE<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> PACKAGE 54670 NO<br /> SYS<br /> DBMS_SQL<br /> PACKAGE 153016 NO<br /> SYS<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> DBMS_SQLTUNE<br /> PACKAGE 18880 NO<br /> SYS<br /> DBMS_STREAMS_ADM_UTL<br /> PACKAGE 67000 NO<br /> <br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> SYS<br /> DBMS_STREAMS_ADM_UTL<br /> PACKAGE BODY 83392 NO<br /> SYS<br /> DBMS_SYSTEM<br /> PACKAGE 5519 NO<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> SYS<br /> DBMS_SYS_SQL<br /> PACKAGE BODY 67200 NO<br /> SYS<br /> DBMS_TRANSACTION<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> PACKAGE 17812 NO<br /> SYS<br /> DBMS_UTILITY<br /> PACKAGE BODY 41652 NO<br /> SYS<br /> OWNER<br /> ----------------------------------------------------------------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> TYPE SHARABLE_MEM KEP<br /> ---------------------------- ------------ ---<br /> HTP<br /> PACKAGE 71047 NO<br /> SYS<br /> XML_SCHEMA_NAME_PRESENT<br /> PACKAGE 13723 NO<br /> <br /> 49 rows selected.<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Union V$DB_OBJECT_CACHE and V$SQLAREA==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT TO_CHAR(SHARABLE_MEM / 1000 ,&quot;999999&quot;) SZ,<br /> 2 DECODE(KEPT_VERSIONS,0,&quot; &quot;,<br /> 3 RPAD(&quot;YES(&quot; || TO_CHAR(KEPT_VERSIONS) || &quot;)&quot; ,6)) KEEPED,<br /> 4 RAWTOHEX(ADDRESS) || &quot;,&quot; || TO_CHAR(HASH_VALUE) NAME,<br /> 5 SUBSTR(SQL_TEXT,1,354) EXTRA, 1 ISCURSOR<br /> 6 FROM V$SQLAREA<br /> 7 WHERE SHARABLE_MEM &gt; 1000<br /> 8 and rownum &lt; 2<br /> 9 UNION<br /> 10 SELECT TO_CHAR(SHARABLE_MEM / 1000 ,&quot;999999&quot;) SZ,<br /> 11 DECODE(KEPT,&quot;YES&quot;,&quot;YES &quot;,&quot; &quot;) KEEPED,<br /> 12 OWNER || &quot;.&quot; || NAME ||<br /> 13 LPAD(&quot; &quot;,29 - (LENGTH(OWNER) + LENGTH(NAME) ) ) ||<br /> 14 &quot;(&quot; || TYPE || &quot;)&quot; NAME, NULL EXTRA, 0 ISCURSOR<br /> 15 FROM V$DB_OBJECT_CACHE V<br /> 16 WHERE SHARABLE_MEM &gt; 1000<br /> 17 and rownum &lt; 2<br /> 18 ORDER BY 1 DESC;<br /> SZ KEEPED<br /> ------- ------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> EXTRA<br /> --------------------------------------------------------------------------------<br /> ISCURSOR<br /> ----------<br /> 17<br /> 20A7DF44,921436339<br /> select snap_interval, retention,most_recent_snap_time, most_recent_snap_id, stat<br /> us_flag, most_recent_purge_time, most_recent_split_id, most_recent_split_time, m<br /> rct_snap_time_num, mrct_purge_time_num, snapint_num, retention_num, swrf_version<br /> SZ KEEPED<br /> ------- ------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> EXTRA<br /> --------------------------------------------------------------------------------<br /> ISCURSOR<br /> ----------<br /> , registration_status, mrct_baseline_id, topnsql from wrm$_wr_control where dbid<br /> = :dbid<br /> 1<br /> 2<br /> SZ KEEPED<br /> ------- ------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> EXTRA<br /> --------------------------------------------------------------------------------<br /> ISCURSOR<br /> ----------<br /> .select id, name, block_size, advice_status, size_for_estimate,<br /> size_factor, buffers_for_estimate, estd_physical_read_factor, estd_physi<br /> cal_reads, estd_physical_read_time,<br /> estd_pct_of_db_time_for_reads, estd_cluster_r<br /> eads, estd_cluster_read_time<br /> SZ KEEPED<br /> ------- ------<br /> NAME<br /> --------------------------------------------------------------------------------<br /> EXTRA<br /> --------------------------------------------------------------------------------<br /> ISCURSOR<br /> ----------<br /> from gv$db_cache_advice where inst_id = userenv(&quot;i<br /> nstance&quot;)(CURSOR)<br /> 0<br /> <br /> SQL&gt;&lt;/source&gt;</div> Admin