Objects Being Accessed:
select client_identifier,program,state,object,module, action,s.*
from gv$session s , gv$access a
where status='ACTIVE'
and a.sid = s.sid and a.inst_id = s.inst_idand object in ('Object_name');
Objects are Locked by DDL:
select * from
DBA_DDL_LOCKS
where name = :name_object;
DBA_DDL_LOCKS
where name = :name_object;