What is the _PGA_MAX_SIZE parameter?
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 the _PGA_MAX_SIZE parameter?
Rating:
_PGA_MAX_SIZE is a hidden parameter for Oracle PGA regions. It specifies the maximum size of the PGA memory for one process. The value for this parameter defaults to 200MB.
Rating:
Was this information helpful?
Other articles
- What is the Resumable Space Allocation feature?
- What is the CROSSCHECK command?
- What are non-critical files?
- What is a large pool?
- What is a redo log file?