SQL> SELECT * FROM V$SESSION WHERE SID IN(SELECT SID FROM v$access WHERE object ='GCO_GENERAL' AND OWNER = 'DEMO40');

SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND OWNERID TADDR LOCKWAIT STATUS SERVER
-------- ---------- ---------- ---------- -------- ---------- ------------------------------ ---------- ---------- -------- -------- -------- ---------
2C0BDEA8 78 6414 271726 2C081FEC 114 DEMO40 47 2147483644 KILLED DEDICATED



This session is still locking my package, and i want to compile it, but i cant cuse it is lock!!!
The session is marked for kill and does not want to get the hell out and release the lock!!

Im thinking of using orakill, will it work, or will it try to kill an already killed session?
The orakill program ask me for sid, wich i know what it is, but what is the thread? It says thread is the id of the thread to kill. Im on windows platform, where do i get that thread number?