Hi,
I have set SYSTEM tablespace's datafile to autoextensible but it is not autoextending. It has reached 100% utilization a couple of times. I manually extended the datafile since it is not autoextending. Any help would be very much appreciated. Thanks!
--DB Version
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
--Tablespace DDL
SQL> SELECT DBMS_METADATA.GET_DDL('TABLESPACE', 'SYSTEM) from dual;
DBMS_METADATA.GET_DDL('TABLESPACE','SYSTEM')
--------------------------------------------------------------------------------
CREATE TABLESPACE "SYSTEM" DATAFILE
'/oracle/test/data4/test01/system01.dbf' SIZE 674013184
AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT DICTIONARY DEFAULT
NOCOMPRESS
STORAGE(INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 505
PCTINCREASE 50)
--Datafile status
TABLESPACE_NAME FILE_ID BYTES_MB MAXBYTES_MB AUT INCREMENT_BY
------------------------------ ---------- ---------- ----------- --- ------------
SYSTEM 1 642.789063 32767.9844 YES 1
My filesystem has still has 35.20 GB free space.