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. Handling Oracle Tablespaces in Aleph 21-up

    Handling Oracle Tablespaces in Aleph 21-up

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description:
    2. Attachment

     

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

     

    Description:


    Aleph 21 includes new configuration for Oracle Tablespaces.
    As tables and indexes grow over time, the tablespace which holds them has to be enlarged. Before Aleph 21 monitoring the free space had be done regularly and resizing, when needed, manually.
    Out-of-the-box installation of Aleph 21 comes with the Tablespaces configured as autoextend, and so they grow when needed, up to a limit of 32 GB.
    If you plan on keeping this configuration, the free disk space must be monitored closely. Running out of disk space might cause damage to the smooth running of Aleph and the DB.

    If you are not sure of your disk space monitoring, we strongly advise you to turn off the autoextend mode, and enlarge the Tablespaces by 20%. This can be done by running the attached script:
    bash autoe_cancel_Aleph.bash
    (the script can be placed anywhere on the server, and run from UNIX user: aleph).
    From then on, continue to monitor the tablespaces free space, and enlarge them manually, as in Aleph 20.

    If you plan on keeping the autoextend mode, be aware of the following:
    A few of the first installations of Aleph 21 installation were installed with autoextend but the limit was mistakenly 1 GB instead of 32 GB.
    If you would like to make sure that the limit is at its maximum, 32 GB, run the attached script:
    bash autoe_32G_Aleph.bash

     

    You can check your current configuration using the following SQL:
     

    s+ aleph_admin
    select TABLESPACE_NAME,AUTOEXTENSIBLE,MAXBYTES from dba_Data_files where TABLESPACE_NAME like 'TS__';

     

     

    Attachment

    autoe_32G_Aleph.bash

    autoe_cancel_Aleph.bash

     


    • Article last edited: 26-Jun-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Handling of UTF-8 characters not representable in MARC-8
      • Harvesting bib and holding data with OAI Data Provider
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. autoextend
      2. AUTOEXTENSIBLE
    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