Pls help to interpret

Posted by Laurel on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Pls-help-to-interpret-tp7278.html

Hi Erman!
Can you pls look at this AWR report..
The problem is that Scheduling is running too long  > 10 hours..
Here i run request  for 20 min  and cancelled it taking awr snaps and the main culprit in OEM is this sql with enormous execution times > 3 mln  .. its part of  OE_SCH_CONC_REQUESTS.Request

Anything else you see as a problem in our db ? that could contribute to our issue why its taking so much time..
 fm7rv4gf8akub
SELECT PEGGING_ID ,   IDENTIFIER3, IDENTIFIER2, IDENTIFIER1, SUPPLY_DEMAND_TYPE, INVENTORY_ITEM_ID, CHAR1, ORGANIZATION_ID, SUPPLY_DEMAND_DATE, SUPPLY_DEMAND_QUANTITY, DEPARTMENT_ID, RESOURCE_ID, ORDER_LINE_ID, SUPPLIER_ID, SUPPLIER_SITE_ID, SUPPLIER_ATP_DATE, DEST_INV_ITEM_ID, SUMMARY_FLAG , AGGREGATE_TIME_FENCE_DATE FROM MRP_ATP_DETAILS_TEMPWHERE (( PEGGING_ID <> :B2 AND (:B3 = 2 OR :B3 = 3)) OR (:B3 = 1)) AND RECORD_TYPE IN (3, 4) AND SESSION_ID = :B1 START WITH PEGGING_ID = :B2 AND SESSION_ID = :B1 AND RECORD_TYPE = 3 CONNECT BY PARENT_PEGGING_ID = PRIOR PEGGING_ID AND SESSION_ID = PRIOR SESSION_ID AND RECORD_TYPE IN (3, 4)

Thx alot!
Laurelawr.zip