Re: Sessions are not removed from v$session

From: vsevolod afanassiev <>
Date: Mon, 7 Sep 2009 20:51:33 -0700 (PDT)
Message-ID: <>

  1. Check values of V$SESSION.PROGRAM, V$SESSION.PROCESS to confirm that program that created these sessions no longer runs.
  2. 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

Original text of this message