RE: 9i poll on spfile feature

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Weiss, Rick Sent: 24 September 2004 16:29
To: 'BSpears_at_Limitedbrands.com'; oracle-l_at_freelists.org 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_at_state.mt.us

-----Original Message-----

From: Spears, Brian [mailto:BSpears_at_Limitedbrands.com] Sent: Friday, September 24, 2004 9:17 AM To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 24 2004 - 10:49:19 CDT