File size is increasing quickly on the sap server

[yiming_zhang]

Hello,

I installed a netweaver on my PC (Windows 😎 only for my test. So no other users using it and almost no jobs running on it. I am not doing many operations on it too. But I found the following folder size is increasing very quickly. About 1G or 2G totally every day, even no user logon and use it. Is there anyone who can tell me how to reduce the size? Thank you.

C:\oracle\ORL\sapdata1

C:\oracle\ORL\sapdata2

C:\oracle\ORL\sapdata3

C:\oracle\ORL\sapdata4

Best regards,
Yiming

[former_member209925 · Accepted solution]

Hi Zhang

check your "database log mode" is enabled or disabled.

check the number of file and size of all files  which is present in this below locataion

Drive:\oracle\<sid>\oraarch

Regards,

saharoon,

[yiming_zhang · Accepted solution]

Hi saharoon,

I have deleted the archived log in this path (Drive:\oracle\<sid>\oraarch), but only 1.6G space recovered. Almost 32G are occupied by the above 4 folders. I do not know what they are and why increasing all the time.

Best regards,

Yiming

[former_member209925 · Accepted solution]

Hi Zhang,

Please refer this note Preventing Tables from increasing considerably : 706478

Regards,

saharoon.s 

[Former Member]

Hi,

may be a good antivirus would solve the issue of File Multiplication

[former_member242544]

Hi Yiming,

Which oracle release is this testsystem? If you don't do anything on the system, then

probably automatic oracle jobs create this data, it would be good if you figure out which tablespace

and which objects increase in size.

Anyway, often the SYSAUX tablespace is a problem, which has a growing statistic history.

With

  exec dbms_stats.alter_stats_history_retention (0);

you can deactivate the statistics history, so that it is not created any more.

You can find more information in SAP note 588668 point 41 or also in ORACLE note 329984.1 if you have access.

Regards, Péter

[yiming_zhang]

Hi Péter,

It is oracle 12.1.0. It seems all the tablespace are increasing rapidly, because I found the data files are updated every day even if I do not logon to SAP and all have large data file size (more than 1 G) . Can you please suggest further? Thank you.

Best regards,
Yiming

[yiming_zhang]

Hi Péter,

SYSAUX tablespace has only 500M.

Best regards,
Yiming

[Former Member]

Hello Yiming,

1. As Peter has suggested, set the retention period to zero.

2. As this is just a play system, disable DB archiving (NOARCHIVELOG).

3. Set your datafiles/tablespaces to "autoextend off"

KR,

Amerjit