Re: db cache size in oracle 9ir2

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.

-- 
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)