{"id":736,"date":"2009-08-11T07:42:14","date_gmt":"2009-08-11T05:42:14","guid":{"rendered":"http:\/\/www.ora-solutions.net\/web\/?p=736"},"modified":"2009-08-12T09:55:17","modified_gmt":"2009-08-12T07:55:17","slug":"high-cpu-utilization-waits-on-cursor-pin-s","status":"publish","type":"post","link":"https:\/\/www.ora-solutions.net\/web\/2009\/08\/11\/high-cpu-utilization-waits-on-cursor-pin-s\/","title":{"rendered":"High CPU Utilization &#8211; waits on cursor: pin S"},"content":{"rendered":"<p>I have recently encountered a problem at a customer site, where the database instances resource utilization was so high that the application did not work anymore. Version was 10.2.0.4 on Linux with Oracle Recommended Generic Patches installed.<\/p>\n<p>Unfortunately, the customer decided to bounce the instance, so that there is no possibility for intensive diagnosis. However, ASH report shows that a dozen sessions either waited on Wait event &#8220;cursor: pin S&#8221; or were active (ON CPU) without any SQL_ID. An AWR Report  showed:<\/p>\n<blockquote>\n<pre>Top 5 Timed Events                                         Avg %Total\r\n~~~~~~~~~~~~~~~~~~                                        wait   Call\r\nEvent                                 Waits    Time (s)   (ms)   Time Wait Class\r\n------------------------------ ------------ ----------- ------ ------ ----------\r\ncursor: pin S                   140,036,615      24,833      0 ######      Other\r\nCPU time                                             19          72.9\r\nlog file sync                         8,767           8      1   30.2     Commit\r\nlog file parallel write               9,039           8      1   29.9 System I\/O\r\ncontrol file parallel write           1,269           5      4   20.2 System I\/O<\/pre>\n<\/blockquote>\n<p>Oracle Support confirmed that this is <strong>Bug 6904068 High CPU usage when there are &#8220;cursor: pin S&#8221; waits.<\/strong> We have filed a backport request for it, as there is no patch for our platform available yet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have recently encountered a problem at a customer site, where the database instances resource utilization was so high that the application did not work anymore. Version was 10.2.0.4 on Linux with Oracle Recommended Generic Patches installed. Unfortunately, the customer decided to bounce the instance, so that there is no possibility for intensive diagnosis. However, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[13,47,19,5],"tags":[],"class_list":["post-736","post","type-post","status-publish","format-standard","hentry","category-10g","category-bugs","category-metalink","category-oracle-database"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/736","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/comments?post=736"}],"version-history":[{"count":10,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/736\/revisions"}],"predecessor-version":[{"id":749,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/736\/revisions\/749"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}