Re: how to figure out how much redo sql statements are generating?
Date: Tue, 1 Jan 2008 02:48:31 -0800 (PST)
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 ;
ryan_gaffuri_at_comcast.net 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.
http://www.freelists.org/webpage/oracle-l Received on Tue Jan 01 2008 - 04:48:31 CST