What is the SORT_AREA_RETAINED_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 SORT_AREA_RETAINED_SIZE parameter?

Rating:

The SORT_AREA_RETAINED_SIZE parameter is used to specify (in bytes) the maximum amount of the user global area (UGA) memory retained after a sort operation is complete.
Some of the properties of the parameter are given below:

  • Parameter type: Integer
  • Default value: The value of the SORT_AREA_SIZE parameter
  • Range of values: The value ranges from the sum of two database blocks to the value of the SORT_AREA_SIZE parameter.


Rating:



Other articles

Click here to Article home

MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+

Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g, 1Z0-040: Upgrade to OCA 10g Fundamentals I, Oracle Fundamentals II, Admin I, Oracle Admin II, PL/SQL CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.
 
HACKER SAFE certified sites prevent over 99.9% of hacker crime.