{"id":538,"date":"2018-10-10T15:21:25","date_gmt":"2018-10-10T18:21:25","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=538"},"modified":"2018-10-10T15:21:25","modified_gmt":"2018-10-10T18:21:25","slug":"statspack-idle-events-data-guard-timer-pman-timer-data-guard-gap-manager-log-file-sync-e-cpu-time","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/10\/10\/statspack-idle-events-data-guard-timer-pman-timer-data-guard-gap-manager-log-file-sync-e-cpu-time\/","title":{"rendered":"Statspack Idle Events Data Guard: Timer, pman timer, Data Guard: Gap Manager, log file sync e CPU time"},"content":{"rendered":"

Ao analisar o Statspack me deparei com os seguintes eventos<\/p>\n

Top 5 Timed Events                                                    Avg %Total\n~~~~~~~~~~~~~~~~~~                                                   wait   Call\nEvent                                            Waits    Time (s)   (ms)   Time\n----------------------------------------- ------------ ----------- ------ ------\nData Guard: Gap Manager                            180      10,800  60001   25.8\nData Guard: Timer                                   18      10,800 ######   25.8\npman timer                                       3,600      10,799   3000   25.8\nCPU time                                                     6,565          15.7\ndb file parallel read                           11,095       1,329    120    3.2\n          -------------------------------------------------------------<\/pre>\n
Causa<\/h2>\n
Este evento est\u00e1 sendo investigado bug: Bug 28523746<\/a><\/span><\/p>\n
Solu\u00e7\u00e3o<\/h2>\n
Adicionar as seguintes linhas de eventos ociosos manualmente<\/p>\n
Oracle 12.2<\/h2>\n
insert into STATS$IDLE_EVENT (event) values ('ASM cluster membership changes');\ninsert into STATS$IDLE_EVENT (event) values ('Backup Appliance Comm SGA setup wait');\ninsert into STATS$IDLE_EVENT (event) values ('Backup Appliance Servlet wait');\ninsert into STATS$IDLE_EVENT (event) values ('Backup Appliance Surrogate wait');\ninsert into STATS$IDLE_EVENT (event) values ('Backup Appliance waiting for work');\ninsert into STATS$IDLE_EVENT (event) values ('Backup Appliance waiting restore start');\ninsert into STATS$IDLE_EVENT (event) values ('DNFS disp IO slave idle');\ninsert into STATS$IDLE_EVENT (event) values ('Data Guard: Gap Manager');\ninsert into STATS$IDLE_EVENT (event) values ('Data Guard: Timer');\ninsert into STATS$IDLE_EVENT (event) values ('Data Guard: controlfile update');\ninsert into STATS$IDLE_EVENT (event) values ('IMFS defer writes scheduler');\ninsert into STATS$IDLE_EVENT (event) values ('LMS CR slave timer');\ninsert into STATS$IDLE_EVENT (event) values ('OFS Receive Queue');\ninsert into STATS$IDLE_EVENT (event) values ('PL\/SQL lock timer');\ninsert into STATS$IDLE_EVENT (event) values ('SCM slave idle');\ninsert into STATS$IDLE_EVENT (event) values ('Sharded  Queues : Part Truncate idle');\ninsert into STATS$IDLE_EVENT (event) values ('Streams AQ: opt idle');\ninsert into STATS$IDLE_EVENT (event) values ('block compare coord process idle');\ninsert into STATS$IDLE_EVENT (event) values ('gopp msg');\ninsert into STATS$IDLE_EVENT (event) values ('nologging fetch slave idle');\ninsert into STATS$IDLE_EVENT (event) values ('pman timer');\ninsert into STATS$IDLE_EVENT (event) values ('recovery coordinator idle');\ninsert into STATS$IDLE_EVENT (event) values ('recovery logmerger idle');\ninsert into STATS$IDLE_EVENT (event) values ('recovery receiver idle');\ninsert into STATS$IDLE_EVENT (event) values ('recovery sender idle');\ncommit;<\/pre>\n
Oracle 18.8<\/h2>\n
insert into STATS$IDLE_EVENT (event) values ('DBWR timer');\ninsert into STATS$IDLE_EVENT (event) values ('LogMiner merger: idle');\ninsert into STATS$IDLE_EVENT (event) values ('memoptimize write drain idle');\ncommit;<\/pre>\n
 <\/p>\n
Fonte: Oracle Support<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Ao analisar o Statspack me deparei com os seguintes eventos Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time —————————————– ———— ———– —— —— Data Guard: Gap Manager 180 10,800 60001 25.8 Data Guard: Timer 18 10,800 ###### 25.8 pman timer 3,600 10,799 3000 25.8 CPU time 6,565 15.7…<\/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":[65,79,80,182,294,339,340],"class_list":["post-538","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-cpu-time","tag-data-guard-gap-manager","tag-data-guard-timer","tag-log-file-sync","tag-pman-timer","tag-statspack","tag-statspack-idle-events"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/538","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=538"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/538\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}