TKPROF: Release 10.2.0.3.0 - Production on Mon Feb 15 14:32:58 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Trace file: pcat_j000_2187268.trc Sort options: default ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** UPDATE "CBS_OWNER"."ITEM_TRAIT_OPTION_MAP" SET "DATA_SET_VERSION_ID" = :1, "ITEM_ID" = :2,"TRAIT_OPTION_ID" = :3 WHERE "DATA_SET_VERSION_ID" = :1 AND "ITEM_ID" = :2 AND "TRAIT_OPTION_ID" = :3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 31567 2065.61 2143.39 0 43794529 63700 31567 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 31567 2065.61 2143.39 0 43794529 63700 31567 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 25 (recursive depth: 3) ******************************************************************************** select file# from file$ where ts#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 0.00 0 16 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 4) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL FILE$ (cr=4 pr=0 pw=0 time=26 us) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 0 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net more data from dblink 212 0.00 0.00 SQL*Net message to dblink 1 0.00 0.00 SQL*Net message from dblink 1 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 31571 2065.61 2143.40 0 43794529 63700 31567 Fetch 8 0.00 0.00 0 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 31583 2065.61 2143.40 0 43794545 63700 31571 Misses in library cache during parse: 1 Misses in library cache during execute: 2 1 user SQL statements in session. 4 internal SQL statements in session. 5 SQL statements in session. ******************************************************************************** Trace file: pcat_j000_2187268.trc Trace file compatibility: 10.01.00 Sort options: default 1 session in tracefile. 1 user SQL statements in trace file. 4 internal SQL statements in trace file. 5 SQL statements in trace file. 2 unique SQL statements in trace file. 32060 lines in trace file. 3474 elapsed seconds in trace file.