Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Delayed block cleanout causing ora-1555?

Delayed block cleanout causing ora-1555?

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Thu, 01 Mar 2007 15:51:19 GMT
Message-ID: <XDCFh.4039$Tg7.2752@trnddc03> 





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

Received on Thu Mar 01 2007 - 09:51:19 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US