Handling Oracle Tablespaces in Aleph 21-up
- 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__';