1 Reply Latest reply: Jul 23, 2012 1:32 PM by Hussein Sawwan-Oracle RSS

    Concurrent request is failing with error "ORA-01562: "

    user11991378
      We have Abort in production with rollback segment error as below.
      Unexpected error found while deleting in staging table . 1100ORA-01562: failed to extend rollback segment number 258

      This is RAC instance having 4 db nodes

      Details for UNDO as follows:

      SQL> SELECT tablespace_name, SEGMENT_NAME, INITIAL_EXTENT, NEXT_EXTENT, MAX_EXTENTS from dba_rollback_segs where SEGMENT_NAME='_SYSSMU258$';

      TABLESPACE_NAME SEGMENT_NAME INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS
      -------------------- ------------------------------ -------------- ----------- -----------
      APPS_UNDOTS1 _SYSSMU258$                            131072                   32765


      TABLESPACE_NAME STATUS Extent Count Total Blocks SPACEINGB
      -------------------- ---------- ------------ ------------ ----------
      APPS_UNDOTS1 ACTIVE 36 6744 .051452637
      APPS_UNDOTS1 UNEXPIRED 513854 8967456 68.4162598
      APPS_UNDOTS1 EXPIRED 237 2016 .015380859



      Tablespace Used MB Free MB Total MB Pct. Free
      ------------------------------ ---------- ---------- ---------- ----------
      APPS_UNDOTS1 70656 0 70656 0


      Can you tell me how to troubleshoot error like "*ORA-01562: failed to extend rollback segment" or "snapshot too old error*"

      Can you help on this issue. because this issue appeared very frequently on PROD instance.

      Thanks in advance.
        • 1. Re: Concurrent request is failing with error "ORA-01562: "
          Hussein Sawwan-Oracle
          Can you tell me how to troubleshoot error like "*ORA-01562: failed to extend rollback segment" or "snapshot too old error*"
          ORA-1562 and ORA-1650 Unable to Extend Rollback Segment [ID 1066542.6]
          ORA 01555 "snapshot too old: rollback segment number %s with name \"%s\" too small" [ID 1555.1]
          Master Note for ORA-1555 Errors [ID 1307334.1]
          TROUBLESHOOTING GUIDE (TSG) - ORA-1555 [ID 467872.1]
          ORA-01555: "Snapshot too old" - Overview [ID 10630.1]
          ORA-01555 "Snapshot too old" - Detailed Explanation [ID 40689.1]
          Can you help on this issue. because this issue appeared very frequently on PROD instance.
          Please log a SR for production issues.

          Thanks,
          Hussein