Chat now with support
Chat with Support

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

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.

Tablespaces Storage

The Tablespaces Storage collection provides a list of all tablespaces and their overall properties and storage characteristics.

Oracle

Realtime Collection

3600

Online

3600

Offline

14400

Allocated Space Used Pct

The percent of used allocated space within this tablespace

Allocation Type

The type of extent allocation to be used for this tablespace. The possible values for this metric are as follows:

Auto DF ASM

The number of autoextensible ASM datafiles

Auto DF FS

The number of autoextensible OS datafiles

Average Fragment Size

The average size of fragments in this tablespace

Big File

Indicates whether the tablespace is a BIGFILE tablespace. BIGFILE tablespaces are supported only for locally managed tablespaces with automatic segment-space management.

Block Size

The tablespace blocksize

Contents

The type of tablespace contents is one of the following:

Database

The database name

Default Table Compression

Indicates whether table compression is enabled by default for this tablespace

Encryption

Indicates whether the tablespace data is encrypted.

Estimated Date Until Full

The estimated date when the tablespace becomes full.

Estimated Until Full

The estimated number of days until the tablespace is full.

Extent Management

Indicates the extent management type:

Force Logging

Indicates whether the tablespace is in FORCE LOGGING mode:

Fragments

The number of fragments in this tablespace

Free

The total amount of free space in this tablespace

Free Pct

The percent of free space in this tablespace

Logging

Indicates whether a redo log is to be generated for the tablespace

Long Term Growth Rate

The long term growth rate.

Manual DF ASM

The number of manual ASM datafiles

Manual DF FS

The number of manual operating system datafiles

Max Fragment Size

The size of the largest fragment in this tablespace

Min Fragment Size

The size of the smallest fragment in this tablespace

Number of Datafiles

The number of datafiles in the tablespace

PDB

In multitenant architectures, the name of the pluggable database

Recycle Free Pct

The percentage of recycle bin space which occupies the allocated free space of the tablespace.

Recycle Free

The total amount of space used by the recycle bin within the allocated free space of the tablespace

Retention

Indicates whether unexpired UNDO operations are retained in the tablespace. This applies only to UNDO tablespaces.

Segment Space Management

Indicates the method used for managing free and used segments:

Short Term Growth Rate

The short term growth rate.

Status

The current status of the tablespace.

Tablespace Name

The name of the currently selected tablespace.

Total

The total amount of space in the currently selected tablespace.

Used

The amount (in megabytes) of space used in this tablespace

Used Growth

The amount (in megabytes) by which the size of the tablespace has increased during the specified time range

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating