{"id":705,"date":"2012-03-31T23:41:41","date_gmt":"2012-03-31T15:41:41","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=705"},"modified":"2012-04-03T23:42:38","modified_gmt":"2012-04-03T15:42:38","slug":"%e5%ae%89%e8%a3%85dbms_shared_pool%e5%8c%85","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=705","title":{"rendered":"\u5b89\u88c5DBMS_SHARED_POOL\u5305"},"content":{"rendered":"

Oracle\u63d0\u4f9b\u4e86\u4e00\u4e2a\u7ba1\u7406\u5171\u4eab\u6c60\u5bf9\u8c61\u7684\u63a5\u53e3\u2014\u2014DBMS_SHARED_POOL\u5305\uff0c\u4e0d\u8fc7\u8fd9\u4e2a\u5305\u572811g\u4ee5\u524d\u7684\u7248\u672c\u662f\u9ed8\u8ba4\u6ca1\u6709\u5b89\u88c5\u7684\u3002
\n\u5148\u770b\u4e00\u4e0b11.2\u7684\u60c5\u51b5\uff1a<\/p>\n

SQL> select * from v$version;\r\nBANNER\r\n--------------------------------------------------------------------------------\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nPL\/SQL Release 11.2.0.3.0 - Production\r\nCORE    11.2.0.3.0      Production\r\nTNS for Solaris: Version 11.2.0.3.0 - Production\r\nNLSRTL Version 11.2.0.3.0 \u2013 Production\r\nSQL> desc dbms_shared_pool\r\nPROCEDURE ABORTED_REQUEST_THRESHOLD\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n THRESHOLD_SIZE                 NUMBER                  IN\r\nPROCEDURE KEEP\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n NAME                           VARCHAR2                IN\r\n FLAG                           CHAR                    IN     DEFAULT\r\nPROCEDURE KEEP\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n SCHEMA                         VARCHAR2                IN\r\n OBJNAME                        VARCHAR2                IN\r\n NAMESPACE                      NUMBER                  IN\r\n HEAPS                          NUMBER                  IN\r\nPROCEDURE KEEP\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n HASH                           VARCHAR2                IN\r\n NAMESPACE                      NUMBER                  IN\r\n HEAPS                          NUMBER                  IN\r\nPROCEDURE MARKHOT\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n SCHEMA                         VARCHAR2                IN\r\n OBJNAME                        VARCHAR2                IN\r\n NAMESPACE                      NUMBER                  IN     DEFAULT\r\n GLOBAL                         BOOLEAN                 IN     DEFAULT\r\nPROCEDURE MARKHOT\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n HASH                           VARCHAR2                IN\r\n NAMESPACE                      NUMBER                  IN     DEFAULT\r\n GLOBAL                         BOOLEAN                 IN     DEFAULT\r\nPROCEDURE PURGE\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n NAME                           VARCHAR2                IN\r\n FLAG                           CHAR                    IN     DEFAULT\r\n HEAPS                          NUMBER                  IN     DEFAULT\r\nPROCEDURE PURGE\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n SCHEMA                         VARCHAR2                IN\r\n OBJNAME                        VARCHAR2                IN\r\n NAMESPACE                      NUMBER                  IN\r\n HEAPS                          NUMBER                  IN\r\nPROCEDURE PURGE\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n HASH                           VARCHAR2                IN\r\n NAMESPACE                      NUMBER                  IN\r\n HEAPS                          NUMBER                  IN\r\nPROCEDURE SIZES\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n MINSIZE                        NUMBER                  IN\r\nPROCEDURE UNKEEP\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n NAME                           VARCHAR2                IN\r\n FLAG                           CHAR                    IN     DEFAULT\r\nPROCEDURE UNKEEP\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n SCHEMA                         VARCHAR2                IN\r\n OBJNAME                        VARCHAR2                IN\r\n NAMESPACE                      NUMBER                  IN\r\nPROCEDURE UNKEEP\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n HASH                           VARCHAR2                IN\r\n NAMESPACE                      NUMBER                  IN\r\nPROCEDURE UNMARKHOT\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n SCHEMA                         VARCHAR2                IN\r\n OBJNAME                        VARCHAR2                IN\r\n NAMESPACE                      NUMBER                  IN     DEFAULT\r\n GLOBAL                         BOOLEAN                 IN     DEFAULT\r\nPROCEDURE UNMARKHOT\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n HASH                           VARCHAR2                IN\r\n NAMESPACE                      NUMBER                  IN     DEFAULT\r\n GLOBAL                         BOOLEAN                 IN     DEFAULT\r\nSQL><\/pre>\n
11.2\u4e2d\uff0c\u8fd9\u4e2a\u5305\u5728\u6570\u636e\u5e93\u521b\u5efa\u7684\u65f6\u523b\u5c31\u4f1a\u9ed8\u8ba4\u5b89\u88c5\u5b8c\u6210\uff0c\u800c\u4e14\u572811.2\u4e2d\uff0c\u8fd9\u4e2a\u5305\u7684\u529f\u80fd\u5f97\u5230\u4e86\u8fdb\u4e00\u6b65\u7684\u589e\u5f3a\u3002\u9664\u4e86\u7ed9\u4e00\u4e9b\u5df2\u6709\u7684\u8fc7\u7a0b\u589e\u52a0\u4e86\u91cd\u8f7d\u7684\u8fc7\u7a0b\u5916\uff0c\u8fd8\u65b0\u589e\u4e86MARKHOT\u4ee5\u53ca\u548c\u5b83\u5bf9\u5e94\u7684UNMARKHOT\u8fc7\u7a0b\u3002MARKHOT\u7528\u6765\u6807\u8bb0\u4e00\u4e2aLIBRARY CACHE\u5bf9\u8c61\u4e3a\u70ed\u5bf9\u8c61\uff0c\u800cUNMARKHOT\u5219\u53d6\u6d88\u8fd9\u4e2a\u6807\u8bb0\u3002
\n\u572810g\u53ca\u4ee5\u524d\u7248\u672c\uff0c\u8fd9\u4e2a\u5305\u5728\u6570\u636e\u5e93\u521b\u5efa\u540e\u5e76\u672a\u9a6c\u4e0a\u521b\u5efa\u9700\u8981\u624b\u5de5\u8c03\u7528$ORACLE_HOME\/rdbms\/admin\/dbmspool.sql\u6765\u521b\u5efa\uff1a<\/p>\n
SQL> select * from v$version;\r\nBANNER\r\n----------------------------------------------------------------\r\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi\r\nPL\/SQL Release 10.2.0.4.0 - Production\r\nCORE    10.2.0.4.0      Production\r\nTNS for Linux: Version 10.2.0.4.0 - Production\r\nNLSRTL Version 10.2.0.4.0 - Production\r\nSQL> desc dbms_shared_pool\r\nERROR:\r\nORA-04043: object dbms_shared_pool does not exist\r\nSQL> @?\/rdbms\/admin\/dbmspool.sql \r\nPackage created.\r\nGrant succeeded.\r\nView created.\r\nPackage body created.\r\nSQL> desc dbms_shared_pool\r\nPROCEDURE ABORTED_REQUEST_THRESHOLD\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n THRESHOLD_SIZE                 NUMBER                  IN\r\nPROCEDURE KEEP\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n NAME                           VARCHAR2                IN\r\n FLAG                           CHAR                    IN     DEFAULT\r\nPROCEDURE PURGE\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n NAME                           VARCHAR2                IN\r\n FLAG                           CHAR                    IN     DEFAULT\r\n HEAPS                          NUMBER                  IN     DEFAULT\r\nPROCEDURE SIZES\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n MINSIZE                        NUMBER                  IN\r\nPROCEDURE UNKEEP\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n NAME                           VARCHAR2                IN\r\n FLAG                           CHAR                    IN     DEFAULT<\/pre>\n
\u572810g\u4e2d\uff0cOracle\u5c06\u5305\u4f53\u521b\u5efa\u7684\u8c03\u7528\u811a\u672c\u6dfb\u52a0\u5230\u4e86dbmspool.sql\u4e2d\uff0c\u800c\u5728\u66f4\u65e9\u7684\u7248\u672c\u4e2d\uff0c\u9664\u4e86\u9700\u8981\u6267\u884cdbmspool.sql\u811a\u672c\u610f\u5916\uff0c\u8fd8\u9700\u8981\u624b\u5de5\u65b9\u5f0f\u6267\u884c$ORACLE_HOME\/rdbms\/admin\/prvtpool.plb\u811a\u672c\u6765\u521b\u5efa\u5305\u4f53\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle\u63d0\u4f9b\u4e86\u4e00\u4e2a\u7ba1\u7406\u5171\u4eab\u6c60\u5bf9\u8c61\u7684\u63a5\u53e3\u2014\u2014DBMS_SHARED_POOL\u5305\uff0c\u4e0d\u8fc7\u8fd9\u4e2a\u5305\u572811g\u4ee5\u524d\u7684\u7248\u672c\u662f\u9ed8\u8ba4\u6ca1\u6709\u5b89\u88c5\u7684\u3002 \u5148\u770b\u4e00\u4e0b11.2\u7684\u60c5\u51b5\uff1a SQL> select * from v$version; BANNER ——————————————————————————– Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production PL\/SQL Release 11.2.0.3.0 – Production CORE 11.2.0.3.0 Production TNS for Solaris: Version 11.2.0.3.0 – Production NLSRTL Version 11.2.0.3.0 \u2013 Production SQL> … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[589,588,590],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-bn","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/705"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=705"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/705\/revisions"}],"predecessor-version":[{"id":707,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/705\/revisions\/707"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}