Database Tuning (MOSC)

MOSC Banner

Need help Tuning Inventory SQL Script

edited Dec 15, 2009 6:38PM in Database Tuning (MOSC) 1 commentAnswered
I'm trying to tune this sql script for our Inventory PLSQL program; the procedure is very slow that it takes hours to complete. I ran a Tkprof on the program trace file and it show that there are two expensive SQL scripts and the one below is the main culprit. Any kind of help will be appreciated.

Thanks in advance.

Leo

---------------------------------------------------------------------------------------------------------

 SELECT msib.organization_id, msib.inventory_item_id, msib.segment1,
                msib.description, msib.planning_make_buy_code, msib.buyer_id,
                msib.planner_code, msib.primary_uom_code,
                msib.safety_stock_bucket_days,
                (SELECT NVL (cic.item_cost, 0)
                   FROM cst_item_costs cic, cst_cost_types cct

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