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
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
: 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