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

    p_manage_32 running way too slowly

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    p_manage_32 has been running for more than 24 hours on our Test server.

    Resolution:
    I find that it is taking 30 minutes for each p_manage_32 process to read 1,000 records:

    185186 READING REC 000635826 AT 09:30:06
    186187 READING REC 000637501 AT 10:00:48
    187188 READING REC 000639494 AT 10:31:21


    The following SQL shows that the ABC01 (and the parallel bib library ABC08) lack certain Oracle indexes:

    abc01@TDALEPH> select index_name from all_indexes where owner = 'USM01' and index_name like 'Z%' minus select index_name from all_indexes where (owner = 'ABC01' or owner = 'ABC08') and index_name like 'Z%' and status = 'VALID';
    **** Hit return to continue ****

    INDEX_NAME
    ------------------------------
    Z0102_ID
    Z0102_ID1
    Z01_ID
    Z01_ID5
    Z02_ID
    Z02_ID1

    The z01 and z02 indexes should have been built by p_manage_02, but I find, looking at the abc08 $data_scratch that the last p_manage_02 (on Oct. 6, in abc08) failed.

    Since the p_manage_102 (in ABC08) was successful, it may be that just the p_manage_02 could be rerun (followed by p_manage_17, etc.).

    • Article last edited: 10/8/2013