Oracle Instances View
These displays present performance metrics for Oracle Database instances. Displays are:
| • | Oracle Instances Table : A list of all Oracle Database instances with detailed utilization metrics. |
| • | Instances Heatmap : A heatmap shows alert status of Oracle Database instances. |
| • | Instance Summary : Detailed performance metrics for one Oracle Database instance. |
Oracle Instances Table
Investigate and compare detailed utilization and performance metrics as well as configurations for all Oracle Database instances. This display contains all information available for Oracle Database instances such as Instance ID, Instance Name, Expired, Host Name, Instance Role, Database Status, Version, SQL Hit Ratio and DD Hit Ratio.
Choose one or All databases from the Database drop-down menu. Each row in the table contains data for a particular Oracle Database instance. Click a column header to sort column data in ascending or descending order. Double-click on a table row to drill-down to the Instance Summary display and view metrics for that particular Oracle Database instance. Toggle between the commonly accessed Heatmap and Summary displays by clicking the drop down list on the display title.
Right-click on a table cell to Export to Excel or Copy Cell Value.
The Alert Level column indicates the most critical alert on the instance, where:
|
|
|
Red indicates that one or more alerts exceeded their ALARM LEVEL threshold in the table row.
Yellow indicates that one or more alerts exceeded their WARNING LEVEL threshold in the table row.
Green indicates that no alerts have reached their alert thresholds.
Instances Heatmap
View status and alerts for all instances on one or all Oracle databases. Use this display to quickly identify an instance with performance or utilization issues.
Choose a Metric from the drop-down menu: Alert Severity, Alert Count, Response Time or DB Space Usage %, Current Logins, Active Sessions, Avg Query Time, Max Query Time, Latch Hit Ratio, Data Dict Hit Ratio, SQL Hit Ratio, Commits/sec, Rollbacks/sec, Disk Reads/sec or Disk Writes/sec.
Each heatmap rectangle represents a different instance. The rectangle color indicates the most critical alert state for the selected metric. Click rectangle to view details in the Instance Summary display and view metrics for a particular instance.
Toggle between the commonly accessed Table and Summary displays by clicking the drop down list on the display title. Mouse-over rectangles to view more details about database instance performance and status.
You can view data based on a log scale, which enables visualization on a logarithmic scale and should be used when the range in your data is very broad.
|
Database |
Choose a database to display. |
|||
|
Instance Count |
The number of instances in the display. |
|||
|
Metric: Choose the type of metric to show in the heatmap. Each rectangle is an instance. Each metric has its own gradient bar that maps current relative values to colors: |
||||
|
|
|
Alert Severity |
The maximum level of alerts in the heatmap rectangle. Values range from 0 - 2, as indicated in the color gradient
|
|
|
|
|
Current Logins |
The number of users logged on. The color gradient |
|
|
|
|
Active Sessions |
The number of active sessions. The color gradient |
|
|
|
|
Avg Query Time |
The average amount of time, in seconds, to perform a query. The color gradient |
|
|
|
|
Max Query Time |
The maximum amount of time, in seconds, to perform a query. The color gradient |
|
|
|
|
Latch Hit Ratio |
The ratio of the number of latch misses to the number of latch gets. The color gradient |
|
|
|
|
Data Dict Hit Ratio |
The ratio of logical reads to physical disk reads. The color gradient |
|
|
|
|
SQL Hit Ratio |
The ratio of logical reads to physical disk reads. The color gradient |
|
|
|
|
Commits/sec |
The number of commits per second. The color gradient |
|
|
|
|
Rollbacks/sec |
The number of rollbacks per second. The color gradient |
|
|
|
|
Disk Reads/sec |
The number of disk reads per second. The color gradient |
|
|
|
|
Disk Writes/sec |
The number of disk writes per second. The color gradient |
|
bar, where 2 is the highest Alert Severity.
Yellow indicates that one or more metrics have reached their alarm threshold. Metrics that have exceeded their specified WARNING LEVEL threshold have an Alert Severity value of 1.
Green indicates that no metrics have reached their alert thresholds. Metrics that have not exceeded their specified thresholds have an Alert Severity value of 0.
Instance Summary
Track utilization and performance metrics for a specific instance. Choose a Database and an Instance from the drop-down menus. Mouse-over the utilization information boxes at the top of the display to see more details. Clicking on them takes you to the Oracle Instances Table display, where you can compare metrics with other Oracle Database instances.
The trend graph traces Avg Query Time in milliseconds and rates for Commits, Rollbacks, Disk Reads and Disk Writes.
Mouse-over to see the values at a particular time. You can specify the time range for the trend graph and view data based on a log scale, which enables visualization on a logarithmic scale and should be used when the range in your data is very broad.
Clicking the Critical/Warning link at the bottom of the display opens the Alerts Table by Component display.
