处理达梦锁问题

三板斧

select TRX_ID, LTYPE, LMODE, BLOCKED, TABLE_ID, TID from v$lock where blocked=1;

select sess_id sid,user_name,trx_id,create_time,appname,clnt_host,run_status,last_send_time ,substr(sql_text,1,40) txt from v$sessions where trx_id in (22359114);

select 'sp_close_session('||sess_id||');' k from v$sessions where trx_id in (select TRX_ID from v$lock where blocked=1);