Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

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

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 Locks Historical Tree 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 Fast Recovery Area Panel 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 Log

Reviewing the Alert Log

Reviewing Monitored Data Guard Environments

Reviewing Summary Information Reviewing Performance Information Reviewing Log Shipping Status Information

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 Filtering Invalid Objects Filtering

Configuring the Alert Log Filtering 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

Filesystem Disk

The Filesystem Disk collection provides storage definitions regarding the filesystem disk where datafiles, dump files or archive files are located.

Collection Type

Operating System

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	20
Online	60
Offline	300

Metric Descriptions


Metric	Description
Filesystem size	The size of the filesystem
Filesystem free %	The percentage of the free disk space on the filesystem.
Filesystem Free Space	The amount (in megabytes) of free disk space on the filesystem
Filesystem Name	The name of the filesystem
Filesystem Type	The type of filesystem (datafiles, dump files or mixed files)
Long Term Estimated Till Full	Estimated number of hours until the filesystem is full, based on the long-term growth rate
Long Term Growth Rate	The estimated long-term growth rate of the filesystem
Mounted On	Mount point name.
Operating System	The name of the operating system where this instance runs
Short Term Estimated Till Full	Estimated number of hours until the filesystem is full, based on the short-term growth rate
Short Term Growth Rate	The filesystem’s estimated short-term growth rate
Used	The amount of used disk space on the filesystem
Used %	The percentage of the used disk space on the filesystem
Used Growth	The growth (in megabytes) of used disk space on the filesystem

Flashback Area

If the flash recovery area feature was used for creating a location on disk that enables the database to create various backup and recovery-related files, the Flashback Area collection provides information about this location.

Collection Type

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	300
Online	300
Offline	900

Metric Descriptions

Indicates the types of the files stored on the flashback area:

•

•

•

•

•

•

Non Reclaimable Space Percent

The percentage, within the flashback area, of non-reclaimable space (space currently in use, which cannot be reclaimed).

Number of Files

Indicates the number of files currently stored on the flashback area.

Used Space Percent

The percentage of used space within the entire disk space allocated to the flashback area.

History Locks Tree Instance

The History Locks Tree Instance collection collects snapshots of instance-level locks that reached or exceeded the minimal duration, in seconds, required for collecting the lock. All locks that meet this criterion are displayed in the lower section of the Locks Historical Tree pane.

Collection Type

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	60
Online	60
Offline	60

Metric Descriptions

The SQL statement that waits for lock release

Blocked SQL Hash

The hash value of the statement waiting for lock

Blocking Serial

Serial number of the locking session

A SID that holds locks

The name of the computer where the client is running

Indicates whether the global lock and the locking and blocked sessions are running on different RAC nodes (True) or not (False)

The Oracle database account of the started session

The name of the host where the instance is installed

Instance name of the session in the lock tree

The number of seconds the lock is running

The wait event on which the blocked statement is waiting

The lock mode in which the session holds the lock.

The lock mode can have one of the following values:

•

•

1 - null (NULL)

•

•

•

•

5 - S/Row-X (SSX)

•

6 - exclusive (X)

Lock Request Mode

The lock mode in which the process requests the lock.

The lock request mode has the same possible values as the lock mode.

The type of user or system lock.

The locks on the user types are obtained by user applications. Any process that is blocking others is likely to be holding one of these locks.

The user type locks are as follows:

•

TM - DML enqueue

•

TX - Transaction enqueue

•

UL - User supplied

The object on which the statement is blocked

The operating system user for the Client

In multitenant architectures, the name of the pluggable database.

The operating system process ID for the Oracle server process

The server program name

The session’s serial number. The combination of SID and serial number provides a unique identification of the session.

The session identification number

History Locks Tree RAC

The History Locks Tree RAC collection collects snapshot of all locks within the RAC that reached or exceeded the minimal duration, in seconds, required for collecting the lock. All locks that meet this criterion are displayed in the lower section of the Locks Historical Tree pane

Collection Type

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	60
Online	60
Offline	60

Metric Descriptions

The SQL statement waiting for lock release

Blocked SQL Hash

The hash value of the statement waiting for lock

Blocking Serial

Serial number of the locking session

A SID that holds locks

The name of the computer where the client is running

Indicates whether the global lock and the locking and blocked sessions are running on different RAC nodes (True) or not (False)

The Oracle database account of the started session

The name of the host where the instance is installed

Instance name of the session in the lock tree

The number of seconds the lock is running

The wait event on which the blocked statement is waiting

The lock mode in which the session holds the lock.

The lock mode can have one of the following values:

•

•

1 - null (NULL)

•

•

•

•

5 - S/Row-X (SSX)

•

6 - exclusive (X)

Lock Request Mode

The lock mode in which the process requests the lock.

The lock request mode has the same possible values as the lock mode.

The type of user or system lock.

The locks on the user types are obtained by user applications. Any process that is blocking others is likely to be holding one of these locks.

The user type locks are as follows:

•

TM - DML enqueue

•

TX - Transaction enqueue

•

UL - User supplied

The object on which the statement is blocked

The operating system user for the Client

In multitenant architectures, the name of the pluggable database.

The operating system process ID for the Oracle server process

The server program name

The session’s serial number, which, in combination with SID, provides a unique identification of the session.

The session identification number

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center