Re: Resizing the SGA

From: Pratap <pratap_fin_at_rediffmail.com>
Date: 11 Aug 2004 22:45:34 -0700
Message-ID: <830861d2.0408112145.2699435b_at_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 - 07:45:34 CEST

This message: [ Message body ]
Next message: Zvika Glickman: "How to return a status from sqlplus to .ksh unix script ?"
Previous message: cs: "Re: Oracle Noob need help with function"
In reply to: Ping Ai: "Resizing the SGA"
Next in thread: Jan: "Re: PL/SQL error !"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message