Daniel Fink wrote:
> In the 3 hours leading up to the latest occurrence, there were only
> 1800 transactions total, using less than 600 undo blocks, no
> stealing/release/reuse of undo blocks (both expired and unexpired). It
> is a time of almost no activity (when compared to normal daily
> processing).
>
> This is what makes the error so odd.
>
> Regards,
> Daniel Fink
>
The size and quantity of the transactions are irrelevant. What's
relevant is when the queries started and whether or nor undo_retention
was set higher than the duration of the queries. Also relevant would be
the size of the undo_ts *if* it were reaching 100% full causing undo
blocks to be reused before the retention period was over.
--
To reply by email remove "_nospam"
Received on Wed Jan 25 2006 - 12:33:01 CST
