Categorias
iiiiii
que esta ejecutando Oracle
Descripcion
que esta ejecutando o que procesos estan ejecutand
Scrippt
SELECT /*+rule*/
a.sid,serial#, a.username, b.INST_ID, trunc(plsql_exec_time/60) plsql_exec_time,
a.program, a.osuser, a.last_call_et, status,
TRUNC(a.last_call_et/60) || ' mins, ' ||MOD(a.last_call_et,60) || ' secs' running,
b.sql_text
FROM gv$sql b, gv$session a
where a.sql_address=b.address
and a.username is not null
and username in ( 'JULGOMEZ' ) -- a.username
and username NOT in ('SYS')
and a.inst_id = b.inst_id
order by a.last_call_et desc, 3;