Skip to Content
0
Former Member
Jan 30, 2009 at 02:45 PM

MB1B Update Performance

51 Views

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.