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

Invalid Objects Panel

The Invalid Objects panel displays all of the database’s schema and the invalid objects detected in each schema, as well as their distribution per schema.

This panel comprises the following sections:

•
Invalid Objects Table
•
Invalid Objects Distribution chart — see Invalid Objects Distribution for the selected schema .
Invalid Objects Table

The Invalid Objects table displays each schema in a separate row, together with invalid objects of the following types:

•
Functions
•
Packages
•
Package bodies
•
Procedures
•
Types
•
Views
•
Other type objects

In addition, the table displays the total number of invalid objects and the alarms invoked as a result of the invalid objects detected in the schema.

* 
IMPORTANT: By default, all of the schemas are monitored by the Invalid Objects collection. A schema with no invalid objects is displayed with a zero value in all of its columns. To exclude specific schemas from being monitored, use the Exclude List pane under the Collection Settings view in the Databases Administration dashboard. For details, see Invalid Objects Filtering .

For each object type (for example, Procedures) whose metric value contains data, that is: a number greater than zero, clicking the metric value displays a popup with a detailed list of all invalid objects for the specific object type in the selected schema.

Invalid Objects Distribution for the selected schema

The invalid objects distribution chart displays the distribution of the invalid objects for the schema selected in the Invalid Objects table.

Database Backup Panel

The Database Backup panel displays various details regarding the backup of the Oracle database and datafile.

This panel contains the sections listed below.

•
Last Successful Backup — the exact time and date when the most recent full backup of the datafile and database took place . A warning icon appears to the left of this section’s title if the time that elapsed from the last successful backup date exceeds a predefined threshold (by default, seven days).
* 
IMPORTANT: The threshold for the number of days that elapsed since the last successful full backup of a specific database can be configured by modifying the settings of the Days Since Full Backup alarm, in the Threshold section of the Alarms view in the Databases Administration dashboard. For details, see “Modifying alarm threshold values” on page 179.
•
Configuration Parameters — user-defined parameters that configure the backup operation, such as the device type and the backup jobs parallelism.
•
Backup Jobs — a list of the backup operations that took place during the selected time range.
A backup operation can have one of the following statuses:
•
Completed
•
Failed
•
Completed with errors
•
Completed with warnings
Operations with a Completed status are indicated with a green check mark icon (), while a warning icon appears near each operation whose status is other than Completed. Each backup job is identified by both the Start Time column, which indicates whether the backup was carried on a database or a datafile, and the Job ID column.
Clicking the row displays a popup with the details of the backup job in the selected row.

Reviewing Configuration Settings

Use the Configuration drilldown to review the current configuration settings of the Oracle agent, as well as tracking the modifications made to these settings.

This drilldown comprises the following panels:

•
SGA — displays the settings and utilization of the SGA memory, using different display for the RAC and instance levels. For details, see Reviewing SGA Settings at the RAC Level and Reviewing SGA Settings at the Instance Level .
•
Initialization parameters — displayed at both the instance and the RAC levels. For details, see Reviewing the Initialization Parameters .

Reviewing SGA Settings at the RAC Level

In Whole Cluster view, use the Memory drilldown to carry out the following operations:

•
Reviewing SGA Settings
•
Reviewing SGA Utilization
•
Reviewing the SGA’s Breakdown
•
Reviewing the free space reserved for the various SGA pools
Reviewing SGA Settings

Use the SGA management section to review the current SGA settings for the entire RAC, using a row that contains the following indicators:

•
Automatic SGA — indicates whether the SGA memory’s automatic memory management is turned on or off.
•
Max SGA Size — displays the maximum amount available for the SGA memory.
•
SGA Utilization — displays the average amount of SGA memory, in megabytes, which was consumed during the selected time range
•
Memory Target — displays the target amount of SGA memory, in megabytes
Reviewing SGA Utilization

The SGA Utilization section contains a chart that displays SGA-related information in a breakdown format, which provides a representation of the size the following components occupy within the SGA memory:

•
ASM Buffer Cache (data is available only if the ASM instance is installed and configured)
•
Buffer Cache
•
Java Pool
•
Large Pool
•
Shared Pool
•
Stream Pool
Reviewing the SGA’s Breakdown

Use the SGA Size section to review the breakdown of the SGA within the RAC, by means of the following components:

•
A chart — providing a representation of the size each of the RAC’s nodes occupies within the SGA
•
A table — containing the name of the RAC or the specific node, along with columns that indicate the SGA’s breakdown between the RAC’s nodes, using the following metrics:
•
Fixed size
•
Variable size
•
Database buffers
•
Redo buffers
Reviewing the free space reserved for the various SGA pools

The SGA Pool Free Space section displays, both graphically using a chart and in a table format, the free space reserved for the following types of SGA pools for each of the RAC’s nodes:

•
Java pool
•
Large pool
•
Shared pool
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating