Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.7.5.50 - User Guide

Installing and Configuring Agents Using Foglight for Oracle
Viewing the Databases Dashboard Assigning Instances to Users Selecting an Instance to Monitor Foglight for Oracle Overview Dashboard Overview view Advisories view SQL Performance Investigator (SQL PI) Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert Log Reviewing Monitored Data Guard Environments Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

Reviewing Exadata-related Information

Starting from version 5.6.5.330, Foglight for Oracle monitors Exadata database machines, both from the hardware and software aspects, using the Exadata drilldown.

The Exadata-related information is presented only in RACs where Exadata is configured. While Exadata appears as one of the drilldowns, clicking Exadata opens an Exadata dashboard.

The Exadata dashboard comprises the following drilldowns:

•
Summary — see Displaying Exadata-related Summarized Data
•
Performance — see Reviewing the Exadata Performance
•
InfiniBand Topology — see Reviewing the InfiniBand Topology

Displaying Exadata-related Summarized Data

The Summary drilldown provides summarized data about the performance and resource utilization of the Exadata cells.

Figure 7. Displaying Exadata-related Summarized Data

This drilldown comprises the following components:

•
Cell Table — see Cell table .
•
Performance and Resource Utilization section — see Performance and resource utilization indicators .
Cell table

The cell table provides the following details about each alert log:

•
ID — displays the cell’s ID
•
Name — displays the cell’s name
•
Status — displays an Orange light if the cell is offline, or a green light if the cell is online
•
Connect Availability — displays a green light if the cell’s availability is 100%, otherwise displays a red light
•
Up Since — displays the date and time when the instance was last started
•
Fans (Working/Total) — displays a green light if the number of working fans equals the total number of fans, otherwise displays a red light
•
Power Supplies (Working/Total) — displays a green light if the number of working units equals the total number of units, otherwise displays a red light
•
Temperature — displays a green light if the temperature’s status is Normal, otherwise displays a red light
Performance and resource utilization indicators

The performance and resource utilization indicators includes the following components.

 
Table 28. Performance and resource utilization indicators
Indicator
Description

Flashcache Hit Ratio (%)

Displays the percentage of block requests resolved from the cell flash cache falls below a predefined threshold. This figure is displayed for the selected cells, as well as for all cells.

Block retrieval is carried out significantly faster by accessing the flash cache, as this cache resides on high-performance flash SSD. Low flash cache hit ratio indicates that many blocks are being retrieved from the regular disks, possibly resulting in performance issues.

Memory Utilization (%)

Displays the memory utilization for the selected cells, as well as for all cells.

Overly high memory utilization can result in excessive swapping, which is likely to lead to performance issues.

CPU Busy Percent (%)

Displays the CPU utilization for the selected cells, as well as for all cells.

Overly high CPU utilization can result in excessive swapping, which is likely to lead to performance issues.

Cell Performance

Displays several key indicators for the cell’s performance, as follows:

•
Run Queue Length
•
InfiniBand MB Sent Rate
•
In fin i band MB Sent Rate

Cell Offload Efficiency

The number of rows processed by the cells for all the queries divided by the number of rows forwarded by the cells to the DB node instances.

Higher values of this metric indicate that the cells made good use of their CPUs and high I/O bandwidth to process high number of rows, extract the relevant ones and only forward those to the DB nodes.

Reviewing the Exadata Performance

Reviewing the Exadata Performance

The Performance drilldown includes the following components:

•
Cell table — see Cell table .
•
Query efficiency statistics
•
Celldisks statistics
Query efficiency statistics
Celldisk response time

The Celldisk Response Time (ms) section displays the following metrics on all of the celldisks, as well as on the celldisks selected in the cell table:

•
Celldisks small writes latency — the average latency, in milliseconds, to write small blocks per request.
•
Celldisks small reads latency — the average latency, in milliseconds, to read small blocks per request.
Flash cache statistics

Use the Flash Cache Statistics section to review the load on the flash cache and the number of I/O errors encountered there, by displaying the following metrics on all of the celldisks, as well as on the celldisks selected in the cell table:

•
Flash cache I/O errors — the number of IO errors that were encountered on the FlashCache
•
Data read from flashcache (MB) — the total number of megabytes that were read from the flash cache during the specified time range.
•
Data written to flashcache (MB) — the total number of megabytes that were written to the flash cache during the specified time range.
Flash cache usage chart

The Flash Cache Usage (MB) chart displays the following metrics on all of the celldisks, as well as on the celldisks selected in the cell table:

•
Flash cache usage — the total amount of space (in megabytes) used on the flash cache.
•
Flash cache usage (keep objects) — the total amount of space (in megabytes) used only on the keep objects in the flash cache.
Flash cache request misses chart

The Flash Cache Request Misses (requests) displays the total number of read IO requests that did not find all data in Flash Cache and therefore had to perform physical read operations. This figure is displayed for all of the celldisks, as well as on the disks selected in the cell table, and is split into two charts:

•
Total number of request misses of all types.
•
Total number of request misses resulting from read IO requests for keep objects.
Celldisks statistics

The Celldisk Statistics section displays the rate (megabytes per second) of physical reads and writes that were carried out during the selected time range on all of the disks, as well as on the disks selected in the cell table.

Reviewing the InfiniBand Topology

Use the InfiniBand topology drilldown to monitor the InfiniBand switches and nodes.

This drilldown includes the following sections:

•
Switches — includes a table that displays all of the InfiniBand switches, which are used for transferring information from the database to the storage cells and conversely. This section provides the following details:
•
Number of InfiniBand switches
•
Subnet manager on switch — identifies which of the switches is a master switch.
•
Link status — the InfiniBand Switch's current link status, as indicated during the last sample.
•
Health status — the InfiniBand Switch's current health status, as indicated by the success or failure of the environment test.
•
Nodes — includes a table that displays all of the InfiniBand nodes. This section provides the following information for each node:
•
Node name
•
Node IP address
•
Node host channel adapter (HCA)
•
Node status
•
Node’s ports on each of the InfiniBand switches
•
Charts — display the rate (Mb/S) of data sent and received through the InfiniBand switch during the specified time range.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating