Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Slow Commit

Re: Slow Commit

From: vob <ga_at_aol.com>
Date: Thu, 29 May 2003 19:29:18 +0200
Message-ID: <bb4kuh$baj$03$1@news.t-online.com>


seperate disk for online logs, no raid 5!!!

log buffer size to standard
( now 1m on solaris )

best thing is to reduce commit rate

"Daniel Morgan" <damorgan_at_exxesolutions.com> schrieb im Newsbeitrag 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 Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Thu May 29 2003 - 12:29:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US