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

From: Asif Momen <>
Date: Tue, 1 Jan 2008 02:48:31 -0800 (PST)
Message-ID: <>


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

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


Asif Momen 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?

Never miss a thing. Make Yahoo your homepage.
-- Received on Tue Jan 01 2008 - 04:48:31 CST

Original text of this message