8 Replies Latest reply on Nov 29, 2006 8:26 AM by 525084

    ORA-01595: error freeing extent (2) of rollback segment (3))

    525084
      Hi there

      I've this error,

      Mon Nov 27 08:15:29 2006
      Errors in file g:\commx00\ms\ora\bdump\commx_smon_2088.trc:
      ORA-01595: error freeing extent (2) of rollback segment (3))
      ORA-01594: attempt to wrap into rollback segment (3) extent (2) which is being freed

      I'm under 9.2.0.6. undo management is auto.

      If i was under 8i it's easy to solve it (Create larger rollback segments, modify minimum extents and maxextents for each rollback segment, create more number of rollback segments.) but how to in 9i ???

      Regards
      Den