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: How to find out concrete ORACLE_HOME via SQL?

Re: How to find out concrete ORACLE_HOME via SQL?

From: NitelyJoy <nitelyjoy_at_ist-einmalig.de>
Date: 14 Aug 2006 11:54:31 -0700
Message-ID: <1155581670.952833.273940@m79g2000cwm.googlegroups.com> 





> SQL> show parameter spfile

>

> NAME                                 TYPE        VALUE


> ------------------------------------ ----------- ------------------------------

> spfile                               string      /oracle/product/10g/dbs/spfile

>                                                  10G.ora

>




If the instance was started by pfile, you see nothing here, I'm
afraid...
Received on Mon Aug 14 2006 - 13:54:31 CDT












Original text of this message













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