ORA-01555: snapshot too old: rollback segment number 14 with name "_SYSSMU14$"
Dear Friends,
I am facing the following error:
"ORA-01555: snapshot too old: rollback segment number 14 with name "_SYSSMU14$" too small"
Here are the system and other necessary details...
Database: Oracle 10204 64-Bit
OS: SUSE LINUX SLES 10 64-bit X86
SQL> show parameters undo
NAME TYPE VALUE
------------------------------------ -----------
undo_management string AUTO
undo_retention integer 4200
undo_tablespace string UNDOTBSP
The size of the UNDO Tablespace: 40GB (10GB files a total of 4)
TableSpace Size (kb) Free (kb) Used % Free %
--------------- ------------ ------------ ------ ------------
UNDOTBSP 40,960,000 39,056,192 5 95
Max. Bytes/Minutes Avg. Bytes/Minutes Max Space (Mb) Avg Space (Mb)
------------------ ------------------ -------------- --------------
31,291,802 8,035,427 2,089 536
I still dont understand that, even though we have allocated such a huge space to UNDO tablespace, and it is not even using it 100%..why is the system is throwing the error...
Thank you,
Nikee