• Become a portal pro
• Download
• Print
• My Downloads ()

• Support
• Technical Documentation
• Foglight for Oracle (Cartridge) 7.3.0
• Foglight for Oracle (Cartridge) 7.3.0 - User Guide

Foglight for Oracle (Cartridge) 7.3.0 - User Guide

Table of Contents  

Installing and Configuring Agents

Installation

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

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

Glossary

Alarm

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

Technical support resources

• Viewing Topics 117 - 120 of 252

×

Overview of Collections

Foglight for Oracle collects raw data for a set of collection types. This data is used by the Rules to trigger alarms and is used to populate dashboards. The collections data tables are not viewable from Foglight for Oracle, but the data is implemented in the various drilldowns of Foglight for Oracle.

The collection data tables are not viewable from Foglight for Oracle.

NOTE: Several collections contain metrics whose name ends with Rate (for example: DBO Wait Buffer Busy Rate). Such metrics, which are not documented in this guide, are used for plotting the original metric (usually called by the same name without the “Rate” suffix) on a graph for the selected time range.

Alert Log

Purpose

The Alert Log collection retrieves the content of Oracle alert log.

Collection Type

Oracle

Collection Sampling Settings

 

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

Metric Descriptions

 

Metric	Description
Critical Errors	The number of critical error notifications that were received during the specified time range.
Dump File Name	Indicates the name of dump file (if this name appears in the alert log message).
Fatal Errors	The number of fatal error notifications that were received during the specified time range.
Informational Errors	The number of informational messages that were received during the specified time range.
Message	The text of the alert log message.
Name	The name of the alert log message.
Severity	Indicates the alert log message severity (Fatal, Critical, Warning, Informational).
Timestamp	Alert log message timestamp.
Type	Alert log message type (Internal Error, Storage, Media Failure and so on).
Warning Errors	The number of warning error notifications that were received during the specified time range.

Archive Destination Miscellaneous

Purpose

The Archive Destination Miscellaneous collection provides Archive Destinations activity rates and time considerations.

Collection Type

Oracle and Operating System

Collection Sampling Settings

 

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

Metric Descriptions

 

 

Metric	Description
Archive Destination Free Space	The free space in the file system where the most critical archive destination is located.
Archive Destination Size	The size of the file system where the most critical archive destination is located.
Archive Rate	The rate of the archiving operation.
Archiving Volume	Archiving volume
Average Archive File Size	The size of the average archive file
Binding	Binding type: • MANDATORY — successful archival is required. • OPTIONAL — successful archival is not required.
Critical Archive Time To Failure	The number of hours left until the critical archive destination fills.
Database	The database name.
Destination	The destination ID of the most critical archive destination.
Destination directory	The archive’s destination directory
Destination Free Space	The total amount (in megabytes) of free space available for the archive destination target.
Destination Total	The total size (in megabytes) of the archive destination target.
Time To Failure	The number of hours remaining until the archive destination with the shortest time to failure is filled.

Archive Logs Storage

Purpose

The Archive Logs Storage collection provides Archive Destinations properties and file systems space data.

Collection Type

Oracle

Collection Sampling Settings

 

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

Metric Descriptions

 

Metric	Description
Archive Destination	The name of the destination archive file.
Archiver Status	The archiver status; can have one of the following values: Stopped, Started, and Failed.
Binding	Binding type: • MANDATORY — successful archival is required. • OPTIONAL — successful archival is not required.
Database	Database name
Destination Directory	The directory used for storing the archive.
Destination End	The value of destination directory is replaced by Recovery Destination if the directory is used for recovery.
Destination Free Space	The total amount (in megabytes) of free space available for the archive destination target.
Destination Total	The total size (in megabytes) of the archive destination target.
Destination Type	The type of the archived log destination: • PUBLIC • PRIVATE
Destination Usable	The amount (in megabytes) of storage space usable for the archive logs in the destination directory.
Error	Displays the error text.
If database in archive mode	Indicates whether the database is in archive mode
Is ASM	Indicates whether the instance is an Automatic Storage Management (ASM) instance
Is Recovery	Indicates whether the directory is used for recovery (True) or not (False).
Log Sequence	Identifies the sequence number of the most recently archived redo log.
Multiple destinations in filesystem	Indicates if more than one archive destinations reside on the same filesystem.
Re-open	Identifies the retry time (in seconds) to open a destination after error.
Space Reclaimable	The amount of space that can be used if files are removed from the Flash Recovery Area.
Status	The current status of the destination in V$ARCHIVE_DEST: • VALID • INACTIVE • DEFERRED • ERROR • DISABLED • BAD PARAM • ALTERNATE • FULL
Target	Specifies whether the archive destination is local or remote to the primary database: • PRIMARY - local • STANDBY - remote
Transmit Mode	The mode in which data is transmitted across the network: • SYNCHRONOUS • ASYNCHRONOUS • PARALLELSYNC
Unarchived redo logs	The percentage of redo logs files that are waiting for archiving
Valid Type	The redo log type or types that are valid for the destination: • ONLINE_LOGFILE • STANDBY_LOGFILE • ALL_LOGFILES

•  Previous
• Viewing Topics 117 - 120 of 252
• Next 

Search this document Search all documents

×

 Welcome to Quest Support

You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center