Re: Oracle architecture - any help would be preferred

Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote:
>"Martin" <mwolski_at_poczta.fm> wrote in message
>news:277610dc.0208210620.370edc27_at_posting.google.com...
>
>> Should I use undo management provided by Oracle9i??
>
>My take on this is yes. Otherwise you will have to create and size rollback
>segments appropriately.

I've now been told that the ORA-600 from Automatic Undo Management in 9.2.0.1 will be fixed in 9.2.0.2

However, the support analyst wasn't able to say when that'll be released.

(I've also heard rumours of poor performance with Automatic Undo Management in 9.0 - but haven't tested it myself, and don't know if that issue has been addressed in later patchsets.)

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/