| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shooting yourself in the spfile
I also heard, at a 10g presentation yesterday, that a lot of the new,
spiffy, automated tuning features require the exclusive use of the spfile.
Brian
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Grabowy, Chris
Sent: Friday, February 20, 2004 8:18 AM
To: oracle-l_at_freelists.org
Subject: RE: Shooting yourself in the spfile
I believe DataGuard requires spfiles. Like CBO, I believe its just a matter of time before more and more new features require spfile.
IMHO, if I have to make a change to a database, I want to do it from within the database not from the OS. We have a couple hundred databases, to manually update pfiles takes forever and is error prone, but running a bunch of ALTER DATABASE commands is quick/easy. YMMV.
(slithering back into my lurker corner)
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Nuno Souto
Sent: Thursday, February 19, 2004 4:40 AM
To: oracle-l_at_freelists.org
Subject: Re: Shooting yourself in the spfile
Fix the illness, not the symptom:
stop using the spfile. Totally unnecessary
feature.
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_optusnet.com.au
----- Original Message -----
From: "Jonathan Gennick" <jonathan_at_gennick.com>
To: <oracle-l_at_freelists.org>
>
> All this has underscored the importance of backing myself up
> when it comes to parameter changes, and I'm wondering about
> best-practices. What do you all do to protect yourself here?
> I can think of two alternatives:
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Feb 20 2004 - 08:52:44 CST
 |
 |