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-l