Sort memory

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raj - 19 Apr 2006 21:59 GMT

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

Reply to this Message

Phil Sherman - 20 Apr 2006 01:46 GMT

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

> How can we increase the size of sortheap for individual sorts?
> sortheap db parameter is the max mem that can be allocated for private
[quoted text clipped - 5 lines]
>
> Thanks a lot for your time..

Reply to this Message