SELECT s.osuser, s.username, s.sid, a.object tablename, a.owner,
       decode(a.ob_typ,2,’DDL’,’DML’) lock_mode
FROM   sys.v_$session S,
       sys.v_$access A
WHERE  a.sid = s.sid  
AND    a.object   like nvl(upper(‘&TableName’||’%’),’%’)
AND    s.osuser   like nvl(lower(‘&OS_User’||’%’),’%’)
AND    s.username like nvl(lower(‘&UserName’||’%’),’%’)
AND    a.ob_typ in (2,4) 
ORDER
   BY  1, 2, 3, 4