TKPROF: Release 11.1.0.6.0 - Production on Tue Dec 30 03:41:38 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. Trace file: e:\oracle\app\diag\rdbms\orcl899\orcl899\trace\orcl899_ora_2552.trc Sort options: prsela exeela fchela ******************************************************************************** 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 distinct owner, table_name FROM all_my_tab_col_stats WHERE owner not in ('SYS','SYSMAN','SYSTEM','OUTLN','TSMSYS','DBSNMP','WMSYS','EXFSYS','CTXSYS','DMSYS','XDB','MDSYS','ORDSYS','OLAPSYS') GROUP BY owner, table_name HAVING SUM(case WHEN histogram = 'FREQUENCY' THEN 1 ELSE 0 END) > 0 AND SUM(case WHEN NUM_NULLS > 0 THEN 1 ELSE 0 END) > 0 AND SUM(case WHEN avg_col_len > 25 THEN 1 ELSE 0 END) > 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.10 0.55 1590 1593 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.10 0.55 1590 1593 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 5 Rows Row Source Operation ------- --------------------------------------------------- 1 FILTER (cr=1593 pr=1590 pw=1590 time=0 us) 378 HASH GROUP BY (cr=1593 pr=1590 pw=1590 time=11 us cost=439 size=195 card=5) 32022 TABLE ACCESS FULL ALL_MY_TAB_COL_STATS (cr=1593 pr=1590 pw=1590 time=1341 us cost=436 size=2276625 card=58375) 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 reliable message 1 0.00 0.00 enq: KO - fast object checkpoint 1 0.00 0.00 direct path read 26 0.09 0.35 SQL*Net message from client 2 5.49 5.50 ******************************************************************************** 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: 5 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 4.68 4.68 ******************************************************************************** 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.00 0.00 0 0 0 0 Fetch 2 0.10 0.55 1590 1593 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.10 0.55 1590 1593 0 1 Misses in library cache during parse: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 5.49 10.18 reliable message 1 0.00 0.00 enq: KO - fast object checkpoint 1 0.00 0.00 direct path read 26 0.09 0.35 OVERALL TOTALS FOR ALL 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 2 user SQL statements in session. 0 internal SQL statements in session. 2 SQL statements in session. ******************************************************************************** Trace file: e:\oracle\app\diag\rdbms\orcl899\orcl899\trace\orcl899_ora_2552.trc Trace file compatibility: 10.01.00 Sort options: prsela exeela fchela 1 session in tracefile. 2 user SQL statements in trace file. 0 internal SQL statements in trace file. 2 SQL statements in trace file. 2 unique SQL statements in trace file. 85 lines in trace file. 6 elapsed seconds in trace file.