Re: Rego generation while executing select statement
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: dba.orcl@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Feb 2005 21:57:53 -0800 (PST)
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.
=====
Have a nice day !!
------------------------------------------------------------
Best Regards,
K Gopalakrishnan,
Co-Author: Oracle Wait Interface: Oracle Press 2004.
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
