Re: SHARED_POOL_SIZE Increase Makes a Bstat Little Worse - Why?
Date: 1997/07/16
Message-ID: <19970716001200.UAA11411_at_ladder02.news.aol.com>#1/1
Original note asked about Oracle Bstats differences after bumping SGA from apprx 360M to 480M on 768M machine.
I just wanted to point out that using 62% of memory for the Oracle SGA when you have a sort_area_retained_size of 1M could quickly consume all real memory if you have more than a few users. You might want to check on your system swap statistics. If you have little to none, then you are fine, but it your system is experiencing swap you may well see an Oracle performance improvement by reducing the size of the buffer pool thereby making more memory available to the user processes (PGAs).
Just another complication to your work.
Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Wed Jul 16 1997 - 00:00:00 CEST