Re: Howto check which init.ora file the instance is using ?

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 4 May 2001 10:11:35 +0100
Message-ID: <988967500.3160.0.nnrp-01.c30bdde2@news.demon.co.uk>

I think once the database is up, it closes any file handles to the init.ora. So no would be my guess.

I 'validated' this theory by trying a 'fuser' on the init.ora. Of course, that doesn't mean it's held in a system view, but given files can reference others, I somehow doubt it...

The default is in $ORACLE_HOME/dbs of course - unless you did a 'startup pfile=...'.

"Matthias Hoys" <matthias_at_reference.be> wrote in message news:3af13196$0$43047$456d72a3_at_news.skynet.be...
> How can I see which initialization.ora file a currently running instance
is
> using ?
> Is there a system view to check this ?
>
>
Received on Fri May 04 2001 - 04:11:35 CDT