본문 바로가기

Oracle/ORA-Error

ORA-1595,ORA-1551,ORA-601,ORA-1575,ORA-1594


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