Chatta subito con l'assistenza
Chat con il supporto

Foglight for Oracle (Cartridge) 5.7.5.41 - 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) Reviewing Overall Activity Reviewing RAC Historic Activity Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert and Error Logs Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

Monitoring Disk Storage

The Storage pane contains the components listed below, which display storage status. The information shown in this pane is aggregated to the RAC level.

Datafiles-related Indicators
•
Cylinder — displays the total amount of used and free datafile storage.
Clicking the cylinder displays a popup, which shows the total space usage by the database, plotted over time.
This popup can also be used to drill down for further investigation, using the Tablespace Storage drilldown. For further details, see Tablespaces page .
•
Total — displays the total amount of datafile storage available (used and free), in megabytes.
•
Free — displays the amount of free RAC storage, in percent.
•
Autoextensible — indicates if at least one datafile in the database is autoextensible:
•
No — all of the datafiles in the database are not autoextensible.
•
Yes — at least one datafile in the database is autoextensible.
Archive Destinations-related Indicators

If archiving is configured, the following indicators under the Archive Space (MB) section display storage-related information about the most critical archive destination, that is: the archive destination with shortest time to failure.

This section contains the following indicators:

•
Cylinder — shows the amount of used archive destination memory.
•
Time to Failure (hours) — indicates the estimated time to failure in hours, based upon the rate of archiving.
* 
IMPORTANT: If the archive files reside on a disk that is managed by ASM, the Archive Space cylinder is disabled and the indication ASM agent is required appears. To retrieve archive data, the ASM instance should be installed and configured. For instructions, see “Adding ASM Instances” on page 34.
Indicators of Storage-related ASM Information

If Automatic Storage Management (ASM) is configured, and the ASM instance is installed and configured, the following indicators display storage-related information about ASM:

•
Cylinder — displays the total amount of allocated and free ASM storage memory.
Clicking the cylinder displays a popup, which shows the space usage of storage managed by ASM, plotted over time.
This popup can also be used to drill down for further investigation, using the Tablespace Storage drilldown. For further details, see Tablespaces page .
•
Allocated (megabytes) — the total amount of ASM memory available (allocated and free), in megabytes.
•
Free (percent) — the amount of free RAC ASM storage memory, in percent.

Monitoring the Cluster's I/O Activity

Monitoring the Cluster’s I/O Activity

The Average I/O activity pane uses the indicators listed below to display I/O status information, aggregated to the RAC level.

•
Block Read Service Time — the maximum amount of service time taken for a block read, in milliseconds.
Click the number on the icon to display a popup that shows the amount of time required for reading a single block into memory from a datafile on each instance, plotted over time.
This indicator can also be used for further investigation by means of the IO Activity for RAC drilldown.
•
Physical Reads — the average number of physical reads, in blocks per second.
Click the number on the icon to display a popup that shows the rate at which data blocks are read from disk on all of the cluster nodes. This value is plotted over time.
This indicator can also be used for further investigation by means of the IO Activity for RAC drilldown.
•
Physical Writes — the average number of physical writes, in blocks per second.
Click the number on the icon to display a popup that shows the rate at which modified blocks are written from the SGA to disk by the DBWR processes on all of the cluster nodes. This value is plotted over time.
This indicator can also be used for further investigation by means of the IO Activity for RAC drilldown.
•
Redo Writes — the average number of redo writes, in writes per second.
Click the number on the icon to display a popup that shows the rate at which redo log entries are written to the redo log files by the LGWR processes on all of the cluster nodes. This value is plotted over time.
This indicator can also be used for further investigation by means of the Redo and Archive Performance for RAC drilldown.

The following indicators display data only if Automatic Storage Management (ASM) is configured, and the ASM instance is installed and configured (see Using Foglight for Oracle ):

•
ASM Reads — the total number of reads carried out by ASM disk groups.
Click the number on the icon to display a popup that shows the total reads carried out by the ASM disk groups, plotted over time.
•
ASM Writes — the total number of writes carried out by ASM disk groups.
Click the number on the icon to display a popup that shows the total reads carried out by the ASM disk groups, plotted over time.

Monitoring Resource Utilization

Use the Resource Utilization pane to perform the tasks described in the following sections:

•
Monitoring the CPU Load
•
Monitoring the RAM
Monitoring the CPU Load

The indicators listed below are used for monitoring the CPU load.

•
CPU (%) — the average CPU load (percentage), during the specified time range, of all CPU units that host the RAC nodes. This indicator displays the distribution between Oracle-incurred load and total CPU load.
•
Number of CPUs — the average number of CPU units on all of the RAC nodes’ hosts.
Clicking the number on the icon displays a popup that shows the total CPU usage on the cluster nodes, plotted over time.
Monitoring the RAM

The indicators listed below are used for monitoring the RAM consumption.

•
Memory (%) — the average memory consumption (percentage), during the specified time range, of all CPU units that host the RAC nodes. This indicator displays the distribution between Oracle-incurred memory consumption and total memory consumption.
•
Total RAM — the total amount of RAM configured for the RAC database nodes, in megabytes.
•
Free RAM — displays the percentage of RAM not in use by the cluster nodes.

Monitoring Session Activity

Use the Sessions section to monitor the session activity that took place during the specified time range, by comparing between the following indicators:

 
•
Avg. Active Sessions — the average number of active sessions that experienced resource contention during the selected time range.
•
Avg. Connected Sessions — the average number of sessions that connected to the database during the selected time range.
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione