Performance Problem in tables

[Former Member]

Dear Friends,

We are having a problem in the tables LTAP, LIPS and VTTK in our PRD environment.

The table are doing a sequential read that are causing a problem

in the performance of the system.

We are running the action "Update Statistics" all day by transaction DB13 but the problem persists.

At the moment we are using a temporary solution.

We are updating the statics tables by DB20 transaction with CX Method.

After these action the sequential read no more happen but the problem comes back after some days.

Anybody knows how to solve the problem permanently?

Best Regards,

Fábio Karnik Tchobnian

[volker_borowski2]

Hi,

after you calculated with -CX and execution is fine

lock the table stats to prevent brconnect from re-analyzing the table with another method.

(Can be done with brconnect in recent patch levels)

Or you enter -CX as the method to be chosen for special tables in table DBSTATC. See

http://help.sap.com/SAPhelp_nw04s/helpdata/en/f4/81e93a637bfd70e10000000a11402f/content.htm

how brconnect decides about the calculation method.

Hope this helps

Volker

[Former Member]

Try running index re organizing if index exists correctly, some times because of index problems data fetching will take much time so it gives performance problems.

Redards,

Sravan

[Former Member]

Hi

We solved this changing Oracle parameters according note below:

SAP Note 124361 - Oracle parameterization (R/3 >= 4.x,Oracle 8.x/9.x)

Best Regards,

Fábio Karnik Tchobnian

[former_member204746]

I had similar issues.. .with the same tables.

Oracle 10.2.0.4 on Windows

I had to modify

optimizer_dynamic_sampling=2

And this fixed our issue. Before attempting this, you need to analyze your SQL requests.

[stefan_koehler]

Hello Fábio,

no oracle version, no sql, no execution plan - no help.

If the problem occurs again - download the scripts from sapnote #1438410 and run the SQL_ID data collector for that particular SQL. Upload the generated output on a web hoster and post the link.

If we don't get these information - we are not able to help you.

Regards

Stefan