Rollback segments size calculation

[Shibu MB]

 

        Hi all
         
        I am getting ORA-01555  in my database and the solution is to create
huge rollback segments  but my doubt is how to calculate the size of this
huge rollback segments . Now I have 24 G of  space in rollback segment
tablespace .But still i am getting the error.The environment is datawarehouse
and loading happens almost every time  except at night . and while loading
data loading  updataion and deletion happens frequently .Please help  me in
calculating  the  size of  huge rollback segment .
         
         
         
        Happy Christmas and New year to all 
         
        Regards,
        Shibu



DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged. 
Before opening attachments please check them for viruses and defects. MindTree 
Consulting Private Limited (MindTree) will not be responsible for any viruses or 
defects or any forwarded attachments emanating either from within MindTree or outside. 
If you have received this message by mistake please notify the sender by return  
e-mail and delete this message from your system. Any unauthorized use or dissemination 
of this message in whole or in part is strictly prohibited.  Please note that e-mails 
are susceptible to change and MindTree shall not be liable for any improper, untimely 
or incomplete transmission.

<<winmail.dat>>