RE: 9i poll on spfile feature

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Fri, 24 Sep 2004 11:29:21 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F8BF@exchsen0a1ma>

Brian,

We are still using the init file. I just (right now) see no need to use the spfile. I like the init file as it is because I can put notes in it with dates of prior values when a change is made.

I know you can do something close to this with the 'alter' commands. But there does not seem to be a benefit to it. Because I can telnet to all of my servers, the need for the spfile (and remote shutdown/startup) is not really there for me.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

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

From: Spears, Brian [mailto:BSpears_at_Limitedbrands.com] Sent: Friday, September 24, 2004 11: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 Received on Fri Sep 24 2004 - 10:25:21 CDT