On Mar 1, 7:51 am, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> Oracle 9.2.0.7
>
> Is there any way determine authoritatively if an ORA-1555 "snapshot too
> old" error was caused by delayed block cleanout? I suspect it is
> happening on overnight processing but am not 100% sure. The query starts
> at 2am and failed at 3:30. Undo retention is 7 hours so that's not the
> problem, and a query of v$undostat for that time period shows only about
> 1g of undo being written during that time. The undo tablespace is 4g.
>
> TIA
Can you compute full statistics on all objects related to your
overnight processing before 2AM?
jg
--
@home.com is bogus.
http://www.thisistrue.com/
Received on Thu Mar 01 2007 - 19:39:27 CST
