topic Re: Table performance is low in Application Development and Automation Discussions

Table performance is low

Former Member — Thu, 10 Dec 2009 03:05:47 GMT

Hi, experts:

I have a such issue, today I encounter a performance issue when selecting a table S680, but it worked fine yesterday. So I do the samething in another client, this client has more data records in S680, and no performance issue with same filter conditions. I think maybe there is something wrong with S680 in the client. Any idea or any action i can do about this? Thanks.

Re: Table performance is low

Former Member — Thu, 10 Dec 2009 03:18:22 GMT

Hi,

Which is the client in which you are facing this problem. Is is the 'DEV' Client.

And how many records it contains.

Are you to fetch the data through the appliction program or you are displaying data through SE16N.

Cross check has the table been modified with any append structures or with any other dictionary objects.

Just try adjusting the table once.

Hope this might help you.

Regards,

Ranjith n

Re: Table performance is low

Former Member — Thu, 10 Dec 2009 03:24:50 GMT

Hi, Nambiar:

Thanks for your reply.

The issue happened in our testing client. we used the two clients solution.

In a client, 84 millions data records, issue happened. Same issue using the Tcode SE16.

In the other client, 104 millions data recores, no issue.

With same filter conditions, so i am a bit confused.

And this table was not changed during 3 months recently.

Re: Table performance is low

Former Member — Thu, 10 Dec 2009 04:10:55 GMT

Hi ,

It doesn't look like a pbm with the table.The test client performance might be slow.

Might be an issue with table locks. When the lock entries reaches threshold, entire system performance would be low

and some transactions would result in dump.

Check ur test clients lock entries,similarly many factors would influence the performance.

Please check with your basis team.

Thanks

Aj Raj

Re: Table performance is low

mvoros — Thu, 10 Dec 2009 04:13:36 GMT

Hi,

you can try to check that table in SE14. There is a button Check. Maybe it will yield some problems. Have a look also at transaction ST04. You can also activate a SQL trace in ST05. SQL trace gives you plenty of useful information. You can find additional information about ST05 here on SDN. For example have a look at this [blog|/people/siegfried.boes/blog/2007/09/05/the-sql-trace-st05-150-quick-and-easy].

Cheers

Re: Table performance is low

Former Member — Thu, 10 Dec 2009 04:14:11 GMT

Hi,

Try to fetch the data based on key.

Or use indexing.

Regards,

Sunny

Re: Table performance is low

Former Member — Thu, 10 Dec 2009 04:25:14 GMT

There is nothing wrong with table S680.

Performance of an object depends on many factors and hence it varies from system to system.

Your testing client is having many records and hence this deviation is seen.

Please do SE30 And ST05 analysis in testing systen and take a decision.

Re: Table performance is low

Former Member — Thu, 10 Dec 2009 05:26:39 GMT

Hi, All:

I found some indices show waring message 'Index does not exist in database system ORACLE', i think this is the root cause, how to rebuild the indices except moving transport? Thanks.

Re: Table performance is low

mvoros — Thu, 10 Dec 2009 06:12:24 GMT

Hi,

I don't think that you can do it from SAP. You will have to use Oracle utilities. There are couple of notes about rebuilding indexes. Have a look on service.sap.com/notes

Cheers

Re: Table performance is low

Former Member — Tue, 15 Dec 2009 08:28:25 GMT

Create the index again by SE14.