Oracle查询锁表语句，根据数据库用户进行查询

// add by 2009-9-11  begin as
注：查询锁表语句，根据数据库用户进行查询，如TOPENG
select a.owner,
       a.object_name,
       a.subobject_name,
       a.object_type,
       l.session_id,
       l.oracle_username,
       l.os_user_name,
       se.SID,
       se.SERIAL#
  from  all_objects a, v$locked_object l,V$session se
where a.object_id = l.object_id
       and se.OSUSER = l.os_user_name
       and l.oracle_username = 'TOPENG';

杀session,可以解锁表的功能
alter system kill session 'SID,SERIAL#';

//end 2009-9-11



局点：
文莱(BMobile)，利比来(Libya)，伊拉克(UFone)，标准版(standard)，南非
Load Payment File
无主付费