messages take a long time to open after EHP1 upgrade

[Former Member]

hi,

We have recently upgraded our PI 7.0 to EHP1 and we find that it takes unusually long time in sxmb_moni to open up(view) messages, has anyone seen this before .

Thank you

Jonu Joy

[marksmyth]

Hi Jonu

Apply note #1020260 Delivering Oracle statistics. This should definitely improve the performance.

Regards

Mark

[marksmyth]

Hello Jonu

Check if note #1124574 Performance improvement for 'SQL Server' in trans SXMB_MONI, is relevant to your system.

Regards

Mark

[Former Member]

Hi Mark,

Thank you, the note you mentioned is for MS SQL server, but we are on Oracle.

Thx

Jonu Joy

[Former Member]

I'd suggest tracing system activity when this long runtime issue occurs, so you could know where this time is spent (db access ? etc) ... a plain SM50 call in parallel could do the trick if runtime is long enough !

Chris