You can write a query by joining v$session and v$ssesion_wait and can come to know about who is using which object.