Go Premium for a chance to win a PS4. Enter to Win

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

PGA_AGGREGRATE_TARGET

what is PGA_AGGREGRATE_TARGET??
0
dbaseek
Asked:
dbaseek
1 Solution
 
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
 
Daniel StanleyCommented:
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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