SPEEDGAIN FOR ORACLE
SQL workload-based analysis
As a basis for optimization in accordance with use, the SQL workload available in the database is evaluated and filed optimally for analysis purposes. The user is provided with the means to analyze the aggregated SQL behavior.
From problem to solution
The consequent integration of proven methods of analysis helps the user on effectively solving problems. By a process of elimination, the bottleneck resource is recognized and, using the causal principle, the responsible factor identified.
Intelligent user operation
The drill-down concept quickly leads even less experienced DBAs with just a few clicks of the mouse from the symptom to the exact cause. The grouping of top-users allows the concentration to be put on the essentials.
Easy to install and a resource-saving operation
Easy installation without agents, low system requirements, and minimal application of system resources make for quick set-up.
24/7 database monitoring
The constant monitoring of databases permits a detailed retrospective analysis. Databases from the past can be analyzed just as well as current databases.
Overview provides information on all databases
The overview show peaks on servers and databases at a glance. This means that you can react quickly to anything that comes up.
The Speedgain Cockpit provides the most important information at a glance.
Wait classes, DB time, 100% ratios and sessions. Then the intelligent drill-down user interface takes over.
From problem to cause in one click
Intelligent drill-down navigation:
From the Cockpit to relevant wait events and resource-demanding sessions in a click of the mouse.
For each tablespace, there is detailed information on I/O, growth, data files.
Here is a rapidly growing TEMP tablespace.
Detailed view on the session level
The top 10 wait events (selected according to wait class), relevant I/O information, basic data on a session, and sort data.
Detailed performance data, also available in the Standard Edition
Savings on license fees. The Standard Edition is suitable for detailed performance analyzes.
Fast detection of performance blocks
The most important basic values, such as wait and DB times, are displayed as an overview, so that it can be quickly ascertained in which area the block is. This supports a proactive performance management and leads to an increased satisfaction among users.
Better usage of available resources
The usage of resources can be observed over a long period of time. This allows cost-saving potential to be identified. Proactive capacity management is supported, as necessary system expansion can be identified early on.
Fast detection of resources consumption
From the Cockpit, the sessions can be reached with a click of the mouse. Through automatic sorting and the ABC analysis, the most resource-demanding sessions are immediately visible.
Same look and feel for monitoring DB2 and Oracle
Speedgain users quickly find their way with the identical look and feel. The same concepts are used such as drill down and distribution according to workload and consumption.