Re: Killed sessions lock some tables

snapkad_at_post.cz (DavidS) wrote in
news:bf5a3209.0303130407.6831d8a9_at_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
>

The Session marked as Killed will be evenetually cleared by Oracle PMon when... The session may be busy rolling back the changes that it performed when it was active.

As regards avoiding this problem.. Check your Applicxation and see if the the developers have written code that locks objects unneccarily.

HTH

-- 
Best Regards,
Ganesh R

======================================
Live to Learn.. Forget and Learn Again
======================================