Skip to Content

File size is increasing quickly on the sap server

Hello,

I installed a netweaver on my PC (Windows 8) 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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Sep 18, 2015 at 09:22 AM

    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,


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 18, 2015 at 09:25 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2015 at 10:58 AM

    Hi,

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.