select s.sid, s.serial#, n.name, ss.value
from v$sesstat ss, v$statname n, v$session s, v$sqlarea sq
where n.name in (
'undo change vector size',
'redo size')
and ss.statistic# = n.statistic#
and s.sql_address = sq.address
and ss.sid = s.sid
and sq.sql_id = '&sql_id'
order by s.sid,n.name desc, ss.value desc;
|