Re: db cache size in oracle 9ir2

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 22 Nov 2003 16:01:53 -0800
Message-ID: <1069545738.980498@yasure>

Howard J. Rogers wrote:

> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1069539193.545809_at_yasure...
>

>>Come on Howard there are two other things the SPFILE is good for.
>>
>>1. On-line permanent parameter changes

>
>
> Achievable by remembering to edit your init.ora. Quite why 'alter system'
> plus edit init.ora is any worse than 'alter system and remember to
> scope=spfile if you *don't* want it to be permanently changed', I can't work
> out.

I'll give you this one. But only because of the intrinsic logic of your arument.

> In other words, all the spfile does is shift the 'burden of proof', as it
> were. In the old days, I could dynamically alter something and be assured
> that such a change would NOT automatically become permanent. Now, I have to
> explicitly ask it not to be.

And that isn't an improvement? ;-)

>>2. Keeping incompetent DBAs from making changes because they change the
>>init.ora and think they've changed the database.

>
>
> I don't believe it wise to design a system to deal with the incompetent, and
> I know you don't really believe that either.

Humor ... humor ... must I emoticon everything?

> But when they've done all of that, you have to ask why you need an spfile at
> all. If you are going to store parameters in a binary file, why not stick
> them in the control file itself and have done with it? Guess what I reckon
> will happen around 13.5z??
>
> Regards
> HJR
Personally I'd like to see the control files go too. I still haven't figured out why we need them as separate files.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sat Nov 22 2003 - 18:01:53 CST