A shared sort happens when the co-ordinator agent 'spawns' subagents to perform a bit of SQL ... Memory is allocated from the database shared memory, so that all the sub-agents can use the memory for sorting ... This happens when INTRA_PARALLEL is set to YES ..
A private sort happens when the co-ordinator agent executes the SQL ... Memory is allocated from the agent's private memory ...
Even if INTRA_PARALLEL is enabled, depending on the query, the optimizer may decide to use private sorts ...
Originally posted by pushp
Can anybody explains How the database manger /Optimizer determines sort will be of kind shared or private, because in each case memory sources are different .
Appreciates your quick response
Visit the new-look IDUG Website , register to gain access to the excellent content.