What is PGA_AGGREGATE_TARGET?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is PGA_AGGREGATE_TARGET?
Rating:
PGA_AGGREGATE_TARGET is an Oracle server parameter that specifies the target aggregate PGA memory available to all server processes attached to the instance.
Some of the properties of the PGA_AGGREGATE_TARGET parameter are given below:
- Parameter type: Big integer
- Syntax:
- Default value: 20% of SGA size or 10MB, whichever is greater
- Modifiable: ALTER SYSTEM
Rating:
Was this information helpful?
Other articles
- What is the ALTER SYSTEM statement?
- What is DBA_CLUSTERS?
- What is high water mark?
- What is a granule?
- What is the DISTINCT clause?