Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> oracle killed session still holding locks

oracle killed session still holding locks

From: Jean <test_at_est.com>
Date: Fri, 29 Oct 2004 14:35:36 +0200
Message-ID: <3810FD4EAD8AD611A50D00805F0DA7FA066B2A27@proxyusinor.usinor.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US