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: 64119
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: Usage of Materialized view to improve performance
Next Topic: insert took a lnog time.
Goto Forum:
  


Current Time: Tue Dec 06 08:23:11 CST 2016

Total time taken to generate the page: 0.10894 seconds