Re: sqlplus hanging on exit

Jared,

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

jkstill_at_cybcon.com 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 7.3.4.5, 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: http://www.orafaq.com
-- 
Author: Louis Avrami
  INET: avramil_at_concentric.net

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: ListGuru_at_fatcity.com (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).