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. Turning off Automatic Segment Advisor ('auto space advisor')

    Turning off Automatic Segment Advisor ('auto space advisor')

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    Following KB 16384-29537, we have turned off the Automatic Optimizer Statistics Collection and Automatic SQL Tuning Advisor. We find that the Automatic Segment Advisor ('auto space advisor') is also taking quite a bit of CPU and would like to turn that off. Should we?

    Resolution:
    The decision as to whether to change the auto space advisor from the default "Enabled" to "Disabled", is independent of Aleph. Unlike the 'auto optimizer stats collection' and the 'sql tuning advisor' tasks which are contrary to what Aleph wants, the auto space advisor may be serving useful functions in an Aleph Oracle,... but Aleph does not *require* that the 'auto space advisor' task be running.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Turning archiving off for specific Oracle table rather than entire database
      • Turning off ue_01_z0102 when z0102 is not used
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    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