OraFAQ Forum: Performance Tuning » excess redo generation

Home » RDBMS Server » Performance Tuning » excess redo generation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

excess redo generation [message #463449]

Thu, 01 July 2010 07:05

dalu
Messages: 7
Registered: June 2010

Junior Member

hi all,
how to Find Out Which SQL Statements Causing excessive Redo generation?

Thanks in advance

dalu

Report message to a moderator

Re: excess redo generation [message #463472 is a reply to message #463449]

Thu, 01 July 2010 08:42

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Define "excessive" and excessive relative to what.
A SQL statement generates the redo it needs to generate not more so can't be excessive.

Regards
Michel

Report message to a moderator

Re: excess redo generation [message #463473 is a reply to message #463449]

Thu, 01 July 2010 08:45

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Find Out Which SQL Statements
Seems Sessions Yes. Statements No.
Did you try Snapper?
http://blog.tanelpoder.com/2008/05/30/oracle-troubleshooting-with-snapper-detecting-whos-causing-excessive-redo-generation/

Demo with excellent discussion. Got nothing more to say.

Report message to a moderator

Re: excess redo generation [message #464203 is a reply to message #463473]

Tue, 06 July 2010 21:55

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

Change less data, generate less redo.

Kevin

Report message to a moderator

Previous Topic:	Description of Events
Next Topic:	parallel DDL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Oct 06 23:31:42 CDT 2025