Many Thanks for the input... 9.2, right? <- Yes! > how about nuking the entire deal and selecting a % of > physical memory for oracle to allocate? > it involves the least amount of thinking. > for a single database instance, give it half. This is what I am trying to do! I started with creating an init.ora, by copying what appears to be an example file init.ora.42920039208 and editing it. The SGA remained the same, I then tried copying init.ora to init<SID>.ora. SGA still stays the same. Pretty frustrating! Is the size then based on sga_max_size ?? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------