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.
Response Time Based
itrprof SQL Analyzer uses
Response Time Performance Modeling. 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.
Trace File Traps
There are a lot of traps in Event 10046 trace files. Interpreting trace files by simple scripts may cause very erroneous results. itrprof SQL Analyzer with the source code of around 6.500 lines reports accurate analysis results.
