I am a software engineer and working as an Oracle Apps DBA. I have started this blog to share my knowledge with others . Here you can find stuff related to Oracle DBA,Oracle Applications DBA,
select p.spid, s.sid,s.process cli_process,s.last_call_et/3600 last_call_et ,
s.status,s.action,s.module,s.program
from gv$session s, gv$process p
where
p.addr=s.paddr
and s.MODULE like ('%TOAD%')
Order by last_call_et;
No comments:
Post a Comment