Re: db cache size in oracle 9ir2

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 22 Nov 2003 17:13:09 +1100
Message-ID: <3fbefe81$0$13681$afc38c87@news.optusnet.com.au>

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:4husrv82rijp350sfah1fvffujo8m27ism_at_4ax.com...

>
> Just to diverge a bit -- I have just put up my first 9i database (in
> fact, it just went live to production within the last hour). It
> supports a purchased package, and was created by a vendor's script, so
> I really had no hand in that - had to just take what was handed me.
> So . . . now, how can I tell for sure if they are using an spfile?

In sql plus, just do 'show parameter spfile'. If it shows a value, you're using an spfile. If it's null, you're not.

Regards
HJR
> (Some time ago I had already decided I preferred to stick with
> init.ora files). I tried to dig it out of their creation scripts but
> they are difficult/impossible to read, buried under several layers of
> complex ksh scripts and at least one jar file, and I'm still a
> relative novice on unix.
Received on Sat Nov 22 2003 - 00:13:09 CST