PGA_AGGREGRATE_TARGET

what is PGA_AGGREGRATE_TARGET??
dbaseekAsked:
Who is Participating?
 
Daniel StanleyDatabase engineerCommented:
When setting this parameter, you should examine the total memory on your system that is available to the Oracle instance and subtract the SGA. You can assign the remaining memory to PGA_AGGREGATE_TARGET.

good luck,
daniels
0
 
dbaseekAuthor Commented:
please
0
 
rbrookerCommented:
PGA_AGGREGATE_TARGET = <value>
controls how much memory the instance should allocate, in total, for all workareas used to sort/hash data

:)
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.

All Courses

From novice to tech pro — start learning today.