Ethan,
I think focusing on which transaction generates more redo will be more helpful than which object ... right?
Let me know if I didn't understand your question completely ...
Raj
-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
-----Original Message-----
From: Post, Ethan [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 21, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: Oh Where Oh Where Is My Redo Coming From
Just had a thought here, have not tried it yet. I have a database that I am
working with that is generating 28 GB of redo each day. I would really like
to know what objects are generating all this redo without going through the
hassle of mining a bunch of log files. It occurred to me that if table
monitoring is active and my stats are up to date I should be able to
multiply the total number of updates, inserts and commits by the average row
size and get a rough % of what objects are generating the most redo.
I am sure there are a number of other factors I need to consider, any ideas
what they are?
* Should I weight inserts, updates and deletes?
* ??
The goal is to identify the objects, then identify the jobs that work on
those objects and see if I can reduce redo. I suspect a lot of this redo is
being generated because of some poor design issues.
Thanks!
- Ethan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
