understanding orphaned processes (v$process > v$session)

From: Singh, Ratnesh (GEI, GEFA, Contractor) <Ratnesh.Singh_at_ge.com>
Date: Fri, 30 Apr 2004 11:42:08 -0400
Message-ID: <53C7726C165C4B46B5470C1A20EDBC4A012833DF@LYHMLVEM01.e2k.ad.ge.com>

Hi=20

We are getting "com.ibm.websphere.ce.cm.StaleConnectionException: = Connection is closed" error in our Application. The following qry returns me ~ 70 rows.
select count(*) from v$process where addr not in (select paddr from = v$session);

We are not using MTS.
I believe it is these orphaned processes that are responsible for these = errors.

1. I'm trying to understand what actions cause orphaned processes ?=20
2. Can we create/reproduce orphaned processes at will ?
3. Why isnt Oracle able to clean up these orphaned processes = automatically ?
4. How to clean up these orphaned processes on Oracle side ?
5. How to inform the application connection pool that these sessions are = no longer valid ?

thanks & regards
ratnesh=20

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Apr 30 2004 - 10:40:02 CDT