My Oracle Support Banner

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

Last updated on APRIL 28, 2020

적용 대상:

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


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.