TKPROF output looks strange, zero for disk/query/current
RDBMS 11.2.0.2 RHEL6 x64
I have a report that takes over two hours to run (it useally takes around 30min). I used tkprof after I traced the session. This is the output of one of the queries:
SELECT ST.STORE, ST.STORE_NAME, RS.STYLE STYLE,
LDX_PROD_HIER_COMMON.GET_STYLE_DESC( RS.STYLE, ST.COUNTRY_ID) ITEM_DESC,
RS.SKU, DECODE(TDH.TRAN_CODE, 1, TDH.UNITS, 0) QTY, DECODE(TDH.TRAN_CODE, 1,
TDH.TOTAL_COST, 0) LANDED_COST, DECODE(TDH.TRAN_CODE, 1, TDH.TOTAL_RETAIL,
0) RETAIL_PRICE, TRAN_DATE
FROM
RAG_SKUS RS, TRAN_DATA_HISTORY TDH, STORE ST, DISTRICT D WHERE D.REGION =