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 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 ". 

     

    • Was this article helpful?