Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which DML use more Rollback sapce?

Re: Which DML use more Rollback sapce?

From: <brendan_o'brien_at_wrightexpress.com>
Date: 1998/04/24
Message-ID: <6hq0i7$h47$1@nnrp1.dejanews.com>#1/1

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 Fri Apr 24 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US