Avira Oracle SQL Card dead process

--Identify SID names
SELECT * from v$access where object = ' Pkg_smssend_proc ';
--Using SID to isolate SPID
Select Spid,osuser, S.program from V$session s,v$process p where s.paddr=p.addr and s.sid= (select SIDs from V$access wher E object = ' Pkg_smssend_proc ');
--Killing process
Login to SSH, kill-9 spid

Select Spid,osuser
From V$session S, v$process p
where s.paddr = P.addr
and S.sid in (the Select Sid from V$access where object = ' Pkg_smssend_proc ');
Pkg name to capitalize



--The second type
[View Lock]
Select A.object_name| | ' | ' | | b.session_id| | ' | ' | | c.serial#| | ' | ' | | c.program| | ' | ' | | c.username| | ' | ' | |c.command| | ' | ' | | c.machine| | ' | ' | |
C.lockwait from All_objects a,v$locked_object b,v$session C where a.object_id=b.object_id and c.sid=b.session_id;

[Unlock]
Alter system kill session ' Session_id,serial '

Avira Oracle SQL Card dead process