RE: 9i poll on spfile feature

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <BSpears@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 24 Sep 2004 13:10:42 -0400

Well, I'll disagree with Rachel.  True having an INIT file is not =
currently broke, but without it you can't modify system parameters, like =
shared_pool_size on the fly.  So yes I have migrated to them, of course =
I'va also added "create pfile=3D<name> from spfile" to my shutdown =
script, along with "alter database backup controlfile to trace".

Save that there bacon, it's mine!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Spears, Brian [mailto:BSpears@xxxxxxxxxxxxxxxxx]
Sent: Friday, September 24, 2004 11: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 =
the spfile ?

If still using the Init file.. What is the main reason for continuing to
using the init file.



Other related posts: