Re: Disabling ROLLBACKS ... ??

It isn't possible as it will blow away the essence of databases: the transactional mechanism.
Also you will be unable to recover your database (which is an automatic rollforward and an automatic rollback)
If you think your app will gain performance, you are mistaken. There are so many areas of Oracle you can tune, that you simply shouldn't ask this question before you have tuned all these other areas. In my 10+ years experience the rollback segments *never* were a *real unresovable* problem, and you won't gain anything by disabling them, except you will be fired when something really goes wrong.

Regards,

Sybrand Bakker, Oracle DBA

"Raphaël ROBIN" <rrn_at_netsecuresoftware.com> wrote in message news:8psrpv$ok4$1_at_reader1.imaginet.fr...
> Hi !!
>
> I'd like to know if it is possible to disable the ROLLBACK mechanism in
> Oracle 8i ?? I think my app will gain performance in this case .... What
 do
> you think about it ??
>
> Thank you for your answer.
>
> Raphaël ROBIN - <rrn_at_netsecuresoftware.com>
>
>
>
Received on Fri Sep 15 2000 - 05:13:51 CDT