Oracle數(shù)據(jù)庫(kù)查找被鎖以及解鎖的解決辦法

    oracle查找被鎖以及解鎖
    SELECT s.sid||','||s.SERIAL#, s.serial#, s.username, s.schemaname, s.osuser, s.process, s.machine,
    s.terminal, s.logon_time, l.type
    FROM v$session s, v$lock l
    where ((s.sid = l.sid
    AND s.username IS NOT NULL))
    and
    (terminal = 'CHINA-C742905EE')
    alter system kill session '383,32773';
    第一條sql是找出被鎖，第二條解鎖