itrprof SQL Analyzer   itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE and Event 10046 trace files of Oracle; finds bottlenecks and offers information on how to tune them.   Recommendations   itrprof SQL Analyzer can read TEXT, ZIP(.zip) and GZIP(.gz) files. If ZIP files include more than one file, only first one is processed. To reduce uploading time, compression is strongly recommended. Enable HTTP/1.1 support for your browsers. itrprof SQL Analyzer sends compressed response to HTTP/1.1 enabled browsers. Then, browsers de-compress reponse on the fly. If you don't need bind variables, don't generate Event 10046 trace files in level 12. This may cause big trace files. Event 10046 in level 8 is strongly recommended if you need just tuning advice. For general tips: Performance tips in itrprof SQL Analyzer User Manual.   Warnings   Don't generate trace files for Oracle Multi-Threaded Sessions (MTS). If your database is MTS configured, add SERVER=DEDICATED to your tns alias in your tnsnames.ora. Don't upload tkprof outputs, SQL statements or other wrong files. Upload unformatted SQL_TRACE or Event 10046 raw trace files. User interface   itrprof SQL Analyzer 6.2.7   Database:  7.3.3 --- 8i 9i --- 11g       Corrupted lines:  50 100 150 All       Top:  5 10 15 All slowest statements       Execution plans:  0 1 2 3 All per statement       Wait group:  Name Name,P1 Name,P1,P2 Name,P1,P2,P3       Aggregate:          Histograms:  Buckets:  Bucket width:  ms  SYS:          Binds:  Bind loops:  1 2 3 4 5 All Bind variables:  1 2 3 4 5 All Tuning advice:  Minimum advice limit:  min     Statement totals:          Comparison file name:  (optional) Main file name:      Why itrprof SQL Analyzer   You can see the basic advantages of itrprof SQL Analyzer here.   Features table   You can see the features of itrprof SQL Analyzer here.   itrprof SQL Analyzer User Manual   itrprof SQL Analyzer User Manual explains the features, use and error codes of itrprof SQL Analyzer.