数据库数据锁定的有关问题
--数据库锁定的记录
select sess.sid,
       sess.serial#,
       lo.oracle_username,
       lo.os_user_name,
       ao.object_name,
       lo.locked_mode
  from v$locked_object lo, dba_objects ao, v$session sess
where ao.object_id = lo.object_id
   and lo.session_id = sess.sid;

---140      78        MSJL          PC2011031300NIM\Administrator   NC_DELIVETOSAOUT      3
---行id   锁标识      数据库用户         哪一台机器                 被锁表             锁模式


----解锁方式,将“行id”和“锁标识”赋给下面的语句即可解锁
alter system kill session '137,455';


--锁定的数据情况
select sid,type,id1,id2,lmode,request,block from v$lock order by sid  ;

--session情况
select * from v$session where sid in (137 ,149);

--查询具体锁定与被锁定的sql语句
select wb.holding_session as 被锁定的会话id,
       sb.username as 被锁定的用户,
       qb.sql_text as 被锁定的sql语句,
       sb.machine as 被锁定的机器,
       sb.terminal,
       wb.waiting_session as 等待执行的会话id,
       sw.username as 等待执行的用户,
       qw.sql_text as 等待执行的sql语句,
       sw.machine as 等待执行的机器,
       sb.terminal,
       wb.LOCK_TYPE as 锁的类型,
       wb.mode_held,
       wb.mode_requested,
       wb.lock_id1,
       wb.lock_id2
  from dba_waiters wb,
       v$session   sb,
       v$session   sw,
       v$sqlarea   qb,
       v$sqlarea   qw
where wb.holding_session = sb.sid
   and wb.waiting_session = sw.sid
   and sb.prev_sql_addr = qb.address
   and sw.sql_address = qw.address
   and wb.mode_held <> 'None';