Re: Sessions are not removed from v$session

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Mon, 7 Sep 2009 20:51:33 -0700 (PDT)
Message-ID: <99674629-39f7-4f4c-884f-502fb8f59860_at_i4g2000prm.googlegroups.com>

Check values of V$SESSION.PROGRAM, V$SESSION.PROCESS to confirm that program that created these sessions no longer runs.
Confirm that sessions are not removed by checking number of threads in ORACLE.EXE.

If program that created sessions no longer runs but Oracle does not close sessions then it
could be a bug. Try to configure Dead Connection Detection. Received on Mon Sep 07 2009 - 22:51:33 CDT

This message: [ Message body ]
Next message: yossarian: "Re: FreeTDS"
Previous message: lsllcm: "SELECT on ASSM tablespace"
Maybe in reply to: Boguslaw Pazur: "Sessions are not removed from v$session"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message