why is my autoextend datafile didn't grow for a tablespace?

[Former Member]

These are my autoextend datafiles for PSAPSR3700. DB02 reported that PSAPSR3700 tablespace is utilized 100%. Shouldn't the datafiles autoexted by them self to solve the 100% utilization problem?

SQL>  select file_name,bytes,maxbytes,blocks,maxblocks  from dba_data_files where tablespace_name = 'PSAPSR3700';

FILE_NAME
--------------------------------------------------------------------------------
     BYTES   MAXBYTES     BLOCKS  MAXBLOCKS
---------- ---------- ---------- ----------
/oracle/TDM/sapdata3/sr3700_1/sr3700.data1
3565158400 1.0486E+10     435200    1280000

/oracle/TDM/sapdata3/sr3700_2/sr3700.data2
3690987520 1.0486E+10     450560    1280000

/oracle/TDM/sapdata3/sr3700_3/sr3700.data3
3670016000 1.0486E+10     448000    1280000


FILE_NAME
--------------------------------------------------------------------------------
     BYTES   MAXBYTES     BLOCKS  MAXBLOCKS
---------- ---------- ---------- ----------
/oracle/TDM/sapdata3/sr3700_4/sr3700.data4
1551892480 1.0486E+10     189440    1280000

/oracle/TDM/sapdata4/sr3700_5/sr3700.data5
1488977920 5368709120     181760     655360

/oracle/TDM/sapdata4/sr3700_6/sr3700.data6
1488977920 5368709120     181760     655360

[former_member524429 · Accepted solution]

Hi,

[|]

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

tq for the reply. From the post it seems that my filesystem is not large enough for all of my datafiles to be extended to their maxsize.

So how to check that my filesystem is sufficient for all of the datafiles maxsize?

[former_member524429 · Accepted solution]

Hi,

You can consider the following Factors for measuring the FileSystem capacity planning and requirement to hold datafiles of tablespace.

1. Current Size of the Datafiles associated with Tablespace

[Showing Disk Volumes with BR*Tools|http://help.sap.com/saphelp_nw70/helpdata/en/85/0ba86126e3b34091746bcfc2aa8a1d/content.htm]

[Showing Tablespaces with BR*Tools|http://help.sap.com/saphelp_nw70/helpdata/en/1d/9c8d3f7057eb0ce10000000a114084/content.htm]

[ Showing Data Files with BR*Tools|http://help.sap.com/saphelp_nw70/helpdata/en/05/710a4654de0b4b9ad131879a2c68d3/content.htm]

2. Autoextend -If it is set to yes, the new data file is created autoextensible. In this case, maxsize and incrsize will paly an important role for the capacity planning

3.maxsize -For autoextensible data files, this parameter specifies the maximum size in MB up to which the data file can be increased.

4.incrsize - For autoextensible data files, this parameter specifies the size in MB, by which the data file is automatically increased when necessary.

Regards,

Bhavik G. Shroff

[Former Member]

I found out that if the autoextended datafiles maximum size cannot be full fill, the datafile will not extend