Home » RDBMS Server » Performance Tuning » how to find code causing redo to generate
how to find code causing redo to generate [message #269260] Fri, 21 September 2007 06:49 Go to next message
vikeshcool@hotmail.com
Messages: 27
Registered: August 2007
Junior Member
how can I find the code in the package
that causes the redo to generate.

Is there any way of finding this out

thanks in advance
Re: how to find code causing redo to generate [message #269264 is a reply to message #269260] Fri, 21 September 2007 07:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Every DML and DDL generates redo.
Be more precise in your question.

And why do you post this in Backup & Recovery forum????
I assume you have a performances problem and move it to this forum. If this is not the case then we'll move it in other forum later.

Regards
Michel

[Updated on: Fri, 21 September 2007 07:18]

Report message to a moderator

Re: how to find code causing redo to generate [message #269714 is a reply to message #269260] Mon, 24 September 2007 05:02 Go to previous messageGo to next message
vikeshcool@hotmail.com
Messages: 27
Registered: August 2007
Junior Member
actually in our project

we have 10 users

and in this system too many redo's are generated
so we just want to know as which part of our code
is generating these redo's so that we can
optimize the code.

As generation of too many redo's slowdown
the process and consumes a lot of space.

So, is there any way please let me know
or tell me how can i reduce the redo's

Re: how to find code causing redo to generate [message #269735 is a reply to message #269714] Mon, 24 September 2007 05:56 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
this system too many redo's are generated

Based on what this "too many"?

If you want to know what"s inside your log, use Log Miner.

Regards
Michel
Previous Topic: Variance in -Row Source Generation, Explain Plan and statspack
Next Topic: Index rebuild
Goto Forum:
  


Current Time: Sat Jun 29 08:18:21 CDT 2024