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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).