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: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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 <DWILLIAMS_at_lifetouch.com> 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.
> dwilliams_at_lifetouch.com
>
>
> -----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.
> paul.baumgartel_at_aya.yale.edu
>
>
>
>
>
> __________________________________________________
> 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: treegarden_at_yahoo.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).
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: treegarden_at_yahoo.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).
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: rafiq9857_at_hotmail.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 Thu Apr 11 2002 - 15:33:39 CDT