SQL Performance (MOSC)

MOSC Banner

Poor performance after upgrade EBS database from 11.2.0.2 to 11.2.0.4

edited Jul 12, 2017 5:00AM in SQL Performance (MOSC) 7 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center