RE: understanding orphaned processes (v$process

From: Ravi Kulkarni <kulkarni.ravi_at_heb.com>
Date: Fri, 30 Apr 2004 13:02:46 -0500
Message-id: <0HWZ00KG6WSM29@sys98048.heb.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Singh, Ratnesh (GEI, GEFA, Contractor)
Sent: Friday, April 30, 2004 10:42 AM
To: oracle-l_at_freelists.org
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.

I'm trying to understand what actions cause orphaned processes ?=20
Can we create/reproduce orphaned processes at will ?
Why isnt Oracle able to clean up these orphaned processes = automatically ?
How to clean up these orphaned processes on Oracle side ?
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

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

Received on Fri Apr 30 2004 - 12:59:58 CDT

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