Re: Oacle 7 Signon Slow

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Thu, 21 Oct 1999 08:21:42 -0400
Message-ID: <380F0556.1F0D5AEF@Unforgettable.com>

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?

Try adding:

oracle_trace_enable = false

to you initxxx.ora. There is a bug in 7.3.3 which causes tracing to be turned on if you don't explicitly turn it off. Received on Thu Oct 21 1999 - 07:21:42 CDT