select p.spid,s.username, s.sid,s.status,t.disk_reads, s.last_call_et/3600 last_call_et_Hrs, s.action,s.program,s.machine cli_mach,s.process cli_process,lpad(t.sql_text,30) "Last SQL" from gv$session s, gv$sqlarea t,v$process p where s.sql_address =t.address and s.sql_hash_value =t.hash_value and p.addr=s.paddr and t.disk_reads > 5 and s.status='INACTIVE' and s.process='1234' order by S.PROGRAM;
Theo dõi
Đăng nhập
0 Góp ý