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 -> Re: Un set parameter in spfile

Re: Un set parameter in spfile

From: zeb <spam_at_nowhere.com>
Date: Sun, 15 Aug 2004 13:38:03 +0200
Message-ID: <411f4aa2$0$29666$636a15ce@news.free.fr> 






"DK" <dakight_at_bellsouth.net> a écrit dans le message de news:
jMHTc.984$sl.260_at_bignews1.bellsouth.net...


> Is there a way to "unset" a parameter in an spfile.  I have a parameter

set


> (sessions_cached_cursors) that I'd like to take the default on.

> (HP11i/9.2.0.5).  Other creating an pfile from an spfile, modifying the

> pfile....., I don't see a way.

>

> TIA



alter system reset sessions_cached_cursors;



HTH

Received on Sun Aug 15 2004 - 06:38:03 CDT












Original text of this message













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