In article <334A6A79.40B1910A_at_pmcgettigan.demon.co.uk>, Steve Phelan
<stevep_at_pmcgettigan.demon.co.uk> writes
>Todd Marshall wrote:
>
>> My application is taking input from the web, so I don't really need
>> rollback enabled. I know I can specify a transaction as 'read
>> only', but
>> how do I disable rollback for updates, inserts, and deletes?
>>
>> -Todd
>
> Er, if you are doing any form of updating you DO need rollback,
>regardless of where you are taking your data from. Why does the WEB make
>you think different? AFAIK, you cannot disable the use of rollback
>within Oracle (and even if you can, I wouldn't recommend it. Ditto for
>'redo', just in case that was what you meant and not 'rollback').
>
>Steve Phelan.
>
AFAIK Oracle will use rollback segments to guarantee read consistency
even if your query doesn't involve updates. It is not something you can
disable.
Andrew Knight e-mail: ack_at_tsm.co.uk
TSM Systems tel : +44 181 673 7750
London fax : +44 181 673 1335
http : www.tsm.co.uk
Received on Tue Apr 08 1997 - 00:00:00 CDT
