2_Session_Execution_Time.sql

2_Session_Execution_Time.sql

SELECT /*+ rule */ b.SID, b.SERIAL#, a.SPID SO_PROC,

trunc((b.last_call_et/60),2) Minutos, b.USERNAME, b.STATUS, 

b.OSUSER, b.MACHINE, b.program, b.module

from v$process a,v$session b

where a.ADDR = b.PADDR

and b.STATUS='ACTIVE'

and b.USERNAME is not null;