Re: Oacle 7 Signon Slow

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
Received on Wed Oct 20 1999 - 19:44:28 CDT