Wednesday, June 15, 2016

Oracle - Kill Locked Sessions

Oracle - List Locked Sessions :-

SELECT    DO.owner
        , DO.object_name
        , DO.object_type
        , vs.SID
        , vs.serial#
        , vs.status
        , vs.osuser
        , vs.machine
        , vs.program
        , vs.module
        , vs.action
    FROM  v$locked_object vlo
        , v$session vs
        , dba_objects DO
   WHERE
        vs.SID = vlo.session_id
        AND vlo.object_id = DO.object_id
ORDER BY module

Oracle - Kill Locked Session :-

alter system kill session 'SID,serial#'
alter system kill session '145,47805'

Type Casting in C++

static_cast