Re: Difference between processes and sessions - SOLVED!

Dennis,

Probably what was happening is that the Attach function was starting the process, then the connect function tries to connect the session, but if the password is no good it fails. Instead of removing/detaching from the process, it probably started a new process and failed again. Repeating it self until it ran out of processes.

In OCI8 the attach and connect function are seperate calls and can cause these problems .....

Anjo.

DENNIS WILLIAMS wrote:
>
> FYI - we found the culprit. A Tomcat app server had an old Oracle password,
> so was apparently retrying an unsuccessful login. Weird.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Monday, February 17, 2003 3:37 PM
> To: 'ORACLE-L_at_fatcity.com'
>
> We got a error on one of our production systems that the maximum number of
> processes were exceeded. I've been trying to track this down but it makes no
> sense. There are 15 sessions in v$session and 49 processes in v$process
> (just 1 under the limit of 50, for now). I checked our other systems and
> sessions and processes are within 3 of each other. Can anyone think of what
> might be going on here? I bounced the instance but the problem recurred.
> Oracle 8.1.6 on Tru64 Alpha.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).