0 Replies Latest reply on Nov 12, 2018 10:38 AM by 3619401

    ORA-1628 - max # extents (32765) reached for rollback segment SYSSMU5$

    3619401

      Our company uses Oracle 10g fusion middeware forms and reports

       

      Users are receiving this error when creating a sales order in the front end:

      " ORA-1628 - max # extents (32765) reached for rollback segment SYSSMU5$"

       

      This is not an upgrade this just a pre-existing database and apps server.

       

      SELECT DISTINCT STATUS,TABLESPACE_NAME, SUM(BYTES), COUNT(*) FROM DBA_UNDO_EXTENTS GROUP BY STATUS, TABLESPACE_NAME;

      STATUS    TABLESPACE_NAME                SUM(BYTES)   COUNT(*)

      --------- ------------------------------ ---------- ----------

      EXPIRED   UNDOTBS1                       3.4177E+10      45736

      UNEXPIRED UNDOTBS1                        131268608         72

      ACTIVE    UNDOTBS1                          2097152          2

       

       

      select max(maxquerylen),max(tuned_undoretention) from DBA_HIST_UNDOSTAT;

      DBA_HIST_UNDOSTAT;

      MAX(MAXQUERYLEN) MAX(TUNED_UNDORETENTION)

      ---------------- ------------------------

                 48054                    48834

       

       

      select max(maxquerylen),max(tuned_undoretention) from v$undostat;

      v$undostat;

      MAX(MAXQUERYLEN) MAX(TUNED_UNDORETENTION)

      ---------------- ------------------------

                   723                     1444

       

      Please help