WebEvent waited on Times Max. Wait Total Waited----- Waited ----- -----direct path write temp 2167 0.02 3.22 direct path read temp 1717 0.01 2.79 db file scattered read 2 0.09 0.17 log file switch (private strand flush incomplete) 1 0.05 0.05 … WebAug 5, 2007 · total 3 0.06 0.06 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 26 Rows Row Source Operation----- -----0 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID RF_STATE 1 DOMAIN INDEX 0 TABLE ACCESS FULL RING ***** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
The SQL Trace Facility and TKPROF - Oracle
Webtotal 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 55 ***** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows WebWait Total Waited ----- Waited ----- ----- SQL*Net message to client 4 0.00 0.00 SQL*Net message from client 4 19.75 39.08 library cache lock 1 0.00 0.00 gc current block 2-way 1645 0.00 0.62 db file sequential read 23 0.00 0.01 db file parallel read 8 0.00 0.00 gc cr multi block request 50254 0.00 7.45 db file scattered read 29 0.00 0.02 OVERALL … coin brothers uk
Using SQL Trace and TKPROF - Oracle
WebSep 21, 2006 · From: Isabel Bedoya Date: Thu, 21 Sep 2006 17:31:42 -0400 (EDT) Message-ID: <[email protected]> . OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows Parse … WebJun 25, 2008 · How can the overall totals elapsed times be less than the sum of the Event waited on times when the elapsed times are supposed to include waiting on events. See … WebOverall Totals. Non-Recursive statements All recursive statements Summary Notes: Take the time now to review the formatted trace file report.txt. Become familiar with the various sections within the report. Supplemental Notes Note that “non-recursive” statements are statements that were entered by the application or user. coin buche