Exadata X5-2 : 11.2.0.4 => log switch/archive 50.3% DB time !!!
Hi ,
I need help to find root cause of log switch/archive 50.3% DB time.
Thanks.
GD.
Details :
redo log file switch frequency = 10 per hour.
redo log size = 600 Mo.
log_buffer = 1Mo.
log_checkpoint_timeout 1800
log_checkpoints_to_alert TRUE
log_checkpoint_interval 0
fast_start_mttr_target 300
SELECT optimal_logfile_size FROM v$instance_recovery => 3Go !
Group Status Member Size
1 INACTIVE +DATAH<...> 400
1 INACTIVE +RECOH<...> 400
2 CURRENT +DATAH<...> 400
2 CURRENT +RECOH<...> 400
3 INACTIVE +DATAH<...> 400
3 INACTIVE +RECOH<...> 400
4 INACTIVE +DATAH<...> 400
4 INACTIVE +RECOH<...> 400
5 INACTIVE +DATAH<...> 400
5 INACTIVE +RECOH<...> 400
6 INACTIVE +DATAH<...> 400
6 INACTIVE +RECOH<...> 400
Top 10 Foreground Events by Total Wait Time
| Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time |
|---|