D.SIDE transforms the way to approach,
interpret, and understand
an AWR report
Through its graphical interface, it allows you to quickly and easily find the information you need by navigating, instead of having to scroll through and search thousands of lines.
| Rapport AWR | d.side AWR analyzer | |
| Graphics | ✘ | ✔ |
| Concise interface | ✘ | ✔ |
| Period selection to analyze | ✔ | ✔ |
| Dynamic navigation | ✘ | ✔ |
| Easy understanding | ✘ | ✔ |
| Simplified interpretation | ✘ | ✔ |
| Time-saving | ✘ | ✔ |
| SQL query sorting | ✔ | ✔ |
| SQL query filtering | ✘ | ✔ |
| Easier team sharing | ≈ | ✔ |
| Data for SQL optimization | ✘ | ✔ |
| SQL tuning assistant | ✘ | ✔ |
| SQL optimization report | ✘ | ✔ |
|
Details of provided data | ★★☆☆☆ | ★★★★★ |
With D.SIDE AWR Analyzer
Within a few clics
Overview of all Oracle activity
at a glance
Navigate easily
and delve into the details
Analyze
the most resource-consuming queries
With all the necessary elements for their optimization: execution plans, tables, indexes, statistics, bind variables…
In an instant
access all relevant information
The period to focus on, a list of resource-consuming queries, their execution plans, the objects involved (tables, indexes, statistics, etc.),
bind variable values …
D.SIDE can even provide insights and recommendations to optimize your SQL queries, making them more efficient, using the SQL tuning assistant “Anais” and its “Anais Report” feature.
| Rapport AWR | d.side AWR analyzer |
| • Flat file, static, representing a fixed period, with raw text spanning several thousand lines | ✔ Graphical representation for immediate reading |
| • Detailed analysis is required, with a risk of misinterpretation | ✔ Easy understanding of any situation |
| • Significant time spent searching and cross-referencing data to understand it | ✔ Automated and dynamic analysis of consumption spikes, zooming in on periods, sorting, and filtering queries... |
| • Missing information for SQL query tuning: tables, indexes, statistics, etc... | ✔ Availability of all essential information for SQL query optimization |
| ✔ AI-assisted with the 'Anais' SQL tuning option: get optimization suggestions for your SQL queries in seconds |
Over 80% of performance issues encountered in a database are attributed to the execution of SQL queries. However, an AWR report only provides the raw text of a few resource-consuming queries along with their execution statistics: execution count, CPU usage, I/O time, etc…
Essential elements for SQL optimization are missing in an AWR report: a list of tables, indexes, object statistics, and more.
With D.SIDE, you have access to all the necessary information for SQL query optimization through a streamlined interface. Additionally, the data generated by D.SIDE over an AWR period is easy to share across teams.
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...