Hi Mark,
no thoughts specific to Oracle, but I'd recommend using the principle of "change only
one element at a time". I'd say they were unwise to upgrade to W2K, and at the same
time change their Oracle parameters. If possible, I'd advise they set all their Oracle
parameters back to their pre-upgrade values, then carry out the same performance
measures they used to arrive at their "was 7/10, is now 3/10" comment. If the
degradation still exists to the same extent, then, yes, it must be the upgrade that
produced the problems, and it needs investigating in that light. If they still get
"7/10", then it must have been the changes to the Oracle parameters, not the W2K
upgrade, that caused the problem.
Changing too many elements simultaneously makes it impossible (or much more difficult)
to isolate the cause, so you change one element at a time. Basic engineering principle!
Paul
-----Original Message-----
Mark Leith
Sent: 10 December 2003 09:04
To: Multiple recipients of list ORACLE-L
Hi All,
We've been asked a question from one of our clients that I'm a little
stumped on.
They run an OLTP database (Oracle 8.1.7), and have recently upgraded their
NT machine to Windows 2000, they were running with 2gb of memory, and
upgraded that to 4gb in the process. As they increased physical memory, they
also increased their SGA size & db_block_buffers.
Since they've upgraded they have noticed a significant decrease in
performance (the way it was described to me was "it was 7 out of 10, and is
now 3 out of 10"..).
Has anybody else done a system upgrade of this nature that has caused less
than desirable effects? Any pointers as to what to look at? We've requested
some stats (top wait stats etc.) and I'll feed these back as and when I get
them - but I thought I'd throw this out to you guys in the vague hope that
someone has experienced some relatively similar experiences.
Cheers!
Mark
===================================================
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===================================================
http://www.cool-tools.co.uk
Maximising throughput & performance
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
--
Author: Paul Vincent
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
