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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
