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

Home -> Community -> Usenet -> c.d.o.server -> Re: Updating a Field ( number (6) ) in 300.000 Rows cause 200 M RBS

Re: Updating a Field ( number (6) ) in 300.000 Rows cause 200 M RBS

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Fri, 18 Jun 1999 09:36:57 +0200
Message-ID: <7kcst2$ei1$1@korweta.task.gda.pl> 





Karl Reitschuster wrote in message <37695F79.8017048C_at_t-online.de>...


>What is with the Rest? or does Oracle put the whole row to the RBS?





In rollbacks Oracle stores __whole__ undo blocks, not change vectors.
So in the worst case rollback may contain all previous table and
indexes blocks.


HTH,



-- 


Piotr Kolodziej pkol_at_otago.gda.pl


Just my private opinion.

Received on Fri Jun 18 1999 - 02:36:57 CDT












Original text of this message













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