Killed sessions lock some tables

From: DavidS <snapkad_at_post.cz>
Date: 13 Mar 2003 04:07:29 -0800
Message-ID: <bf5a3209.0303130407.6831d8a9@posting.google.com>

How can I definitely kill sessions marked as 'killed'? They lock some tables. Is it only way to restart database? I would like to awoid this, if it is not inevitable.

Database is Oracle9i (specifically it is iasdb infrastructure DB from AS9i) running on Windows 2000 Server.

Do I have to kill some windows processes? I cannot find any related in Task Manager.
There is some OS Process ID in OEM at Sessions part but I presume it is not the same number as PID number in Task Manager at Processes tab in Win2k.

Any hint would be greatly appreciated

Thanx

David Received on Thu Mar 13 2003 - 06:07:29 CST