Home » RDBMS Server » Performance Tuning » Log File Sync  () 1 Vote
Log File Sync [message #163550] Fri, 17 March 2006 03:50 Go to next message
amitsingla
Messages: 4
Registered: March 2006
Junior Member
How can I reduce Log File Sync waits.
My database is in Noarchivelog mode.

Report message to a moderator

Re: Log File Sync [message #163552 is a reply to message #163550] Fri, 17 March 2006 04:02 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Did You want to stop archiving of logs?

Report message to a moderator

Re: Log File Sync [message #163553 is a reply to message #163550] Fri, 17 March 2006 04:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
may be your application is doing too much of commits.

Report message to a moderator

Re: Log File Sync [message #163567 is a reply to message #163550] Fri, 17 March 2006 04:56 Go to previous message
alanm
Messages: 284
Registered: March 2005
Senior Member
have you run a statspack report?

Report message to a moderator

Previous Topic: Interpreting tkprof
Next Topic: Difference in Execution timing
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 18:13:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.