ActiveBase SQL Improvement Automation Suite™ 

In today‘s world, confronted with recession and ever growing workloads, automation is a proven way for increasing productivity and saving costs.

SQL Improvement Automation Suite™  can improve SQL execution times by a factor of x5 x10 and more without changing application source-code or database configurations.
It transforms the task of improving Oracle performance into a continuous process with minimal time and effort consuming manual interventions and DBA expertise required.

The SQL Improvement Automation Suite™  can be applied to different applications across your data center without any changes to source-code or database configurations. It is particularly valuable for business applications and reporting environments where source-code cannot be improved because it is not accessible or no longer maintained.

Data centers gain substantial savings and improved Quality of Service with SQL Improvement Automation Suite™ , increasing productivity by implementing a repetitive fully automated performance improvement process.

Managed by operators delivering fast results in short time, (rather than existing solutions used only by DBAs with extensive expertise that are always in great shortage), ActiveBase SQL Improvement Automation Suite™  provides an efficient platform for implementing reliable and predictable solutions to performance problems in Oracle Data Centers.

The SQL Improvement Automation Suite™  includes two products for complete automation:
ActiveBase Tuning Robot™  and ActiveBase Performance™ .
The ActiveBase Tuning Robot™  automates the tasks needed to:
1. Identify performance degrading SQL statements
2. Find the right optimization ‘Hints’, and -
3. Create fixing Rules imported by ActiveBase Performance™ 

ActiveBase Performance™ , using its rule engine, automates the following tasks in real-time:
1. Intercept SQL requests from the applications on their way to the database;
2. Identify the SQL statements for which the right ‘Hints’ have been found,
3. Append these ‘Hints’ or your own rewrites to the SQL statement on-the-fly and
4. Send these improved SQL statements to the database, for optimized execution.

With quick Installation it is fully operational within hours, supporting all application types running on Oracle versions 8i and above.