TKPROF

From: <amerar_at_iwc.net>
Date: 1 Mar 2007 08:31:48 -0800
Message-ID: <1172766708.755169.214530@k78g2000cwa.googlegroups.com>

Hi All,

I am following up on my own post. I ran TKPROF against my large query, and, once of the inline functions returned the following results.

While there was no disk I/O, there were a lot of buffer hits. Do you know of any way to cut these fetches down? I'm just a bit lost on no disk I/O, but it took 20 minutes to finish this query......

Thanks!

SELECT MAX(CO.ORDER_DATE)
FROM
CUSTOMER_ORDER CO,ORDER_LINE OL,PRODUCT P WHERE CO.ORDER_ID = OL.ORDER_ID
AND OL.PRODUCT_ID = P.PRODUCT_ID AND P.SUBPRODUCT_ID = :b1 AND CO.CUSTOMER_ID = :b2

call     count       cpu    elapsed       disk      query
current        rows

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

Parse        1      0.00       0.00          0          0
0           0
Execute    456      3.60       3.96          0          0
0           0
Fetch      456     16.67      17.63          0     234384
0         456

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

total      913     20.27      21.59          0     234384
0         456

Received on Thu Mar 01 2007 - 10:31:48 CST