Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • Last Modified:

Sizing the PGA

What is the best way to determing the optiminal size of the pga_aggregrate_target?
0
msimons4
Asked:
msimons4
  • 3
1 Solution
 
sdstuberCommented:
let your system run with realistic loads for a while then check V$PGA_TARGET_ADVICE


"realistic" and "a while" are going to be determined by your database and application.
If you have fairly uniform load that occurs all the time you might need only a few hours to give the system enough time to gather useful information.

If you have peaks and valleys of usage and/or of different types of activities it will take longer.  There is no absolute number that will apply to all.
0
 
sdstuberCommented:
you can also use information found in v$pga_target_advice_histogram to get a little more detailed view
but  I usually see the first view giving enough and the histograms simply support that info rather than provide different recommendation
0
 
msimons4Author Commented:
Is there a way to plot the inverse of sort area and see where the inflection point is?
0
 
sdstuberCommented:
where are you seeing sort area trending?

I don't see a column by that name in either of the views above in my db.

Are you referring to sort_area_size  v$parameter?

If so,  that's a single value,  there is no curve inflection for one point.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now