Re: db cache size in oracle 9ir2

"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.

> 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 :(
>
> You have no idea how many times I've been saved from these people by the
> fact that they never learned about recompiling the sp file.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************