Mark, I have not done a MicroSlop upgrade, but I have in the past upped the SGA size and gotten when I really did not want, which was database performance degradation. You might ask them to check the pagefile size. If it's system maintained or too small funny things do happen. BTW: My rule of thumb with Win2K is pagefile size = physical memory *1.5.
Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- Sent: Wednesday, December 10, 2003 4:04 AM 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: Goulet, Dick 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).