Re: Oracle 7.3.2.2 - Login taking forever

From: Denny Koovakattu <denny_vk_at_my-deja.com>
Date: Thu, 15 Jul 1999 14:42:11 GMT
Message-ID: <7mks00$hk5$1@nnrp1.deja.com>

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