Navigation
 
Recommendations

  • itrprof SQL Analyzer can read TEXT, ZIP(.zip) and GZIP(.gz) files. If ZIP files include more than one file, only the 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.
Warnings

  • Don't generate trace files for Oracle Shared Server (MTS). If your database is shared server configured, add SERVER=DEDICATED to your tns alias in your tnsnames.ora.

    If you are using Oracle Shared Server on 10g+, you can consolidate data in multiple trace files into single file by trcsess utility.

  • Don't upload tkprof outputs, SQL statements or other wrong files. Upload unformatted SQL_TRACE or Event 10046 raw trace files.

  • Don't split trace files into multiple trace files. This may cause wrong analysis results.
User Interface

itrprof SQL Analyzer 6.2.6

Database: 

 

 

 

   

Top: 

slowest statements

 

 

 

Execution plans: 

per statement

 

 

 

   

Aggregate: 

 

 

 

 

ms 

SYS: 

 

 

 

 

Binds: 

Bind loops: 

Bind variables: 

Tuning advice: 

Minimum advice limit: 

min

 

 

    

Comparison file name: 

(optional)

Main file name: