OraFAQ Forum: Performance Tuning » Find a correct value for PGA_AGGREGATE

Home » RDBMS Server » Performance Tuning » Find a correct value for PGA_AGGREGATE_TARGET (Oracle 9i, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Find a correct value for PGA_AGGREGATE_TARGET [message #310795]

Wed, 02 April 2008 07:50

agostino_neto
Messages: 180
Registered: July 2005

Senior Member

Hi all,
Is there a way to find a good value for PGA_AGGREGATE_TARGET ?
I read that "The PGA_AGGREGATE_TARGET should be set to attempt to keep the ESTD_PGA_CACHE_HIT_PERCENTAGE greater than 95 percent."
I tried the following query
--
select min (a.PGA_TARGET_FOR_ESTIMATE)
from v$pga_target_advice a
where a.ESTD_PGA_CACHE_HIT_PERCENTAGE > 95
--
The answer is NULL (There is no row with ESTD_PGA_CACHE_HIT_PERCENTAGE > 95).
How and where (pfile or spfile) can I set that parameter ?

Thanks.

Report message to a moderator