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

Sessions Summary

The Sessions Summary collection retrieves information regarding session types.

Collection Type

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
Active Sessions	The average number of active sessions during the specified time range
Active Sessions PCT	The average percentage of active sessions within the total sessions during the specified time range
Background Sessions	The average number of background sessions that ran during the specified time range.
Blocked Sessions	The average number of blocked processes that were collected during the specified last sample.
Cached Sessions	The average number of cached sessions during the specified time range
Foreground Sessions	The average number of foreground sessions that ran during the specified time range.
Inactive Sessions	The average number of inactive sessions during the specified time range
Killed Sessions	The average number of killed sessions during the specified time range
PDB	In multitenant architectures, the name of the pluggable database
Sniped Sessions	The average number of sniped sessions during the specified time range
Total Sessions	The average number of sessions during the specified time range
Total Sessions Limit	The maximum allowable number of sessions

Servers

The Servers collection provides instance processes.

Collection Type

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
Dedicated Servers	The number of dedicated server processes. Each dedicated server process service a single client process.
Dispatchers	The number of multi-threaded server (MTS) dispatchers. MTS dispatchers coordinate the allocation of shared servers to client tasks.
Shared Servers	The number of servers that service more than one client process. This value includes both shared servers and multi-threaded servers (MTS).

Tablespaces Free Space Fragmentation

The Tablespaces Free Space Fragmentation collection retrieves information regarding the fragmentation of tablespace free space.

Collection Type

Collection Sampling Settings

None (on-demand collection).

Metric Descriptions


Metric	Description
Average Extent Size	The average size of free extents in this tablespace
Extents	The number of free extents in this tablespace
Max Extent Size	The size of the largest free extent in the selected tablespace
Min Extent Size	The size of the smallest free extent in this tablespace
Partly Usable	The total sum of fragments that are smaller than the maximum allocated extent in the tablespace, but bigger than, or equal to, the minimum allocated extent in the tablespace
PDB	In multitenant architectures, the name of the pluggable database
Tablespace Name	The name of the currently selected tablespace
Unusable	Total sum of fragments whose size is less than the size of the minimum extent in the tablespace
Usable	Total sum of fragments that are greater than or equal to the minimum extent in the tablespace.

Tablespaces Storage

The Tablespaces Storage collection provides a list of all tablespaces and their overall properties and storage characteristics.

Collection Type

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	3600
Online	3600
Offline	14400

Metric Descriptions

Allocated Space Used Pct

The percent of used allocated space within this tablespace

Allocation Type

The type of extent allocation to be used for this tablespace. The possible values for this metric are as follows:

•

•

•

The number of autoextensible ASM datafiles

The number of autoextensible OS datafiles

Average Fragment Size

The average size of fragments in this tablespace

Indicates whether the tablespace is a BIGFILE tablespace. BIGFILE tablespaces are supported only for locally managed tablespaces with automatic segment-space management.

The tablespace blocksize

The type of tablespace contents is one of the following:

•

•

•

The database name

Default Table Compression

Indicates whether table compression is enabled by default for this tablespace

Indicates whether the tablespace data is encrypted.

Estimated Date Until Full

The estimated date when the tablespace becomes full.

Estimated Until Full

The estimated number of days until the tablespace is full.

Extent Management

Indicates the extent management type:

•

DICTIONARY — where the management of extents is within the Oracle data dictionary.

•

LOCAL — where the management of extents is within the tablespace itself.

Indicates whether the tablespace is in FORCE LOGGING mode:

•

Yes — logs all changes to all objects in the tablespace except changes to temporary segments.

•

No — logs are not created.

The number of fragments in this tablespace

The total amount of free space in this tablespace

The percent of free space in this tablespace

Indicates whether a redo log is to be generated for the tablespace

Long Term Growth Rate

The long term growth rate.

The number of manual ASM datafiles

The number of manual operating system datafiles

Max Fragment Size

The size of the largest fragment in this tablespace

Min Fragment Size

The size of the smallest fragment in this tablespace

Number of Datafiles

The number of datafiles in the tablespace

In multitenant architectures, the name of the pluggable database

Recycle Free Pct

The percentage of recycle bin space which occupies the allocated free space of the tablespace.

The total amount of space used by the recycle bin within the allocated free space of the tablespace

Indicates whether unexpired UNDO operations are retained in the tablespace. This applies only to UNDO tablespaces.

Segment Space Management

Indicates the method used for managing free and used segments:

•

manually — by free lists

•

automatically — by bitmaps

Short Term Growth Rate

The short term growth rate.

The current status of the tablespace.

•

•

Tablespace Name

The name of the currently selected tablespace.

The total amount of space in the currently selected tablespace.

The amount (in megabytes) of space used in this tablespace

The amount (in megabytes) by which the size of the tablespace has increased during the specified time range

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