select a.object_name objectname,b.session_id,c.serial#,c.program program,c.username username,c.command,c.machine machine,c.lockwait from all_objects a,v$locked_object b,v$session c where a.object_id =b.object_id and c.sid=b.session_id

Related posts:

1. 如何使用跟踪事件10046
2. sqlplus下如何看执行计划
3. 如何导出用户下所有的sequence