Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to kill a session that marked for kill

how to kill a session that marked for kill

From: Sigrid Staudte <mstaudte_at_rz.uni-leipzig.de>
Date: 1997/12/01
Message-ID: <34830B6D.5C2B38E5@rz.uni-leipzig.de>#1/1

In the database a session is running that runs and runs and blockade ressources, locks tables and so on. The session is never ending.
It is not possible to kill this session
with the alter system kill session command. The session is only marked for kill. The only way to terminate the session is shutting down the database. Knows anywhere another way to solve this problem?

Bye...Sigrid Received on Mon Dec 01 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US