SMQ2 Issue

[Former Member]

Hello,

I am having a wierd problem with SMQ2--

Problem: Messages are getting accumulated and being processed very slowly. Eventhugh there are many DIA WPs in waiting mode.

- Configured SARFC properly

- Configured enough AI_RUNTIME_XX connections

- Configured enough Queue parellalism

- Messages are taking a verylong time in DB_SPLITTER_QUEIUING

Did anyone have this kind of issue before? Did I miss anything?

Any help is greately appreciated.

Regards

[Former Member]

Venu,

Performance Issue !!!

Check out for "DB_SPLITTER_QUEIUING" issue :

http://www.scribd.com/doc/7247858/XI-Performance-Check-Version-894509

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/104ff330-5d59-2a10-f9bb-843c9415c...

Regards,

[Former Member]

Santhosh,

Before I posted the question, I have read through all the documents related to performance and tuned accordingly. I am doing the performance tuning for first time on installation with Oracle 10g. I have done the tuning before on other systems, but didn't face this issue. Is there anything different in Oracle 10g. By the way this is a new installation.

Did we miss any post installation activity related to Oracle?

Please advise..

[agasthuri_doss]

Hey,

Are you processing SYNC messages,

Cheers

Agasthuri

[Former Member]

No. All my scenarios are Async.

[Former Member]

just tell your basis guys to run "DBSTATISTICS" and give restart...

[Former Member]

Ran the DB Statistics, but it didn't fix the issue.