Home » RDBMS Server » Performance Tuning » Find a correct value for PGA_AGGREGATE_TARGET (Oracle 9i, AIX)
Find a correct value for PGA_AGGREGATE_TARGET [message #310795] Wed, 02 April 2008 07:50 Go to next message
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.
Re: Find a correct value for PGA_AGGREGATE_TARGET [message #310802 is a reply to message #310795] Wed, 02 April 2008 08:02 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I read that "The PGA_AGGREGATE_TARGET should be set to attempt to keep the ESTD_PGA_CACHE_HIT_PERCENTAGE greater than 95 percent."

Where?

Regards
Michel
Previous Topic: database buffer cache
Next Topic: insert took a lnog time.
Goto Forum:
  


Current Time: Sat Aug 19 11:58:51 CDT 2017

Total time taken to generate the page: 0.19341 seconds