Chat now with support
Chat with Support

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

Overview tab

The Overview tab contains the following sections, which display general information about the pluggable database selected in the Pluggable Databases List table:

Activity within Instance/Cluster tab

The Activity within Instance tab contains the following sections, which display information about the pluggable database selected in the Pluggable Databases List table:

Storage Drilldown

The Storage drilldown comprises the panels described in the following topics:

Tablespaces and Datafiles Panel

The Tablespaces and Datafiles panel comprises the sections described in the following topics:

Datafiles grid — accessed by clicking the link View all datafiles on the upper right side of the screen. For details, see Datafiles Grid .
Clicking the name of the requested datafile from the Tablespace Details > Datafiles pane, under the tablespace-specific page (see Tablespace Details Section ).

The Tablespaces page displays the database individual tablespace information, sorted by either percent of space usage or size.

The Tablespaces page contains the following components:

The Top 10 Tablespaces bar chart displays the tablespaces that have the highest used value, sorted by:

Show top

Use the Show top options to select which metric the vertical axis displays for the top 10 tablespaces:

Size — size in megabytes.
% Space Usage — percent.

Percent (chart vertical axis)

The percentage of the database tablespace pages currently being utilized.

Megabytes (chart vertical axis)

The database tablespace utilized size in megabytes.

Tablespaces (chart horizontal axis)

The names of the top 10 most utilized tablespaces.

Tablespace bar

The bar chart representation of the utilized tablespaces.

Click a specific tablespace representation to drill down further to the Tablespace-specific page. For details, see Tablespace-specific page .

The Tablespaces Summary table shows the status for all of the database tablespaces.

To view details on a specific tablespace, click the tablespace.

PDB

In multitenant architectures, identifies the pluggable database that uses the tablespace shown in the Tablespace column.

Tablespace

The name of the tablespace.

Click the tablespace name to drill down further to the Tablespace-specific page. For details, see Tablespace-specific page .

Total Size

The total amount of allocated space (in megabytes) in this tablespace.

% Space Usage

The percentage of used allocated space in this tablespace.

Contents

The type of tablespaces content:

Number of Datafiles

The number of datafiles in the selected tablespace. To view a list of all datafiles of which the tablespace consists, and possibly drill-down to a datafile-specific page, click the tablespace name to access the Tablespace Details > Datafiles pane.

Estimated Until Full

Estimated number of days until tablespace is full.

If the tablespace used space did not grow during the selected period, this field shows the indication no growth.

Autoextensible Datafiles

The sum of the Autoextensible OS Datafiles and Autoextensible ASM Datafiles metrics.

Alarms

The number of warning, critical, and fatal alarms for this Oracle database tablespace.

For further details, see DB Alarms .

The Datafiles grid displays a list, sorted by usage, of all datafiles used by the database.

Table 15. Datafiles Grid

PDB

In multitenant architectures, identifies the pluggable database that uses the datafile shown in the File Name column.

File Name

The file name of the datafile, including the full directory path.

Click the file name to drill down further to the Datafile-specific panel. For details, see Datafile-specific Page .

Tablespace

The name of the tablespace that contains the selected datafile.

Size

The current size of the datafile in megabytes.

Used

The current used megabytes associated to the datafile, as a percentage of datafile’s allocated size.

Autoextend

Indicates whether the datafile is auto-extensible.

The Tablespace-specific page charts used and free space, as well as the fragmentation level of the tablespace (to determine how much space can yet be utilized). The datafiles that make up the individual tablespace appear on the bottom pane of the dashboard.

This page comprises the following sections:

The tablespace properties are provided using the following panes:

Alarms

The number of warning, critical, and fatal alarms for the selected tablespace.

For further details, see DB Alarms .

Status

Indicates the current status of the tablespace — Online or Offline.

PDB

In multitenant architectures, shows the pluggable database that was listed beside the selected tablespace in the Tablespaces Summary table.

Extent Management

Indicates the method used for managing extents in this tablespace:

Allocation Type

The type of extent allocation to be used for this tablespace.

Force Logging

Indicates if the tablespace is in Force Logging mode, which logs all changes to all objects in the tablespace, except changes to temporary segments. The possible values are Yes and No.

Logging

Indicates if a redo log is to be generated for the tablespace.

The possible values are Logging and No.

Segment Space Management

Indicates how free and used segments are managed.

Default Table Compression

Indicates the status of default table compression; either Enabled or Disabled.

Retention

Indicates if unexpired undo blocks are retained in the tablespace.

Big File

Indicates if the tablespace is a BIGFILE tablespace (Yes) or a small file tablespace (No). BIGFILE tablespaces are supported only for locally managed tablespaces with automatic segment-space management.

Block Size

The size of the memory block used by this tablespace in megabytes.

Encrypted

Indicates whether the tablespace data is encrypted (Yes) or not (No).

Total

Total amount of available memory for this tablespace, plotted over time.

Used

Amount of available memory that is used for this tablespace, plotted over time.

The tablespace details are provided using the following panes:

Table 19. Datafiles Table

Datafile name

The datafile name, including the full directory path.

Click the datafile name to drill down further to the Datafile-specific panel. For details, see Datafile-specific Page .

Size

The current size of the datafile in megabytes.

Filesystem Free

Available space on the file system as a percentage of file system size, rounded up to one decimal.

If the filesystem resides on an Automatic Storage Management (ASM) disk, retrieving this information requires having the ASM instance installed and configured.

Alarms

The number of warning, critical, and fatal alarms for this Oracle database tablespace.

This table provides the following information for tablespace metrics.

Total

The total amount of space in the selected tablespace.

Free Space

The total amount of free space in the selected tablespace.

Used

The amount of space used in the selected tablespace.

Allocated Space Used Percentage

The percentage of used space for non auto-extensible files in the selected tablespace.

Free Space Percentage

The percentage of free space.

Minimum Fragment Size

The size of the smallest fragment in the selected tablespace.

Maximum Fragment Size

The size of the largest fragment in the selected tablespace.

Average Fragment Size

The average size of fragments in the selected tablespace.

Recycle Free (MB)

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

Recycle Free (%)

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

Estimated Until Full

Estimated number of days until tablespace is full.

If the tablespace used space did not grow during the selected period, this field shows the indication no growth.

Autoextensible OS Datafiles

Number of autoextensible OS datafiles (DF).

Autoextensible ASM Datafiles

If storage is managed using Automatic Storage Management (ASM), and the ASM instance is installed and configured, displays the number of autoextensible ASM datafiles (DF).

Manual OS Datafiles

Number of manual OS datafiles (DF).

Manual ASM Datafiles

If storage is managed using Automatic Storage Management (ASM), and the ASM instance is installed and configured, displays the number of manual ASM datafiles (DF).

The individual Datafile properties panel displays general properties of the selected datafile, as well as a representation of the used and free space that make up the specific datafile.

The Oracle database datafile-specific panel comprises the sections listed below.

Alarms

The number of warning, critical, and fatal alarms for the selected datafile.

Datafile

The name of the datafile, including the full directory path.

Tablespace

The name of the tablespace to which the datafile belongs.

PDB

In multitenant architectures, the name of the pluggable database.

Size

The size of the datafile in megabytes.

Used

The used size of the datafile in megabytes.

% Used

The percentage of the datafile used.

Status

Indicates whether the datafile is available:

Autoextend

Indicates whether the datafile is auto-extensible.

Details are provided for:

Table 22. Space Usage

Used (percent)

The percentage of the datafile being used.

Used (megabytes)

The number of megabytes being used.

Total (megabytes)

The total number of megabytes available.

Use the Fragmentation section to view the file fragmentation status of used and free extents, using a fragmentation analysis triggered by clicking Analyze Fragmentation.

Table 23. Fragmentation

Fully Usable

The amount of memory that is not being used by a datafile and is viable; represented by the blue portion of the horizontal memory bar.

This bar displays the file fragmentation snapshot of used and free extents.

Partly Usable

The amount of datafile memory that is partly usable; represented by the violet portion of the horizontal memory bar.

Unusable

The amount of tablespace memory that is unusable; represented by the pink portion of the horizontal memory bar.

Used

The amount of tablespace memory that is used; represented by the orange portion of the horizontal memory bar.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating