Question: is there a way to dynamically reset/empty rollbacks?
I am running Oracle 9.2.0.8 on Win 2003 server.
I am running a package that calls remote procedures in begin ... end blocks (about 6 of them) one after the other. Each remote procedure has a "commit" at the end.
Frequently I am getting this type of meesage: ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small.
Database restart is the only fix for it at the moment. I can only do it during the weekend backup though.
It looks like UNDO tablespace is being full. It has 6 datafiles of 2G each.
SPFile shows:
*.undo_management='auto'
*.undo_retention=7200
When I query rollback views, I get the following:
select SEGMENT_NAME, STATUS
from DBA_ROLLBACK_SEGS
order by segment_id;
select * from V$ROLLSTAT
