Dictionary Traps: many statistics of child(recursive) statements are included in their parents' statistics. If you query dictionary views directly, you may fall in this trap. This may distort your measurements and decisions. Self Tuning Advice: You can write your own dynamic tuning advices. Fast: itrprof SQL Analyzer can read trace files in ZIP(.zip) and GZIP(.gz) formats. itrprof SQL Analyzer sends compressed analysis results to HTTP/1.1 enabled browsers. Then, browsers de-compress reponse on the fly. itrprof SQL Analyzer doesn't save trace files to server. Trace files are processed in the memory-efficient data structures ON-THE-FLY while you post your trace files. itrprof SQL Analyzer uses its own data structures such as Hash, Tree, List, etc. It doesn't use any database. itrprof SQL Analyzer is a web based Java Servlet application. Java Servlet technology is faster than other technologies such as CGI.WEB Based: You don't have to install anything on your clients. Installing and upgrading are very easy. Time Based: itrprof SQL Analyzer uses Time Based Performance Analysis. In other words, itrprof SQL Analyzer uses the best performance analysis method for diagnosing performance problems. Security:SQL_TRACE and Event 10046 trace files don't include CONNECT statements. That means your username/password in CONNECT statements are not included in SQL_TRACE and Event 10046 trace files. Event 10046 Trace Files: itrprof SQL Analyzer analyzes Event 10046 trace, that is one of the best available sources for Oracle tuning. It includes many statistics to tune Oracle.
What is new in this release:
Version 6.2 for Oracle is compatible with Oracle 11g.
J2SE 1.4.2 and a Servlet 2.3 Container