—查询死锁
    select s.sid,
    s.machine,
    o.object_name,
    l.oracle_username,
    l.locked_mode,
    ‘ALTER SYSTEM KILL SESSION ‘’’ || s.sid || ‘, ‘ || s.serial# ||
    ‘’’;’ Command,s.SQL_EXEC_START
    from v$locked_object l, v$session s, all_objects o
    where l.session_id = s.sid
    and l.object_id = o.object_id ;