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