Very slow response of SXMB_MONI transaction

[Former Member]

Hello Experts,

We are facing performance issue for transaction SXMB_MONI in ECC production server. It is taking around 10-15 min and even give Time out

error in ST22 dump.I have gone through various threads on this topic where it is suggested to rebuild indexes and run DB stat.I have rebuild the indexes

SXMSPMAST~ARC

SXMSPMAST~DEL

SXMSPMAST~MON

SXMSPMAST~PAR

SXMSPMAST~RTM

SXMSPMAST~TID

SXMSPEMAS~0

and updated statistics but again I am not gaining any thing . Need ur immediate support to troubleshoot this.

Thanks

Aditya Roushan

[former_member201275]

Hi, is your question answered. Would be great if you could mark and close, and also provide the solution so that others with the same error could also benefit.

[former_member201275]

You need to rebuild the indexes of tables related to SXMB_Moni

SXMSPMAST - master table

SXMSPEMAS

SXMSCLUR 

and SXMSCLUP

This has solved my problem.

Please check and do the following:

.For rebuilding Please go to DB02 go to detailed analysis fill the Object Name & execute it,now click on Table Index,Select the Appropriate index,then go to detailed analysis,Now check the storage Quality of Index.Ideally it should be more than 75%.If the storage quality is quite less then go to index menu & rebuild Index.next day you will not get any warning related to this Index

[Former Member]

Hi Aditya.

i am from Basis.

please do the following

first run sxmb_moni once you get the result after 10 mins do the following

1. go to st22 and see if there is any dump?

2. go to st11 and check for the latest WP process log file and you might get an answer.

3. IF Solman is configured then please generate the EWA and check for the suggestions in terms of memory parameters.

4. generate the AWR report at Oracle it will suggest which SQL statement is taking more memory.

(you can generate AWR report /oracle/SID/112_64/rdbms/admin/awr Reports.

and also try to run SXMB_MONI for lesser time and check for the options (ERRORS Only ) rather then all messages . and see if it runs fast?

Regards

Dishant Pathak.

[tomasz_domanski]

Hi,

Are you a basis consultant? Have you checked if time out is on DB level and then checked parameters? Maybe the SQL statement is not being possible to run with current memory allocation?

I'm not basis specialist, I'm functional, but we had some issues also, with queries especially which were solved by correction on DB level. (or DB parameters on OS level - I'm not sure)

Regards,

Tomek

[Former Member]

Hi Tomasz,

Yeah, I am from Basis Team.Time Out is happening as this transaction is running longer than what is defined in parameter rdisp/max_wprun_time. My concern is, why this transaction is running so long (more than 10 mins).I have taken some corrective action as stated before but it didn't help me.

Thanks

Aditya

[tomasz_domanski]

Hi,

Have you tried ST05 and analyze which DB selections are taking that much time? I guess it would be this part that can last that long?

BR,

Tomek