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

  • From: "David Kurtz" <info@xxxxxxxxxxxxxxx>
  • To: <ryan_gaffuri@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 5 Jan 2008 22:36:16 -0000

Statspack (or AWR) will give you an idea of when the database is producing
the redo, and that can be enough for you to work out what is generating the

Then if you need to collect details for specific sessions, you could collect
details from v$sesstat for individual sessions.  If you can't add your own
code to whatever you suspect is generting the redo you could perhaps using
triggers that fire after LOGON and before LOGOFF for specific programs, and
if you need more granularity before and after DML on specific tables - but
could end up collecting a lot of data that you will then work on.  Th

David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
Book: PeopleSoft for the Oracle DBA:
DBA Blogs: PeopleSoft:, Oracle:
PeopleSoft DBA Forum: 

>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx 
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of 
>Sent: Monday, December 31, 2007 6:58 PM
>To: oracle-l@xxxxxxxxxxxxx
>Subject: how to figure out how much redo sql statements are generating?
>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? 


Other related posts: