Re: Oacle 7 Signon Slow

In article <7ulni7$1g9$1_at_holly.prod.itd.earthlink.net>,   "Charles Hansis" <chansis_at_earthlink.net> wrote:
> You can also mv the $ORACLE_HOME/otrace/admin/*.dat files. This
prevents any
> tracing an any of you instances. Otherwise you would have to make the
> changes stated below for every instance of the 7.3 db. I noticed a
dramatic
> improvement in sql*net connect times after making the changes that
mention
> above. The .dat files on some of my servers had approached 40M. (Bad
SysA
> and DBA).
>
> Jim
>
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> news:380e3560.34406853_at_news.demon.nl...
> > On Wed, 20 Oct 1999 20:21:35 GMT, redknot_at_my-deja.com wrote:
> >
> > >On an otherwise idle system (HP 9000/HP-UX 10.20) it takes about 30
> > >seconds just to sign-on to Oracle (ie. the time from entering the
> > >password to receiving the prompt in sqlplus).
> > >
> > >What could cause this? It seems to happen in all of out 7.3.3
instances
> > >but in none of our 8.0.5 instances (same server). What tables, etc.
> > >should I look at?
> > >
> > >Thanks.
> > >
> > >
> > >
> > >Sent via Deja.com http://www.deja.com/
> > >Before you buy.
> >
> > 7.3.3...
> > Should be Oracle Trace, which was on by default in 7.3.3 only.
> > Go into svrmgrl and type show parameter epc
> > (I never remember if it was EPC_ENABLE or EPC_DISABLE)
> > Then you need to define an env var in the Oracle .profile or .login
> > to make sure this is set to FALSE instead of TRUE.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > Hth,
> >
> >
> > Sybrand Bakker, Oracle DBA
>
>

Thanks for the help. Getting rid of the .dat files did the trick. It's amazing how much difference it makes to not wait 20 seconds to connect. Thanks again.

Brian

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 21 1999 - 08:24:06 CDT