Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to unset SORT_AREA_SIZE ?

how to unset SORT_AREA_SIZE ?

From: Frank Langelage <frank_at_lafr.de>
Date: Tue, 30 Dec 2003 22:13:06 +0100
Message-ID: <bsspp8$139fe$1@ID-48907.news.uni-berlin.de> 





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
Received on Tue Dec 30 2003 - 15:13:06 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US