Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.9.5.10 - User Guide

Installing and Configuring Agents Using Foglight for Oracle
Viewing the Databases Dashboard Assigning Instances to Users Selecting an Instance to Monitor Foglight for Oracle Overview Dashboard Overview view Advisories view SQL Performance Investigator (SQL PI) Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert Log Reviewing Monitored Data Guard Environments Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

Locks Tree

Purpose

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

Collection Type

Oracle

Collection Sampling Settings
 
 
Frequency Mode
Collection Interval (Seconds)

Realtime Collection

20

Metric Descriptions
 
 
Metric
Description

Blocked SQL

The SQL statement waiting for lock release.

Blocking Serial

The session serial number is either:

•
Waiting for lock (blocked).
•
Holding the object (locking).

Blocking SID

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

Client Machine

The name of the Client machine

Cross Instance

The lock is between different cluster nodes for global locks.

DB User Name

The Oracle user, which is either:

•
Waiting for lock (blocked)
•
Holding the object (locking)

Host

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

•
Waiting for lock (blocked)
•
Holding the object (locking)

Instance

The Oracle instance session is either:

•
Waiting for lock (blocked).
•
Holding the object (locking).

Lock Duration

The wait length of time, in seconds.

Lock Event

The event on which the blocked session is waiting

Lock Mode

The lock mode in which the session holds the lock

Lock Request Mode

The lock mode in which the process requests the lock

Lock Type

The type of user or system lock.

Object Wanted

The object requested for lock.

OS User Name

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

•
Waiting for lock (blocked).
•
Holding the object (locking).

PDB

In multitenant architectures, the name of the pluggable database.

PID

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

•
Waiting for lock (blocked)
•
Holding the object (locking)

Program

The operating system program is either:

•
Waiting for lock (blocked)
•
Holding the object (locking)

Serial

The session serial number is either:

•
Waiting for lock (blocked).
•
Holding the object (locking).

SID

The blocked session’s system ID (SID)

Locks Tree RAC

Purpose

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

Collection Type

Oracle

Collection Sampling Settings
 
 
Frequency Mode
Collection Interval (Seconds)

Realtime Collection

20 seconds

Metric Descriptions
 
 
Metric
Description

Blocked SQL

The SQL statement waiting for lock release

Blocking Serial

The session serial number is either:

•
Waiting for lock (blocked).
•
Holding the object (locking).

Blocking SID

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

Client Machine

The name of the host where the instance is running

Cross Instance

The lock is between different cluster nodes for global locks.

DB User Name

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

•
Waiting for lock (blocked).
•
Holding the object (locking).

Host

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

•
Waiting for lock (blocked).
•
Holding the object (locking).

Instance

The instance name of the session in the lock tree

Lock Duration

The wait length of time, in seconds.

Lock Event

The wait event on which the blocked session is waiting

Lock Mode

The lock mode in which the session holds the lock.

Lock Request Mode

The lock mode in which the process requests the lock.

Lock Type

The type of user or system lock.

Object Wanted

The object requested for lock.

OS User Name

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

•
Waiting for lock (blocked).
•
Holding the object (locking).

PDB

In multitenant architectures, the name of the pluggable database.

PID

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

•
Waiting for lock (blocked).
•
Holding the object (locking).

Program

The operating system program name is either:

•
Waiting for lock (blocked).
•
Holding the object (locking)

SID

The blocked session’s system ID (SID)

OS and Instance Statistics

Purpose

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

Oracle

Collection Sampling Settings
 
 
Frequency Mode
Collection Interval (Seconds)

Realtime Collection

20 seconds

Online

60 seconds

Offline

300 seconds

Metric Descriptions
 
 
Metric
Description

ASM Buffer Cache Size

The amount of memory allocated to the ASM buffer cache.

Automatic SGA

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.

Calls

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.

Execute Count

Number of statements executed during the specified time range.

Fixed Size

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.

Free Memory

Amount of free RAM in the system.

Free SGA Pct

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

Free SGA Size

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.

Instance CPU

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.

Java pool Size

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.

Memory Usage

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

PDB

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:

•
Buffer cache
•
Shared pool
•
Large pool
•
Java pool
•
Streams pool

Transactions

The number of transactions running.

Used RAM Pct Rate

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

Used SGA Pct

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

Used SGA Size

Total size of the currently used SGA memory.

User Calls

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.

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

User Rollbacks

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.

Variable Size

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

OS File System IO Summary

Purpose

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating