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.