-
session killed still locking a package
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?
-
I found the thread number, it is the spid in v$process view, if i try to use orakill on it, it says: Could not attach to Oracle instance 78: err = 2, any idea why?
-
Ok sid is the oracle sid, not the session sid, and it killed the process and i have to more lock on my package.
HEY, i post a question and answer my question by myself, thats the first time i see that
-
run this script to find out OSPID
select substr(s.sid,1,3) sid,substr(s.serial#,1,5) ser,
substr(osuser,1,8) osuser,spid ospid,
substr(status,1,3) stat,substr(command,1,3) com,
substr(schemaname,1,10) schema,
substr(type,1,3) typ,
substr(decode((consistent_gets+block_gets),0,'None',
(100*(consistent_gets+block_gets-physical_reads)/
(consistent_gets+block_gets))
),1,4) "%HIT",value CPU,
substr(block_changes,1,5) bchng,
substr(consistent_changes,1,5) cchng
from v$process p, v$SESSTAT t,v$sess_io i ,v$session s
where i.sid=s.sid and p.addr=paddr(+) and s.sid=t.sid and
t.statistic#=12
once you got the OSPID, do the following command
ORAKILL SID_NAME OSPID
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|