Re: Killed sessions lock some tables

DavidS wrote:

> How can I definitely kill sessions marked as 'killed'?
> They lock some tables. Is it only way to restart database?

They are likely rolling back. After all, you do not want a killed process just to stop and abort, leaving behind partial transactions, inconsistent data and a screwed database.

> I would like to awoid this, if it is not inevitable.

Ah.. the trick is not to have to kill sessions in the first place. Killing sessions must be an exception.

As soon as it becomes so common that you're looking for ways to overcome the locks issue, then you have a more serious problem on your hands than killed sessions still being busy.

> Do I have to kill some windows processes?

Rather not.

> I cannot find any related in Task Manager.

Which is a Good Thing (tm). Task Manager only shows processes that have Window handles. Non-interactive processes (and threads) do not create (or seldom do create) windows.

> Any hint would be greatly appreciated

Seeing like you have a propensity for killing stuff, you're not perhaps interested in signing up for the Gulf War : Episode 2? ;-)

--
Billy