TKPROF: Release 11.2.0.1.0 - Development on Wed Dec 19 17:12:47 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Trace file: orcl_ora_2069.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 -------------------------------------------------------------------------------- *** SESSION ID:(141.85) 2012-12-19 16:11:34.538 ******************************************************************************** SQL ID: Plan Hash: 3661727852 alter session set sql_trace=true call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 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 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 62 ******************************************************************************** select count(pad) from test 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.77 0.74 0 17856 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.77 0.74 0 17856 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17856 pr=0 pw=0 time=746948 us) 10000000 TABLE ACCESS FULL TEST (cr=17856 pr=0 pw=0 time=77 us) ******************************************************************************** select count(pad) from test 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.66 0.64 0 17856 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.66 0.64 0 17856 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17856 pr=0 pw=0 time=642778 us) 10000000 TABLE ACCESS FULL TEST (cr=17856 pr=0 pw=0 time=45 us) ******************************************************************************** SQL ID: Plan Hash: 3663149339 select * from table(dbms_xplan.display_cursor(null, null, 'allstats last')) 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 0 0 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 14 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 14 COLLECTION ITERATOR PICKLER FETCH DISPLAY_CURSOR (cr=8 pr=0 pw=0 time=20366 us) ******************************************************************************** SQL ID: Plan Hash: 3663129422 select /* EXEC_FROM_DBMS_XPLAN */ 1, prev_sql_id, prev_child_number from v$session where sid=userenv('sid') and username is not null and prev_hash_value <> 0 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 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=136 us) 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=152 us) 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=5 us) -------------------------------------------------------------------------------- SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ /* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, object_name, cardinality, bytes, temp_space, cost, io_cost, cpu_cost, time, partition_start, partition_stop, object_node, other_tag, distribution, null, access_predicates, filter_predicates, null, null, null, other_xml, starts, outrows, crgets, cugets, reads, writes, etime, mem_opt, mem_one, last_mem_used, last_mem_usage, opt_cnt, one_cnt, multi_cnt, max_tmp, last_tmp from (select /*+ no_merge */ id, depth, position, operation, options, cost, time, cardinality, bytes, object_node, object_name, other_tag, partition_start, partition_stop, distribution, temp_space, io_cost, cpu_cost, filter_predicates, access_predicates, other, projection, qblock_name, object_alias, other_xml, last_starts starts, last_output_rows outrows, last_cr_buffer_gets crgets, last_cu_buffer_gets cugets, last_disk_reads reads, last_disk_writes writes, last_elapsed_time etime, estimated_optimal_size mem_opt, estimated_onepass_size mem_one, last_memory_used last_mem_used, last_execution last_mem_usage, optimal_executions opt_cnt, onepass_executions one_cnt, multipasses_executions multi_cnt, max_tempseg_size max_tmp, last_tempseg_size last_tmp from V$SQL_PLAN_STATISTICS_ALL vp where SQL_ID = '5ymq7bbd9da47' and child_number=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 4 0.00 0.00 0 0 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 3 VIEW (cr=0 pr=0 pw=0 time=409 us) 3 FIXED TABLE FIXED INDEX X$QESRSTATALL (ind:4) (cr=0 pr=0 pw=0 time=345 us) -------------------------------------------------------------------------------- SQL ID: Plan Hash: 3682230541 SELECT PLAN_TABLE_OUTPUT FROM TABLE(CAST(DBMS_XPLAN.PREPARE_RECORDS(:B1 , :B2 ) AS SYS.DBMS_XPLAN_TYPE_TABLE)) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 0 0 72 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.00 0.00 0 0 0 72 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 1) -------------------------------------------------------------------------------- SQL ID: Plan Hash: 3682229942 SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ extractvalue(xmlval, '/*/info[@type = "sql_profile"]'), extractvalue(xmlval, '/*/info[@type = "outline"]'), extractvalue(xmlval, '/*/info[@type = "dynamic_sampling"]'), extractvalue(xmlval, '/*/info[@type = "row_shipping"]'), extractvalue(xmlval, '/*/info[@type = "index_size"]'), extractvalue(xmlval,'/*/info[@type = "plan_hash"]') from (select xmltype(:v_other_xml) xmlval from dual) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.03 0.03 0 6 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.03 0.03 0 6 0 8 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 2) -------------------------------------------------------------------------------- SQL ID: Plan Hash: 3663135487 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: 3) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID KOPM$ (cr=2 pr=0 pw=0 time=24 us) 1 INDEX UNIQUE SCAN I_KOPM1 (cr=1 pr=0 pw=0 time=8 us)(object id 365) -------------------------------------------------------------------------------- select /* EXEC_FROM_DBMS_XPLAN */ rtrim(sql_text) from v$sql where SQL_ID=:v_sql_id and child_number=:v_child_number call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 0 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.00 0.00 0 0 0 8 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 1) -------------------------------------------------------------------------------- SQL ID: Plan Hash: 3663156583 alter session set "_rowsource_statistics_sampfreq"=0 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: 62 ******************************************************************************** select count(pad) from test 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.59 0.57 0 17856 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.59 0.57 0 17856 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17856 pr=0 pw=0 time=0 us) 10000000 TABLE ACCESS FULL TEST (cr=17856 pr=0 pw=0 time=0 us) ******************************************************************************** SQL ID: Plan Hash: 3663754663 select * from table(dbms_xplan.display_cursor(null, null, 'allstats last')) 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 0 0 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 14 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 14 COLLECTION ITERATOR PICKLER FETCH DISPLAY_CURSOR (cr=0 pr=0 pw=0 time=0 us) ******************************************************************************** SQL ID: Plan Hash: 3663748758 select /* EXEC_FROM_DBMS_XPLAN */ 1, prev_sql_id, prev_child_number from v$session where sid=userenv('sid') and username is not null and prev_hash_value <> 0 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 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=0 us) 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=0 us) 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=0 us) -------------------------------------------------------------------------------- SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ /* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, object_name, cardinality, bytes, temp_space, cost, io_cost, cpu_cost, time, partition_start, partition_stop, object_node, other_tag, distribution, null, access_predicates, filter_predicates, null, null, null, other_xml, starts, outrows, crgets, cugets, reads, writes, etime, mem_opt, mem_one, last_mem_used, last_mem_usage, opt_cnt, one_cnt, multi_cnt, max_tmp, last_tmp from (select /*+ no_merge */ id, depth, position, operation, options, cost, time, cardinality, bytes, object_node, object_name, other_tag, partition_start, partition_stop, distribution, temp_space, io_cost, cpu_cost, filter_predicates, access_predicates, other, projection, qblock_name, object_alias, other_xml, last_starts starts, last_output_rows outrows, last_cr_buffer_gets crgets, last_cu_buffer_gets cugets, last_disk_reads reads, last_disk_writes writes, last_elapsed_time etime, estimated_optimal_size mem_opt, estimated_onepass_size mem_one, last_memory_used last_mem_used, last_execution last_mem_usage, optimal_executions opt_cnt, onepass_executions one_cnt, multipasses_executions multi_cnt, max_tempseg_size max_tmp, last_tempseg_size last_tmp from V$SQL_PLAN_STATISTICS_ALL vp where SQL_ID = '5ymq7bbd9da47' and child_number=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 4 0.00 0.00 0 0 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 3 VIEW (cr=0 pr=0 pw=0 time=0 us) 3 FIXED TABLE FIXED INDEX X$QESRSTATALL (ind:4) (cr=0 pr=0 pw=0 time=0 us) -------------------------------------------------------------------------------- SQL ID: Plan Hash: 3663774539 alter session set "_rowsource_statistics_sampfreq"=128 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: 62 ******************************************************************************** select count(pad) from test 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.66 0.65 0 17856 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.66 0.65 0 17856 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17856 pr=0 pw=0 time=651693 us) 10000000 TABLE ACCESS FULL TEST (cr=17856 pr=0 pw=0 time=55 us) ******************************************************************************** SQL ID: Plan Hash: 3664447949 select * from table(dbms_xplan.display_cursor(null, null, 'allstats last')) 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 0 0 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 14 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 14 COLLECTION ITERATOR PICKLER FETCH DISPLAY_CURSOR (cr=0 pr=0 pw=0 time=5369 us) ******************************************************************************** SQL ID: Plan Hash: 3664442863 select /* EXEC_FROM_DBMS_XPLAN */ 1, prev_sql_id, prev_child_number from v$session where sid=userenv('sid') and username is not null and prev_hash_value <> 0 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 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=127 us) 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=150 us) 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=3 us) -------------------------------------------------------------------------------- SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ /* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, object_name, cardinality, bytes, temp_space, cost, io_cost, cpu_cost, time, partition_start, partition_stop, object_node, other_tag, distribution, null, access_predicates, filter_predicates, null, null, null, other_xml, starts, outrows, crgets, cugets, reads, writes, etime, mem_opt, mem_one, last_mem_used, last_mem_usage, opt_cnt, one_cnt, multi_cnt, max_tmp, last_tmp from (select /*+ no_merge */ id, depth, position, operation, options, cost, time, cardinality, bytes, object_node, object_name, other_tag, partition_start, partition_stop, distribution, temp_space, io_cost, cpu_cost, filter_predicates, access_predicates, other, projection, qblock_name, object_alias, other_xml, last_starts starts, last_output_rows outrows, last_cr_buffer_gets crgets, last_cu_buffer_gets cugets, last_disk_reads reads, last_disk_writes writes, last_elapsed_time etime, estimated_optimal_size mem_opt, estimated_onepass_size mem_one, last_memory_used last_mem_used, last_execution last_mem_usage, optimal_executions opt_cnt, onepass_executions one_cnt, multipasses_executions multi_cnt, max_tempseg_size max_tmp, last_tempseg_size last_tmp from V$SQL_PLAN_STATISTICS_ALL vp where SQL_ID = '5ymq7bbd9da47' and child_number=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 4 0.01 0.00 0 0 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 3 VIEW (cr=0 pr=0 pw=0 time=156 us) 3 FIXED TABLE FIXED INDEX X$QESRSTATALL (ind:4) (cr=0 pr=0 pw=0 time=134 us) -------------------------------------------------------------------------------- SQL ID: Plan Hash: 3664466939 alter session set "_rowsource_statistics_sampfreq"=16 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: 62 ******************************************************************************** select count(pad) from test 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 1.13 1.10 0 17856 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 1.13 1.10 0 17856 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17856 pr=0 pw=0 time=1101289 us) 10000000 TABLE ACCESS FULL TEST (cr=17856 pr=0 pw=0 time=47 us) ******************************************************************************** SQL ID: Plan Hash: 3665597173 select * from table(dbms_xplan.display_cursor(null, null, 'allstats last')) 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 0 0 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 14 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 14 COLLECTION ITERATOR PICKLER FETCH DISPLAY_CURSOR (cr=0 pr=0 pw=0 time=7603 us) ******************************************************************************** SQL ID: Plan Hash: 3665589438 select /* EXEC_FROM_DBMS_XPLAN */ 1, prev_sql_id, prev_child_number from v$session where sid=userenv('sid') and username is not null and prev_hash_value <> 0 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 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=132 us) 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=148 us) 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=3 us) -------------------------------------------------------------------------------- SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ /* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, object_name, cardinality, bytes, temp_space, cost, io_cost, cpu_cost, time, partition_start, partition_stop, object_node, other_tag, distribution, null, access_predicates, filter_predicates, null, null, null, other_xml, starts, outrows, crgets, cugets, reads, writes, etime, mem_opt, mem_one, last_mem_used, last_mem_usage, opt_cnt, one_cnt, multi_cnt, max_tmp, last_tmp from (select /*+ no_merge */ id, depth, position, operation, options, cost, time, cardinality, bytes, object_node, object_name, other_tag, partition_start, partition_stop, distribution, temp_space, io_cost, cpu_cost, filter_predicates, access_predicates, other, projection, qblock_name, object_alias, other_xml, last_starts starts, last_output_rows outrows, last_cr_buffer_gets crgets, last_cu_buffer_gets cugets, last_disk_reads reads, last_disk_writes writes, last_elapsed_time etime, estimated_optimal_size mem_opt, estimated_onepass_size mem_one, last_memory_used last_mem_used, last_execution last_mem_usage, optimal_executions opt_cnt, onepass_executions one_cnt, multipasses_executions multi_cnt, max_tempseg_size max_tmp, last_tempseg_size last_tmp from V$SQL_PLAN_STATISTICS_ALL vp where SQL_ID = '5ymq7bbd9da47' and child_number=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 4 0.01 0.00 0 0 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 3 VIEW (cr=0 pr=0 pw=0 time=152 us) 3 FIXED TABLE FIXED INDEX X$QESRSTATALL (ind:4) (cr=0 pr=0 pw=0 time=130 us) -------------------------------------------------------------------------------- SQL ID: Plan Hash: 3665621598 alter session set "_rowsource_statistics_sampfreq"=8 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: 62 ******************************************************************************** select count(pad) from test 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 1.68 1.64 0 17856 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 1.68 1.64 0 17856 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17856 pr=0 pw=0 time=1646018 us) 10000000 TABLE ACCESS FULL TEST (cr=17856 pr=0 pw=0 time=50 us) ******************************************************************************** SQL ID: Plan Hash: 3667292993 select * from table(dbms_xplan.display_cursor(null, null, 'allstats last')) 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 0 0 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 14 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 14 COLLECTION ITERATOR PICKLER FETCH DISPLAY_CURSOR (cr=0 pr=0 pw=0 time=4757 us) ******************************************************************************** SQL ID: Plan Hash: 3667288206 select /* EXEC_FROM_DBMS_XPLAN */ 1, prev_sql_id, prev_child_number from v$session where sid=userenv('sid') and username is not null and prev_hash_value <> 0 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 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=123 us) 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=137 us) 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=4 us) -------------------------------------------------------------------------------- SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ /* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, object_name, cardinality, bytes, temp_space, cost, io_cost, cpu_cost, time, partition_start, partition_stop, object_node, other_tag, distribution, null, access_predicates, filter_predicates, null, null, null, other_xml, starts, outrows, crgets, cugets, reads, writes, etime, mem_opt, mem_one, last_mem_used, last_mem_usage, opt_cnt, one_cnt, multi_cnt, max_tmp, last_tmp from (select /*+ no_merge */ id, depth, position, operation, options, cost, time, cardinality, bytes, object_node, object_name, other_tag, partition_start, partition_stop, distribution, temp_space, io_cost, cpu_cost, filter_predicates, access_predicates, other, projection, qblock_name, object_alias, other_xml, last_starts starts, last_output_rows outrows, last_cr_buffer_gets crgets, last_cu_buffer_gets cugets, last_disk_reads reads, last_disk_writes writes, last_elapsed_time etime, estimated_optimal_size mem_opt, estimated_onepass_size mem_one, last_memory_used last_mem_used, last_execution last_mem_usage, optimal_executions opt_cnt, onepass_executions one_cnt, multipasses_executions multi_cnt, max_tempseg_size max_tmp, last_tempseg_size last_tmp from V$SQL_PLAN_STATISTICS_ALL vp where SQL_ID = '5ymq7bbd9da47' and child_number=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 4 0.00 0.00 0 0 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 3 VIEW (cr=0 pr=0 pw=0 time=143 us) 3 FIXED TABLE FIXED INDEX X$QESRSTATALL (ind:4) (cr=0 pr=0 pw=0 time=123 us) -------------------------------------------------------------------------------- SQL ID: Plan Hash: 3667325014 alter session set "_rowsource_statistics_sampfreq"=4 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: 62 ******************************************************************************** select count(pad) from test 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 2.50 2.44 0 17856 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 2.50 2.44 0 17856 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17856 pr=0 pw=0 time=2442009 us) 10000000 TABLE ACCESS FULL TEST (cr=17856 pr=0 pw=0 time=54 us) ******************************************************************************** SQL ID: Plan Hash: 3669800964 select * from table(dbms_xplan.display_cursor(null, null, 'allstats last')) 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 0 0 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 14 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 14 COLLECTION ITERATOR PICKLER FETCH DISPLAY_CURSOR (cr=0 pr=0 pw=0 time=4555 us) ******************************************************************************** SQL ID: Plan Hash: 3669795763 select /* EXEC_FROM_DBMS_XPLAN */ 1, prev_sql_id, prev_child_number from v$session where sid=userenv('sid') and username is not null and prev_hash_value <> 0 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 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=124 us) 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=139 us) 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=3 us) -------------------------------------------------------------------------------- SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ /* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, object_name, cardinality, bytes, temp_space, cost, io_cost, cpu_cost, time, partition_start, partition_stop, object_node, other_tag, distribution, null, access_predicates, filter_predicates, null, null, null, other_xml, starts, outrows, crgets, cugets, reads, writes, etime, mem_opt, mem_one, last_mem_used, last_mem_usage, opt_cnt, one_cnt, multi_cnt, max_tmp, last_tmp from (select /*+ no_merge */ id, depth, position, operation, options, cost, time, cardinality, bytes, object_node, object_name, other_tag, partition_start, partition_stop, distribution, temp_space, io_cost, cpu_cost, filter_predicates, access_predicates, other, projection, qblock_name, object_alias, other_xml, last_starts starts, last_output_rows outrows, last_cr_buffer_gets crgets, last_cu_buffer_gets cugets, last_disk_reads reads, last_disk_writes writes, last_elapsed_time etime, estimated_optimal_size mem_opt, estimated_onepass_size mem_one, last_memory_used last_mem_used, last_execution last_mem_usage, optimal_executions opt_cnt, onepass_executions one_cnt, multipasses_executions multi_cnt, max_tempseg_size max_tmp, last_tempseg_size last_tmp from V$SQL_PLAN_STATISTICS_ALL vp where SQL_ID = '5ymq7bbd9da47' and child_number=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 4 0.00 0.00 0 0 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 3 VIEW (cr=0 pr=0 pw=0 time=235 us) 3 FIXED TABLE FIXED INDEX X$QESRSTATALL (ind:4) (cr=0 pr=0 pw=0 time=214 us) -------------------------------------------------------------------------------- SQL ID: Plan Hash: 3669830777 alter session set "_rowsource_statistics_sampfreq"=2 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: 62 ******************************************************************************** select count(pad) from test 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 4.44 4.33 0 17856 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 4.44 4.33 0 17856 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17856 pr=0 pw=0 time=4339828 us) 10000000 TABLE ACCESS FULL TEST (cr=17856 pr=0 pw=0 time=54 us) ******************************************************************************** SQL ID: Plan Hash: 3674198928 select * from table(dbms_xplan.display_cursor(null, null, 'allstats last')) 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 0 0 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 14 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 14 COLLECTION ITERATOR PICKLER FETCH DISPLAY_CURSOR (cr=0 pr=0 pw=0 time=5422 us) ******************************************************************************** SQL ID: Plan Hash: 3674193391 select /* EXEC_FROM_DBMS_XPLAN */ 1, prev_sql_id, prev_child_number from v$session where sid=userenv('sid') and username is not null and prev_hash_value <> 0 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 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=128 us) 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=142 us) 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=4 us) -------------------------------------------------------------------------------- SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ /* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, object_name, cardinality, bytes, temp_space, cost, io_cost, cpu_cost, time, partition_start, partition_stop, object_node, other_tag, distribution, null, access_predicates, filter_predicates, null, null, null, other_xml, starts, outrows, crgets, cugets, reads, writes, etime, mem_opt, mem_one, last_mem_used, last_mem_usage, opt_cnt, one_cnt, multi_cnt, max_tmp, last_tmp from (select /*+ no_merge */ id, depth, position, operation, options, cost, time, cardinality, bytes, object_node, object_name, other_tag, partition_start, partition_stop, distribution, temp_space, io_cost, cpu_cost, filter_predicates, access_predicates, other, projection, qblock_name, object_alias, other_xml, last_starts starts, last_output_rows outrows, last_cr_buffer_gets crgets, last_cu_buffer_gets cugets, last_disk_reads reads, last_disk_writes writes, last_elapsed_time etime, estimated_optimal_size mem_opt, estimated_onepass_size mem_one, last_memory_used last_mem_used, last_execution last_mem_usage, optimal_executions opt_cnt, onepass_executions one_cnt, multipasses_executions multi_cnt, max_tempseg_size max_tmp, last_tempseg_size last_tmp from V$SQL_PLAN_STATISTICS_ALL vp where SQL_ID = '5ymq7bbd9da47' and child_number=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 4 0.00 0.00 0 0 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 3 VIEW (cr=0 pr=0 pw=0 time=337 us) 3 FIXED TABLE FIXED INDEX X$QESRSTATALL (ind:4) (cr=0 pr=0 pw=0 time=269 us) -------------------------------------------------------------------------------- SQL ID: Plan Hash: 3674213804 alter session set "_rowsource_statistics_sampfreq"=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 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: 62 ******************************************************************************** select count(pad) from test 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 8.18 8.00 0 17856 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 8.18 8.00 0 17856 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17856 pr=0 pw=0 time=8004828 us) 10000000 TABLE ACCESS FULL TEST (cr=17856 pr=0 pw=0 time=54 us) ******************************************************************************** SQL ID: Plan Hash: 3682231310 select * from table(dbms_xplan.display_cursor(null, null, 'allstats last')) 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.01 0.00 0 0 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.00 0 0 0 14 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 ******************************************************************************** SQL ID: Plan Hash: 3682226644 select /* EXEC_FROM_DBMS_XPLAN */ 1, prev_sql_id, prev_child_number from v$session where sid=userenv('sid') and username is not null and prev_hash_value <> 0 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 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=188 us) 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=175 us) 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=5 us) -------------------------------------------------------------------------------- SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ /* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, object_name, cardinality, bytes, temp_space, cost, io_cost, cpu_cost, time, partition_start, partition_stop, object_node, other_tag, distribution, null, access_predicates, filter_predicates, null, null, null, other_xml, starts, outrows, crgets, cugets, reads, writes, etime, mem_opt, mem_one, last_mem_used, last_mem_usage, opt_cnt, one_cnt, multi_cnt, max_tmp, last_tmp from (select /*+ no_merge */ id, depth, position, operation, options, cost, time, cardinality, bytes, object_node, object_name, other_tag, partition_start, partition_stop, distribution, temp_space, io_cost, cpu_cost, filter_predicates, access_predicates, other, projection, qblock_name, object_alias, other_xml, last_starts starts, last_output_rows outrows, last_cr_buffer_gets crgets, last_cu_buffer_gets cugets, last_disk_reads reads, last_disk_writes writes, last_elapsed_time etime, estimated_optimal_size mem_opt, estimated_onepass_size mem_one, last_memory_used last_mem_used, last_execution last_mem_usage, optimal_executions opt_cnt, onepass_executions one_cnt, multipasses_executions multi_cnt, max_tempseg_size max_tmp, last_tempseg_size last_tmp from V$SQL_PLAN_STATISTICS_ALL vp where SQL_ID = '5ymq7bbd9da47' and child_number=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 4 0.00 0.00 0 0 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 62 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 3 VIEW (cr=0 pr=0 pw=0 time=256 us) 3 FIXED TABLE FIXED INDEX X$QESRSTATALL (ind:4) (cr=0 pr=0 pw=0 time=200 us) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 24 0.00 0.00 0 0 0 0 Execute 25 0.00 0.00 0 0 0 0 Fetch 34 20.62 20.16 0 160704 0 121 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 83 20.62 20.16 0 160704 0 121 Misses in library cache during parse: 0 Misses in library cache during execute: 1 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 20 0.00 0.00 0 0 0 0 Execute 41 0.00 0.00 0 0 0 0 Fetch 73 0.05 0.04 0 8 0 121 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 134 0.05 0.04 0 8 0 121 Misses in library cache during parse: 0 44 user SQL statements in session. 1 internal SQL statements in session. 45 SQL statements in session. ******************************************************************************** Trace file: orcl_ora_2069.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 44 user SQL statements in trace file. 1 internal SQL statements in trace file. 45 SQL statements in trace file. 16 unique SQL statements in trace file. 694 lines in trace file. 16567 elapsed seconds in trace file.