Check whether the UNDO tablespace is automatically expanded.

Check whether the UNDO tablespace is automatically expanded.

Query the remaining free space of the Oracle RAC shared disk

Executed as root # su - grid

After switching the grid user, execute:

asmcmd

ASMCMD> lsdg   

(2)Query table space utilization:

Executed as root：su – oracle

Then execute：sqlplus “/ as sysdba”

select file_name,autoextensible,increment_by from dba_data_files;

select file_name,autoextensible,increment_by from dba_data_files where tablespace_name = 'DSDB_DEFAULT_DATA';

select file_name,autoextensible,increment_by from dba_data_files where tablespace_name = 'DSDB_SLD_DATA';