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

  • From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
  • To: ryan_gaffuri@xxxxxxxxxxx
  • Date: Mon, 31 Dec 2007 13:25:14 -0600

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.'

Other related posts: