Chat now with support
Chat with Support

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

Filesystem Disk

The Filesystem Disk collection provides storage definitions regarding the filesystem disk where datafiles, dump files or archive files are located.

Operating System

Realtime Collection

20

Online

60

Offline

300

Filesystem size

The size of the filesystem

Filesystem free %

The percentage of the free disk space on the filesystem.

Filesystem Free Space

The amount (in megabytes) of free disk space on the filesystem

Filesystem Name

The name of the filesystem

Filesystem Type

The type of filesystem (datafiles, dump files or mixed files)

Long Term Estimated Till Full

Estimated number of hours until the filesystem is full, based on the long-term growth rate

Long Term Growth Rate

The estimated long-term growth rate of the filesystem

Mounted On

Mount point name.

Operating System

The name of the operating system where this instance runs

Short Term Estimated Till Full

Estimated number of hours until the filesystem is full, based on the short-term growth rate

Short Term Growth Rate

The filesystem’s estimated short-term growth rate

Used

The amount of used disk space on the filesystem

Used %

The percentage of the used disk space on the filesystem

Used Growth

The growth (in megabytes) of used disk space on the filesystem

Flashback Area

If the flash recovery area feature was used for creating a location on disk that enables the database to create various backup and recovery-related files, the Flashback Area collection provides information about this location.

Oracle

Realtime Collection

300

Online

300

Offline

900

File Type

Indicates the types of the files stored on the flashback area:

Non Reclaimable Space Percent

The percentage, within the flashback area, of non-reclaimable space (space currently in use, which cannot be reclaimed).

Number of Files

Indicates the number of files currently stored on the flashback area.

Used Space Percent

The percentage of used space within the entire disk space allocated to the flashback area.

History Locks Tree Instance

The History Locks Tree Instance collection collects snapshots of instance-level locks that reached or exceeded the minimal duration, in seconds, required for collecting the lock. All locks that meet this criterion are displayed in the lower section of the Locks Historical Tree pane.

Oracle

Realtime Collection

60

Online

60

Offline

60

Blocked SQL

The SQL statement that waits for lock release

Blocked SQL Hash

The hash value of the statement waiting for lock

Blocking Serial

Serial number of the locking session

Blocking SID

A SID that holds locks

Client Machine

The name of the computer where the client is running

Cross Instance

Indicates whether the global lock and the locking and blocked sessions are running on different RAC nodes (True) or not (False)

DB User Name

The Oracle database account of the started session

Host

The name of the host where the instance is installed

Instance

Instance name of the session in the lock tree

Lock Duration

The number of seconds the lock is running

Lock Event

The wait event on which the blocked statement is waiting

Lock Mode

The lock mode in which the session holds the lock.

The lock mode can have one of the following values:

Lock Request Mode

The lock mode in which the process requests the lock.

The lock request mode has the same possible values as the lock mode.

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 as follows:

Object Wanted

The object on which the statement is blocked

OS User Name

The operating system user for the Client

PDB

In multitenant architectures, the name of the pluggable database.

PID

The operating system process ID for the Oracle server process

Program

The server program name

Serial

The session’s serial number. The combination of SID and serial number provides a unique identification of the session.

SID

The session identification number

History Locks Tree RAC

The History Locks Tree RAC collection collects snapshot of all locks within the RAC that reached or exceeded the minimal duration, in seconds, required for collecting the lock. All locks that meet this criterion are displayed in the lower section of the Locks Historical Tree pane

Oracle

Realtime Collection

60

Online

60

Offline

60

Blocked SQL

The SQL statement waiting for lock release

Blocked SQL Hash

The hash value of the statement waiting for lock

Blocking Serial

Serial number of the locking session

Blocking SID

A SID that holds locks

Client Machine

The name of the computer where the client is running

Cross Instance

Indicates whether the global lock and the locking and blocked sessions are running on different RAC nodes (True) or not (False)

DB User Name

The Oracle database account of the started session

Host

The name of the host where the instance is installed

Instance

Instance name of the session in the lock tree

Lock Duration

The number of seconds the lock is running

Lock Event

The wait event on which the blocked statement is waiting

Lock Mode

The lock mode in which the session holds the lock.

The lock mode can have one of the following values:

Lock Request Mode

The lock mode in which the process requests the lock.

The lock request mode has the same possible values as the lock mode.

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 as follows:

Object Wanted

The object on which the statement is blocked

OS User Name

The operating system user for the Client

PDB

In multitenant architectures, the name of the pluggable database.

PID

The operating system process ID for the Oracle server process

Program

The server program name

Serial

The session’s serial number, which, in combination with SID, provides a unique identification of the session.

SID

The session identification number

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating