Após instalar o Statspack Oracle 11.2.0.4 me deparei com os seguintes eventos
|
1 2 3 4 5 6 7 8 9 |
Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time ----------------------------------------- ------------ ----------- ------ ------ 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 3003 11.4 AQPC idle 120 3,601 30008 11.4 |
Resolvendo
Atualização tabela de eventos Statspack
|
1 2 3 4 5 6 |
SQL> delete from STATS$IDLE_EVENT; insert into STATS$IDLE_EVENT select name from V$EVENT_NAME where wait_class='Idle'; insert into STATS$IDLE_EVENT values('log file parallel write'); insert into STATS$IDLE_EVENT values('target log write size'); commit; |