Re: Killing a session

From: Greg Jackson <gjackson_at_pier1.com>
Date: 1996/12/19
Message-ID: <59brd4$b89@news0-alterdial.uu.net>#1/1

In article <32B8FD55.1A5_at_dircon.co.uk>
Tim Rogers <timr_at_dircon.co.uk> wrote:

> B C Zygmunt wrote:

>> Sometimes when I have killed a session the process stays "alive" until I shut
>> down the database.

> When you kill a session the database has to rollback the transaction. If
> the transaction is hefty it can take a while to rollback before finally
> disappearing.

You can rollback the transaction manually to get the session out quicker by getting the transaction ID from v$transaction and then use

ROLLBACK WORK FORCE '<transaction_ID>';

greg jackson
gjackson_at_pier1.com Received on Thu Dec 19 1996 - 00:00:00 CST