Re: SQL*PLUS terminating slowly

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Thu, 26 Aug 1999 08:44:55 -0400
Message-ID: <37C536C7.438D5ADC@Unforgettable.com>

Hans Georg Reinfeld wrote:

> Hi,
>
> I had the same situation. I have done what tmgn proposed (see "Re:
> database login very slow" by "tmgn" on 23-Aug-99 at 16:18):
>
> << Just move  $ORACLE_HOME/otrace/admin/process.dat and regid.dat
> files to a
> << Backup Location and see the difference.  Or you can set
> EPC_DISABLED=TRUE in
> << U'r Session statup files.
> <<
> << The reason is becos Oracle Tracing is enabled by default in 7.3.3
> version
> << and it slows down the Connections.
>
> It helps also when exiting SQL*Plus!
>
> Hans Georg .
>
> ALianto schrieb:
>
>> Hi,
>>
>> I always following this newsgroup, but I didn't find the solution of
>> my
>> problem. The problem is,
>>
>> when user, who using the SQL*PLUS, exit from SQL*PLUS at Unix
>> prompt. He/She
>> will  waiting for 1-2 minutes after that to find his/her prompt.
>>
>> What the problem had been occured with the Oracle ?
>>
>> We are using Oracle 7.3.3 running under HP UX 9000 model K380.
>>
>> Regards,
>> Alianto
>> alianto_at_mincom.co.id
>

Was this problem fixed in 7.3.4? I was once told that I needed to delete the process.dat and regid.dat filea and set ORA_TRACE_ENABLE = false.

I have never seen the EPC_DISABLED parameter before. What is its function?

Ken

Received on Thu Aug 26 1999 - 07:44:55 CDT