We had a session that the SysAdmin killed in UNIX via 'kill -9' instead of letting us kill it via onmode. However, the end user is having a problem logging in. It appears that the old session still has a lock out there somewhere. Is there a simple way to figure out which lock this orphan session has and kill it?
Use the query below to identify what locks this session had, maybe you will need restart the IDS to normalize this situation.
select substr(trim(dbsname) || "." || trim(tabname),1,30) as banco_tabela,
substr(rowidlk,1,8) as linha, type as tipo,
substr(sid,1,8) as sessao, substr(username,1,8) as usuario,
substr(is_wlock,1,1) as blk,
substr(waiter,1,8) as sesblk
from syslocks l, syssessions s
where l.owner = s.sid
order by 4