If you know which tables are affected by which parts of the application, dba_tab_modifcations can give insert/update/delete activity on the tables. I believe monitoring has to be turned on for that though (its on by default). On Dec 31, 2007 12:58 PM, <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 > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'