| Feature |
Available |
New Feature |
| Overall response time |
Yes |
|
| Overall NON-SYS statistics |
Yes |
|
| Overall NON-SYS service histograms |
Yes |
|
| Overall NON-SYS waits |
Yes |
|
| Overall NON-SYS wait histograms |
Yes |
|
| Overall NON-SYS tuning advices |
Yes |
|
| Overall SYS statistics |
Yes |
|
| Overall SYS service histograms |
Yes |
|
| Overall SYS waits |
Yes |
|
| Overall SYS wait histograms |
Yes |
|
| Overall SYS tuning advices |
Yes |
|
| Overall UN-KNOWN waits |
Yes |
|
| Overall UN-KNOWN wait histograms |
Yes |
|
| Overall UN-KNOWN tuning advices |
Yes |
|
| Oracle database |
7.3.3 to 11g |
|
| Catching physical corruptions in trace files |
Yes |
|
| Catching logical corruptions in trace files |
Yes |
|
Top N statements ordered by response time
|
Yes |
|
| Top N statements ordered by service time |
Yes |
Yes |
| Top N statements ordered by wait time |
Yes |
Yes |
| Top N statements ordered by logical IO |
Yes |
Yes |
| Number of execution plans for each statements |
Unlimited |
|
| Grouping wait events by name |
Yes |
|
| Grouping wait events by name,P1 |
Yes |
|
| Grouping wait events by name,P1,P2 |
Yes |
|
| Grouping wait events by name,P1,P2,P3 |
Yes |
|
| Aggregating statements |
Yes |
|
| Determining number of buckets |
Yes |
|
| Determining bucket width |
Yes |
|
| Option for SYS statements |
Yes |
|
| Bind variables |
Yes |
|
| Number of loops for bind variables |
Unlimited |
|
| Number of bind variables |
Unlimited |
|
| Determining tuning advice limit |
Yes |
|
| Comparison of 2 trace files |
Yes |
|
| Statement response time |
Yes |
|
| Statement exclusive statistics |
Yes |
|
| Statement service histograms |
Yes |
|
| Statement cumulative statistics |
Yes |
|
| Child statements of statement |
Yes |
|
| Statement waits |
Yes |
|
| Statement wait histograms |
Yes |
|
| Statement tuning advice |
Yes |
|
| User interface parameters |
Yes |
|
| Trace file statistics |
Yes |
|
| Web based |
Yes |
|
| Charts |
Yes |
|
| HTTP 1/1 support |
Yes |
|
| Reading ZIP(.zip) trace files |
Yes |
|
| Reading GZIP(.gz) trace files |
Yes |
|
| Analyzing trace files on the fly without saving to a database or a file |
Yes |
|
| Analyzing Remote Procedure Calls(RPC) |
Yes |
|
| Analyzing segment level statistics in execution plans |
Yes |
|
| Java-Servlet based, platform independent |
Yes |
|
| Multi-threaded Java source code |
Yes |
|
| Cascade Style Sheet (CSS) output |
Yes |
|
itrprof SQL Analyzer 6.2 features