We are facing the issue of cube refresh getting failed because of the below issue.
<ERROR> <![CDATA[ 37162: ORA-37162: OLAP error ORA-01555: snapshot too old: rollback segment number 36 with name "_SYSSMU36_297363472$" too small XOQ-01600: OLAP DML error while executing DML "SYS.AWXML!R11_LOAD_MEASURES" ORA-06512: at "SYS.DBMS_CUBE", line 234 ORA-06512: at "SYS.DBMS_CUBE", line 316 ORA-06512: at line 1 ]]>> </ERROR>
To resolve this DBA increases the rollback segment, however we get this error often. Is there anyway to permanent solution like if we increase the rollback segment to the level that this error wont occur, in that case is there any way to estimate the same?