Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Why are Oracle statistics in Aleph locked?

    Why are Oracle statistics in Aleph locked?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Product: Aleph
    • Product Version: 18,19,20,21,22,23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Question

    Why are Oracle statistics in Aleph locked?

    I've found that all our tables has locked statistics

    select owner, table_name, stattype_locked 
    from dba_tab_statistics 
    where stattype_locked is not null 
    and owner like 'ABC%';

    returns all tables.

    Is it the normal configuration or something went wrong ? 

    Answer

    Yes, indeed, this is normal. 
    Aleph is working with the RULE base optimizer, hence optimizer_mode is set to CHOOSE, and statistics are deleted and locked. 

    See also the article  UTIL A / 8 (List Analyzed Tables/Indexes); "Oracle Optimizer Changes for ALEPH"  .

    Additional Information

    Please see additional information from rep_ver #9117 of Aleph version 18.... 

    Description: ALEPH was written and is tuned to work with the Rule Based optimizer.

    Since in 9i when a customer gather statistics, ALEPH does NOT WORK, and since Oracle 10g will no longer support the Rule Based optimizer, Ex Libris should adapt ALEPH to work with the Cost Based Optimizer, using hints where necessary. 

    ******* 
    Please use util a/8. (List Analyzed Tables / Indexes) to identify analyzed tables 

    ================================================= 
    This list should be empty 
    if not please use util a 9 to delete statistics 

    List of tables and indexes analyzed 
    ================================================= 


    If the list is not empty, please delete them by using util a/9. 

     

    • Article last edited: 14-April-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Why are opening hours not taken into account for executing jobs (overdue notices, courtesy notices)?
      • Why are requests in OPAC not blocked by global delinquencies?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved