Re: About rollback consumption

for an insert, oracle needs only record (in the rollback segment) the rowid of the newly inserted row.

for a delete, oracle needs to record (in the rollback segement) the entire contents of the deleted row.

for an update, i'm not sure... it could be that oracle stores the entire row, or just the previous values of the modified columns.

but why is this important to you ?

"Pierre Charpenay" <pcharpenay_at_unilog.fr> wrote in message news:39D1DE3C.FEF72B67_at_unilog.fr...
> Hello !
>
> Does anyone know some rules about the rollback segments consumption for
> the statements :
>
> SELECT (none I suppose)
> INSERT (?)
> DELETE (?)
> UPDATE (?)
>
> I write them in a supposed growing consumption order. Can anyone confirm
> that ?
>
> Thanks
>
> --
> Pierre CHARPENAY
>
Received on Wed Sep 27 2000 - 22:38:25 CDT