Couldn't you look at the name of the db in the pfile and compare it to
the sid in sqlplus?
KK
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Shahid Nasir
Sent: Tuesday, July 03, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L
Subject: PFILE location in NTHi all,
I have two parameter files in two different directories on the same machine. Is there a way I can find out which parameter file is being used by the database.One way I tried was to make the changes in one file and see if it takes effect when the database is restarted. but I have more than 52 machines and it will be time consuming to do the same for all machines especially when these machines are on remote locations.
Thanks.
Shahid.