Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: sqlplus hanging on exit

Re: sqlplus hanging on exit

From: Louis Avrami <>
Date: Tue, 20 Mar 2001 22:27:39 -0800
Message-ID: <>


Thanks for the reply.

I'm embarrassed to say that the cause of the problem was Oracle Trace. The solution was to set EPC_DISABLE=TRUE in the environment and listener.ora, and stop and restart the database.

I remember doing this a couple of years ago, when Oracle Trace was first enabled by default.

Apparently one of my predecessors didn't set EPC_DISABLED anywhere, but simply removed the .dat log files under $ORACLE_HOME/otrace/admin. Does this mean that the trace overhead is still part of the Oracle processes, but just can't find the log files to write out to?

Lou Avrami wrote:

> You may want to check v$session_wait while the session
> is exiting and see if it's waiting on a resource in the
> the database.
> If that doesn't reveal anything, you may want to try
> truss on the server process and see what is going on there.
> ( assuming you aren't using MTS )
> Jared
> On Fri, 16 Mar 2001, Louis Avrami wrote:
> > Hello all,
> >
> > I recently had to migrate a legacy database to a Sun 420 running Solaris
> > 2.8, latest recommended patches. I installed RDBMS, created a
> > database and imported the data successfully.
> >
> > I have actually had to do this on several different servers (we're
> > finally scheduled to upgrade to RDBMS 8.1.7 next month). All have gone
> > well with the exception of one server.
> >
> > The symptoms of the problem seem to occur when trying to exit a
> > connection to this particular database. The exiting process seems to
> > hang for an unusually long period of time. For example, from the
> > command line, if I use sqlplus to connect to the database, the
> > connection starts up almost instananeously. SQL statements execute
> > quickly, with no apparent problems. However, when I try to exit, the
> > sqlplus session seems to just hang:
> ...

Please see the official ORACLE-L FAQ:
Author: Louis Avrami

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Mar 21 2001 - 00:27:39 CST

Original text of this message