Re: Sort_area_size parameter for the instance

From: Iosif Tanasescu <a_at_j.smith>
Date: 28 Apr 1998 22:57:01 GMT
Message-ID: <01bd72f9$04b7f5f0$5f1b67d1@iosif>

kayartho_at_norcross.rms.slb.com wrote in article <6i4sd0$e6t$1_at_nnrp1.dejanews.com>...
> 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?

Yes of course, you can have much more than 64kBytes. The reason why your instance not start could be an inapropiate initxxxx.ora after
you made your modification in the init file.

Note that this parameter is for each session , so if you put , let's say sort_area_size=1000000
and you have 10 users connected in the same time, who need sorting operation, on the server yuo will need more than SGA, another 10*10000000 space!
So, increase the value carefuly, see the results.

Bye!

> Thanks,
> Ravi
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Tue Apr 28 1998 - 17:57:01 CDT