From: "Ketan Shah" <shahkn@home.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server
References: <3af13196$0$43047$456d72a3@news.skynet.be>
Subject: Re: Howto check which init.ora file the instance is using ?
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <pQ3J6.50476$B22.12668504@news1.rdc2.pa.home.com>
Date: Sun, 06 May 2001 03:48:37 GMT
NNTP-Posting-Host: 65.9.136.164
X-Complaints-To: abuse@home.net
X-Trace: news1.rdc2.pa.home.com 989120917 65.9.136.164 (Sat, 05 May 2001 20:48:37 PDT)
NNTP-Posting-Date: Sat, 05 May 2001 20:48:37 PDT
Organization: Excite@Home - The Leader in Broadband http://home.com/faster


in svrmgr do show parameter all. It should show an entry for PFILE and this
is the one which is being used. Also check v$parameter table.

"Matthias Hoys" <matthias@reference.be> wrote in message
news:3af13196$0$43047$456d72a3@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 ?
>
>