TKPROF: Release 11.1.0.6.0 - Production on Tue Dec 30 03:35:53 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. Trace file: e:\oracle\app\diag\rdbms\orcl899\orcl899\trace\orcl899_ora_788.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 ******************************************************************************** The following statement encountered a error during parse: select object_name, object_type from ( select o.*, max(last_ddl_time) over ( partition by owner ) last_modified_time from all_my_objects o ) where last_ddl_time = last_modified_time;select object_name, object_type from ( select o.*, max(last_ddl_time) over ( partition by owner ) last_modified_time from all_my_objects o ) where last_ddl_time = last_modified_time;select object_name, object_type from ( select o.*, max(last_ddl_time) over ( partition by owner ) last_modified_time from all_my_objects o ) where last_ddl_time = last_modified_time Error encountered: ORA-00911 ******************************************************************************** select object_name, object_type from ( select o.*, max(last_ddl_time) over ( partition by owner ) last_modified_time from all_my_objects o ) where last_ddl_time = last_modified_time 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 37 1.12 16.47 6025 6029 0 528 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 39 1.12 16.47 6025 6029 0 528 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 5 Rows Row Source Operation ------- --------------------------------------------------- 528 VIEW (cr=6029 pr=6025 pw=6025 time=451 us cost=6555 size=18911520 card=411120) 411120 WINDOW SORT (cr=6029 pr=6025 pw=6025 time=80729 us cost=6555 size=19733760 card=411120) 411120 TABLE ACCESS FULL ALL_MY_OBJECTS (cr=6029 pr=6025 pw=6025 time=1308002 us cost=1644 size=19733760 card=411120) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 37 0.00 0.00 reliable message 1 0.00 0.00 direct path read 97 1.20 15.10 SQL*Net message from client 37 12.36 12.46 ******************************************************************************** delete from sdo_geor_ddl__table$$ 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: 1 Optimizer mode: ALL_ROWS Parsing user id: 52 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE SDO_GEOR_DDL__TABLE$$ (cr=0 pr=0 pw=0 time=0 us) 0 TABLE ACCESS FULL SDO_GEOR_DDL__TABLE$$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1) ******************************************************************************** declare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 52 (recursive depth: 1) 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 2.68 2.68 ******************************************************************************** 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 ******************************************************************************** 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 37 1.12 16.47 6025 6029 0 528 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 41 1.12 16.47 6025 6029 0 528 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 39 0.00 0.00 SQL*Net message from client 39 14.62 29.77 SQL*Net break/reset to client 2 0.00 0.00 reliable message 1 0.00 0.00 direct path read 97 1.20 15.10 OVERALL TOTALS FOR ALL 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 1 Misses in library cache during parse: 1 4 user SQL statements in session. 0 internal SQL statements in session. 4 SQL statements in session. ******************************************************************************** Trace file: e:\oracle\app\diag\rdbms\orcl899\orcl899\trace\orcl899_ora_788.trc Trace file compatibility: 10.01.00 Sort options: prsela exeela fchela 1 session in tracefile. 4 user SQL statements in trace file. 0 internal SQL statements in trace file. 4 SQL statements in trace file. 4 unique SQL statements in trace file. 333 lines in trace file. 43 elapsed seconds in trace file.