RE: how to figure out how much redo sql statements are generating?
- From: Asif Momen <asif_oracle@xxxxxxxxx>
- To: info@xxxxxxxxxxxxxxx, ryan_gaffuri@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Sun, 6 Jan 2008 00:40:29 -0800 (PST)
Hi,
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.
Regards
Asif Momen
http://momendba.blogspot.com
David Kurtz <info@xxxxxxxxxxxxxxx> 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
regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz@xxxxxxxxxxxxxxx
web: www.go-faster.co.uk
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
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
>ryan_gaffuri@xxxxxxxxxxx
>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?
>--
>//www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
Other related posts:
