Re: db cache size in oracle 9ir2

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 22 Nov 2003 17:14:16 +1100
Message-ID: <3fbefec4$0$13591$afc38c87@news.optusnet.com.au>

"Bricklen" <bricklen-rem_at_yahoo.comz> wrote in message news:cVvvb.114580$jy.9044_at_clgrps13...
> Daniel Morgan wrote:
>
> > Bricklen wrote:
> >
> >> Ed Stevens wrote:
> >> <snip>
> >> So . . . now, how can I tell for sure if they are using an spfile?
> >> <snip>
> >> try:
> >> show parameter spfile
> >>
> >> I believe if value is undefined, you are using an init.ora file, else
> >> it will show you the path to your spfile
> >>
> >
> > Missed the original post but show parameter spfile has nothing to do
> > with it.
>
> My apologies, it was assumption I made after noticing that the value of
> that parameter was null whilst using init.ora, ubt then displayed the
> path (?/dbs/spfile@.ora) after the spfile option was implemented.
>

Bricklen, you're spot on. If you're using an spfile, show parameter spfile displays a value. If it's null, you're using an init.ora. Not quite sure what Daniel was on about.

Regards
HJR Received on Sat Nov 22 2003 - 00:14:16 CST