Disk layout and disk speed itself matters. While testing one same batch job with similar data on prod and test machine, test machine was performing same job in half of the time(2 hours) than prod(4 hours) and difference was fast fiber optical drives on test box even with slower processor but as it was write intensive job it was running faster on test.
Please involve your unix group to explain/investigate this performance problem when everything is almost same as far as code,data and other relevant params are concerned. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Thu, 11 Apr 2002 11:28:38 -0800 Dennis-- The faster machine had 10 database connections, the slower, 50. Not all were used in either case. But my comparison is for inserts done by a single session, i.e., it's not the aggregate insert rate, but a direct comparison of the same insert statement in a single session on each server. As for the disk layout, I don't have that information readily available (the SA department doesn't like to let the DBA department get involved in such things!). I don't think it's significantly different, though. Thanks, Paul --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Paul - How many insert processes did you run on each system? Is the > disk > layout identical in terms of spreading across devices? > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Wednesday, April 10, 2002 6:43 PM > To: Multiple recipients of list ORACLE-L > > > Greetings! > > I am trying to diagnose a performance difference between two > databases > running the same test. They are similarly configured (same SGA size, > etc.), and the servers are identical except for the number of CPUs > (server A has 4, server B has 6). > > On database A, INSERT performance is about 190 rows/second. > > On database B, INSERT performance is over 500 rows/second. > > I saw some cache buffers chains, buffer busy, and library cache latch > waits on database A while the test was running, as well as redo log > sync waits. The waits didn't seem excessive, though. I checked for > "checkpoint not complete" redo allocation messages in database A's > alert log and found none. The db_block_lru_latches parameter is set > to > one-half the number of CPUs in both machines. > > I'd much appreciate any suggestions as to what else to check. I know > that freelists can be an issue (there are multiple sessions > performing > inserts); how can I check to see if there's freelist contention? > Anything else I should investigate? > > Many TIA, > > > > > > ===== > Paul Baumgartel, Adept Computer Associates, Inc. > [EMAIL PROTECTED] > > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). MOHAMMAD RAFIQ _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).