"Paul" <lagarutte_at_yahoo.fr> wrote in
news:3810FD4EAD8AD611A50D00805F0DA7FA064C7CE9_at_proxyusinor.usinor.com:
> Hi,
> how can i determine whici is the current initSID.ora used to start the
> instance in case when there are many of inti file in different directory.
> I know that the standard is ORACLE_HOME\databases.
> Is there any sql command to show me this ?
>
No, there is no such command/query.
Keep in mind that some/many parameters can be changed
"on the fly" after the DB has started which could
complicate matching existing parameter values to any file.
Also keep in mind that for newer versions of Oracle the
initSID.ora is deprecated & replaced by SPFILE
Received on Fri Oct 08 2004 - 09:13:54 CDT
