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:12:08 GMT
Message-ID: <Icvvb.114408$jy.59119@clgrps13> 





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
Received on Fri Nov 21 2003 - 15:12:08 CST












Original text of this message













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