Anais, Your “One-Click Assistant”
for SQL Tuning
More than 80% of performance issues in an Oracle database are attributable to SQL queries.
Anais, the “one-click” assistant for SQL optimization, addresses this issue with two main objectives:
• Precisely identify the elements that can slow down a query.
• Provide solutions where possible.
Some examples of suggestions that Anais can make include:
• Add or change an index
• Rewritethe query
• Revise a statistic
• Change the join type
• Adjust an Oracle parameter
• Fix an anomaly
Anais takes just a few milliseconds to analyze the query and generate its recommendations. And with just one click, the user can get assistance !
Cardinality Editor
• Are you anticipating a volume change?
• Did Oracle optimizer misestimate cardinality?
• Or does a statistic seem incorrect?
• Simulate potential changes in Anais’ recommendations without gathering new statistics !
Anais Can Handle
Very Different Situations
Complexity :
Execution plans with hundreds of lines
Volume :
Tables containing billions of rows
Load :
Optimization of queries executed tens of thousands of times per second
A poor execution plan, a missing index, outdated statistics, or an unoptimized query can be the cause of a significantly slowed application on a database.
Our latest
ARTICLES
Replay schema administration
Replay schema administration Using the D.SIDE Console is very easy to manage the Replay collection schema to modify retention or free up space. All available operations (adding days, deleting a day, or clearing a day) can be performed with just a few clicks in the...
Object search
Un objet Oracle a-t-il été utilisé sur une période ? La fenêtre Replay de résumé de l’activité Oracle fournit entre autres éléments la liste des requêtes SQL qui ont consommé du temps (elapsed time) ou des ressources (CPU, IOs) sur la période sélectionnée. Le...
Oracle SE2 : lecture de la limite de CPU avec d.side
Consommation de CPU par Oracle L’écran principal de d.side permet de suivre en temps réel la consommation globale de CPU de nos instances Oracle.Pour cela nous disposons de plusieurs indicateurs répartis sur 3 zones différentes de cet écran. Exemple : 1 - L’instance...