Problem with undo tablespace and snapshot too old

2003-10-15 Thread Daiminger, Helmut
Hi! We are experiencing a weird problem here... We have automatic undo management enabled and the undo tablespace is 6 GB in size. undo_retention is set to 30 minutes. when a certain transaction runs, it fails with ORA-1555 Snapshot too old, although the undo tablespace only uses 700 MB (out of

RE: Problem with undo tablespace and snapshot too old

2003-10-15 Thread John Kanagaraj
PROTECTED] Sent: Wednesday, October 15, 2003 9:25 AM To: Multiple recipients of list ORACLE-L Subject: Problem with undo tablespace and snapshot too old Hi! We are experiencing a weird problem here... We have automatic undo management enabled and the undo tablespace is 6 GB in size. undo_retention

RE: Problem with undo tablespace and snapshot too old

2003-10-15 Thread Kirtikumar Deshpande
: Problem with undo tablespace and snapshot too old Hi! We are experiencing a weird problem here... We have automatic undo management enabled and the undo tablespace is 6 GB in size. undo_retention is set to 30 minutes. when a certain transaction runs, it fails with ORA-1555