It appears that the issue is with the way connections are closed by websphere. We had a similar issue with ArcPlan's DYNASIGHT. It turned out that there was a bug in the ArcPlan's Native Oracle Driver supplied. Switching to another driver(OLEDB) fixed the issue. Thanks, Ravi. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Singh, Ratnesh (GEI, GEFA, Contractor) Sent: Friday, April 30, 2004 10:42 AM To: oracle-l@xxxxxxxxxxxxx Subject: understanding orphaned processes (v$process > v$session) 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------