RE: 9i poll on spfile feature

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Sat, 25 Sep 2004 02:54:20 +1000
Message-Id: <200409241654.i8OGsI7u002528@rgmgw1.us.oracle.com>

Rick

Someone else has already mentioned the ALTER SYSTEM command.  If you still =
want the init.ora hanging around as a backup or something, you can simply u=
se the CREATE PFILE command once you've changed the SPFILE with an ALTER SY=

STEM command to give you the complete picture.

IIRC, you need an SPFILE for the dynamic SGA stuff to work correctly, so Ru=
th's more conservative "if it ain't broke don't fix it" approach also disab=
les some of the ease of management functionality as a side effect.  This ca=
n be particularly problematic in a 24x7 shop, where you don't have the opti=

on to bounce the database to reflect init.ora changes.

HTH.
=

Pete
=

"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook
=

"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] = On Behalf Of Weiss, Rick
Sent: Saturday, 25 September 2004 1:29 AM 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 - 11:50:18 CDT