Database Reference
In-Depth Information
Parent Statement ID 1
Hash Value 955957303
SQL ID 7wd0gdwwgph1r
SELECT EXTRACT(YEAR FROM D), ID, PAD FROM T ORDER BY EXTRACT(YEAR FROM D), ID
Next, you find the execution plan, if it's available in the trace file. Its format is similar to the output generated by
TKPROF:
Execution Plan
**************
Optimizer Mode ALL_ROWS
Hash Value 961378228
Rows Operation
--------- -------------------------------------------------------------
1,000,000 SORT ORDER BY (cr=38474 pr=71499 pw=33035 time=11123996 us
cost=216750 size=264000000 card=1000000)
1,000,000 TABLE ACCESS FULL T (cr=38474 pr=38463 pw=0 time=5674541 us
cost=21 size=264000000 card=1000000)
As is the case for all SQL statements, the execution plan is followed by the execution statistics, the resource usage
profile, and, if available, the recursive SQL statements at level 2 (you're currently looking at a SQL statement at level 1).
In this case, you can see that the recursive SQL statements are responsible for less than 1 percent of the response time.
In other words, SQL statement 2 is itself responsible for the whole response time:
Database Call Statistics with Recursive Statements
**************************************************
Call Count Misses CPU Elapsed PIO LIO Consistent Current Rows
----------------- ------ ------ ----- ------- ------ ------ ---------- ------- ---------
Parse 1 1 0.004 0.010 7 32 32 0 0
Execute 1 1 0.000 0.000 0 0 0 0 0
Fetch 10,001 0 6.492 11.926 71,499 38,482 38,474 8 1,000,000
----------------- ------ ------ ----- ------- ------ ------ ---------- ------- ---------
Total 10,003 2 6.496 11.936 71,506 38,514 38,506 8 1,000,000
Average (per row) 0 0 0.000 0.000 0 0 0 0 1
Database Call Statistics without Recursive Statements
*****************************************************
Call Count Misses CPU Elapsed PIO LIO Consistent Current Rows
----------------- ------ ------ ----- ------- ------ ------ ---------- ------- ---------
Parse 1 1 0.001 0.001 0 9 9 0 0
Execute 1 1 0.000 0.000 0 0 0 0 0
Fetch 10,001 0 6.492 11.926 71,499 38,482 38,474 8 1,000,000
----------------- ------ ------ ----- ------- ------ ------ ---------- ------- ---------
Total 10,003 2 6.493 11.927 71,499 38,491 38,483 8 1,000,000
Average (per row) 0 0 0.000 0.000 0 0 0 0 1
