Chatta subito con l'assistenza
Chat con il supporto

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

Redo Log Storage

The Redo Log Storage collection provides a list of all Redo log groups and their overall properties.

Oracle

Realtime Collection

300

Online

900

Offline

3600

Archived

The archive status of the log file:

First change#

A system-allocated number (SCN), identifying the first time a change was recorded in this log.

First Time

The time at which the first SCN in the log was recorded.

Group Status

The status of the group is one of the following:

This information is derived from the v$log table.

Group#

The log group number.

Sequence#

The sequence number.

Size

The size (in megabytes) of the log .

Sessions Summary

The Sessions Summary collection retrieves information regarding session types.

Oracle

Realtime Collection

20

Online

60

Offline

300

Active Sessions

The average number of active sessions during the specified time range

Active Sessions PCT

The average percentage of active sessions within the total sessions during the specified time range

Background Sessions

The average number of background sessions that ran during the specified time range.

Blocked Sessions

The average number of blocked processes that were collected during the specified last sample.

Cached Sessions

The average number of cached sessions during the specified time range

Foreground Sessions

The average number of foreground sessions that ran during the specified time range.

Inactive Sessions

The average number of inactive sessions during the specified time range

Killed Sessions

The average number of killed sessions during the specified time range

PDB

In multitenant architectures, the name of the pluggable database

Sniped Sessions

The average number of sniped sessions during the specified time range

Total Sessions

The average number of sessions during the specified time range

Total Sessions Limit

The maximum allowable number of sessions

Servers

The Servers collection provides instance processes.

Oracle

Realtime Collection

20

Online

60

Offline

300

Dedicated Servers

The number of dedicated server processes. Each dedicated server process service a single client process.

Dispatchers

The number of multi-threaded server (MTS) dispatchers. MTS dispatchers coordinate the allocation of shared servers to client tasks.

Shared Servers

The number of servers that service more than one client process. This value includes both shared servers and multi-threaded servers (MTS).

Tablespaces Free Space Fragmentation

The Tablespaces Free Space Fragmentation collection retrieves information regarding the fragmentation of tablespace free space.

Oracle

None (on-demand collection).

Average Extent Size

The average size of free extents in this tablespace

Extents

The number of free extents in this tablespace

Max Extent Size

The size of the largest free extent in the selected tablespace

Min Extent Size

The size of the smallest free extent in this tablespace

Partly Usable

The total sum of fragments that are smaller than the maximum allocated extent in the tablespace, but bigger than, or equal to, the minimum allocated extent in the tablespace

PDB

In multitenant architectures, the name of the pluggable database

Tablespace Name

The name of the currently selected tablespace

Unusable

Total sum of fragments whose size is less than the size of the minimum extent in the tablespace

Usable

Total sum of fragments that are greater than or equal to the minimum extent in the tablespace.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione