DB version : 19c
OS : RHEL 7.x
The tablespace shown in below picture is at 86% utilization. So, I need to add space to this tablespace.
To do this, I have 2 options
Option1)
should I set the Max size to Unlimited so that some of the files shown below can grow to 32 GB using
ALTER DATABASE DATAFILE '/oradbs/wmos/dbf01/DB_WMOS/datafile/o1_mf_ts_kkms__8y7sxdwx_.dbf' AUTOEXTEND ON MAXSIZE UNLIMITED;
Option2)
or just add a datafile to the tablespace as shown below ?
ALTER TABLESPACE TS_KKMS_CLM_DAT_01 ADD DATAFILE SIZE 10g AUTOEXTEND ON MAXSIZE unlimited ;
Which option would you go for ?
