{"id":43,"date":"2011-05-31T12:51:37","date_gmt":"2011-05-31T12:51:37","guid":{"rendered":"http:\/\/tomas.papp.me.uk\/?p=43"},"modified":"2011-05-31T12:51:37","modified_gmt":"2011-05-31T12:51:37","slug":"oracle-ako-vynutit-hard-parse-vyhodenim-cursora-z-cache","status":"publish","type":"post","link":"https:\/\/tomas.papp.me.uk\/?p=43","title":{"rendered":"Oracle: ako vynutit hard parse vyhodenim cursora z cache"},"content":{"rendered":"<p>Je na to pekny trik:)<\/p>\n<pre>SQL&gt; select address, hash_value from v$sqlarea where sql_text = 'select * from dept';\r\n\r\nADDRESS HASH_VALUE\r\n-------- ----------\r\n2671F27C 3599690174\r\n\r\nSQL&gt; exec dbms_shared_pool.purge('2671F27C,3599690174','C');\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt; select address, hash_value from v$sqlarea where sql_text = 'select * from dept';\r\n\r\nno rows selected<\/pre>\n<p>pozn: funguje od 11.1 vyssie, na 10.2.x.y je locknuta kontextom 5614566 ( 5614566 trace name context forever )<br \/>\nci zabralo alebo nie je dobre checknut vo v$sql v stlpci invalidations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Je na to pekny trik:) SQL&gt; select address, hash_value from v$sqlarea where sql_text = &#8216;select * from dept&#8217;; ADDRESS HASH_VALUE &#8212;&#8212;&#8211; &#8212;&#8212;&#8212;- 2671F27C 3599690174 SQL&gt; exec dbms_shared_pool.purge(&#8216;2671F27C,3599690174&#8242;,&#8217;C&#8217;); PL\/SQL procedure successfully completed. SQL&gt; select address, hash_value from v$sqlarea where sql_text = &#8216;select * from dept&#8217;; no rows selected pozn: funguje od 11.1 vyssie, na 10.2.x.y je [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-43","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/43","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=43"}],"version-history":[{"count":5,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/43\/revisions"}],"predecessor-version":[{"id":72,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/43\/revisions\/72"}],"wp:attachment":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}