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

Undo Activity

The Undo Activity collection collects UNDO operations-related information.

Oracle

Realtime Collection

600

Online

600

Offline

600

Active UNDO Tablespace

The name of the last active undo tablespace of the last period when undo statistics were collected (by default: every 10 minutes)

Begin Time

The beginning of the last period when undo statistics were collected

End Time

The end of the last period when undo statistics were collected

Expired Blocks Removed

Number of expired undo blocks stolen from other undo segments

Expired Blocks Reused

Number of expired undo blocks reused within the same undo segments

Expired Blocks Steals

Number of attempts to steal expired undo blocks from other undo segments

Highest Concurrently TNXs

The highest number of transactions executed concurrently within the specified time range

Longest Query

The length, in seconds, of the longest query executed in the instance during the specified time range

Longest Query SQL ID

SQL identifier of the longest running SQL statement within the specified time range

No Space Error Count

The number of times requests for space in the undo tablespace failed to find any free space available

SnapShot Too Old Error Count

The number of times the error ORA-01555 (snapshot too old) occurred

Transactions

The total number of transactions executed within the specified time range

Unexpired Blocks Removed

Number of unexpired blocks removed from certain undo segments so they can be used by other transactions

Unexpired Blocks Reused

Number of unexpired undo blocks reused by transactions

Unexpired Blocks Steals

Number of attempts to obtain undo space by stealing unexpired extents from other transactions

Used Blocks

The total number of undo blocks consumed

Total Summary

The Total Summary collection collects UNDO definitions, storage and retention.

Oracle

Realtime Collection

600

Online

600

Offline

600

Active Undo Tablespace

Name of the last active undo tablespace

Actual Undo Size

The size (in megabytes) of the undo tablespace

Autoextensible

Indicates whether the datafile is autoextensible

Current Retention

Specifies (in seconds) the low threshold value of undo retention

Minimum Required Undo Size

The minimum size (in megabytes) of undo space required. This value takes into account transactions rate, undo generation rate and current undo retention.

Optimal Retention

The optimal undo retention, taking into account undo generation rate and actual undo size

Retention Guarantee

Indicates the state of the Undo tablespace retention (GUARANTEE/NOGUARANTEE)

Retention value of GUARANTEE indicates that unexpired undo, in all undo segments in the undo tablespace, should be retained even at the cost of failure of forward-going operations that need to generate undo in those segments.

Transactions Count

The rate of transaction executed within the specified time range

Undo Generated Volume

The rate per second (in megabytes) of undo generated within the specified time range

Undo Management

Indicates whether undo management is automatic or manual

Usability

The Usability collection provides retrieved instance usability based on response time and instance availability.

Oracle

Realtime Collection

60

Online

60

Offline

300

Availability

The percentage of time, within the selected time range, during which the database was available:

Connect Availability

The percentage of time, within the selected time range, during which the connection to the database instance was successful.

Connection Time

The amount of time it takes to establish a connection.

Error Message

Last error message that was received upon trying to connect to the database (if an unsuccessful connection trial took place).

Listener Error Message

The last error message (if any) for each listener

Listener Name

The listener name for each listener

Listener Status

For each listener: the percentage of time, within the selected time range, during which the listener was available.

OS Connect Availability

The percentage of time, within the selected time range, during which the connection to the OS was successful.

OS Error Message

The last error message (if any) received upon an unsuccessful connection trial.

Response Time

The amount of time (in microseconds) used by the active cursor for carrying out parsing/executing/fetching operations

Up Since

The date and time when the instance started

 

Glossary

This section includes a glossary of terms used in this product.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating