Re: db cache size in oracle 9ir2

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 22 Nov 2003 06:44:30 +1100
Message-ID: <3fbe6b2a$0$14031$afc38c87@news.optusnet.com.au>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1069360098.420598_at_yasure...
> Niall Litchfield wrote:
> > edit the init.ora or use alter system. this should be documented at
> > http://tahiti.oracle.com
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
>
> And nothing will happen.
>
> In 9i you must recompile the init.ora into the spfile
> for the change to take effect.

What??

Come on Daniel. Let's not use phrases such as "you must" when the spfile is entirely optional, and there are very good reasons for not using one.

Regards
HJR Received on Fri Nov 21 2003 - 13:44:30 CST