Thursday 7 December 2023

Oracle Objects Being Accessed by Programs/Users

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_id
and object in ('Object_name');


Objects are Locked by DDL:

select * from
DBA_DDL_LOCKS
where name = :name_object;