topic Re: Table: M_PREMP? in Application Development and Automation Discussions

Table: M_PREMP?

Former Member — Thu, 08 Mar 2007 23:22:01 GMT

Hi,

I am trying to figure a performance issue. When activing the CCURE_PIDSL flag, you get a different selection box via PA30. One called "Search Help: External Person ID EXT", which goes against infotype 0709. This search help is against table M_PREMP, which composes of several join.

Anyhow, when using it, it takes over 30 minutes to return a record. Even if you use a value you know exist like a PERNR / PERSON_EXT value and type it in the search help, it takes 30 or more minutes to return the value.

Look at the performance trace, it doing a lot of stuff and hanging around the M_PREMP table.

Anyone come across performance issue or know what this is causing a problem?

Re: Table: M_PREMP?

Former Member — Mon, 12 Mar 2007 17:27:48 GMT

Anyone experiences this or have some form of experiences?

Re: Table: M_PREMP?

Former Member — Thu, 19 Apr 2007 15:14:23 GMT

FYI..

Anyone interested. Issue resolved.

Message From SAP:

Your message has been forwarded to Oracle development support for

further analysis. I have logged into your database and can see

where the slow query is performing a "merge join cartesian" - which

is not what we would expect to see as this would be a very slow query.

In review of your 9.2.0.7 settings I can see you have not applied

any of the required one-off patches and the init.ora parameters are

also not set per recommendations (missing underscore parms/events).

Please ref oss notes: 938986 / 124361 and apply the required patches

and init.ora settings. Once done, please test the same process and

return the message if it continues to timeout. You should also

refresh the database stats on the tables PA0001/PA0002 which were

last updated 3/9.