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

    Aleph 20 acquisitions slow

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    * Several users in Acquisitions report the system is slow
    * It takes the system up to one minute to react
    * Troubleshooting in PC and logs did not reveal any problems.

    Cause:
    Missing Oracle index z68_id6

    Resolution:
    The lack of Oracle indexes can be a major cause of slowness.

    * Util a 17/14 for xxx50 shows a missing z68_id6 for table z68

    Enter Table Name : z68

    Defined in file_list:
    __________________________________________________________
    IND z68_id 600K 0K TS2X
    IND z68_id1 800K 0K TS2X
    IND z68_id2 200K 0K TS2X
    IND z68_id3 200K 0K TS2X
    IND z68_id4 100K 0K TS2X
    IND z68_id6 600K 0K TS2X
    IND z68_id7 10M 0K TS3X
    __________________________________________________________

    Exist in the Database:

    INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
    --------------- ------- ---------- ----------- --------------------
    Z68_ID VALID NORMAL UNIQUE Z68_REC_KEY
    Z68_ID1 VALID NORMAL NONUNIQUE Z68_ORDER_NUMBER
    Z68_ID2 VALID NORMAL NONUNIQUE Z68_SUB_LIBRARY
    Z68_ID3 VALID NORMAL NONUNIQUE Z68_ORDERING_UNIT
    Z68_ID4 VALID NORMAL NONUNIQUE Z68_ORDER_STATUS_DATE_X
    Z68_ID7 VALID NORMAL NONUNIQUE Z68_TARGET_ID

    *** Remark: Z68_ID6 is not included in the above list

    * Create the missing index z68_id6 with util a/17/2

    Category: System Management (500)

    Subject: Oracle (500)


    • Article last edited: 10/8/2013
    //Feedback