First, get the sessid using the following sql: select unique dbsname db, tabname table, case when type=”S” then “shared lock” when type=”IS” then “intent shared lock” when type=”SIX” then “shared intent excl lock” when type=”XS” then “shared key value by RR” when type=”IX” then “intent excl lock” when type=”X” then “exclusive lock” when type=”XR” then… Continue reading Unlock Informix table
Category: SQL
Kill Oracle sessions
Some time the Oracle connections stay open, blocking the other transactions, there’s no other option than kill it. We firstly need to identify it, as system user, execute the following query: SELECT s.inst_id, s.sid, s.serial#, p.spid, s.username, s.program FROM gv$session s JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id WHERE s.type !=… Continue reading Kill Oracle sessions