ITPub博客

SORT_AREA_RETAINED_SIZE• When the sort completes and the sort area still contains sorted rows to be fetched,the sort area can shrink to the size specified by the parameterSORT_AREA_RETAINED_SIZE.• The memory is released back to the User Global Area (UGA) for use by the sameOracle server process (not to the operating system) after the last row is fetchedfrom the sort space.• The default value for this parameter is equal to the value of theSORT_AREA_SIZE parameter.SQL> select