CODEWITHSUNDEEP
databaseoracle-databaseoracle11g
user710818
user710818

Reputation: 24248

ORA-01555 for auto extendable UNDO segment

I have an undo tablespace with the AUTOEXTEND option enabled. But sometimes I receive error: ORA-01555 snapshot too old: rollback segment number 5 with name "_SYSSMU234124$" too small... But how it can be? when space is low, instead of overwriting unexpired undo information, the tablespace auto-extends.

Upvotes: 0

Views: 440

Answers (1)

J.Col
J.Col

Reputation: 41

    show parameter undo_retention;
    ALTER SYSTEM SET UNDO_RETENTION = 3600;
  show parameter undo_retention;

Upvotes: 1

Related Questions