p_manage_32 running way too slowly
- 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