Re: how to figure out how much redo sql statements are generating?
- From: Asif Momen <asif_oracle@xxxxxxxxx>
- To: ryan_gaffuri@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 1 Jan 2008 02:48:31 -0800 (PST)
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?
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Never miss a thing. Make Yahoo your homepage.
Other related posts:
