Re: Slow Commit

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 29 May 2003 21:32:00 +1000
Message-ID: <NWlBa.45636$1s1.611923@newsfeeds.bigpond.com>

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3ED573DC.B3B8234_at_exxesolutions.com...
> Just received a copy of a profile created with DBMS_PROFILER from a new
> Oracle application one of my students built at his place of business
> using 8.1.7.4 EE on a 2 CPU Alpha.
>
> Of interest ... of the lines taking more than 1% of the total time for
> each run is the following:
>
> COMMIT;
>
> recorded as 3.5697 seconds. And this is on a system with no more than a
> few hundred users and what I would consider a low-to-moderate
> transaction rate.
>
> Other than log file switches and checking for waits any suggestions with
> respect to where to continue the search will be appreciated.
>
> Thanks.
> --

Hi Daniel ,

Perform a 10046 level 8 trace on an effected session and see what waits are causing the issue.

Cheers

Richard Received on Thu May 29 2003 - 06:32:00 CDT