Menu de navegação

[diegomelloParticipante]

Aqui na empresa, uso essa query:
SELECT a.module
,c.job
,a.sid
,a.username
,a.osuser
,DECODE(b.event, 'db file scattered read', 'Full', 'Pesado') tipo
,TO_CHAR(a.logon_time, 'dd/mm/yyyy hh24:mi') logon
FROM v$session_wait b
,v$session a
,dba_jobs_running c
WHERE b.event IN ('db file sequential read', 'db file scattered read')
AND a.sid = b.sid
AND a.sid = c.sid(+)
ORDER BY a.username