Estimate undo tablespace size
Posted on 2006-06-05
I have seen oracle document to estimate undo tablespace in oracle 10g/any version of oracle is given below.
Undospace = (Undo Retention Period * Undo Blocks Per Second) + Overhead
The Overhead should account for metadata such as bitmaps.
Here i have a question.
Undo Retention period is set 30mints for my database and i would like to know how to find UNDO Blocks Per seconds and Overhead information.
Could you please any one give me detailed information.
Thanks & Regards,