Re: How am supposed to know which init file I am using pfile or spfile?

Hi there

if you are using unix, then give this command in the prompt

ps -ef |grep pmon

Usually it says pmon_initxxx.ora something..

xxx is the name of the instance.

now go to $ORACLE_HOME/dbs and look for all init*.ora

you should see initxxx.ora.. That should be your file

regards

NP

On Fri, 27 Dec 2002 09:33:38 GMT, EriK Miller <bopew2000_at_yahoo.com> wrote:

> Hi guys,
>
> I have a strange question here,
> How am I going to find out which init file my instance is using?
> Since I always start my instance by issue "startup" without any
> parameter, I am really sure which init file I am actually using.
>
> It may appears stupid and unnecessary, but I need know that.Thanks!
>

-- 
Prabhakar Narayanan