Hi All,

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

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 ...

HTH

Sathyaram