Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

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

Locks Tree

The Locks Tree Instance collection provides lock tree information at the instance level.

Collection Type

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	20

Metric Descriptions

The SQL statement waiting for lock release.

Blocking Serial

The session serial number is either:

•

Waiting for lock (blocked).

•

Holding the object (locking).

The session identifier for the session is holding the object (locking).

The name of the Client machine

The lock is between different cluster nodes for global locks.

The Oracle user, which is either:

•

Waiting for lock (blocked)

•

Holding the object (locking)

The host where the Oracle instance is installed, which is either:

•

Waiting for lock (blocked)

•

Holding the object (locking)

The Oracle instance session is either:

•

Waiting for lock (blocked).

•

Holding the object (locking).

The wait length of time, in seconds.

The event on which the blocked session is waiting

The lock mode in which the session holds the lock

Lock Request Mode

The lock mode in which the process requests the lock

The type of user or system lock.

The object requested for lock.

The OS user name with which the session logged in is either:

•

Waiting for lock (blocked).

•

Holding the object (locking).

In multitenant architectures, the name of the pluggable database.

The operating system process ID for the Oracle server process. The process ID is either:

•

Waiting for lock (blocked)

•

Holding the object (locking)

The operating system program is either:

•

Waiting for lock (blocked)

•

Holding the object (locking)

The session serial number is either:

•

Waiting for lock (blocked).

•

Holding the object (locking).

The blocked session’s system ID (SID)

Locks Tree RAC

The Locks Tree RAC collection provides lock tree information at the global level.

Collection Type

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	20 seconds

Metric Descriptions

The SQL statement waiting for lock release

Blocking Serial

The session serial number is either:

•

Waiting for lock (blocked).

•

Holding the object (locking).

The session identifier for the session is holding the object (locking).

The name of the host where the instance is running

The lock is between different cluster nodes for global locks.

The Oracle user (locking/blocked) that is either:

•

Waiting for lock (blocked).

•

Holding the object (locking).

The host where that the Oracle instance is installed is either:

•

Waiting for lock (blocked).

•

Holding the object (locking).

The instance name of the session in the lock tree

The wait length of time, in seconds.

The wait event on which the blocked session is waiting

The lock mode in which the session holds the lock.

Lock Request Mode

The lock mode in which the process requests the lock.

The type of user or system lock.

The object requested for lock.

The OS user name that the session logged in with is either:

•

Waiting for lock (blocked).

•

Holding the object (locking).

In multitenant architectures, the name of the pluggable database.

The operating system process ID for the Oracle server process. The process ID is either:

•

Waiting for lock (blocked).

•

Holding the object (locking).

The operating system program name is either:

•

Waiting for lock (blocked).

•

Holding the object (locking)

The blocked session’s system ID (SID)

Long Running Session

The Long Running Session collection collects long-running query that runs more than specific time.

Collection Type

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
Session ID	Session identifier
Serial Number	Session serial number
SQL ID	SQL ID
Container ID	Container Name
Elapsed Time	Elapsed time in seconds since the session has become active.
Oracle User Name	Oracle user name
OS User	Operating system client user name
Program	Operating system program name
Machine	Operating system machine name
Module	Name of the currently executing module
CPU Time	Amount of CPU time (in 10s of milliseconds) used by a session from the time a user call starts until it ends.
SQL Text	SQL Text

OS and Instance Statistics

The OS and Instance Statistics collection provides the following data:

•

CPU and memory information about the operating system

•

CPU and memory-related information about the operating system and the monitored instance.

Collection Type

Collection Sampling Settings


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

Metric Descriptions

ASM Buffer Cache Size

The amount of memory allocated to the ASM buffer cache.

Indicates whether the database is configured in manual or automatic memory management mode.

Average Connected Sessions

Total number of current logons.

Balance System CPU Utilization

The extent (displayed as a percentage) to which system CPU utilization is balanced across RAC nodes.

Buffer Cache Size

The amount of memory currently allocated to the buffer cache. The buffer cache, which is used for caching frequently accessed data blocks, is normally the largest memory cache used by Oracle.

Bytes received via SQL*Net from dblink

Total number of bytes received from a database link over Oracle Net Services.

Bytes sent via SQL*Net to client

Total number of bytes sent to the client from the foreground processes.

Bytes sent via SQL*Net to dblink

Total number of bytes sent over a database link.

Measures the workload being placed on the instance from all work sources.

Current SGA Size

The actual size currently allocated to the System Global Area (SGA) memory.

Cursor Authentications

Number of privilege checks conducted during execution of an operation.

Data Dictionary Cache Hit Ratio

The data dictionary cache hit ratio is used for measuring the ratio of dictionary hits to misses. The data dictionary cache is used for holding rows from the internal Oracle metadata tables, including SQL stored in packages.

Default 16K Buffer Cache Size

The default space allocated within the buffer cache to 16k-size data blocks.

Default 2K Buffer Cache Size

The default space allocated within the buffer cache to 2k-size data blocks.

Default 32K Buffer Cache Size

The default space allocated within the buffer cache to 32k-size data blocks.

Default 4K Buffer Cache Size

The default space allocated within the buffer cache to 4k-size data blocks.

Default 8K Buffer Cache Size

The default space allocated within the buffer cache to 8k-size data blocks.

Default Buffer Cache Size

Size in MB of default cache area of SGA that cache blocks of data and indexes that are not assigned to specific buffer pools.

Number of statements executed during the specified time range.

The fixed part of the SGA is an internal area set by Oracle, which cannot be manually modified.

This area contains the following data:

•

General information about the state of the database and the instance that needs to be accessed by background processes

•

Information communicated between processes

Flash Cache Insert Skip: DBWR Overloaded

The number of writes to the flash cache that were skipped (insert skip) as a result of an overloaded DBWR, which has exceeded a predefined threshold.

Flash Cache Read Hit Ratio

The percentage of read requests that were resolved from Flash Cache, out of the total of physical read total IO requests.

Flash Cache Read Hits

The number of read requests, resolved from Flash Cache.

Amount of free RAM in the system.

The percentage of free memory out of the total amount of memory allocated to SGA.

The size (in megabytes) of free memory out of the total amount of memory allocated to SGA.

Hard Parse Ratio

The ratio of hard parse calls (real parses) to total parses.

The amount of CPU time used by a session from the time a user call starts until it ends.

Instance CPU Load

The amount of time the instance was using CPU within the total elapsed time (as a percentage).

Instance RAM Percentage

Total memory, in percentage, allocated to the instance out of the total RAM.

Java Pool Free Pct

The amount of free space in the Java pool, expressed as a percentage of the Java pool’s total size.

Java Pool Free Size

The amount (in megabytes) of free space in the Java pool.

The size of the Java pool, which caches class definition, Java methods, and Java objects. An improperly sized Java pool can affect the parse rate.

Java Pool Used Size

The amount (in megabytes) of used space in the Java pool.

Keep Pool Cache Size

The size of the Keep buffer pool. This pool contains frequently accessed segments in the buffer cache.

Large Pool Free Pct

The amount of free space in the Java pool, expressed as a percentage of the large pool’s total size.

Large Pool Free Size

The amount (in megabytes) of free space in the large pool.

Large Pool Size

The size of the Large pool. This pool is used in multi-threaded servers (MTS) for session memory, parallel execution, and backup processes.

Large Pool Used Percent

The percentage of used space in the large pool.

Large Pool Used Size

The amount (in megabytes) of used space in the large pool.

Library Cache Hit Ratio

The effectiveness of the library cache, computed by comparing the number of queries submitted to Oracle server for execution, which found the parsed execution plan in the library cache (soft parsing), with the entire number of queries submitted during the specified time range (including queries that required the parsing of a new statement, also known as “hard parsing”).

Logons Cumulative

The total number of current logons.

Logons per Second

The average number of logons per second for the specified time range.

Maximum Memory Size

The maximum size (in megabytes) of memory that can be allocated to an Oracle instance.

Maximum SGA Size

The maximum defined size of the System Global Area (SGA) memory.

The amount of memory consumed by all OS processes (including Oracle).

Memory Utilization

The relative share, in percents, of memory consumed by all OS processes (including Oracle) out of the total memory.

Messages Received

Number of messages sent and received between background processes.

Opened Cursors Cumulative

Total number of cursors opened since the instance started.

Opened Cursors Current

Total number of currently open cursors.

Oracle/System CPU Usage

The amount of CPU consumed by the entire system, broken down into monitored instance activity and all other activities

Parse count (hard)

The number of times an SQL statement has undergone a hard parsing process, which requires reloading the SQL statement to the shared pool, along with the associated RAM memory allocation.

Parse count (total)

Total number of parse calls (hard and soft).

In multitenant architectures, the name of the pluggable database

PGA Currently Allocated

The amount of Program Global Area (PGA) memory allocated for the current session.

Physical Read Total IO Requests

The total number of I/O requests due to physical reads.

Potential SGA Growth

The amount (in megabytes) by which the SGA memory has increased during the specified time range.

Recursive Calls

Number of recursive calls generated at both the user and system level.

Recycle Pool Cache Size

The amount of memory currently allocated to the Recycle buffer pool. This pool contains blocks belonging to segments that are not frequently accessed.

Redo Buffers Cache Size

The size of the redo buffer, which contains redo entries that must be written to the redo log. A properly sized redo buffer improves performance by minimizing the time waiting for writes to the log file to complete.

Result Cache Find/Create Ratio

The result cache find/create ratio is used for measuring the ratio of result cache hits to misses.

The Result Cache is an area within the shared pool, which contains the end results of a query execution. Failure to find these end results, that is: a result cache miss, leads to creation operation.

Low values of this metric indicate that the contents of the result cache are being inefficiently used.

Result Cache Max Size

The maximum size (in megabytes) of memory allocated to the result cache.

Session Cursor Cache Count

Total number of cursors cached. This statistic is incremented only if SESSION_CACHED_CURSORS > 0.

Session Cursor Cache Hits

Number of hits in the session cursor cache. A hit means that the SQL statement did not have to be re-parsed.

Shared Pool Free Pct

The amount of free space in the shared pool, expressed as a percentage of the shared pool’s total size.

Shared Pool Free Size

The amount (in megabytes) of free space in the shared pool.

Shared Pool Size

The size of the shared pool. The shared pool caches SQL statements, PL/SQL programs, object definitions and session memory for MTS sessions. Performance can improve when the shared pool is sized properly, thereby avoiding reparsing and reloading.

Shared Pool Used Percent

The amount of used space in the shared pool, expressed as a percentage of the shared pool’s total size.

Shared Pool Used Size

The amount (in megabytes) of used space in the shared pool.

SQL*Net roundtrips to/from client

Total number of Net8 messages sent to and received from the client

SQL*Net roundtrips to/from dblink

Total number of Net8 messages sent and received over a database link.

Stream Pool Size

The size (in megabytes) of the stream pool area (the area that caches Oracle Streams objects) within the SGA.

System CPU Utilization

The overall operating system CPU usage, including Oracle.

System Kernel CPU Utilization

Percentage of CPU time consumed by the operating system's processes (kernel mode activities).

System User CPU Utilization

Percentage of CPU time consumed by the operating system's processes (user mode activities).

Target Memory Size

The size (in megabytes) required for optimal memory utilization by the monitored Oracle instance. When this parameter, which was introduced in Oracle 11g, is set, Oracle automatically tunes memory allocation by resizing the SGA and PGA as needed.

Target SGA Size

Specifies the total size (in megabytes) of all SGA components. Specifying the SGA_TARGET results in automatic sizing of the following memory pools:

•

•

•

•

•

The number of transactions running.

Used RAM Pct Rate

The overall utilization of RAM by all processes, including Oracle.

The amount of used space in the SGA memory, expressed as a percentage of the SGA memory’s total size.

Total size of the currently used SGA memory.

Number of user calls such as login, parse, fetch, or execute. This metric value represents the rate at which the user application addresses Oracle.

User Calls Per Parse

The average number of calls in relation to statement parses. Changes in this rate most likely result from application change, but may also indicate that usage patterns are changing and users are moving from one module to another, either more or less frequently.

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 and they must be written to disk.

User Rollback Ratio

The percentage of rolled back transactions, that is: transactions for which the ROLLBACK statement was issued, either manually or as a result of an error that occurred during the transaction.

Number of transactions that were rolled back. Rollbacks occur either because of a manually issuing a ROLLBACK command or in the event of an error.

Variable Others Size

The size of variable portion of SGA excluding shared pool, large pool and java pool.

The variable portion of SGA, which contains shared pool, large pool and java pool.

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