RE: how to figure out how much redo sql statements are generating?
Date: Sun, 6 Jan 2008 00:40:29 -0800 (PST)
I usually use the following query to monitor the amount of redo generation:
select s.username, s.sid, t.addr, t.status, t.used_ublk, t.used_urec, decode(bitand(t.flag,128),0,'NO','YES') rolling_back from v$session s, v$transaction t where s.taddr=t.addr;
Hope you find this helpful.
David Kurtz <info_at_go-faster.co.uk> wrote: 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 redo.
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
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com DBA Blogs: PeopleSoft: http://blog.psftdba.com, Oracle: http://blog.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
>Sent: Monday, December 31, 2007 6:58 PM
>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?
-- http://www.freelists.org/webpage/oracle-l --------------------------------- Looking for last minute shopping deals? Find them fast with Yahoo! Search. -- http://www.freelists.org/webpage/oracle-lReceived on Sun Jan 06 2008 - 02:40:29 CST