Re: Slow Commit

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 29 May 2003 05:43:02 -0700
Message-ID: <2687bb95.0305290443.2f781981@posting.google.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.

Daniel, has the student verified that the disk being used for the redo logs is not the problem due to contention or perhaps depending on the disk farm setup it being an older (and less capable) device, non-cached etc...?

Just an idea, -- Mark D Powell -- Received on Thu May 29 2003 - 07:43:02 CDT