Re: NT -> Win2K causes performance degradation..

Mark,

This is pure speculation, as you didn't provide any particulars.

Upgrading to Win2k is not likely the culprit, or at least, I have experienced any kind of problem in moving a database from NT -> Win2k.

When they upgraded the memory, by just now much did they increase db_block_buffers?

If increased too much, they could be spending a lot of time waiting on latches, as there may be too much memory to search through.

As always, excellent advice may be had from Steve Adams: http://www.ixora.com.au/q+a/pool.htm

Also, when upgrading to 4G of memory, did they set the /3GB switch?

Unless you do, there is only 2G of memory available to Oracle, and if you increase the size of the SGA too much and start excessive paging...

HTH Jared

On Wed, 2003-12-10 at 01:04, Mark Leith wrote:
> 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: mark_at_cool-tools.co.uk
> ===================================================
> 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: mark_at_cool-tools.co.uk
>
> 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: 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.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

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: 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).