Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.3.2.2 - Login taking forever
Hi,
These files are used by Oracle*Trace. I believe it is enabled by default since 7.3.x .
Regards,
Denny
In article <378D55B4.82424222_at_bigfoot.com>,
Doug Cowles <dcowles_at_bigfoot.com> wrote:
> This sounds like a great success story but help me out here..what
> are those files?
>
> Denny Koovakattu wrote:
>
> > Hi,
> >
> > This could be due to Oracle writing to the trace files process.dat
and
> > regid.dat . Go to $ORACLE_HOME/otrace/admin directory and check for
the
> > size of these files. Run otrccref to reset these file to the default
> > size. Also set the environment variable EPC_DISABLED to TRUE and/or
add
> > the following entry in the $TNS_ADMIN/listener.ora.
> >
> > SID_LIST_TEST =
> > (SID_LIST =
> > (SID_DESC =
> > (ORACLE_HOME = /u01/app/oracle/product/734)
> > (SID_NAME = TEST)
> > (ENVS='EPC_DISABLED=TRUE') <------- Add this line
> > )
> > )
> >
> > Regards,
> > Denny
> >
> > In article <378A5E64.E340BAF5_at_unisys.com>,
> > Susan Halligan <susan.halligan_at_unisys.com> wrote:
> > > <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> > > <html>
> > > We are running an Oracle 7.3.2.2 on Solaris 2.6 It has
> > been
> > > up and running for almost a year with no problems. We have
> > noticed
> > > in the past month or so that when we login using SQL*Plus
2.3.2.2.0
> > that
> > > it is taking up to 90 seconds to get to the SQL prompt. Any
> > ideas?
> > > We are not running auditing, redo logs are ok, temp TS is
ok.
> > Once
> > > logged in performance is fine.
> > > <p>Thanks,
> > > <br>Susan</html>
> >
> > --
> > Denny Koovakattu
> > denny_at_vitalsol.com
> > http://vitalsol.com/
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
>
--
Denny Koovakattu
denny_at_vitalsol.com
http://vitalsol.com/
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Jul 15 1999 - 09:42:11 CDT