| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rego generation while executing select statement
Sami:
Never trust the autotrace numbers. It may not be correct. Can you please run your test in an isolated environment and verify the the redo generation.
You can use the script at
http://www.jlcomp.demon.co.uk/faq/redologuse.html to find out how much
redo is filled in the current redolog. You can run your SELECT and
then run the script again to get the status of the current redolog. If
the delta is really big, (greater than or equal to the redo size
reported in autotrace), then you can dump the redolog contents or use
logminer to get the acutal redo records and that will tell the truth.
 |
 |