TKPROF: Release 11.2.0.3.0 - Development on Tue Nov 12 03:14:53 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: wedb1_ora_8123_test_plan1.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 ******************************************************************************** SELECT TAM.MANF AS MANF, TAM.MAJOR_LOCATION AS OPTION_LOCATION, (SELECT LOCATION_DESCRIPTION FROM BLUEB_TAM_DESCRIPTION WHERE NT_NUM = TAM.MAJOR_LOCATION AND ROWNUM = 1) AS LOCATION_DESCRIPTION, (SELECT LOCATION_DESCRIPTION FROM BLUEB_TAM_DESCRIPTION WHERE NT_NUM = TAM.MANF AND ROWNUM = 1) AS MANF_DESCRIPTION, TAM.NT_NUM AS SKU, TAM.REBEAT_GROUP, TAM_DESCRIPTION.SHORT_DESC AS DESCRIPTION, (SELECT SHORT_DESC FROM BLUEB_TAM_DESCRIPTION WHERE LOCATION_CODE = 'AB' AND NT_NUM = TAM.NT_NUM AND LOCATION = TAM.LOCATION AND ROWNUM = 1) AS EN_DESCRIPTION, TAM.DESCRIPTION AS LONG_DESCRIPTION, PRP.LIST_PRICE, PRP.COST_PRICE, TCS.TOT_RANGE AS TOT_RANGE, TCS.AVG_RANGE AS AVG_RANGE, REBEATS.DISCOUNTABLE AS DISCOUNTABLE, TCCC.TCCCIBUTE_KEYWORD AS TCCCIBUTE_KEYWORD, TCCC.TCCCIBUTE_TERM AS TCCCIBUTE_TERM, TCCC.QTY AS QTY, TAM.TAX_CODE, TAM.MAT_LOCATION, TAM.OPTICAL_NAME, TAM.MAT_TYPE, TAM.MAT_SOURCE FROM BLUEB_TAM TAM INNER JOIN BLUEB_TAM_DESCRIPTION TAM_DESCRIPTION ON TAM.NT_NUM = TAM_DESCRIPTION.NT_NUM AND TAM.LOCATION = TAM_DESCRIPTION.LOCATION AND TAM_DESCRIPTION.LOCATION_CODE = :LOCATION_CODE INNER JOIN PRICE_LIST PRP ON TAM.NT_NUM = PRP.NT_NUM AND PRP.cates = :cates AND PRP.MONEY_UNIT = :MONEY_UNIT INNER JOIN TAM_REBEAT REBEATS ON TAM.REBEAT_GROUP = REBEATS.REBEAT_GROUP AND REBEATS.REBEAT_NAME = :REBEAT_NAME INNER JOIN TAM_CATEGORY_STATS TCS ON TAM.LOCATION = TCS.LOCATION AND TAM.MANF = TCS.MANF AND PRP.MONEY_UNIT = TCS.MONEY_UNIT AND TCS.cates = PRP.cates LEFT JOIN TAM_CLASSIFICATIONS TCCC ON TAM.NT_NUM = TCCC.NT_NUM WHERE NVL (TAM.DISABLED, 'N') = 'N' AND SYSDATE BETWEEN NVL (TAM.STRT_DATE, DATE '0001-01-01') AND NVL (TAM.END_DATE, DATE '3999-12-31') AND TAM.MANF = :MANF AND TAM.NT_NUM IN((SELECT /*+ CARDINALITY(t, 1) */ COLUMN_VALUE FROM table (Split(:NTNUM_LIST,:NTNUM_LIST_delim)) t) ORDER BY TAM.NT_NUM call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.32 0.32 0 48 0 0 Fetch 1 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.32 0.32 0 48 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 COUNT STOPKEY (cr=0 pr=0 pw=0 time=0 us) 0 0 0 TABLE ACCESS BY INDEX ROWID BLUEB_TAM_DESCRIPTION (cr=0 pr=0 pw=0 time=0 us cost=5 size=134 card=2) 0 0 0 INDEX RANGE SCAN BLUEB_TAM_DESCRIPTION_N2 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=2)(object id 112788) 0 0 0 COUNT STOPKEY (cr=0 pr=0 pw=0 time=0 us) 0 0 0 TABLE ACCESS BY INDEX ROWID BLUEB_TAM_DESCRIPTION (cr=0 pr=0 pw=0 time=0 us cost=5 size=134 card=2) 0 0 0 INDEX RANGE SCAN BLUEB_TAM_DESCRIPTION_N2 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=2)(object id 112788) 0 0 0 COUNT STOPKEY (cr=0 pr=0 pw=0 time=0 us) 0 0 0 TABLE ACCESS BY INDEX ROWID BLUEB_TAM_DESCRIPTION (cr=0 pr=0 pw=0 time=0 us cost=4 size=81 card=1) 0 0 0 INDEX RANGE SCAN BLUEB_TAM_DESCRIPTION_U1_MARKT (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 112789) 0 0 0 SORT ORDER BY (cr=0 pr=0 pw=0 time=584 us cost=48 size=2432 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=562 us) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=559 us cost=47 size=2432 card=1) 0 0 0 NESTED LOOPS OUTER (cr=0 pr=0 pw=0 time=555 us cost=44 size=2351 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=550 us cost=42 size=2320 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=546 us cost=39 size=2292 card=1) 0 0 0 NESTED LOOPS OUTER (cr=0 pr=0 pw=0 time=545 us cost=37 size=2276 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=541 us cost=36 size=2250 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=538 us cost=33 size=2218 card=1) 0 0 0 VIEW VW_NSO_1 (cr=0 pr=0 pw=0 time=533 us cost=29 size=2002 card=1) 0 0 0 HASH UNIQUE (cr=0 pr=0 pw=0 time=526 us) 0 0 0 COLLECTION ITERATOR PICKLER FETCH SPLIT (cr=0 pr=0 pw=0 time=401 us cost=29 size=2 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID BLUEB_TAM (cr=0 pr=0 pw=0 time=0 us cost=3 size=216 card=1) 0 0 0 INDEX RANGE SCAN BLUEB_TAM_N4 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 112794) 0 0 0 TABLE ACCESS BY INDEX ROWID TAM_CATEGORY_STATS_B (cr=0 pr=0 pw=0 time=0 us cost=3 size=32 card=1) 0 0 0 INDEX RANGE SCAN TAM_CATEGORY_STATS_N1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 112800) 0 0 0 TABLE ACCESS BY INDEX ROWID TAM_MAIN_CLASSIFICATIONS (cr=0 pr=0 pw=0 time=0 us cost=1 size=26 card=1) 0 0 0 INDEX UNIQUE SCAN GEDIS_TAM_MAIN_CLASSIFICATIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 112799) 0 0 0 TABLE ACCESS BY INDEX ROWID TAM_REBEAT (cr=0 pr=0 pw=0 time=0 us cost=2 size=16 card=1) 0 0 0 INDEX RANGE SCAN TAM_REBEAT_N1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 112817) 0 0 0 TABLE ACCESS BY INDEX ROWID PRICE_LIST (cr=0 pr=0 pw=0 time=0 us cost=3 size=28 card=1) 0 0 0 INDEX RANGE SCAN PRICE_LIST_U1_MARKT (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 112841) 0 0 0 INDEX RANGE SCAN TAM_CLASSIFICATIONS_N5 (cr=0 pr=0 pw=0 time=0 us cost=2 size=93 card=3)(object id 112785) 0 0 0 INDEX RANGE SCAN BLUEB_TAM_DESCRIPTION_U1_MARKT (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 112789) 0 0 0 TABLE ACCESS BY INDEX ROWID BLUEB_TAM_DESCRIPTION (cr=0 pr=0 pw=0 time=0 us cost=3 size=81 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 2 0.00 0.00 library cache pin 3 0.00 0.00 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 13.52 13.52 ******************************************************************************** SQL ID: grwydz59pu6mc Plan Hash: 3684871272 select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=48 us cost=1 size=15 card=1) ******************************************************************************** SQL ID: 47r1y8yn34jmj Plan Hash: 2191121161 select default$ from col$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 4 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID COL$ (cr=1 pr=0 pw=0 time=10 us cost=1 size=15 card=1) ******************************************************************************** SQL ID: 1mjd9xp80vuqa Plan Hash: 3023518864 select node,owner,name from syn$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID SYN$ (cr=3 pr=0 pw=0 time=52 us cost=2 size=35 card=1) 1 1 1 INDEX UNIQUE SCAN I_SYN1 (cr=2 pr=0 pw=0 time=36 us cost=1 size=0 card=1)(object id 77) ******************************************************************************** SQL ID: 3ktacv9r56b51 Plan Hash: 4184428695 select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 1 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 1 6 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=6 pr=1 pw=0 time=9465 us cost=10 size=222 card=3) 1 1 1 NESTED LOOPS OUTER (cr=6 pr=1 pw=0 time=9353 us cost=9 size=222 card=3) 1 1 1 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=3 pr=1 pw=0 time=9307 us cost=3 size=84 card=3) 1 1 1 INDEX RANGE SCAN I_DEPENDENCY1 (cr=2 pr=0 pw=0 time=48 us cost=2 size=0 card=3)(object id 106) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 pr=0 pw=0 time=29 us cost=2 size=46 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=20 us cost=1 size=0 card=1)(object id 36) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 2 0.00 0.00 gc cr grant 2-way 1 0.00 0.00 db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: 8swypbbr0m372 Plan Hash: 893970548 select order#,columns,types from access$ where d_obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID ACCESS$ (cr=2 pr=0 pw=0 time=38 us cost=3 size=174 card=6) 0 0 0 INDEX RANGE SCAN I_ACCESS1 (cr=2 pr=0 pw=0 time=29 us cost=2 size=0 card=6)(object id 108) ******************************************************************************** SQL ID: cb21bacyh3c7d Plan Hash: 3452538079 select metadata from kopm$ where name='DB_FDO' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID KOPM$ (cr=2 pr=0 pw=0 time=19 us cost=1 size=108 card=1) 1 1 1 INDEX UNIQUE SCAN I_KOPM1 (cr=1 pr=0 pw=0 time=12 us cost=0 size=0 card=1)(object id 545) ******************************************************************************** SQL ID: ga9j9xk5cy9s0 Plan Hash: 1697022209 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID IDL_SB4$ (cr=3 pr=0 pw=0 time=26 us cost=3 size=19 card=1) 0 0 0 INDEX RANGE SCAN I_IDL_SB41 (cr=3 pr=0 pw=0 time=20 us cost=2 size=0 card=1)(object id 239) ******************************************************************************** SQL ID: cvn54b7yz0s8u Plan Hash: 3246118364 select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID IDL_UB1$ (cr=3 pr=0 pw=0 time=24 us cost=3 size=18 card=1) 0 0 0 INDEX RANGE SCAN I_IDL_UB11 (cr=3 pr=0 pw=0 time=19 us cost=2 size=0 card=1)(object id 236) ******************************************************************************** SQL ID: c6awqs517jpj0 Plan Hash: 1319326155 select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID IDL_CHAR$ (cr=3 pr=0 pw=0 time=50 us cost=3 size=21 card=1) 0 0 0 INDEX RANGE SCAN I_IDL_CHAR1 (cr=3 pr=0 pw=0 time=15 us cost=2 size=0 card=1)(object id 237) ******************************************************************************** SQL ID: 39m4sx9k63ba2 Plan Hash: 2317816222 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID IDL_UB2$ (cr=3 pr=0 pw=0 time=19 us cost=3 size=21 card=1) 0 0 0 INDEX RANGE SCAN I_IDL_UB21 (cr=3 pr=0 pw=0 time=13 us cost=2 size=0 card=1)(object id 238) ******************************************************************************** SQL ID: 2syvqzbxp4k9z Plan Hash: 1423211129 select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 4 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=55 us cost=5 size=65 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=50 us cost=4 size=49 card=1) 0 0 0 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=47 us cost=2 size=16 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=33 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 36) 0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=16 card=1) 0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 11) ******************************************************************************** SQL ID: 06nvwn223659v Plan Hash: 0 alter session set events '10046 trace name context off' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: SYS ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.32 0.32 0 48 0 0 Fetch 1 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.32 0.32 0 48 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 206.64 220.17 library cache lock 2 0.00 0.00 library cache pin 3 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 13 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 0 0 0 0 Fetch 14 0.00 0.00 1 35 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 40 0.00 0.01 1 35 0 6 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 2 0.00 0.00 gc cr grant 2-way 1 0.00 0.00 db file sequential read 1 0.00 0.00 2 user SQL statements in session. 11 internal SQL statements in session. 13 SQL statements in session. ******************************************************************************** Trace file: wedb1_ora_8123_test_plan1.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 2 user SQL statements in trace file. 11 internal SQL statements in trace file. 13 SQL statements in trace file. 13 unique SQL statements in trace file. 441 lines in trace file. 220 elapsed seconds in trace file.