Hi, I am trying to work out how much undo a session used when I ran a shrink command from EM after running the segment advisor. I can't find an answer to this in MOS or Google. While it is running I was running
select stn.name, sess.sid, sess.value
from v$statname stn, v$sesstat sess
where stn.statistic#=sess.statistic#
and sess.sid=142
and sess.statistic# in (193,84,14,100,323,194);
to give me this sort of info :
NAME SID VALUE
---------------------------------------------------------------- ---------- ----------
session logical reads 142 64697317
db block gets 142 64484203
db block changes 142 35691561
redo entries 142 17939195
redo size 142 4762952220
undo change vector size 142 1955647920
But I can't seem to find a way of getting undo info after the session/job has finished.
Any ideas please?