Business applications suffer from overall performance degradation and long response times.
Database experts estimate that about 70% of application performance issues can be resolved by SQL tuning, yet manual tuning of SQL requests is time consuming and requires extensive DBA expertise that is always in shortage.
With ActiveBase Tuning Robot™ for Oracle you can save time tuning SQL code requests for maximum performance and making sure it performs well before end users are impacted and the business suffers.
It improves performance of long-running SQL requests by x10-x100 while saving DBA time and expert resources.
ActiveBase Tuning Robot is powerful and intuitive server-based SQL tuning software that delivers an automatic and continuous SQL tuning process on your production environments. It identifies top-SQL requests from Oracle AWR, analyzes the SQL and identifies quality execution alternatives. Alternatives are benchmarked serially in a tightly controlled manner, highlighting the best execution alternative for your environment optimization strategy (Elapsed time, CPU or IO). With a single mouse click, a SQL request fixing-rule is created in ActiveBase Performance™ proxy in production or pre-production environment, for immediate application SQL fixing (rewrite), without touching application source-code or database configurations.
Examples
  ActiveBase Tuning Robot improved response-time of a Siebel application request from 10 minutes to less than 15 seconds by quickly identifying an Oracle Hint. Fixing the original SQL request in Siebel application to use the hint was performed by a rule in ActiveBase Performance™.
  It improved response-time of a proprietary application SQL request from 0.5 to 0.015 seconds. This request is executed a million time per day, resulting in substantial server resource savings.