Sort memory

[Raj]

How can we increase the size of sortheap for individual sorts?
sortheap db parameter is the max mem that can be allocated for private
sorts or shared sorts so the parameter which would sorts should be
app_ctrl_heap size or appheapsize rather than sort heap??
I read somewhere that e sort heap is allocated from agent private
memory .. so where does that come from? i mean what db parameter would
affect it??

Thanks a lot for your time..

[Phil Sherman]

Increase the size of of sortheap by allocating a larger sortheap. There
are one or two additional parameters that can also effect this.
Sheapthres and (depending on what version you are running)
sheapthres_shr. Sortheap is the (default) amount of storage allocated
when a sort starts. The sheapthres parameters control the maximum amount
of storage allocated for all concurrent sorts for the instance.

Search the online information center for the parameters to get full
details about using them.
Phil Sherman

Raj wrote:

How can we increase the size of sortheap for individual sorts?
sortheap db parameter is the max mem that can be allocated for private
sorts or shared sorts so the parameter which would sorts should be
app_ctrl_heap size or appheapsize rather than sort heap??
I read somewhere that e sort heap is allocated from agent private
memory .. so where does that come from? i mean what db parameter would
affect it??

Thanks a lot for your time..