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

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

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

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

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

• Viewing Topics 45 - 48 of 248

×

Reviewing Instance Usability

The Instance Usability panel displays aggregated information regarding the instance’s usability and availability.

This panel supports the following tasks:

•	Identifying instances. For details, see The Instance Pane .

•	Viewing usability-related alarms. For details, see The Alarms Pane .

•	Tracking the instance’s availability, plotted over the defined time range. For details, see The Instance Availability Section .

•	Tracking the listener’s availability, plotted over the defined time range. For details, see The Listener Availability Section .

•	Tracking the instance’s connection time, plotted over the defined time range. For details, see The Connection Time Section

•	Tracking the instance’s response time, plotted over the defined time range. For details, see The Response Time Section .

The Instance Pane

The Instance pane contains the following indicators:

•	DB Type — identifies monitored database’s type (for example: SQL Server or Oracle).

•	Oracle Version — identifies the Oracle version number, along with the most recently installed patches.

•	Up Since — identifies the date and time when the instance was last started. If the database is not running this area reads “Database is down”, and a popup is available, displaying the database status.

The Alarms Pane

The Alarms pane displays the usability-related outstanding alarms. These alarms alert the following issues per instance: response time, instance availability, instance connection availability, OS connection availability, instance connection time, and Listener status.

The Instance Availability Section

The Instance Availability section displays the instance availability in percentages, plotted over the time range. If the instance was unavailable once or more during this time, the relevant message describing the last occurrence of unavailability appears in the Error Message box.

The Listener Availability Section

The Listener Availability section displays the availability of all listeners configured for the instance, in percentages, plotted over the time range. If one or more of the listeners were unavailable during this time, a message describing this issue appears under the Listener Errors section.

The Connection Time Section

The Connection Time section displays the instance’s connection time, in seconds, plotted over the time range.

The Response Time Section

The Response Time section displays the instance’s response time, in milliseconds, plotted over the time range.

Reviewing Cluster Usability

Use the Cluster Usability panel to compare between the various RAC nodes, regarding the following indicators:

•	Availability — measured in percentages

IMPORTANT: The Availability section also displays the listener’s availability during the specified time range.

•	Connection Time — measured in milliseconds

•	Response Time — measured in milliseconds

 

To investigate a single instance, select the requested instance from the list at the top of the panel. The display switches to instance usability. For details, see Reviewing Instance Usability .

Reviewing Locks Activity at the Cluster Level

The Activity Locks panel for a RAC comprises the following panes:

•	Locks Activity

•	Lock Tree (Current)

•	Locks Historical Tree

Locks Activity

The Locks Activity pane displays a breakdown of all lock types and their general properties.

 

Table 9. Locks Activity pane

Name	Description
Lock Name	The name of the lock.
Gets	The total number of enqueue requests or enqueue conversions for this type of enqueue.
Gets Rate	The rate of lock gets.
Gets (percent)	The percentage of lock gets for this type of lock within the total number of locks.
Enqueue Waits	The total number of times an enqueue request or conversion resulted in a wait event.
Waits Rate	The number of wait events per second.
Wait (percent)	The percentage of wait events for this type of lock within the total number of locks.
Lock Wait	The total amount of time spent waiting for the enqueue or enqueue conversion.
Average Lock Duration	The average length of time for a lock, in milliseconds.
Lock Efficiency	The percentage of lock requests that did not escalate to a blocking lock.
Alarms	The number of warning, critical, and fatal alarms that were invoked for this Oracle database instance. Holding the cursor over each alarm type displays a dwell that shows the most recent alarms invoked for this database instance, sorted by severity. Click each alarm type to drill down and manage the alarms. See the Foglight Online Help, Monitoring System-Wide Alarms for details on the alarm information.

Lock Tree (Current)

The Lock Tree (Current) pane displays current data, which is available only in real-time mode.

Clicking any locking or locked session table row displays a popup that is used for viewing further details. For information see Session Details Popup .

 

Table 10. Lock Tree (Current)

Name	Description
PDB	In multitenant architectures, the name of the pluggable database where the lock took place.
Session	The identifier for a session that holds or acquires the lock.
Serial	The session’s serial number. The combination of SID and serial number provides a unique identification of the session.
DB User	The database user name.
Object Wanted	The object requested for lock.
Lock Type	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: • TM — DML enqueue • TX — Transaction enqueue • UL — User supplied
Lock Mode	The lock mode in which the session holds the lock. This row can have one of the following values: • None • Null • Row-S (SS) • Row-X (SX) • Share • S/Row-X (SSX) • Exclusive
Lock Request Mode	The lock mode in which the process requests the lock. This row can have one of the values listed below. • None • Null • Row-S (SS) • Row-X (SX) • Share • S/Row-X (SSX) • Exclusive
Lock Duration	The duration of the lock in seconds.
Cross Instance	Defines whether the lock is between different cluster nodes: • YES — for global locks • NO — for single node locks
Instance	The name of the instance to which the blocking or blocked session belongs.
Kill Session	Used for terminating the selected session, by means of the Kill Session dialog box that is displayed upon clicking this column. NOTE: Killing a session requires having specific privileges. Please provide an Oracle user with these privileges. Alternatively, select the check box Log-in as SYSDBA to provide the credentials of a SYSDBA user.

Session Details Popup

 

Table 11. Session Details Popup

Name	Description
SID	The session identifier
Serial	The session’s serial number. The combination of SID and serial number provides a unique identification of the session.
Process	The process number
DB User	The database user name
OS	The operating system name
Program	The name of the program that is processing the SQL statements
Client	The Client computer identifier
Host	The host computer identifier
Current SQL	The SQL text of the SQL statement that is currently being processed in this session

Locks Historical Tree

The Locks Historical Tree pane displays the overall locks activity that took place within the selected time range, as well as locks that exceeded a predefined threshold.

This pane comprises the following sections:

•	Lock Wait Events — a chart that displays all of the lock wait events, plotted over time. This chart can be viewed in either of the following views:

•	Baseline — displaying only lock wait events.

•	Breakdown — displaying both lock and non-lock wait events.

•	Locks Exceeding a predefined threshold — displays locks that reached or exceeded the minimal duration, in seconds, which a lock should reach or exceed in order to be collected.

NOTE: The minimal duration’s length is defined using the Locks pane of the Collection Settings view.

Reviewing Locks Activity at the Instance Level

The Activity Locks panel, which displays lock summary information for an Oracle instance, comprises the following panes:

•	Locks Wait Events chart

The content of this pane is similar to that of the chart displayed under the Activity > Locks > Locks Historical Tree pane at the Whole Cluster mode. For more information, see Locks Historical Tree.

•	Locks Activity pane — identical to the Locks Activity pane in the Whole Cluster mode. For more information, see Locks Activity.

•	Locks Tree (Current) pane — identical to the Locks Tree (Current) pane in the Whole Cluster mode. For more information, see Lock Tree (Current).

•	Locks Historical Tree — see Locks Historical Tree .

•  Previous
• Viewing Topics 45 - 48 of 248
• 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

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