| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Performance analysis (enqueue and buffer busy waits)
Jonathen,
The trace file only related to one process. We were running 23 others simultaneously. All where doing the same thing with a different data selection. The application is certainly hosed as all ERP applications are as I understand it, even Oracle Apps. This happens to be J.D. Edwards OneWorld. The F4211 update you speak of is a mystery as it doesn't really make sense for the same session to update that many rows in the sales order table. I will be following up with JDE on that one. The log buffer was originally 5 MB and log file sync waits were high. I thought reducing the log buffer size would help. Unfortunalty it is hard to get real measures of the impact of changes as the system is heavily used and time to perform testing is far and few in between. Hopefully we will have the system all to ourselves on Sunday for some very detailed iterative testing and analysis. We have progressivly increased log buffer size from 64K, 128K, to 256K. Will try some more drastic modifications on Sunday. Don't have the other information you need but will let you know next week how things go. Thanks for all the help.
http://www.freetechnicaltraining.com/docs/52750.txt
>-----Original Message-----
>From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
>Sent: Wednesday, August 15, 2001 12:56 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: Performance analysis (enqueue and buffer busy waits)
>
>
>
>Could you post the URL for the trace file
>again.
>
>One observation - 3,000 commits per
>minute seems very odd for processing
>230 sales order lines per minute.
>
>Also 3,000 commits per minute doesn't
>seem to be consistent with the trace file
>which I can no longer see that had one
>update executed twice, updating 86,000
>rows or so.
>
>You can look at x$kcbfwait to identify
>which file the v$waitstat waits cam from.
>
>Clearly the application is somewhat
>defective, and solving it by fiddling with
>the database may be a forlorn hope,
>but if you haven't tried it yet, a log buffer
>of 10MB might help - on the other hand
>it might just make all the log file syncs
>last longer.
>
>Do you have figures for
> total elapsed run time
> total wait time on log file sync
> total wait time on tx enqueues
> total CPU used
>for the duration of the run ?
>
>
>Jonathan Lewis
>
>Seminars on getting the best out of Oracle
>Last few places available for Sept 10th/11th
>See http://www.jlcomp.demon.co.uk/seminar.html
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jonathan Lewis
> INET: jonathan_at_jlcomp.demon.co.uk
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: epost_at_kcc.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Aug 15 2001 - 14:42:56 CDT
 |
 |