Foglight for Oracle (Cartridge) 5.7.5.50

Chat now with support

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

Reporting

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

Reference

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

Glossary

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

Redo Archive Performance

Purpose

The Redo Archive Performance collection provides redo and archive activity information.

Collection Type

Oracle

Collection Sampling Settings


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

Metric Descriptions

Metric

Description

Average Redo Write Time

The average time (ms) spent writing a redo log entry to the log files. User sessions experience log write waits when, upon commits, an individual session waits for the LGWR to flush its redo information to the redo log file.

Balance Archive Waits

The extent to which archive wait events are balanced across RAC nodes.

Balance Average Redo Write Time

The extent to which average redo write time is balanced across RAC nodes.

Balance Redo Waits

The extent to which average redo wait events are balanced across RAC nodes.

Balance Redo Writes

The extent to which redo writes are balanced across RAC nodes.

Commits

Number of transactions committed during the current interval. After a transaction is committed, the redo generated by that transaction reflects the changes made to database blocks, which must be written to disk.

Log File Sync Event

Average time spent on writing redo log entries during a commit.

Log Switch Wait

The time the session spent waiting for the completion of a redo log switch.

Log Write Wait

Time spent waiting for the completion of a write (physical I/O) to a logfile. LGWR experience log write waits when it periodically flushes the contents of the log buffer into the active log file.

Redo Waits

Elapsed redo wait time, including the time spent waiting on contention resulting from:

•

User sessions writing redo entries to the redo log buffer

•

LGWR writing the log buffer contents into the active redo log file

•

ARCH archiving redo logs to the destination location

Redo Writes

Total number of write operations issued by the log writer (LGWR) to the redo log files.

Redo Writes Volume

Total amount (in megabytes) of redo operations generated and written to redo logs

Time to Sync a Redo Log Entry

Average time spent on writing single redo log entry to logfile during a commit.

Redo Instances Miscellaneous

Purpose

The Redo Instances Miscellaneous collection provides Redo Log Switches information.

Collection Type

Oracle

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
Log Switches	The number of redo Logs switches during the specified time range

Redo Logs Member Storage

Purpose

The Redo Logs Member Storage is a list of Redo log members and their properties.

Collection Type

Oracle

Collection Sampling Settings


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

The redo log group number

Member Name

The redo log group member name

Member Status

The redo log group member status is one of the following:

•

•

•

•

Redo Log Storage

Purpose

The Redo Log Storage collection provides a list of all Redo log groups and their overall properties.

Collection Type

Oracle

Collection Sampling Settings


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

The archive status of the log file:

•

yes

•

First change#

A system-allocated number (SCN), identifying the first time a change was recorded in this log.

First Time

The time at which the first SCN in the log was recorded.

Group Status

The status of the group is one of the following:

•

•

•

•

•

This information is derived from the v$log table.

Group#

The log group number.

Sequence#

The sequence number.

Size

The size (in megabytes) of the log .

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for Oracle (Cartridge) 5.7.5.50 - User Guide

Redo Archive Performance

Redo Instances Miscellaneous

Redo Logs Member Storage

Redo Log Storage