Extending Tablespace on ASM

Today after checking the Daily Health Check Report I found that INDX tablespace is running out of space

Megs Megs Megs Megs Megs
Tablespace Max Size Allocated Used Used % Free %

INDX 6,144 5,632 5,543.50 90.23 9.77

Now to resolve the Issue first we need to check where the datafiles are located and what is the uniform size of the datafiles which customer is using.

We can use the following query for the same

select FILE_NAME,BYTES,STATUS,AUTOEXTENSIBLE from dba_data_files where TABLESPACE_NAME='INDX';

Now we can extend the Tablespace by using the following query

ALTER TABLESPACE "INDX" ADD DATAFILE '+DATA/prod_sa/datafile/indx.004' SIZE 1946157056 autoextend ON;


Here the datafiles are located on ASM.

Cheers
Aashish