DB - Oracle code currently accessed



PT : Como identificar codigo em uso  
EN : How to identify code currently in use

select a.sid, a.username,a.program, b.owner, b.object, b.type
 from   v$session a, v$access b
 where  a.sid = b.sid and object like 'ITEM_MASTER'

select  a.*, s.* 
from gv$access a, gv$session s 
where a.sid = s.sid and a.owner = 'RMS'

-----
Obrigado pela leitura, espero que este post o tenha ajudado :)
Thank you for reading, hope this post was helpful  :) 

Comments