Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

FREE TRIALS

Foglight for Oracle (Cartridge) 5.7.5.41 - User Guide

Table of Contents

Installing and Configuring Agents

Installing and Configuring Agents Upgrading to the Current Version Overview Running the Upgrade Wizard Migrating Agents

About Monitoring Extensions

Configuring the On Demand Port on the Agent Manager Concentrator

Installing and Monitoring a Single Oracle Instance Discovering Multiple Instances to Monitor

Loading a TNS file

Adding CRS Agents for Monitoring Clusterware

Adding Agents for Monitoring Exadata Environments

Modifying the Exadata Monitoring Settings

Adding ASM Instances Configuring Multiple Instances for Monitoring using Silent Installation

Contents of the input CSV file for Oracle instances Configuring Multiple Instances for ASM Contents of the input CSV file for ASM instances

Using Foglight for Oracle

Viewing the Databases Dashboard Assigning Instances to Users Selecting an Instance to Monitor

Filtering the Display by Severity Creating User-defined Database Groups Components Shared by All Foglight for Oracle Screens Using the Currently Selected Database Group Table Viewing Data about the Exadata Cells

Foglight for Oracle Overview Dashboard

Breakdown and Baseline Chart Formats Home Page Toolbar

Overview view Advisories view SQL Performance Investigator (SQL PI)

Viewing Historical Metrics Blocking History Activity Highlights Viewing Change Tracking Viewing Execution Plans Comparing Performance

Reviewing Overall Activity

Monitoring Current Activity Monitoring Current Storage Tracking Throughput Monitoring Historical Activity Monitoring Alarms Enabling or disabling baseline calculation Generating Reports

Reviewing RAC Historic Activity

Monitoring the Cluster's Usability and Load Balance Monitoring Interconnect, Cluster, and Global Cache Monitoring Disk Storage Monitoring the Cluster's I/O Activity Monitoring Resource Utilization Monitoring Session Activity

Oracle Activity Drilldown

Viewing the Foglight for Oracle Real-time Summary Page Reviewing Instance Usability Reviewing Cluster Usability Reviewing Locks Activity at the Cluster Level Reviewing Locks Activity at the Instance Level Viewing Detailed Sessions Data Viewing Datafiles I/O Activity at the Cluster Level Viewing Datafiles I/O Activity at the Instance Level Viewing User-Defined Collections

Pluggable Databases Drilldown

Pluggable Databases List table Overview tab Activity within Instance/Cluster tab

Storage Drilldown

Tablespaces and Datafiles Panel Redo Logs Panel Members of Group [n] Table Archive Logs Panel Archive Log Destinations Table Invalid Objects Panel Database Backup Panel

Reviewing Configuration Settings

Reviewing SGA Settings at the RAC Level Reviewing SGA Settings at the Instance Level Reviewing the Initialization Parameters

Reviewing the Alert and Error Logs

Reviewing the Error Log Reviewing the Alert Log

Reviewing ASM Instances

Reviewing Summary Information Reviewing Parameter Information Reviewing Alert Log Information

Reviewing Exadata-related Information

Displaying Exadata-related Summarized Data Reviewing the Exadata Performance Reviewing the InfiniBand Topology

Administering Foglight for Oracle

Opening the Databases Administration Dashboard Reviewing the Administration Settings Defining Connection Details

Defining the Connection Settings for the Monitored Oracle Instances Validating Connectivity and Starting to Monitor the Instances Defining the Connection Settings for the Monitored ASM Instances

Defining Data Collection and Storage Options Customizing Alarms for Foglight for Oracle Rules

Introducing the Alarms View Setting and Modifying Alarm Sensitivity Levels Modifying Alarm Settings Configuring Email Notifications Cloning Agent Settings Reviewing Rule Definitions

Defining Retention Policies Defining the Collection Settings

Locks Top SQL Statements Tablespace Settings Invalid Objects Settings

Configuring the Alert Log Panel Display Configuring the List of Listeners per Instance Configuring User-defined Collections Configuring the On-demand Data Port Changing the Monitoring Mode of the RAC One Node Agents Administering SQL Performance Investigator

Generating Reports for a Foglight for Oracle RAC or Instance Studying the Various Reports

Overview of Collections

Alert Log Archive Destination Miscellaneous Archive Logs Storage ASM Diskgroups ASM Diskgroups Balance ASM Disks ASM Instance Total ASM Operations Backup Config Backup Jobs Backup Type Status Cluster Latency Cluster Misses Datafile Fragmentation Datafile IO Activity Datafiles Storage Dataguard Destination Status Dataguard Redo Apply Dataguard Status Dump File Event Wait Exadata Cell Flashcache Exadata Cell General Exadata Cell InfiniBand Exadata Cell InfiniBand Ports Exadata Cell InfiniBand Switches Exadata Cell Statistics Exadata Cell General Filesystem Disk Flashback Area History Locks Tree Instance History Locks Tree RAC Host Properties Initialization Parameters Instance General Invalid Objects Invalid Objects List IO Activity Jobs Queue Latches Activity Locks Activity Locks Breakdown Locks Instance Locks Tree Locks Tree RAC OS and Instance Statistics OS File System IO Summary OS General Network Summary Parallel PGA Statistics Pluggable Databases Information Pluggable Databases State Redo Archive Performance Redo Instances Miscellaneous Redo Logs Member Storage Redo Log Storage Sessions Summary Servers Tablespaces Free Space Fragmentation Tablespaces Storage Top Blocked Objects Top Sessions Top SQLs Top SQLs Full Text Top SQLs Text Total Archive Storage Total Database Storage Total Instance Waits Undo Activity Total Summary Usability

Alarm Authentication Buffer Wait Calibration Cartridge Cluster Wait CPU Usage CPU Wait Cursors DataGuard DataFlow Deadlock Disk Transfer Time Disk Utilization DiskPerf Dispatcher Drilldown External Procedures Foglight Agent Manager Foglight Management Server Host Name Host Process I/O Wait Kernel Memory Kernel Mode Kill LRU LSN Latch Wait Licensing Lock Wait Logical Reads Metric Network Wait OLTP Other Wait Paging Panel Per-Seat Licensing Per Server Licensing Physical Reads PID Privileged Mode Process Random I/O Recompile Recursive Calls Referential Integrity Relational Data Engine SQL*Net Scattered Read Schema Locks Sequential Read Severity Spinner SQL *net Threshold Transaction Unused Space User Mode

Viewing Data about the Exadata Cells

The table displayed in the Exadata tab contains the following columns.

Table 4. Exadata table
Name	Description
Exadata
Sev	The highest severity alarm invoked within all cells monitored by the selected agent, which determines the agent’s health state.
Name	The name of the Exadata agent.
Version	The version number of the Oracle Linux used for running the Exadata storage server.
Online Cells	The number of cells monitored by the selected agent that are currently online.
Temperature Status	The temperature status of all cells monitored by the selected agent, as provided by the Baseboard Management Controller (BMC); indicates whether the temperature is normal. Any deviation from the normal temperature value, which is determined by Oracle, invokes an alarm indicated using an orange color on this column.
Total Read Rate (Mb/S)	The rate (megabytes/second) at which data was read from all celldisks during the specified time range.
Total Written Rate (Mb/S)	The rate (megabytes/second) at which data was written on all celldisks during the specified time range.
Alarms	The number of warning, critical, and fatal alarms for the celldisks. When holding the cursor over one of the alarm counts, the dwell displays the most recent alarms invoked for these celldisks, sorted by severity. Clicking this field displays the Alarms list, which is listed by severity order. See the Foglight Online Help, “Monitoring System-Wide Alarms” topic for details on the alarm information.
System Utilization
CPU Load (%)	The overall operating system CPU usage by all processes (including CPU usage by the database).
Memory (%)	The percentage, within the total memory, of memory consumed by all operating system processes (including the database). This value includes both RAM resident memory and swapped memory.
Monitoring Status
	Indicator whether data is being collected.

Foglight for Oracle Overview Dashboard

Foglight for Oracle Overview Dashboard

The Foglight for Oracle Overview dashboard provides various detailed views that are accessible using the toolbar.

The Overview dashboard contents depends on whether a RAC (Real Application Cluster) or an Oracle database instance is selected.

Breakdown and Baseline Chart Formats

Several charts can display information in either of the following formats:

•

Baseline format — where a selected individual metric is displayed as a single line.

•

Breakdown format — a representation of actual activity of a metric or a set of metrics, compared with the typical behavior of these metrics for the selected time range. A breakdown display can also present a single metric divided into various components. For example, space utilization is broken down by the various components that occupy the space.

Home Page Toolbar

Home Page Toolbar

The Foglight for Oracle Overview dashboard provides the following toolbar buttons.

Table 5. Foglight for Oracle Home Page Toolbar

Opens the Overview view.

Opens the Advisories view.

Opens the SQL Performance Investigator (SQL PI) drilldown, which displays performance-related data at the following levels:

•

High-level data — available for all instances.

•

In-depth data, delivered by means of the Cluster view or Instance view tree — available only for instances or RACs that have Performance Analysis installed and configured.

Opens the Reviewing Instance Usability, which contains the following panels:

•

Real-Time — see Viewing the Foglight for Oracle Real-time Summary Page .

•

Usability — see Reviewing Instance Usability and Reviewing Cluster Usability .

•

Locks — see Reviewing Locks Activity at the Cluster Level and Reviewing Locks Activity at the Instance Level .

•

Sessions — see Viewing Detailed Sessions Data .

•

Overall Datafiles I/O — see Viewing Datafiles I/O Activity at the Cluster Level and Viewing Datafiles I/O Activity at the Instance Level .

•

User-defined Collections — see Viewing User-Defined Collections .

Pluggable Databases

Oracle instance 12C - pluggable only — Opens the Pluggable Databases Drilldown, which contains the following components:

•

Pluggable Databases List table — see Pluggable Databases List table .

•

Overview tab — see Overview tab .

•

Activity within Instance — shows the selected pluggable databases’ activity as part of the entire instance activity. For details, see Activity within Instance/Cluster tab .

Opens the Storage Drilldown, which contains the following panels:

•

Tablespaces and Datafiles — see Tablespaces and Datafiles Panel .

•

Redo Logs — see Redo Logs Panel .

•

Archive Logs — see Archive Logs Panel .

•

Invalid Objects — see Invalid Objects Panel .

•

Database Backup — see Database Backup Panel .

The Storage panels are common for both RAC and all of the instances.

Opens the Configuration drilldown, which contains the panels listed below.

•

SGA — see Reviewing SGA Settings at the RAC Level .

•

Initialization Parameters — see Reviewing the Initialization Parameters .

Opens the Alerts drilldown, which contains the following panels:

•

Error Log — see Reviewing the Error Log .

•

Alert log — see Reviewing the Alert Log .

In RACs that have Exadata configured, opens the Exadata drilldown, which contains the following panels:

•

•

•

InfiniBand Topology

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating