Killed database sessions

From: Alex B. Danchenkov <dabr_at_leaves.spb.su>
Date: 1997/02/24
Message-ID: <01bc2259$99bf5c20$542b7dc1@dabr>#1/1

Hello

I have the following problem using Oracle Workgroup Server v.7.2 for Windows NT 3.51 :
The users connect to database server using SQL*Net v.1 for DOS. When I kill a database user session using command 'ALTER SYSTEM KILL SESSION ...' or Oracle Workgroup Server disconnects a user session which exceeded it's idle time profile limit then such killed session remains on the database server very long time with status "KILLED". Is there any ways to force Oracle Server to remove the killed sessions immediately?

Regards

---

Alex B. Danchenkov, Oracle Technical Expert, Leaves Inc. e-mail: dabr_at_leaves.spb.su Received on Mon Feb 24 1997 - 00:00:00 CST