RE: 9i poll on spfile feature

Tom,

        If you rely soly on a PFILE, no you can't unless you restart the = instance which is a pretty hard thing to do in the middle of the day, = especially when there are robots that are your clients.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

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

From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us] Sent: Friday, September 24, 2004 1:21 PM To: Goulet, Dick; BSpears_at_Limitedbrands.com; oracle-l_at_freelists.org Subject: RE: 9i poll on spfile feature

Dick,

What do you mean you can't modify system params? I can modify any = system
param on the fly. I just have to also to update the init.ora file.

Again, I'm not losing any functionality. And the number of times I = modify
the init.ora params I can count on one hand every three months.

I also added a database shutdown trigger to issue an "alter database = backup
controlfile to trace" in all my databases.

Tom Mercadante
Oracle Certified Professional

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

From: Goulet, Dick [mailto:DGoulet_at_vicr.com]=20 Sent: Friday, September 24, 2004 1:11 PM To: BSpears_at_Limitedbrands.com; oracle-l_at_freelists.org Subject: RE: 9i poll on spfile feature

Well, I'll disagree with Rachel. True having an INIT file is not =3D currently broke, but without it you can't modify system parameters, like = =3D
shared_pool_size on the fly. So yes I have migrated to them, of course = =3D
I'va also added "create pfile=3D3D<name> from spfile" to my shutdown =3D = 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_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 =3D = 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 - 12:27:20 CDT