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

    Multi-process, I/O intensive jobs slow in Aleph 22/Oracle 11r2

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description 
    Multi-process, I/O intensive functions are slow in Aleph 22/Oracle 11r2: 

    1. Multiple file-20 jobs being run at the same time for different ADMs in a consortia are slow. {See link to Article 000041897 (file-20 slow in v22) below} 
    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
    Cause/Resolution 
          A. Missing Oracle indexes 

    This is a common cause of extreme slowness not just in version 22 but in all Aleph versions. See link to Article 000043308 (*How to tell if Oracle indexes for a particular library are present & VALID?*) below 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.

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

     

    • Was this article helpful?