Automatic SQL tuning, graphing of Statspack/AWR reports, and object comparison between source and destination, among various other scenarios.
"Toad" is a database management tool for developers and database administrators, with over 4 million licenses sold worldwide. It is available for Oracle Database and SQL Server. 【Feature Introduction】 ■ Automatic SQL Tuning → Just paste the SQL you want to tune on the screen and press the analyze button! Toad automatically generates SQL rewrite patterns that change the execution plan, executes the rewritten SQL in the connected environment, and measures the time taken. ■ Comparison and modification of database/schema/table data between databases → You can compare various database objects from the source and target during data migration. ■ Graphical display of STATSPACK and AWR reports → Normally, graphing Statspack or AWR reports is done through Excel, but with Toad, you can graph reports directly without using Excel.
Inquire About This Product
basic information
【Other Functions】 ■ Bidirectional conversion between ANSI-compliant SQL and Oracle-compliant SQL → When the database product changes, SQL executed from the application can be rewritten to ANSI-compliant SQL using the tool. ■ Table data CSV output / Output data masking → Easily output table data to CSV, and mask it with a specified string during CSV output. ■ Object DDL generation → Easily generate DDL for objects from Toad. ■ Performance measurement support function → Capture SQL executed in the production environment and replay it in any environment. ■ DB health check → Check if it is operating healthily across multiple databases. * For more details, please refer to our website. ■ Introduction to Toad https://cosol.jp/license/toad/ ■ Toad technical information (Toad Tips) https://cosol.jp/knowledge/toad-tips/
Price information
Multiple editions are available, and the features available vary by edition. License type: Perpetual license with maintenance Contract duration: 1 year to multiple years Billing unit: Seats (number of users) Price: Available at a low cost. Please contact us for details. *The price range assumes the edition with the most common usage.
Price range
P3
Delivery Time
P3
Applications/Examples of results
■Case Study of Using Toad for Tuning Delayed SQL ●Case 1: Customer Using Oracle Database Extracted SQL with execution times around 10 seconds and aimed to halve the execution time using Toad for tuning. Results: - SQL1 Before Tuning: 42.21 seconds After Tuning: 19.78 seconds - SQL2 Before Tuning: 8.57 seconds After Tuning: 2.79 seconds - SQL3 Before Tuning: 8.57 seconds After Tuning: 1.46 seconds ●Case 2: Customer Using SQL Server Performance degradation occurred in numerous SQLs, so tuning was performed using Toad. Results: - Tuning of all slow SQLs was completed in just one day. - Performance improved by up to 180 times to 2 times.
Detailed information
-
SQL can be automatically tuned with SQL Optimizer. SQL Optimizer is a feature exclusive to Toad.
-
It is also possible to debug stored programs coded in PL/SQL.
-
Even exporting/importing data with a high level of difficulty can be easily executed by anyone using Toad.
-
Typically, Statspack reports and AWR reports, which can only be verified with numerical data, can be automatically graphed and displayed using Toad.
-
When migrating data, comparing the database objects and table data of the source and destination can be easily and quickly executed using Toad. You can also leave the comparison results and the generation of correction scripts to Toad.
catalog（1）
Download All Catalogs
Company information
Our company consists of specialists who understand the field of database operations. We continue to provide services that contribute to the IT society as a partner that supports the system infrastructure of companies, solving challenges in database operations together with our customers. If you are responsible for the information systems department and have any concerns or issues regarding infrastructure centered around databases, please feel free to consult with us.