Problem Description
===================
ORA-1595 occurs when using a rollback segment that has an optimal clause. In
addition, ORA-1551 or ORA-601 or ORA-1575 or ORA-1594 may be written to the
alert log, and/or to an SMON trace file.
ORA-1595 "error freeing extent (%s) of rollback segment (%s))"
Cause: Some error occurred while freeing inactive rollback segment
extents.
ORA-1551 "extended rollback segment, pinned blocks released"
Cause: This is an internal error message not normally issued.
ORA-601 "cleanup lock conflict"
Cause: The Process Monitor process encountered a lock conflict while trying
to recover processes.
ORA-1575 "timeout waiting for space management resource"
Cause: Failed to acquire necessary resource to do space management.
ORA-1594 "attempt to wrap into rollback segment (%s) extent (%s) which is
being freed"
Cause: Undo generated to free a rollback segment extent is attempting to
write into the same extent due to small extents and/or too
many extents to free
Solution Description
====================
These errors should be handled internally and can be safely ignored. The
operation should succeed on later attempts. They indicate that the rollback
segments are shrinking.
'Oracle > ORA-Error' 카테고리의 다른 글
ORA-24324,ORA-01041 (0) | 2015.09.14 |
---|---|
ORA-20000:ORU-10027 (0) | 2015.09.14 |
ORA-00376,ORA-01110 (0) | 2015.09.14 |
ORA-01031 (0) | 2015.09.14 |
ORA-02097,ORA-00439 (0) | 2015.09.14 |