lunes, 24 de enero de 2011

ORACLE: identificar proceso oracle a través de una query.

sqlplus "/as sysdba"

set linesize 2500
col spid for a10
col physical_reads for 99999999999999
col username for a10
col machine for a10
col module for a35
col terminal for a10
col program for a20
col traceid for a50
alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';
set pagesize 1500
col high_value format 9999999999999999999


select distinct spid, s.sid, s.serial#, si.physical_reads, s.username , s.module "Module",
SUBSTR(s.machine,1,10) machine, s.client_info "Client Info", s.logon_time "Connect Time",p.TRACEID traceid
from v$session s, v$process p, SYS.v_$sess_io si
where s.paddr = p.addr(+) and si.SID(+) = s.SID
and s.module not like 'bridge%'
and s.username= 'esquema'
order by si.physical_reads asc;

No hay comentarios:

Publicar un comentario