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

Reviewing SGA Settings at the Instance Level

Reviewing SGA Settings

Use the SGA management section to review the current SGA settings for the entire RAC, by means of 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 the instance’s current SGA size in either of the following views:

•
Baseline — total SGA space utilization (current SGA size)
•
Breakdown — displays the size the following components occupy within the instance’s SGA:
•
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 instance, by means of the following components:

•
A pie chart — providing a representation of the size each component described in the table occupies within the instance’s SGA
•
A table — shows the SGA’s breakdown between the following components:
•
Fixed size
•
Variable size
•
Database buffers
•
Redo buffers
Reviewing the Free Space Reserved for the Various SGA Pools

The 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:

•
Shared pool
•
Java pool
•
Large pool

Reviewing the Initialization Parameters

The Initialization Parameters panel displays the entire list of initialization parameters, as defined by Oracle. These parameters define the characteristics of each Oracle instance when the instance is started.

Upon clicking anywhere on a row that displays a specific initialization parameter, a popup appears, listing the properties of the selected parameter:

•
The parameter description, taken from Oracle’s documentation (also appears under the Description column).
•
Link to perform searching for further information.
•
Change History table — displays the entire history (time and dates) when the Foglight for Oracle agent detected the changes made to this parameter since the instance was created.

The Initialization Parameters table varies between instance mode and RAC mode. For details about the RAC mode view, see Reviewing the Initialization Parameters in RAC Mode .

In Instance mode, the table displays the following columns

 
Table 27. Initialization Parameters for Instance mode
Name
Description

Parameter

Parameter name.

PDB

In multitenant architectures, the name of the pluggable database.

PDB is Modifiable

Hidden by default. In multitenant architectures, displays the list of pluggable databases that have been modified.

Current Value

The parameter’s current value.

Default

Indicates whether the parameter’s current value is its default value, as defined by Oracle.

Dynamic

Indicates whether the initialization parameter is dynamic, that is, can be modified using the ALTER SESSION, ALTER SYSTEM, or ALTER SYSTEM DEFERRED commands while an instance is running.

Modified

Indicates whether the parameter’s value has been modified.

Deprecated

Indicates whether the parameter is deprecated, in which case specifying it in a parameter file will invoke a warning message when the instance starts.

Type

The parameter type, as defined by Oracle.

Description

The parameter description, taken from Oracle site.

PDB_modifiable

Indicates whether the pluggable database can be modified.

NOTE: This column is not displayed by default.
Reviewing the Initialization Parameters in RAC Mode

In RAC mode, the Initialization Parameters panel can be accessed by selecting either the Whole Cluster or a specific instance view.

In the Whole Cluster view, instance-specific initialization parameters are displayed with the icon to the left of the parameter name, and the names of the various instances are displayed in the Scope column.

The following columns in Initialization Parameters table differ in RAC mode.

 
Table 28. Initialization Parameters in RAC mode
Name
Description

Parameter

Parameter name. A icon to the left of the name indicates that the parameter applies differently to specific instances.

Scope

Indicates whether the parameter applies to the entire RAC or varies between specific instances.

Current Value

The parameter’s current value. This value can be either instance-specific or apply to the entire RAC.

Reviewing the Alert and Error Logs

The Alerts drilldown provides a view on the alert and error logs received for a selected Oracle agent during the specified time range.

This drilldown comprises the following panels:

•
Error Log — see Reviewing the Error Log
•
Alert Log — see Reviewing the Alert Log
* 
NOTE: Both the Error Log and Alert Log panels are displayed only at the instance level. Selecting the Error Log or Alert Log menu item from within a RAC, when the Whole Cluster view is selected, displays a message that prompts the selection of the requested instance.

Reviewing the Error Log

The Error Log panel shows error messages that were selected to be extracted and displayed from the Foglight agent error logs. The error messages appear with their exact date and time, as well as severity level.

Only a small number of the error log messages are displayed in this panel. The messages to be displayed, as well as their severity, are determined within the agent and cannot be modified by the user.

The type of agents whose error logs are used for the message display is determined according to the selected view, as listed below.

•
DB_Oracle — if the selected view is a single instance.
•
DB_Oracle_RAC_Instance — if the selected view is a RAC node.
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione