Re: Oacle 7 Signon Slow

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Oct 1999 21:36:57 GMT
Message-ID: <380e3560.34406853@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 - 16:36:57 CDT