一、ORACLE鎖表

1、查找引起鎖表的SQL語句及原因

    CREATE OR REPLACE FORCE VIEW SYS.ygzhoulocktable (SID,
                                                  serial#,
                                                  locked_mode,
                                                  oracle_username,
                                                  user#,
                                                  os_user_name,
                                                  machine,
                                                  sql_text,
                                                  logon_time,
                                                  action
                                                 )
AS
   SELECT   ses.SID, ses.serial#, LOCKED.locked_mode, LOCKED.oracle_username,
            ses.user#, LOCKED.os_user_name, ses.machine, SQL.sql_text,
            ses.logon_time, SQL.action
       FROM v$session ses, v$locked_object LOCKED, v$sqlarea SQL
      WHERE LOCKED.session_id = ses.SID AND ses.prev_sql_addr = SQL.address
   ORDER BY ses.SID, ses.serial#;

2、解除鎖表現象

     ALTER SYSTEM KILL SESSION 'SES.SID,SES.SERIAL#'; 

                          OR  KILL -9 PID

二、MSSQL Server鎖表的SQL語句及原因

1、sp_who2

             查看 SPID>50 的STATUS    BLKBY

      SP_WHO2 SPID

      DBCC INPUTBUFFER(SPID)