Re: SQL*PLUS terminating slowly

From: Hans Georg Reinfeld <hg.reinfeld_at_uni-bielefeld.de>
Date: Thu, 26 Aug 1999 11:28:16 +0200
Message-ID: <37C508B0.6FEA214A@uni-bielefeld.de>

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

Received on Thu Aug 26 1999 - 04:28:16 CDT