VBDATA inserts are taking more time.

[Former Member]

Hi,

We are seeing performance issue with VBDATA inserts.

I gone through the sap note:67014 and ran the program RSM13002 with re-org option.

It deleted the incomplete update requests, but the size of the VBDATA table didnt reduce.

Our database team recommends to export,truncate,import, run the update stats of VBDATA.

But I would like to follow the sap standard way.

Could anyone suggest me how to perform re-org of VBDATA?

Regards,

Gowri Shankar.

[thiago_cavalheiro]

Hi Gowri,

Are you using SecureFile to store your LOB segments?

There are some known bugs for this behaviour, like 12989671. The best you can do is to apply the latest SBP as these bugs are corrected there. As a workaround you can try setting event 10019 with level 1 or moving the table to a non-ASSM tablespace.

Best regards,

Thiago

[Former Member]

Sorry for the late Reply.

Stefen@ I have done online re-org of vbdata on sandbox,Dev,QA systems, eliminated the fragmentations. functional team will re-run the reports in staging today or monday, will update the status of the performance of the system.

Radha Krishnan/Thiago@ We are on oracle 11g patch4, going to apply latest patches.

Regards,

Gowri Shankar.

[Former Member]

Hi Gowri,

What is the version of your Oracle ? Could you please provide more details around slowness ? Do you experience the slowness all the time or sporadically or only with certain transactions ?

Are you seeing the work process spin while it tries to insert a record into VBDATA ?

I have faced similar issue in the past (With Oracle 10g) and it happened to be an Oracle bug. See this note for details if you happen to use 10g.

http://service.sap.com/sap/support/notes/1491797

Thanks

[stefan_koehler]

Hi Gowri,

i am sorry, but how should a reorg improve the INSERT DML performance? (except the possibility of reducing a few logical I/Os depending on the B*-Tree level)

> Could anyone suggest me how to perform re-org of VBDATA?

Depends on your table structure (e.g. still using LONG RAW or already using BLOB).

However i fully doubt that the reorg will fix any DML performance issue. Are you using Oracle ACO? We already got a discussion on SCN about a performance issue when using LONG RAW in combination with Oracle ACO.

Regards

Stefan

[Former Member]

Hi Stefan,

You are right, Re-org may not improve the performance but our dba team suggested to do on VBDATA table as it has many fragmentations.

Oracle SQL command level VBDATA structure shows BLOB and at SAP level (Tcode SE11) it shows LRAW as column. I believe whatever it is showing in SQL command is correct.

We are not using Oracle ACO.

As VBDATA table already has BLOB, Can I go ahead and perform offline re-org on the table?

Regards,

Gowri Shankar.

[stefan_koehler]

Hi Gowri,

fragmentation ... the unholy ghost in an Oracle database

However you can reorg your table online, if it already is defined with BLOB columns (the described difference between ABAP DDIC and SQL level is totally normal). So go ahead, but don't expect to fix the issue with that task.

Regards

Stefan