Re: db cache size in oracle 9ir2

Howard J. Rogers wrote:

> 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
I'll answer that question. I am currently on a W2K SP4 machine with Oracle 9.2.0.4 and 10.1.0.1. In both cases, I can assure you I am using the spfile. And in both cases:

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- 
------------------------------
spfile                               string 
%ORACLE_HOME%\DATABASE\SPFILE%
                                                  ORACLE_SID%.ORA

Well where the ? did that come from? I did this earlier and it returned no value.

I retract my statement and I'm going to bed.

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