Skip to Content
avatar image
Former Member

MB1B Update Performance

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 30, 2009 at 03:08 PM

    Moved to Performance forum

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2009 at 08:48 PM

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

    Regards

    Dileep

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 19, 2009 at 03:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 02, 2009 at 12:40 PM

    Thanks

    Add comment
    10|10000 characters needed characters exceeded