Inactive Program

Inactive Program SELECT p.spid,s.sid,s.last_call_et / 3600 last_call_et_Hrs,s.status,s.action,s.MODULE,s.program,t.disk_reads,Lpad(t.sql_text, 30) “Last SQL”FROM gv$session s,gv$sqlarea t,gv$process pWHERE s.sql_address = t.addressAND s.sql_hash_value = t.hash_valueAND p.addr = s.paddrAND s.status = … Read more