Re: Sort_area_size parameter for the instance

From: <cmohan_at_iname.com>
Date: Thu, 30 Apr 1998 11:40:51 -0600
Message-ID: <6ia9ij$sqc$1@nnrp1.dejanews.com>

I have SORT_AREA_SIZE of 1M, on Windows95. But my RAM is 64M. Sort_Area_Size that you specify has to reside in the RAM (and outside your SGA, within your PGA). So it depends on your RAM size, and your SGA size, along with other applications you have open on your machine.

Hope this helps,
CM

In article <6i4sd0$e6t$1_at_nnrp1.dejanews.com>#1/1, kayartho_at_norcross.rms.slb.com wrote:
>
> I am not able to increase the sort_area_size parameter for my oracle 7.3
> instance more than 64kbytes. If I increase in init.ora file and try to
restart
> the instance, it fails to start.
>
> Can I have this parameter more than 64 kbytes on Windows NT 4.0?
> Thanks,
> Ravi
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 30 1998 - 12:40:51 CDT