Re: db cache size in oracle 9ir2

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 23 Nov 2003 11:11:24 -0800
Message-ID: <1069614711.928403@yasure>

Comments in-line.

Niall Litchfield 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

>
>
> This I buy, though I'd like to reduce further the number of changes that
> require a restart, or to put it another way increase the number where
> scope=memory or scope=both is valid.

I agree. Some of the changes that require a bounce make no sense to me at all.

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

>
>
> This I don't buy, for a start they are going to bounce the 'changed'
> database to no effect :(

Exactly. And then they actually look for someone to help them and we find out what they were trying to do and nip it in the bud.

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK

-- 
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 Sun Nov 23 2003 - 13:11:24 CST