renny_at_eircom.net wrote:
> Hi Sybrand,
>
> Thanks for the response.
>
>
>>This should explain why a rollback is 'slower' and why your method is
>>very strange.
>
>
> Yes, I agree what we're doing with our test suite is a perverse use of
> a database - from your reply it would seem that the slow performance of
> rollbacks compared to commits is something we'll have to live with.
>
> Kind regards,;
>
> Renny
And in 9i you should not be using rollback segments at all. Rather
you should be using UNDO where you have nothing to say about anything
except retention time. The two versions you mention are best
configured with completely different solutions.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Sep 15 2005 - 10:51:18 CDT
