Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Autoextensible Tablespace is not extending

2669717Aug 27 2014 — edited Aug 29 2014

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.

This post has been answered by Hemant K Chitale on Aug 28 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2014
Added on Aug 27 2014
6 comments
2,347 views