Other detail trace report examples
You might want to try other report combinations too. See the following examples from detail traces.
What do you want to do? | Steps |
|---|---|
For an SQL statement summary per thread, sorted by Average CPU usage, followed by average SQL row processing statistics per statement. | LTRAC ==> Y STRAC ==> SQL,SORTSQL=AC,SQLPOPUP |
For a detail event trace per thread, with pop-up displays per SQL statement | LTRAC ==> Y DTRAC ==> Y POPUP ==> SQL |
For SQL statement text and EXPLAIN data for all dynamic SQL executed or BINDs of static SQL | POPUP ==> (SQL-TEXT,EXPLAIN) |
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*