NAST table giving TIME_OUT dump

[former_member198270]

Hello All,

We are getting TIME_OUT dump while accessing NAST table in one of our PROD system

IN SE11 tcode for Displaying NAST table "Number of Entries"

it is giving too much time and after that giving time out dump

Any suggestions .

Regards,

Amber S

[markus_doehr2 · Accepted solution]

> IN SE11 tcode for Displaying NAST table "Number of Entries"

> it is giving too much time and after that giving time out dump

The "select count(*)" is taking too long.

What database version are you using? Are the statistics of the table NAST up-to-date?

Markus

[former_member198270]

Thanks

[former_member198270]

Thank you all for providing valuable information.

I am closing this thread and rewarding the points.

Thanks,

Amber S

[Former Member]

Dear Amber,

as Markus already mentioned please have a look onto the statistics of your database optimizer. We solved a lot of such problems in several SAP systems be updating the database optimizer statistics.

Beside you may have a look onto the indexes of the table as well as the buffering.

Hope this helps.

Regards

André

[Former Member]

Please ask the developer to create the required indexes on it if required.

Also let us know the oracle release and patch you have?