Find the OS process and kill it using kill -9 . Be carefull because some of then are backgorund process or parallel process for example so, use "ps -ef | grep ospid" before killing it. Example:
--Query to find the OSPID of session killed (for RAC run this query on each instance instead of using gv$ tables)
SQL>SELECT spid
FROM v$process
WHERE NOT EXISTS ( SELECT 1
FROM v$session
WHERE paddr = addr);
[hostname-SID1]/home/oracle> ps -ef | grep 2744432
oraebs 2601182 3592334 0 16:43:23 pts/7 0:00 grep 2744432
oraebs 2744432 1 0 16:59:17 - 0:00 oracleSID3 (LOCAL=NO)
This one you can kill but not this one below (This is a parallel process):
[hostname-SID3]/home/oracle> ps -ef | grep 5136530
oraebs 2601176 3592334 0 16:43:23 pts/7 0:00 grep 5136530
oraebs 5136530 1 0 Nov 07 - 7:44 ora_pz99_SID3
Best Regards,
Paulo Portugal
No comments:
Post a Comment