Re: sqlplus hanging on exit

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: 
  INET: jkstill_at_cybcon.com

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).