select p.SPID, p.SERIAL# as proserial,p.PID as pid, s.SID as sessionid,      
s.SERIAL# as sessseri, s.USERNAME,s.OSUSER,s.MACHINE,
      s.PROGRAM,s.ACTION,s.STATUS
from v$session s, v$process p
where s.PADDR=p.ADDR and s.SID in (select session_id from v$locked_object  where object_id in (select object_id from dba_objects
where wner='&schema' and object_name='&name'));