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

    How to check if tablespaces are autoextend

    • Article Type: General
    • Product: Aleph
    • Product Version: 20
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local;

    Desired Outcome Goal:
    Check if Oracle tablespaces are in autoextend mode and what is the defined maximum size (in Oracle 11/11r2 the maximum is 32Gb)

    Procedure:
    The following SQL from the aleph user prompt will show whether each Oracle datafile is autoextensible. (Autoextensibility is defined at the datafile level.):

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

    Check the values in AUTOEXTENSIBLE column; if it’s NO this feature is not enabled on the file in column FILE_NAME.

    Category: System management


    • Article last edited: 10/8/2013