Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow Commit
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