Re: how to figure out how much redo sql statements are generating?

Hi,

I normally use the following query to get the redo information:

select b.name stat_name, sum(a.value)
  from v$sesstat a, v$statname b
 where a.statistic# = b.statistic#
   and b.name like '%redo%'
group by b.name ;

Regards

Asif Momen
http://momendba.blogspot.com

ryan_gaffuri_at_comcast.net wrote: We are generating alot of redo. We have sql loader data loads and dml on the database. I am trying to track which parts of the application are probably generating the most redo. Is there a way to do this?
--

http://www.freelists.org/webpage/oracle-l