Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    manage-18 extremely slow; "unable to extend index ..." messages in Oracle log

    • Product: Aleph 
    • Product Version: 20,21,22,23
    • Relevant for Installation Type: Dedicated-Direct,Direct,Local,Total Care

     

    Description:

    The manage-18 job (or some other batch job) suddenly runs much slower than it should (for instance, processing 

    only one input record/second rather than the normal 20/second).  There are no error messages in the job log.

     

    Resolution:
    An examination of the /exlibris/app/oracle/diag/rdbms/aleph21/aleph21/trace/alert_aleph21.log  showed thousands 

    of the following error message:

        ORA-1654: unable to extend index ALB01.Z00R_ID1 by 8192 in tablespace TS1X

     

    (Note that despite these errors, util a/17/14 for the z00r shows that the x00r_id1 is present and valid.)

     

    Adding a datafile to the TS1X tablespace -- as described in the article "How to add a datafile to a tablespace" -- resolved the problem.   (Note: Oracle does *not* need to be stopped in order for the added datafile to be available for use-- in fact, the job itself doesn't need to be stopped.)

     

    For other causes of job slowness, consult the "Aleph is slow *MASTER RECORD*" article.

    Attachment

    If there is an attachment add link to the attachment according to steps below, if there is no content please delete the header for this section