Tablespace auto extending

[former_member199632]

Hello,

In PRD: PSAPSR3 tablespace is consisting with 9 Data Files and it is in AutoExtened YES mode

All Datafiles are set to MAXSIZE as 10000 MB - with auto extensible yes

Currently 5 of the DataFiles reached to its maxsize.

So other 4 DataFiles is currently getting the data.

(sr3.data1 - 5250 MB used,

sr3.data3 - 5780 MB used,

sr3.data5 - 6250 MB used,

sr3.data7 - 5900MB used)

What will happen when those 4 data files also reached to its MAX Size. (i.e: to 10000 MB)

Will that automatically add a new datafile? (like sr3.data10)

Or else

Before reaching to its MAX size do we need to add a datafile manually and increase the Tablespace Size?

regards,

[Former Member · Accepted solution]

Hi,

You will need to manually add new datafiles before the remaining 4 data files fill in completely.

The Autoexpensible is for the size of a single data files. However, you would need to add data files whenever the existing ones become close to filling completely.

Regards,

Hari Kishan

[former_member204746]

AUTOEXTEND feature will automatically extend existing datafiles,

it will not create new datafiles for you. it's your responsibility to create new datafiles in advance.

[Former Member]

Hi,

Will that automatically add a new datafile? (like sr3.data10)

You will have to add the datafiles manually using BRTools.

Keeping the autoextend in ON mode in production environment may lead to a situation where we do not have free disk space to add a datafile to the tablespaces. In such a situation all ur operations will be stopped until u add the disk space. So, in a PRODUCTION environment it is always better to have the datafiles in autoextend OFF mode and monitor the datafile/DB growth periodically(daily/weekly) to avoid a situations when the entire disk space is filled up.

Hope this helps.

Regards,

Varadharajan M

[Former Member]

The above datafiles will only grow until 10000 MB, you now almost have 16 GB freespace in tablespace.

You have to add new datafiles, but I suggest to extend the existing datafiles upto 32 GB, check whether you OS supports or not. This is easy from DBA prospective as you will have less datafiles to manage.

[former_member709110]

You will have to add additional datafiles ....

Regards,

Neel