On Fri, 30 Apr 1999, John Girifalco wrote:
> Ari, 
> 
> I have a question. Once an instance is up and running, how can you tell
> what initialization 
> file the database was started with? Is there an entry in one of the
> v$tables? Any help you 
> may provide regarding this question will be greatly appreciated. Thank
> you. 
> 
> John Girifalco 
> DBA duPont Hospital for Children 
> 
John,

You need to query the V$PARAMETER view:

SQL> desc v$parameter
 Name                            Null?    Type
 ------------------------------- -------- ----
 NUM                                      NUMBER
 NAME                                     VARCHAR2(64)
 TYPE                                     NUMBER
 VALUE                                    VARCHAR2(512)
 ISDEFAULT                                VARCHAR2(9)
 ISSES_MODIFIABLE                         VARCHAR2(5)
 ISSYS_MODIFIABLE                         VARCHAR2(9)
 ISMODIFIED                               VARCHAR2(10)
 ISADJUSTED                               VARCHAR2(5)
 DESCRIPTION                              VARCHAR2(64) 

The key columns are NAME, VALUE, and ISDEFAULT. If ISDEFAULT is "FALSE"
then it is set in the init.ora file or indirectly through another init.ora
value.

So, a good query is:

SELECT NAME, VALUE
FROM V$PARAMETER
WHERE ISDEFAULT = 'FALSE';

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 280+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page ../index.htm"> Back to Ari Kaplan's Home Page