Chat now with support
Chat with Support

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

History Locks Tree RAC

Purpose

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

Collection Type

Oracle

Collection Sampling Settings
 
 
Frequency Mode
Collection Interval (Seconds)

Realtime Collection

60

Online

60

Offline

60

Metric Descriptions
 
 
Metric
Description

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:

•
0 - none
•
1 - null (NULL)
•
2 - row-S (SS)
•
3 - row-X (SX)
•
4 - share (S)
•
5 - S/Row-X (SSX)
•
6 - exclusive (X)

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:

•
TM - DML enqueue
•
TX - Transaction enqueue
•
UL - User supplied

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

Host Properties

Purpose

The Host Properties collection provides operating system version, CPU, memory and network host properties.

Collection Type

Operating System

Collection Sampling Settings
 
 
Frequency Mode
Collection Interval (Seconds)

Realtime Collection

300

Online

900

Offline

86400

Metric Descriptions
 
 
Metric
Description

Machine Model

The model of the host machine (for example: Sun Fire V240)

Number of CPU

The number of CPU units installed on the host

Number of IO Devices

The number of IO devices configured on the host

Number of Network Interfaces

Number of network interfaces installed on the host

Operating System

The name of the operating system installed on the host

Operating System Version

The version of the operating system installed on the host

Physical Hostname

The host name, defined per network interface

RAM

The amount of RAM available on the physical host

Initialization Parameters

Purpose

The Initialization Parameters collection collects definitions and change tracking history of Oracle’s initialization parameters.

Collection Type

Oracle

Collection Sampling Settings
 
 
Frequency Mode
Collection Interval (Seconds)

Realtime Collection

900

Online

900

Offline

3600

Metric Descriptions
 
 
Metric
Description

Current Value

Parameter value for the session (if the value was modified within the session); otherwise, the instance-wide parameter value.

Description

The parameter description

Instance Level

Indicates whether the parameter can have a different value for each instance (TRUE) or must retain the same value for all RAC nodes (FALSE).

Is Default?

Indicates whether the parameter’s value is set to the default value (TRUE) or was modified (FALSE)

Is Deprecated?

Indicates whether the parameter has been deprecated (TRUE) or not (FALSE)

Is Dynamic?

Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)

Is Modified?

Indicates whether the parameter has been modified after instance startup:

•
MODIFIED — the parameter has been modified with ALTER SESSION
•
SYSTEM_MOD — the parameter has been modified with ALTER SYSTEM, thereby modifying all of the currently logged-in session values
•
FALSE — the parameter has not been modified after instance startup

Is System Modifiable?

Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect.

This metric can have one of the following values:

•
IMMEDIATE — the parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used for starting the instance. The change takes effect immediately.
•
DEFERRED — the parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used for starting the instance. The change takes effect in subsequent sessions.
•
FALSE — the parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used for starting the instance. The change takes effect in subsequent instances.

Parameter

Initialization parameter name

PDB

In multitenant architectures, the name of the pluggable database.

Show Hidden Parameters

Indicates whether the parameter is hidden (TRUE) or not (FALSE)

Type

Indicates the parameter type.

The possible values are as follows:

•
Boolean
•
String
•
Integer
•
Parameter file
•
Reserved
•
Big integer

Instance General

Purpose

The Instance General collection collects general instance data such as version and archive logging.

Collection Type

Oracle

Collection Sampling Settings
 
 
Frequency Mode
Collection Interval (Seconds)

Realtime Collection

300

Online

900

Offline

3600

Metric Descriptions
 
 
Metric
Description

DB Version

The database version.

Is Archived

Indicates whether the instance is configured in archive mode.

Is Connected to ASM

Indicates whether the instance is an Automatic Storage Management (ASM) instance.

Is Data Guard Configured

Indicates whether Data Guard is configured on this instance.

Is Exadata

Indicates if this instance is part of Exadata Architecture.

Is Flashback Configured

Indicates whether the flashback recovery is configured.

Is RMAN Configured

Indicates whether RMAN is configured on the database for backup and recovery.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating