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. Keyword searching on common words takes extremely long; multiple z97's

    Keyword searching on common words takes extremely long; multiple z97's

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    Keyword searching on very common words, such as "to" and "a", has been getting progressively worse and now takes between 30 and 60 seconds. This is the case even when nothing else is happening on the server.

    Normally, there should be only one z97 record for a particular word. In this case, we have found that these common words have multiple z97 records (in some cases, thousands) for the same word.

    This can be seen by doing the SQL:

    SQL-xxx01> select z97_word from z97 group by z97_word having count (*) > 1;

    It seems that this is related to the problem described in Article 000045445 ("Keyword Index Not Working After Oracle/ALEPH Restart") where Oracle Statistics were sometimes interfering with keyword searching.

    Resolution:
    We have concluded that this can be solved by:

    1. eliminating the Oracle Statistics -- as described in Article 000046838 ("UTIL A / 8 (List Analyzed Tables/Indexes); 'Oracle Optimizer Changes for ALEPH'") -- (which has been done) in order to prevent the re-occurrence of the multiple z97's; and

    2. rebuilding the keyword indexes with p_manage_01 (in parallel mode) to eliminate the existing multiple z97's.

    Additional Information

    Keyword Index Not Working After Oracle/ALEPH Restart
    UTIL A / 8 (List Analyzed Tables/Indexes); "Oracle Optimizer Changes for ALEPH"


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Keyword searches take long time then give "Page cannot be displayed"
      • Killing p_manage_05 in the middle of the process?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. 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