RE: 9i poll on spfile feature
- From: "David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Sep 2004 16:55:03 +0100
Yes, alter system set xxx =3D yyy scope =3D spfile|both|memory
Spfile will edit the spfile, both will do spfile and in memory. Memory
will do just memory - note some parameters you cannot do both or memory
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Weiss, Rick
Sent: 24 September 2004 16:29
To: 'BSpears@xxxxxxxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
Subject: RE: 9i poll on spfile feature
Brian:
I am currently using SPFILE on my 9.2.0.5 production environment.
As an additional request from the experts: I keep my INIT.ORA files
around
in case I want to adjust my instance parameters, (I just edit the
INIT.ORA
and recreate the SPFILE). Is there any easier way to do this??
Thanks
Rick Weiss
Oracle Database Administrator
Technical Services Bureau
Central Services Division
MT Dept of Labor & Industry
Helena, MT
Phone: (406) 444-9628
E-Mail: rweiss@xxxxxxxxxxx
-----Original Message-----
From: Spears, Brian [mailto:BSpears@xxxxxxxxxxxxxxxxx]
Sent: Friday, September 24, 2004 9:17 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 9i poll on spfile feature
Just wanted to see what people have resorted to using in real world
practice with the spfile.
With 9i, are you still using the init file or have you migrated to
using
the spfile ?
If still using the Init file.. What is the main reason for continuing to
using the init file.
Brian
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
