Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: log file sync
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_at_digistar.com <oracle_at_digistar.com> 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
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 10 2006 - 14:49:57 CDT
![]() |
![]() |