Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> oracle killed session still holding locks
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 Received on Fri Oct 29 2004 - 07:35:36 CDT