This discussion is archived
2 Replies Latest reply: Nov 4, 2012 9:51 PM by 892844 RSS

Cube Refresh Failure

892844 Newbie
Currently Being Moderated
Hi,

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?

rgds,
Prakash S

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points