Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Foglight for Oracle (Cartridge) 6.3.0 - 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)

Performance Tree 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 Viewing Alarm Sensitivity Levels for Unassigned Agents Modifying Alarm Templates 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 Long Running Session 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

OS File System IO Summary

The OS File System IO Summary collection provides IO information about the operating system.

Collection Type

Operating System

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
Operating System	The name of the operating system where the selected instance is running.
System Physical Reads	The number of physical read operations carried out from this operating system.
System Physical Writes	The number of physical write operations carried out from this operating system.
System RW Operations	Total number of disk operations (both read and write) carried out by the operating system. This metric does not include operations that were satisfied using the file system.

OS General Network Summary

The OS General Network Summary collection provides network information about the operating system.

Collection Type

Operating System

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
Net Collisions	The number of times two computers sent packets at the same time on the network, and the packets “collided”, resulting in the need to retransmit both packets.
Net Errors	Number of errors reported on the various network interfaces.
Network Name	The network interface name.
Operating System	The name of the operating system where the selected instance is running.
Packets	The total sum of packets received and sent on this network interface (the sum of the packets_in and packets_out values).
Packets In	Number of packets received by this network interface.
Packets Out	Number of packets sent from this network interface.

Parallel

The Parallel collection provides information about the instance’s parallel executions.

Collection Type

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
Active Parallel Sessions (11i)	Number of active parallel sessions
Active Serial Sessions (11i)	Number of active sessions that were serialized
DDL Statements Parallelized	Number of DDL statements that were executed in parallel
DML Statements Parallelized	Number of DML statements that were executed in parallel
Parallel operations Downgraded	Total number of times parallel execution was requested but execution was downgraded
Parallel Operations Downgraded 1 to 25 Pct	Number of times parallel execution was requested but execution was downgraded up to 25% due to insufficient parallel execution servers
Parallel Operations Downgraded 25 to 50 Pct	Number of times parallel execution was requested but execution was downgraded 25% or more as a result of insufficient parallel execution servers
Parallel Operations Downgraded 50 to 75 Pct	Number of times parallel execution was requested but execution was downgraded 50% or more as a result of insufficient parallel execution servers
Parallel Operations Downgraded 75 to 99 Pct	Number of times parallel execution was requested but execution was downgraded 75% or more as a result of insufficient parallel execution servers
Parallel Operations Downgraded to Serial	Number of times parallel execution was requested but execution was serial as a result of insufficient parallel execution servers
Parallel Operations not Downgraded	Number of times parallel execution was executed at the requested degree of parallelism
Parallel QC (11i)	The number of parallel query coordinators
Parallel Slaves (11i)	The number of parallel slaves
PQ Servers Busy	The number of servers that were simultaneously executing SQL queries and DML statements.
PQ Servers Busy Percent	The percent of busy parallel servers within the total number of parallel servers
PQ Servers Idle	The number of currently idle parallel servers
PQ Servers Limit	The maximum allowed number of parallel servers
Queries Parallelized	Number of SELECT statements executed in parallel

PGA Statistics

The PGA Statistics collection collects information about the use of the PGA memory.

Collection Type

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
PGA Aggregate Target	The value of the PGA Aggregate Target parameter in bytes. The pga_aggregate_target parameter, which was introduced in Oracle 11g, defines the total amount of memory available in Oracle for allocation to the PGA memory structure. If the value of this parameter is set correctly, all work areas executed by the system since start-up are processed exclusively in the PGA memory, requiring no extra passes. In such a case, the PGA hit percent’s value is 100%, and Oracle does not need to allocate extra memory to the PGA. However, when this value is set too small, the hit percent’s value decreases, and Oracle may need to perform one or more extra memory allocations.
PGA Hit Percent	The PGA cache hit ratio (as a percentage). When the value of this metric is 100%, it indicates that all work areas executed by the system processed the entire input data exclusively via the PGA memory, thereby making optimal use of this memory. Any lower value indicates that at least one work area required one or more extra passes over the input data.
PGA Overallocation Count	The number of extra PGA memory allocations that were carried out during the specified time range. Over-allocating PGA memory can happen if the value of the dynamic initialization parameter, PGA_AGGREGATE_TARGET, which is set to all server processes, is too small to allow executing all work area workload (operations) exclusively in the PGA memory. Such a scenario requires Oracle to allocate extra PGA memory. Ideally, the PGA cache hit ratio should be close to 100%, resulting in an extremely small number (close to zero) of PGA overallocations. High values of the PGA Overallocation Count metric indicate the need to increase the value of PGA_AGGREGATE_TARGET.

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