RE: Unidentified sessions brought us to maximum processes - more

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Tue, 02 Jul 2002 13:13:13 -0800
Message-ID: <F001.0048E521.20020702131313@fatcity.com>

I'm on 8.1.6.2, Solaris 2.6.

All the unidentified sessions were active but had no SQL associated with them.

Jay Miller

-----Original Message-----
Sent: Tuesday, July 02, 2002 3:43 PM
To: 'ORACLE-L_at_fatcity.com'

We just had a problem on our datawarehouse where we hit the maximum number of processes (had never happened before). When I checked in Enterprise Manager and v$sessions I saw dozens of sessions with no username or osusername attached.

I was able to resolve the issue with a shutdown abort and restart (after spending 15 minutes to get the requisite approvals).

There were no errors in the alert log and no trace files. Nothing odd on the Unix side either.

I'll be keeping my eye out for a recurrence and logging a TAR with Oracle but has anyone seen this sort of thing happen before?

Thanks,
Jay Miller
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.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). Received on Tue Jul 02 2002 - 16:13:13 CDT