Skip to main content

Important Features

  • TuTool has a lot of powerful graphical features.
  • I.a. it is possible to merge two different graphics in order to recognize any correlation between corresponding statistics.
  • This tool enables graphical presentation of formulas in Oracle’s syntax. For ex. a formula of buffer cache hitratio can be input as follows: round((1 – “physical reads cache”/decode(“consistent gets from cache” + “db block gets from cache”,0,1,”consistent gets from cache” + “db block gets from cache”))*100)
  • It is possible to find sqls caused peaks of logical or physical reads at the data segment level. This is a very powerful approach in performance tuning.
  • This program provides discovery of top sqls on different criteria and from different sources.
  • TuTool works fine with sqls of arbitrary length. There is no length limit such as 32K or similar.
  • This tool extracts bind values from awr, memory and sql monitoring reports (also from historical ones). That significantly reduces manual effort during sql tuning.
  • There are a lot of features for fixing execution plans in this program.
  • One can insert hidden hints into sqls by different methods as well.
  • Every database connection has it‘s own prescript. It is a sql script that is automatically executed before every script for sql execution or generating explain plans. There you can make session parameter and bind variables definitions and settings.
  • It is possible to activate a 10046 event tracing for running sessions for a certain period of time. After this time is over the corresponding trace file is transfered to the client site and interpreted there by tkprof utility. All these steps the program makes itself without any manual user effort.
  • This program has 2 methods for detection of sparse indexes. The first one is based on optimizer statistics and is therefore fast. The second one calculates all data itself. It is more precise than the first one but takes more time.
  • There are 2 methods implemented for reading from the alertlog file:
    • reading from the external table
    • reading from the appropriate fixed table
  • It is possible to read trace files as well.
  • If you have a performance issue that can be solved by appropriate setting of optimizer_features_enable, this tool can help you to find a very targeted solution: one or a couple of parameter settings solving your problem instead of optimizer_features_enable, that influences a lot of performance features and therefore isn’t usually suitable as a work around.
  • Important scripts are adjusted for using in RAC environment.
  • There are more than 900 scripts in this tool. For beginners it can be not so easy to navigate among them. The concept of associated scripts simplifies this process. Most of the scripts in TuTool have so called associated scripts, i.e. a handful of scripts that are usually executed after the current one. That makes a choice of the next script for execution much easier.
  • It is possible to switch from the complete version to essential scripts. This feature was introduced especially for sql tuning.