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@xxxxxxxxxxx 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? -- //www.freelists.org/webpage/oracle-l --------------------------------- Never miss a thing. Make Yahoo your homepage.