Size of data files

[Former Member]

Hello Experts,

I need to compare size of my production and quality systems.

There is an option in ST06 for file system, that is the only way and best way to look at the sap data files and more things need to be checked.

I want to file current sizes of all the sapdata's and them compare file from both the systems.

Thanks

[former_member204746]

transaction DB02OLD, click on CURRENT SIZES button.

[Former Member]

Hi Learning SAP,

I suggest you to use the DB02 (or DB02N) transaction.

Click on u201CFreespace statisticsu201D in order to see your tablespaces. After that, if you choose one of your tablespace and click on u201CData files / Temp filesu201D the system will show you every single data file.

I hope thatu2019s what you are looking for.

Regards,

Federico Biavati

[Former Member]

Thanks Federico.

Actually before doing a system refresh i want to compare current sizes of all the sapdata's on both the system.

For refresh purpose we only consider size of for eg sapdat1-20 or other stuff like

/opt

/installs

/home

I was looking at ST06 to find the size of sapdata files.

Thanks.

[Former Member]

Hello Learning SAP,

Here is my suggestion: open a Linux/UNIX shell and check the sapdata* size in this way:

ServerName:/oracle/SID # df -h | grep sapdata | grep %

Filesystem Size Used Avail Use% Mounted on

249G 122G 127G 49% /oracle/SID/sapdata1

249G 169G 80G 68% /oracle/SID/sapdata2

249G 122G 127G 49% /oracle/SID/sapdata3

249G 141G 108G 57% /oracle/SID/sapdata4

249G 151G 98G 61% /oracle/SID/sapdata5

249G 147G 102G 60% /oracle/SID/sapdata6

ServerName:/oracle/SID #

And check the u201CUsedu201D column in order to see the space needed.

> For refresh purpose we only consider size of for eg sapdat1-20 or other stuff like

After the datafile restore you have to apply also the archive logs, so you need enough space in the archive partition (/oracle/SID/saparch/ or /oracle/SID/oraarch/ ).

If you are not sure where your archive logs are stored, check your oracle parameter file:

ServerName:/oracle/SID/sapdata1 # more /oracle/SID/102_64/dbs/initSID.ora | grep archive

*.log_archive_dest='/oracle/SID/saparch/SIDarch'

ServerName:/oracle/SID/sapdata1 #

Regards,

Federico