Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

525084Nov 27 2006 — edited Nov 29 2006
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2006
Added on Nov 27 2006
8 comments
7,437 views