Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: db cache size in oracle 9ir2

Re: db cache size in oracle 9ir2

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Fri, 21 Nov 2003 21:59:36 GMT
Message-ID: <cVvvb.114580$jy.9044@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. Received on Fri Nov 21 2003 - 15:59:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US