Re: Help! How to find pfile

From: Olivier <oberco_at_club-internet.fr>
Date: 2000/03/14
Message-ID: <8ajsii$h84$1@front4m.grolier.fr>#1/1

Hello,
or in SQL you can try :
select value from v$parameters where name = 'ifile'; Hope this help
BR
Olivier

"Em Pradhan" <empradhan_at_dplus.net> a écrit dans le message news: 38CD6DCD.CC871D2C_at_dplus.net...
> In unix
> find / -name init<SID>.ora -print
>
> and in NT I think from oracle home dir
> dir init<SID>.ora /s
>
> HTH
> pradhan
>
> sjoshi_at_ingr.com wrote:
>
> > Hello All
> > Quick question..is there an easy way to tell where an instance's pfile
> > is located from within Oracle
> >
> > thanks
> > Sunit
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
Received on Tue Mar 14 2000 - 00:00:00 CST