Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.9.2.1 - 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

Generating Reports for a Foglight for Oracle RAC or Instance

Generating Reports for a Foglight for Oracle RAC or Instance
To generate reports for a selected RAC or instance:
1
Go to Dashboards > Reports.
2
Click Run a Report.
The Run Report dialog box opens.
3
On the first screen, Select Template, Go to All Oracle Templates.
4
Select the requested report.
5
Click Next.
6
Select the requested time range.
7
Select the instance or RAC for which the report will be generated.
8
Click Next.
9
Assign a name for the report.
10
Select the report format (PDF, Excel or XML).
11
Use the Email Recipients field to type the name of the report’s recipients.
12
Click Finish.
The report generation process starts. Upon successful completion of this process, the Report Generated Confirmation dialog box opens.
13
Click Download Now to download the file.
14
Open the file using a relevant program for the selected format.

Studying the Various Reports

The reports that can be generated for Foglight for Oracle are described below. Except for the Cluster Balance report, all of the reports can be generated for either a RAC or an instance.

•
ASM Summary Report — Displays general ASM instance-related information including Disk Groups and their associated Disks.
•
Cluster Balance Report — used for monitoring the load balance, during the selected time range, between the various nodes in the selected RAC.
•
Database Backup Report — Provides an overview of RMAN configuration and database backups.
•
Databases Storage Report — displays a breakdown of the database storage space usage at the host, instance and tablespace levels. If the monitored instance is part of a multitenant architecture, this report at the instance level includes a graph of pluggable database distribution by storage.
•
Health Check Report — used for monitoring various aspects of the instance’s or RAC’s health, that is: availability, listener status, response time and connection time.
•
Host Disk Capacity Report — provides information about the file system disk of each of the monitored host, such as the file system type, the disk size, the amount (MB) of used and free space on the disk, and the percentage of free space.
•
I/O Activity Report — provides several I/O activity indicators, such as workload, physical and logical read and write operations, and wait events.
•
Invalid Objects Report — Displays a summary of invalid objects.
•
Locks Report — Displays lock waits chart (Average Active Sessions) and lock tree.
•
Oracle Cross Instances Availability Report — provides storage-related information about the instance, RAC, node or cluster, such as availability percentage, listener status, connection time, and average response time.
•
Oracle Cross Instances Inventory Report — provides a list with properties of all the monitored instances.
•
Oracle Executive Summary Report — provides key decision-makers with a summary view of the Oracle activity. If the monitored instance is part of a multitenant architecture, this report displays a grid showing data for each pluggable database.
•
Storage Planning Report — Displays a prediction of storage growth using a linear regression method, based on the available historical data (up to 3 months).
•
Storage Summary Report — provides various storage-related indicators, such as the status of datafiles and ASM, and the top 10 tablespaces sorted by space usage. If the monitored instance is part of a multitenant architecture, this report at the instance level includes a graph of pluggable database distribution by storage.
•
Top DB Users Reports — displays the DB users that generated the highest amount of activity for a given time frame.
•
Top Statements Report — Displays the top-consuming SQL statements that were executed during the specified time range. To exclude specific statements from the report, use the optional Exclude Text fields using a LIKE format. For example, specify %backup% to exclude all the statements that contain the word ‘backup’ as part of their text.
•
Workload Summary Report — provides various workload indicators, such as the workload resource breakdown, CPU utilization and SQL executions.

 

Reference

This section describes the collections that are used with monitored Oracle databases:

•
Overview of Collections

Overview of Collections

Foglight for Oracle collects raw data for a set of collection types. This data is used by the Rules to trigger alarms and is used to populate dashboards. The collections data tables are not viewable from Foglight for Oracle, but the data is implemented in the various drilldowns of Foglight for Oracle.

The collection data tables are not viewable from Foglight for Oracle.

* 
NOTE: Several collections contain metrics whose name ends with Rate (for example: DBO Wait Buffer Busy Rate). Such metrics, which are not documented in this guide, are used for plotting the original metric (usually called by the same name without the “Rate” suffix) on a graph for the selected time range.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating