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. index build for z0102

    index build for z0102

    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: 15.2

    Description:
    The index built for z0102_id1 was set off. We were expecting this to be much quicker. None of the browse indexes are working in the catalogue subsets, so this is causing major difficulty in the Reading Rooms.

    Resolution:
    The z0102_id1 index occupies around 22,000 extents. This is because each extent is defined as 1MB. It certainly may have taken longer than usual to build because of this but, according to Oracle documentation, it should not present a performance problem in current usage.

    However, in case you have to rebuild z0102 in the future, it would be better to change file_list and define this index in tablespace TS9X, with initial allocation 1000M (same as z0102_id). Then, according to TS9X definition (next extent 100M) you would have a little over 200 extents.

    But if you do it, you must remember beforehand to check that you have the necessary 22GB free in TS9X !!

    Additional Information

    browse, index, z0102, file_list, tablespace TS9X, extent


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Index 'xxx01.Z00_ID' ... is in unusable state
      • Index entry can be found although field was deleted
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 15.2
      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