{"id":741,"date":"2019-03-07T18:26:31","date_gmt":"2019-03-07T21:26:31","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=741"},"modified":"2019-03-07T18:26:31","modified_gmt":"2019-03-07T21:26:31","slug":"oracle-statspack-idle-events-lgwr-worker-group-idle-cpu-time-heartbeat-redo-informer-lreg-timer-aqpc-idle","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2019\/03\/07\/oracle-statspack-idle-events-lgwr-worker-group-idle-cpu-time-heartbeat-redo-informer-lreg-timer-aqpc-idle\/","title":{"rendered":"Oracle \u2013 Statspack Idle events (LGWR worker group idle CPU time heartbeat redo informer lreg timer AQPC idle)"},"content":{"rendered":"<p>Ap\u00f3s instalar o Statspack Oracle 11.2.0.4 me deparei com os seguintes eventos<\/p>\n<pre class=\"lang:plsql decode:true \">Top 5 Timed Events                                                    Avg %Total\n~~~~~~~~~~~~~~~~~~                                                   wait   Call\nEvent                                            Waits    Time (s)   (ms)   Time\n----------------------------------------- ------------ ----------- ------ ------\nLGWR worker group idle                          12,929        41.0\nCPU time                                            12       6,923 ######   22.0\nheartbeat redo informer                          3,604       3,604   1000   11.4\nlreg timer                                       1,201       3,607   3003   11.4\nAQPC idle                                          120       3,601  30008   11.4<\/pre>\n<p>Resolvendo<\/p>\n<p>Atualiza\u00e7\u00e3o tabela de eventos Statspack<\/p>\n<pre class=\"lang:plsql decode:true \">SQL&gt; \ndelete from STATS$IDLE_EVENT;\ninsert into STATS$IDLE_EVENT select name from V$EVENT_NAME where wait_class='Idle';\ninsert into STATS$IDLE_EVENT values('log file parallel write');\ninsert into STATS$IDLE_EVENT values('target log write size');\ncommit;<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ap\u00f3s instalar o Statspack Oracle 11.2.0.4 me deparei com os seguintes eventos Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212; &#8212;&#8212; LGWR worker group idle 12,929 41.0 CPU time 12 6,923 ###### 22.0 heartbeat redo informer 3,604 3,604 1000 11.4 lreg timer 1,201 3,607&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[44,65,148,170,186,282,339],"class_list":["post-741","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-aqpc-idle","tag-cpu-time","tag-heartbeat-redo-informer","tag-lgwr-worker-group-idle","tag-lreg-timer","tag-oracle-statspack-idle-events-lgwr-worker-group-idle-cpu-time-heartbeat-redo-informer-lreg-timer-aqpc-idle","tag-statspack"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=741"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/741\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}