Table performance is low

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[mvoros]

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

[Former Member]

Hi,

Try to fetch the data based on key.

Or use indexing.

Regards,

Sunny

[Former Member]

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.

[Former Member]

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.

[mvoros]

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

[Former Member]

Create the index again by SE14.