The request "Launch MRP Supply Chain Planning Processes" execute too slow
The request "Launch MRP Supply Chain Planning Processes" execute too slow,The execution took 40 minutes.
After I reduce the table clustering factor ,then it takes 7 minutes.
I want to change it faster,so I get the request trace,Fragments as follows:
=====================================================================================
DELETE FROM mrp_bom_components
WHERE compile_designator=:vdesig
AND 1=1
AND rownum <= 75000
AND organization_id = :org_id
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 13 0.00 0.00 0 0 0 0
Execute 13 58.08 128.46 191341 784928 11192592 916596
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 26 58.08 128.46 191341 784928 11192592 916596
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS