Oracle Tablespace [ Check +ASM | Add Tablespace]

Check +ASM

SQL> select name, total_mb, free_mb from v$asm_diskgroup;

Check Disk

SQL> show parameter create

Add Tablespace

SQL> alter tablespace users add datafile size 1000m autoextend on next 500m maxsize 8000m;

Check Tablespace autoextend

SQL> desc dba_data_files;

SQL> select Tablespace_name, file_name, bytes/1024/1024 mbytes, AUTOEXTENSIBLE, MAXBYTES/1024/1024 maxbytes, INCREMENT_BY nextmb

from dba_data_files