Oracle-L: Why Multiple Parses in Trace ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 04 Oct 2002 04:38:21 -0800
Message-ID: <F001.004E083A.20021004043821@fatcity.com>

Qs Why is the Followign Query being parsed 3 Times ?

SELECT ORDER_ACTION_ID
FROM
TASK_LOCATION_DETAILS WHERE ORDER_ACTION_ID='7118439A1' AND LOCATION_CD='B' AND LOCATION_ID='LOCALNSTRTT' AND KIND_OF_INFO='A' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse        3      0.00       0.00          0          0          0           0
Execute      3      0.00       0.00          0          0          0           0
Fetch        3      2.92       7.50       7430       9252         12           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        9      2.92       7.50       7430       9252         12           0

Misses in library cache during parse: 1
Optimizer goal: RULE
Parsing user id: 29 (BELGADOE)

Rows Row Source Operation

-------  ---------------------------------------------------
      0  TABLE ACCESS FULL TASK_LOCATION_DETAILS

Thanks

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 04 2002 - 07:38:21 CDT