Chatta subito con l'assistenza
Chat con il supporto

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

Total Database Storage

The Total Database Storage collection retrieves the database’s total storage, that is: the summarized value of total free space and total allocated space.

Oracle

Realtime Collection

300

Online

900

Offline

3600

Maximum Used Percent

The maximum percent of the used disk space of all the

database datafiles.

Total Allocated Space

The total size (in megabytes) of allocated space in the database.

Total Allocated Space Delta

The incremental change in the total size of the database’s allocated space during the specified time range.

Total Allocated Space Rate

The rate (in megabytes/seconds) at which disk space was allocated on the database during the last sample.

Total Free Space Percent

The percent of the total free disk space within the database.

Total Instance Waits

The Total Instance Waits collection collects the total amount of time (in seconds) that the instance spent on wait events since the last sample.

Oracle

Realtime Collection

60

Online

300

Offline

900

Total Waits

The total amount of time (in seconds) that the instance spent on wait events since the last sample.

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

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione