FreeLists / oracle-l / Re: how to figure out how much redo sql statements are generating?

[Asif Momen <asif_oracle@xxxxxxxxx>]

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? 
--
http://www.freelists.org/webpage/oracle-l




       
---------------------------------
Never miss a thing.   Make Yahoo your homepage.