Re: SQL*PLUS terminating slowly

From: Hans Georg Reinfeld <hg.reinfeld_at_uni-bielefeld.de>
Date: Thu, 26 Aug 1999 15:04:42 +0200
Message-ID: <37C53B6A.C1546665@uni-bielefeld.de>

 
 

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@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

I'm not able to give any answer to your questions, please ask tmgn@excite.com!

Received on Thu Aug 26 1999 - 08:04:42 CDT