Database Administration (MOSC)

MOSC Banner

TKPROF output looks strange, zero for disk/query/current

edited Sep 5, 2012 10:31PM in Database Administration (MOSC) 9 commentsAnswered
Hi,

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 =

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