| My current session stats - display REDOs |
set lines 200
select substr(name,1,40) stat,
value
from v$statname n,
v$mystat t
where n.statistic# = t.statistic#
and (n.name like '%redo entries%' or n.name like '%redo size%')
order by value DESC
/
|