Space Overview on ST04

[Former Member]

Dear all ,

I have checked sto4 > Space>Space Overview , it show below Space overview detail.

DB Name IRP Started 17.10.2010

DB Server PRODORADB 06:45:21

DB Release 10.2.0.4.0

Name DEFAULT Filling degree:

DB system: ORA

Size: 246.86 GB Total size: 410.16 GB

Free Size: 15.85 GB Total free size: 179.15 GB

Used: 94 % Total used: 56 %

What will happen if the Total Free size will reach 410GB ?

Kindly advise

[former_member204746]

Oracle will generate errors, update process in SAP will stop, users will not be able to work on some transactions if some tablespaces are filled.

this is basic info found on ADM100.

this is yet another basic questions asked by you.

this forum is not a substitute to training.

[former_member199632]

Hi,

This Total size: 410.16 GB is the free space calculated considering data files can grow to the maximum specified limits.

(that is MaxSize of the Datafiles)

Then Size (in ur case 246.86) refers to the total "current" size of all the database data files.

(that is datafiles, already filled)

You better to check the space from Tablespace point of view. Mainly all R/3 Data resides in PSAPSR3 tablespace

There you check; how many datafiles available and the free amount available.

and by considering the DB growth and available free space in PSAPSR3 you can get idea about the remaining space usage.

While reaching this limit, you need to add additonal data files to the identified tablespaces either on the exisiting file system or a new filesystem depending on the free space availability there.

From my experience this 410.16 GB not telling that much. better to explore from tablespace level / datafile level.

regards,