RE: Shooting yourself in the spfile
- From: Brian McGraw <brian.mcgraw@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Feb 2004 08:52:44 -0600
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
---------------------------------
| Brian McGraw -+- Senior DBA |
| mailto:Brian.McGraw@xxxxxxxxx |
---------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Grabowy, Chris
Sent: Friday, February 20, 2004 8:18 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Nuno Souto
Sent: Thursday, February 19, 2004 4:40 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx
----- Original Message -----
From: "Jonathan Gennick" <jonathan@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
>
> 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:
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
