Loan/return activity is slow

• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
Two of our circulation desks are reporting slow loan and returns transactions this morning.

They're saying it's taking several minutes, or timing out entirely, to do transactions that usually happen very quickly.

Resolution:
The Oracle-index-check SQL showed the following results (with annotations):

abc50@ALEPH1> select index_name from all_indexes where owner = 'USM50' or owner = 'USR00' and index_name like 'Z%' minus select index_name from all_indexes where owner = 'ABC50' and index_name like 'Z%' and status = 'VALID';
**** Hit return to continue ****

INDEX_NAME
------------------------------
Z1003_ID - German DBS table
Z107_ID - course enrollments table
Z301_ID - Due dates table
Z325_ID - SDI
Z700_ID - ILL
Z700_ID1 "
Z700_ID2 "

I don't think the others are significant (since you don't use these functions), but it is curious that the z301_id is missing.

We found that because of the missing z301_id, the abc50 z301 had grown to 60,000 records -- way more than it should have....

The z301_id Oracle index was missing from the file_list. Adding it, and doing util a/17/2 to build it, corrected the problem.

See Article 000043308 ("*How to tell if Oracle indexes for a particular library are present & VALID?*") for other SQL for checking on missing Oracle indexes.