Poor performance after upgrade EBS database from 11.2.0.2 to 11.2.0.4
Hello Comunity,
I'm desperate
After upgrade EBS database from 11.2.0.2 to 11.2.0.4, we have serious performace issues in all EBS environment. The most common is the wait for "Db file sequencial read" as follows:
SQL ID: a3cr4626ahuzh Plan Hash: 385819352
SELECT DESCRIPTION , CONCATENATED_SEGMENTS
FROM
MTL_SYSTEM_ITEMS_KFV WHERE ORGANIZATION_ID = :b1 AND INVENTORY_ITEM_ID =
:b2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 34.48 1571.40 254577 651533 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 34.49 1571.40 254577 651533 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE