Solved

Sizing the PGA

Posted on 2011-03-24
4
336 Views
Last Modified: 2012-05-11
What is the best way to determing the optiminal size of the pga_aggregrate_target?
0
Comment
Question by:msimons4
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 35206975
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
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 35207031
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
 

Author Comment

by:msimons4
ID: 35209233
Is there a way to plot the inverse of sort area and see where the inflection point is?
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 35209349
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

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle dataguard 5 61
Field name with special character (Ñ) in Oracle 11 141
Oracle 12c Default Isolation Level 17 56
oracle forms question 22 48
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question