Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Calculating RBS space needed
I am trying to calculate the amount of rollback space needed to complete an
update. Ex. Table A has column ContractID defined as Varchar2(16). The
average size for each record is 10 bytes. There are 5000 rows in the table.
There is an index on Table A on the ContractID field. I want to update the
ContractID for all 5000 rows. How do I calculate the amount of rollback
space?
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 17 1999 - 15:24:15 CST