Tip on using the SORT_AREA_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.
Tip on using the SORT_AREA_SIZE parameter.
Rating:
Oracle does not recommend using the SORT_AREA_SIZE parameter to enable automatic sizing of SQL working areas, unless the instance is configured with the shared server option. However, the PGA_AGGREGATE_TARGET parameter is recommended. The SORT_AREA_SIZE parameter is retained for backward compatibility.
Rating:
Was this information helpful?
Other articles
- What is the Character Set Scanner utility?
- What is the DBMS_MONITOR package?
- What is an ASM instance?
- What is Globalization Development Kit (GDK) ?
- What is DMON?
