OraFAQ Forum: Performance Tuning » poor performance during switch log file

Home » RDBMS Server » Performance Tuning » poor performance during switch log file (Oracle 12.2.0.1 linux 7.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

poor performance during switch log file [message #676074]

Sun, 12 May 2019 05:37

fabi88
Messages: 112
Registered: November 2011

Senior Member

Hi experts,

There is a delay in response time of queries because of long time for switch log file (Private strand flush not complete), actually response time of queries are good before and after switch log file .
- redo logs are on fast disks
- redolog size is 1.5G (log switch per hour is normal, about 5)

wait events are as follws:


db file async I/O submit 
CPU + Wait for CPU
log file parallel write

can something like latch contention cause wait for db writer? or something else?
could you please help to resolve this issue? thank you in advance?

Report message to a moderator

[Message index]

		poor performance during switch log file By: fabi88 on Sun, 12 May 2019 05:37
		Re: poor performance during switch log file By: BlackSwan on Sun, 12 May 2019 08:36
		Re: poor performance during switch log file By: John Watson on Sun, 12 May 2019 11:53
		Re: poor performance during switch log file By: fabi88 on Tue, 14 May 2019 04:27
		Re: poor performance during switch log file By: John Watson on Tue, 14 May 2019 04:49
		Re: poor performance during switch log file By: trantuananh24hg on Mon, 20 May 2019 22:02

Previous Topic:	Query Taking Alot of time ..Help in Tuning
Next Topic:	improve performance on updating clob data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:23:21 CDT 2024