Re: how to unset SORT_AREA_SIZE ?

Frank Langelage wrote:

> Today I read that param SORT_AREA_SIZE shouldn't be used with Oracle
> 9.2.0.4 anymore. Instead PGA_AGGREGATE_TARGET should be used.
> My datebase was created with SORT_AREA_SIZE=5M and PGA_AGGREGTE_TARGET=24M.
> My question is: How do I unset this param ?
> I didn't find an "alter system"-command to do so.
>
> A possible way would be to create an init.ora from spfile, startup
> database with this and recreate the spfile.
>
> Regards
> Frank

Edit the init.ora
Recompile the spfile.
Restart the database.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)