cancel
Showing results for 
Search instead for 
Did you mean: 

sxmb_moni SXMSPMAST Table

Former Member
0 Kudos

Hello,

In ECC 6 Dev system, we are processing some excel files through Zprogram which helps in getting the required format of sap PI. we are monitoring through SXMB_MONI in ECC system.

we are able to execute sxmb_moni but it is taking a very very long time (nearly an hour). So please kindly suggest your views and how to improve system performance.

I debuged the code and system is taking long time  while reading the data from "sxmspmast" table.

Please help me...

Accepted Solutions (1)

Accepted Solutions (1)

MichalKrawczyk
Active Contributor
0 Kudos

Hi,

1. check if you can update statistics (when running oracle) - OSS note -

1020260 - Delivering Oracle statistics

2. OSS note - 1362116

3. DB check

then it will work again

Regards,

Michal Krawczyk

Former Member
0 Kudos

Hi Sankar and Michal,

Sankar- I have seen those above threads before drafting this querry.

All those notes are specific to SAP PI...i am facing this problem in SAP ECC Dev system not in SAP PI system.

MichalKrawczyk
Active Contributor
0 Kudos

Hi,

>>>All those notes are specific to SAP PI...i am facing this problem in SAP ECC Dev system not in SAP PI system.

not true the same applies to ECC - DB stats and DB check are DB specific and have nothing to with SAP system

Regards,

Michal Krawczyk

Answers (1)

Answers (1)

Former Member
0 Kudos