where STATISTIC# in (select STATISTIC# from v$statname where name like '%redo%')
and value>0
order by value
/
NAME
----------------------------------------------------------------
spare statistic 2
SQL> select name from v$statname where STATISTIC#=194;
NAME
----------------------------------------------------------------
redo size
SQL> select name from v$statname where STATISTIC#=197;
NAME
----------------------------------------------------------------
redo size for direct writes
No comments:
Post a Comment