Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Aleph 20 acquisitions slow

    Aleph 20 acquisitions slow

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Aleph 18 and Aleph 20 on same server
      • Aleph 20 and end of Oracle support for 11.1.0.7
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Oracle (500)
      4. Prod:Aleph
      5. System Management (500)
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved