My Oracle Support Banner

LOG SWITCH 시의 성능 저하 (Doc ID 2398725.1)

Last updated on MAY 15, 2018

적용 대상:

Oracle Exadata Storage Server Software - 버전 12.1.2.2.0 과(와) 그 후속
이 문서의 내용은 모든 플랫폼에 적용됩니다.

증상

1. database alert.log 에 아래 메시지가 보이며 성능 저하가 관찰됨. 

Thread 2 cannot allocate new log, sequence 157
Redo flush for thread 1 is not complete

2. 문제 시점의 AWR top10 wait 에는 'remote log force - log switch/recovery' 가 관찰됨.

Top 10 Foreground Events by Total Wait Time

Event Waits Total Wait Time (sec) Avg Wait % DB time Wait Class
--------------------------------------------------------------------------------------------------------------
DB CPU 690.9 73.2
remote log force - log switch/recovery 45 152.4 3386.19ms 16.1 Cluster <<<<<
buffer busy waits 361 87.5 242.49ms 9.3 Concurrency
cell single block physical read 59,592 20.4 341.74us 2.2 User I/O 

원인

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


이 문서에서
증상
원인
해결책
참고


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.