By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

Sort memory

P: n/a
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..

Apr 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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..

Apr 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.