FreeLists / oracle-l / understanding orphaned processes (v$process > v$session)

["Singh, Ratnesh (GEI, GEFA, Contractor)" <Ratnesh.Singh@xxxxxx>]

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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------