Multi-process, I/O intensive jobs slow in Aleph 22-up

Description 

Multi-process, I/O intensive functions are slow in Aleph 22/Oracle 11r2 (or higher): 

1. Multiple file-20 jobs being run at the same time for different ADMs in a consortia are slow. {See Article " file-20 slow in v22 ".} 
2. Word and/or Headings indexing are slow. (See link to articles below.) 
3. I/O-intensive GUI activities (such as invoice processing, order index display, and return of items to patrons with many items on loan) are slow

Causes/Resolutions

       A. Missing Oracle indexes 

This is a common cause of extreme slowness not just in version 22 but in all Aleph versions. See Article " *How to  tell if Oracle indexes for a particular library are present & VALID?* "  for SQL which can be used to check *all* of the Oracle indexes for a library with a single command. 

      B. SGA 

Three large sites, who had SGA (as seen in the SQL query "show sga") of 1.5G found in Aleph 22/Oracle 11r2 that increasing the SGA to 8G or 10G improved performance.  Do the following to see your SGA value:

  > sqlplus ALEPH_ADMIN/ALEPH_ADMIN

  aleph_admin@LIBP> show sga

  See also, the article " How to increase the Oracle SGA ". 

Additional Information

Article  *How to  tell if Oracle indexes for a particular library are present & VALID?*

Article   How to increase the Oracle SGA

• Article last edited: 26-Jan-2021