Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

sqlplus hanging on exit

From: Louis Avrami <>
Date: Fri, 16 Mar 2001 01:04:17 -0800
Message-ID: <>

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:

PDOM:SYS> exit
Disconnected from Oracle7 Server Release - Production With the distributed, replication and parallel query options PL/SQL Release - Production

It can take over a minute for a command-line prompt to finally appear. If I do a 'ps -fu userid' in another window while the exit is hanging, I can see the sqlplus session process still there.

Even more interesting, if I am running 'top' in another window, when exiting I can seem the CPU usage % climb astronomically, as well as the system load average. When the sqlplus session finally ends and returns a command-line prompt, the CPU and load averages back down. I/O is negligible.

This server has 4 CPUs and 4 gig of memory. The SGA of the database is approximately 250 meg, so I don't think it's a resource issue.

It appears that all utilities that connect to the database are exhibiting this same symptom. svrmgrl, exp, imp, they all seem to hang for over a minute after they start to exit.

I have relink oracle and all of it's utilities. It doesn't seem to have made a

Everything in the init.ora and /etc/system seem to be ok. I have used the same settings for serveral other database servers. No other have exhibited this behavior.

If anyone has any clues as to what might be causing this problem, they would be greatly appreciated.


Lou Avrami


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 Fri Mar 16 2001 - 03:04:17 CST

Original text of this message