DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Finding Out Which SQL Statements Cause Redo?

  1. 09-25-2007, 01:34 PM #1
    paulb
    paulb is offline Junior Member
    Join Date
    Jun 2007
    Posts
    23

    Question Finding Out Which SQL Statements Cause Redo?

    What's the best way to find out which specific SQL statements (DML) caused redo? We've seen our archive logs grow rapidly lately, and I'd like to pinpoint which process/statements are causing all that redo. Is there a way to look at historical statements to see how much redo they generated?

    Thanks.
    Reply With Quote Reply With Quote
  2. 09-25-2007, 02:22 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    use log miner on the archive redo log files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width