Re: log file sync

  • From: "Richard Ji" <richard.c.ji@xxxxxxxxx>
  • To: oracle@xxxxxxxxxxxx
  • Date: Tue, 10 Oct 2006 15:49:57 -0400

What kind of application is that?  Java?  If that's the case, make sure he
turns off auto commit.  Otherwise despite his change, it's still committing
frequently.  The same thing might apply to other language too.

Richard

On 10/10/06, oracle@xxxxxxxxxxxx <oracle@xxxxxxxxxxxx> wrote:


hi,

I am trying to uncover the root cause of log file sync waits causing an
application to decrease in performance.  10046 trace shows hundreds of
thousands of lines of log file sync with ela time around 1000.  1ms by




Other related posts: