itrprof SQL Analyzer for Oracle

A web based tool which analyzes SQL_TRACE and Event 10046 trace files of Oracle.
Download

itrprof SQL Analyzer for Oracle Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Demo
  • Publisher Name:
  • ubTools
  • Publisher web site:
  • Operating Systems:
  • Windows 2003/XP/2000/98/Me/NT
  • File Size:
  • 570KB

itrprof SQL Analyzer for Oracle Tags


itrprof SQL Analyzer for Oracle Description

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. Why itrprof SQL Analyzer 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.


itrprof SQL Analyzer for Oracle Related Software