Data Base size

[Former Member]

Hi Experts,

The size of the oracle data base for SAP-XI is increased by 9% strangly in 1 day, where as 1% increase in the oracle data base size normally takes 1 to 2 weeks.

What could be the problem? Please give me some links or some idea how to check to know what causes this problem.

Thnx

Subbu

[Former Member · Accepted solution]

Check the throughput for that day.

You can check this in the message monitoring in the RWB.

Or you can check ST04N / ST03N.

[Former Member · Accepted solution]

Hi Barry,

Thanks alot for your quick answer.

i tried both options

1) when i tried to see all the messages in message monitoring, the browser got stuck. Could you please tell me am i doing correct.

2) I am not authorised to ST04n/3N

Could you please tell me what causes this problem?

Thanks alot

subbu

[Former Member · Accepted solution]

Hi Barry,

i got authorizations for ST04N

What to do now? Please suggest me.

Thanx

Subbu

[Former Member]

Hi,

However it is very difficult to comment why your database size suddenly grow by 9% but you can check following:

- Reduce trace level for messages (SXMB_ADM->IE configuration->tuning)

- Heavy transactions (however it is unlikely until some jobs are running accidently and sending huge chunk of data to XI)

- Check with user of interfaces whether they received lot of un-necessary data or not.

Give some more information to help you in this case. There are trasactions to monitor disk growth but since you are authorized then you can ask for SAP BASIS help.

Regards,

Gourav

[Former Member]

HI Gourav,

Please tell me what are the trasactions to see the growth of database in SAP.

Now i have full authorizaiton.

Please guide me, My problem is , i need to do a investigation why this increase.

One clue is so many users are interacting in Dev server frequenlty.

Apart from that i dont have any clue.

Thnx

Subbu