tiptop解table_lock

SELECT   s .sid,   s .   serial# ,   s .   username ,decode(   l .type,   'TM' , 'TABLE LOCK' , 'TX' ,   'ROW LOCK' ,NULL)   LOCK_LEVEL   ,

o . owner , o . object_name , o . object_type , s . terminal , s . machine , s .program, s . osuser

FROM   v$session s ,   v$lock l ,   dba_objects o

WHERE   l .sid   =   s .sid

AND   l .   id1   =   o .   object_id (+)

AND   s .   username   is   NOT   Null

and   object_name =   'FAJ_FILE'

ALTER   SYSTEM   KILL   SESSION   'sid,serial#'