The amount of memory to be used as a workarea for each sort.
Specifically, this parameter defines the maximum number of private memory pages to be used for private sorts or the maximum number of shared memory pages to be used for shared sorts.
A private sort is performed by an agent assigned to work for a specific application as a result of a connect request or, within a parallel environment, a new SQL request. When the application requires a sort, the database manager provides the sort heap from the agent’s private memory. (The database manager allocates private memory to the agent when the agent is assigned to work for the application.)
A shared sort is performed by agents working on behalf of an application within a partitioned environment or within an instance in which the INTRA_PARALLEL parameter is turned on. When the application requires a sort, the database manager allocates the sort heap from the database shared memory. The agents then share the sort heap to coordinate the sort.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
