Re: how to find if instance started by pfile or spfile

From: <sybrandb_at_hccnet.nl>
Date: Tue, 24 Apr 2007 21:00:17 +0200
Message-ID: <7rks231ohl8c74c04odeej80r43h17s9mi@4ax.com>

On 24 Apr 2007 11:56:35 -0700, esthershensh_at_yahoo.com wrote:

>Hi,
>
>I have a very stupid question to ask..
>
>is there any way to find which parameter file started the oracle
>instance?
>
>For example, is that pfile or spfile? location of the file ?
>
>can I find those info from dictionary views ?
>
>your help is very appreciated.
>
>Thanks.

Doc question, which also has been ask before.

Show parameter spfile

Will show the location of the spfile when started by spfile, will be NULL when started by pfile.
Easy and ALL documented.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Tue Apr 24 2007 - 14:00:17 CDT