Niall Litchfield wrote:
> Chuck wrote:
>> Oracle 9.2.0.7
>>
>> I got an ORA-1555 snapshot too old today on a export where consistent=y
>> was set. The export failed at 6 hrs even though undo_retention was set
>> to 8 hours. Querying v$undostat shows that during the time when the
>> export was running a total of only 150m of undo was written. The undo
>> tablespace is 4g. Why would I get an ora-1555 when undo_retention is set
>> plenty high enough, and the undoblks written weren't anywhere near
>> maxing out the undo tablespace?
>>
>> TIA
>
> because undo_retention is not guaranteed in 9.2 and therefore cannot be
> relied upon. Sad but true.
>
I thought it was only not guaranteed if the instance needed to start
reusing unexpired extents due to space constraints. Is that not so?
Received on Wed Dec 20 2006 - 10:47:08 CST
