Re: oracle killed session still holding locks

Jean wrote:

> Hi,
> i'm new to oracle,
> the version is 9.2 aix 5.1 64 bit
> I've killed a session, it's been 9 days since.
> It's still marked as killed in v$session
> after that i've killed the pid in unix by kill -9 <pid>
> The session is still here holding locks on one table.
>
> What can i do to get rid of this ?
>
> Are there any comands to show me what this session do, how many io, cpu
> (like sp_monitor in sybase) ?
>
> thx for help

shutdown abort comes to mind.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)