Home » RDBMS Server » Performance Tuning » excess redo generation
excess redo generation [message #463449] Thu, 01 July 2010 07:05 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 04 08:05:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.