Re: How do I find the init.ora file?

Hi,

If you don't specify a parameter file to use when you start up, it'll use the default..if you want to look at some stats you can check v$instance,v$sga, or v$parameter to see what your settings are..or, if it's reasonable to do so, just shut down and restart but specify a parameter file name

startup pfile = directory/directory/init.ora

Hth,

Steve

In article <3A3A579A.E60A1AA6_at_gmx.de>,
  Christian Wandrei <Christian.Berlin_at_gmx.de> wrote:
> Hi Al,
>
> thank you very much for your answer. But these are only the default
> directories for the init.ora file. It is possible to start Oracle
 using an
> init.ora file in a different directory. If there are two files - one
 in the
> default directory and another one anywhere else - how do I find out
 which
> one was actually used when the instance was started.
>
> Best regards Jan Dieckmann
> (sorry for the incorrect email address. I use the pc of my friend
 Christian
> Wandrei)
>
> alistair.thomson_at_sphinxcst.co.uk wrote:
>
> > It depends what version of oracle you're using and platform.
> >
> > On Oracle 7 / 8 it will be in
> >
> > NT: d:\orant\database
> > UNIX: $ORACLE_HOME/dbs
> >
> > with 8i it will be in
> >
> > NT: oracle_home\admin\sid_name\pfile
> > UNIX: $ORACLE_BASE/admin/sid_name/pfile
> >
> > Hope it helps
> >
> > Al
> >
>
>

Sent via Deja.com
http://www.deja.com/ Received on Sat Dec 16 2000 - 12:22:33 CST