| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: understanding orphaned processes (v$process > v$session)
Ratnesh,
I too have seen this condition. I'm not sure I understand the client side mechanics, but from a server perspective, a process is created when an attempt to connect to the database is made, but a session is only created when the connection is actually made.
sqlplus /nolog <--- creates a process
connect scott/tiger <----- actually creates a session for the
process
We found that a particular app server was creating processes, but not sessions. It appeared that the username/password was not correct, but the app server was not disconnecting from the database, so the number of processes continued to climb, even though very few new sessions were being created. We contacted the app support team and they corrected the login. The problem then disappeared.
Daniel
"Singh, Ratnesh (GEI, GEFA, Contractor)" wrote:
>
> 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
> -----------------------------------------------------------------
-- 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 - 12:26:12 CDT
 |
 |