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

[Ravi Kulkarni <kulkarni.ravi@xxxxxxx>]

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