{"id":1202,"date":"2014-05-21T16:07:16","date_gmt":"2014-05-21T08:07:16","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=1202"},"modified":"2014-05-21T16:07:16","modified_gmt":"2014-05-21T08:07:16","slug":"dbms_shared_pool%e5%ae%89%e8%a3%85-pls-00201-identifier-dbms_shared_pool-keep-must-be-declared","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=1202","title":{"rendered":"DBMS_SHARED_POOL\u5b89\u88c5-PLS-00201: identifier &#8216;DBMS_SHARED_POOL.KEEP&#8217; must be declared"},"content":{"rendered":"<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; exec DBMS_SHARED_POOL.KEEP(&#039;STANDARD&#039;,&#039;P&#039;);\r\nBEGIN DBMS_SHARED_POOL.KEEP(&#039;STANDARD&#039;,&#039;P&#039;); END;\r\n\r\n      *\r\nERROR at line 1:\r\nORA-06550: line 1, column 7:\r\nPLS-00201: identifier &#039;DBMS_SHARED_POOL.KEEP&#039; must be declared\r\nORA-06550: line 1, column 7:\r\nPL\/SQL: Statement ignored\r\n\r\n<\/pre>\n<p><strong>\u67e5\u770b\u662f\u5426\u5b89\u88c5\u4e86DBMS_SHARED_POOL\u5305<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; select count(*) from DBA_OBJECTS where object_name=&#039;DBMS_SHARED_POOL&#039;;\r\n\r\n  COUNT(*)\r\n----------\r\n         0\r\n<\/pre>\n<p><strong>\u5b89\u88c5DBMS_SHARED_POOL\u5305<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; @?\/rdbms\/admin\/dbmspool.sql\r\n\r\nPackage created.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nView created.\r\n\r\n\r\nPackage body created.\r\n<\/pre>\n<p><strong>\u9a8c\u8bc1<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; select count(*) from DBA_OBJECTS where object_name=&#039;DBMS_SHARED_POOL&#039;;\r\n\r\n  COUNT(*)\r\n----------\r\n         2\r\n\r\nSQL&gt; exec DBMS_SHARED_POOL.KEEP(&#039;STANDARD&#039;,&#039;P&#039;);\r\n\r\nPL\/SQL procedure successfully completed.\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQL&gt; exec DBMS_SHARED_POOL.KEEP(&#039;STANDARD&#039; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[87],"tags":[255,257,256],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1202"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1202"}],"version-history":[{"count":2,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1202\/revisions"}],"predecessor-version":[{"id":1204,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1202\/revisions\/1204"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1202"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}