Sizing Undo tablespace

Hi
 
I am trying to size my undo tablepsace by looking at the undo rates.i.e the 
column UNDOBLKS in v$undostat.
 
Value for undoblks for particular sql is 13841 and my database size is 8kb.Does 
this mean that i need to have a undo tablespace size of 
 
select 8192*13841/1024/1024 from dual
108Gb ?
 
Not the particular sql does a corelated update ofmere  72762 rows and the 
figure of 108Gb doesnt make much sense .This is a JDBC app and i dont have much 
idea if this sql is in some for loop or something.
 
regards
Hrishy
 
regards
Hrishy
 


      

Other related posts: