DB sizing

[Former Member]

Hi all,

   How we can decide which data file needs to be more in size than others .Ex we have 5 sap data files if disk space needs to added how to consider which needs to added more than other data files

with regards,

Krishna

[Former Member · Accepted solution]

Hi,

Which database do you use?

If Oracle, then check transaction db02. Space -> Tablespaces -> Overview shows information like the rate at which a tablespace grows over a day/week/month. Based on this you should be able to forecast your data file requirements. Next in the Data/Temp file section you see which data/temp files are being used for which tablespace. Based on which tablespace grows at the maximum rate, decide which datafile needs extension.

The process should be similar for other databases as well.

Regards,

Srikishan

[Former Member]

Hi ,

Why do you need to add spaces to a data file??

if a tablespace is full , then just add a datafile to tablespace using brtools.

Regards

Deepak