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