Home » RDBMS Server » Server Administration » log file sync
log file sync [message #61048] Mon, 22 March 2004 21:28 Go to next message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
Hello folk!

I have a excessive amount of 'log file sync' waits on my database(30-35%). In documentation are write that this waitevent occur when the session are commit. I have traced some sessions on database and has seen that this waitevent occur not only after commits but also after exec and fetch operations. Can anyone explain to me why this occur.
Re: log file sync [message #61057 is a reply to message #61048] Wed, 24 March 2004 09:56 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
in performance tuning forum..
Previous Topic: oracle Data manager Export or import
Next Topic: JOIN_INDEX Fied in DBA_INDEXES?
Goto Forum:
  


Current Time: Fri Sep 20 12:22:19 CDT 2024