Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! How to find pfile
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