— ———————————————————-
— File Name :
— http://www.oracle-base.com/dba/monitoring/session_undo.sql
— Author : DR Timothy S Hall
— Description : Displays undo information
— on relevant database sessions.
— Requirements : Access to the V$ views.
— Call Syntax : @session_undo
— Last Modified: 29/03/2005
— ———————————————————-
SET LINESIZE 200COLUMN username FORMAT A15
SELECT s.username,
s.sid,
s.serial#,
t.used_ublk,
t.used_urec,
rs.segment_name,
r.rssize,
r.status
FROM v$transaction t,
v$session s,
v$rollstat r,
dba_rollback_segs rs
WHERE s.saddr = t.ses_addr
AND t.xidusn = r.usn
AND rs.segment_id = t.xidusn
ORDER BY t.used_ublk DESC;
Inicio » Scripts sql curiosos » session_undo.sql
Pingback: Matar un sesión en Oracle « Cajón de sastre sobre oracle
Pingback: Oracle-Tablas del diccionario de datos | ACP-Servicios Informáticos
:]
Gracias