Oracle裡查看物件被誰鎖定

select * from v$session
where SID = (
      select SID from v$lock where id1=(
             select object_id
             from user_objects
             where object_name=UPPER('TEMPBUFFER')
      )
)