Home » RDBMS Server » Performance Tuning » Configuration of PGA Aggregate Target
Configuration of PGA Aggregate Target [message #175929] Tue, 06 June 2006 02:30 Go to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
I am seeing following statistics in OEM

Aggregate PGA Target 20 MB
Current PGA allocated 55621 KB
Maximum PGA allocated 80323 KB
cache Hit Percetage 54.07%

Here, Current and MAX PGA are exeeding the "Aggregate PGA Target"
Is it happening because sort segments are only allocated an are not de-allocated till database is bounced?

If this is the case what is the actual pupose of "Aggregate PGA Target"?

Please suggest on this.

Thanks in Advance,
Pratap

Report message to a moderator

Re: Configuration of PGA Aggregate Target [message #176024 is a reply to message #175929] Tue, 06 June 2006 07:32 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Your PGA aggregate target is under sized, so Oracle allocates more memory to it. Remember, a target is the preferred value to aim for - not a minimum or maximum value.

Report message to a moderator

Re: Configuration of PGA Aggregate Target [message #179213 is a reply to message #175929] Mon, 26 June 2006 06:52 Go to previous message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Hi,

You have to read oracle database documentation with ther topic PGA Aggregate Target.Which is very helpfull to allocate perfact size of PGA.Oracel database documentation is available with Examples. if you face any problem please send me the mail & i will send you soft copy of document.

bye

jimit

Report message to a moderator

Previous Topic: Question on 10.2.0.2 patch application on 10.2.0.1 database
Next Topic: convert partition table to normal table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 01:55:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.