Re: Which DML use more Rollback sapce?

From: Colin Sutherland <c.sutherland_at_easynet.com>
Date: 1998/04/27
Message-ID: <6i0a82$km8$1@apple.news.easynet.net>#1/1

Rollback extents are issued on an individual transaction basis, This means that no one particular statement can take up more than the other. It just depends on the transaction being under taken.

Colin.
brendan_o'brien_at_wrightexpress.com wrote in message <6hq0i7$h47$1_at_nnrp1.dejanews.com>...
>As far as I've always thought, all three 'write' DML statements use the
>identical amount of rollback segment space, that being the entire contents
of
>each affected row. If someone knows otherwise and wants to shatter my
world,
>I welcome the input...
>
>
>In article <353ED136.5335767_at_nortel.ca>,
> gchen <gchen_at_nortel.ca> wrote:
>>
>> Hi,
>>
>> Can anyone tell me which DML (insert, update,delete) use more space in
>> rollback segments?
>>
>> Thanks
>>
>> G.Chen
>> Nortel
>>
>> gchen_at_nortel.ca
>>
>>
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon Apr 27 1998 - 00:00:00 CDT