MB1B Update Performance

[Former Member]

Hi Team,

For inventory the users executing the MB1B tcode that time only update for MB1B is taking nearly 4000 sec to complete. In that period the update is in initial status and creating lock entry for other users.

Only for MB1B it is taking lot of time as comapre to earlier.

The following SQL plan for the respective update :

SQL Statement

SELECT

/*+

FIRST_ROWS (1)

*/

*

FROM

"EKBE"

WHERE

"MANDT" = :A0 AND "EBELN" = :A1 AND "MATNR" = :A2 AND "VGABE" = :A3 AND ROWNUM <= :A4#

Execution Plan

Explain from v$sql_plan: Address: 0700000495FD9BB8 Hash_value: 1548818089 Child_number: 0 Sql_id: 9mm068tf525p9

Parse Timestamp: 20090130 13:28:31.

The statistics of EKBE and index quality is proper.

Kindly suggest.

Oracle version 10.2.0.4

Kernel 247.

R3 Enterprise*200.

Regards,

Rahul.

[Former Member]

Thanks

[Former Member]

Hi

There may be customization required for variant settings for the data that you are trying to fetch with this. Kindly contact someone from logistics or procurement to look into your problem.

Your query might be processing a lot of records from the database that may be a reason for such delays.

Regards

Chen

[former_member251078]

Could you please provide the explain plan and the index on this table ?

Regards

Dileep

[JPReyes]

Moved to Performance forum