サポートと今すぐチャット
サポートとのチャット

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

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:

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

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

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

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:

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).

The tablespace details are provided using the following panes:

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.

Details are provided for:

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

関連ドキュメント
Foglight for Oracle (Cartridge) - 5.9.4.20
Deployment Guide
Release Notes
User Guide
Showing 1 to 3 of 3 rows

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択