Re: Resizing the SGA

From: Pratap <pratap_fin_at_rediffmail.com>
Date: 11 Aug 2004 22:45:34 -0700
Message-ID: <830861d2.0408112145.2699435b@posting.google.com>

I suggest you use workarea_size_policy = AUTO as you are using Oracle 9i. Oracle will then manage the sizes of all components of PGA like hash_area_size, sort_area_size etc.

Also switch on the all "advices" in the database like db_cache_advice.

Once you start running the system check these views to adjust your memory components -

V$DB_CACHE_ADVICE
V$PGA_TARGET_ADVICE
V$SHARED_POOL_ADVICE

Pratap Deshmukh
Cognizant Technology Solutions, India
www.cognizant.com Received on Thu Aug 12 2004 - 00:45:34 CDT