|
Monitor Current PerformanceThe DBTuna Current Performance View displays current Oracle performance metrics including:
- Current Oracle Key Performance Indicators
- Resource Consumption and Oracle Waits for last 5 minutes
- Details on all currently connected client sessions
|
Historical Oracle PerformanceThe DBTuna Activity View is the main view within DBTuna where historical activity and performance information is displayed, including:
- Time series activity graphs showing Oracle resource consumption versus number of completed database queries.
- Completely configurable time views, from last 5 minutes to last 30 days.
- Time series graphs of host CPU consumption
- Breakdown of activity by Oracle Wait state
- Correlated drilldown by Server, Client, SQL, Grouped SQL, Module, User, Program, Session, Database/Schema
|
 |
 |
Oracle StatisticsThe DBTuna Statistics View displays historical statistical information on your Oracle database:
- Report and analyze Oracle Instance level statistics
- Display Delta Graph's over-time
|
SQL DrilldownOnce poorly performing SQL has been identified by DBTuna the DBA can drill into the SQL View to display details of the statement and explain plan:
- One click statement analysis shows the Oracle Explain plan in a powerful graphical Treeview to quickly see if it has the optimum access path.
- Display Oracle wait states correlated with SQL.
- SQL Parsing to enhance analysis.
|
 |
 |
Objects ViewThe DBTuna Objects View displays all the current Oracle configuration parameters from any monitored database, as well as databases, tables and objects:
- One-click view to check or cross reference Database config values.
- Switch between monitored databases to compare config values.
- Quickly view information on tables and indexes.
- Report on changes to configuration parameters.
|
Comprehensive ReportsDBTuna has many powerful historical reports including:
- Time Series Comparison - compare two periods of time and immediately quantify the difference in performance between them. Ideal for comparing seperate load tests.
- Top SQL Report
- Grouped SQL Report - group SQL by functional area, or report on PL/SQL packages.
- Oracle Wait State Analysis
- Oracle Instance Statistics
|
 |