Chat now with support
Chat mit Support

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

•
Name — the name of the pluggable database
•
Open mode — the pluggable database’s state; the possible values are: mount, read-write, read-only, and migrate
•
Created on — the day on which the pluggable database was created
•
Cloned from — if this pluggable database was cloned, the name of the originating pluggable database
•
Availability — displays the selected pluggable database’s availability within the selected time range
•
Storage — displays the pluggable database's storage compared with the storage of the entire instance or RAC
•
Workload — displays the pluggable database’s workload during the specified time range
•
Workload Across Cluster — if the selected pluggable database is part of a RAC, displays the balance between the various pluggable databases within the RAC

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:

•
Workload-related Metrics — displays a list of metrics for the pluggable database
•
Workload — displays the pluggable database’s workload compared with the workload of the entire instance or RAC
•
Selected metric — displays the activity of the metric selected in the Metric table, compared with the workload of the entire instance or RAC

Storage Drilldown

Storage Drilldown

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

•
Tablespaces and Datafiles Panel — for details, see Tablespaces and Datafiles Panel .
•
Redo Logs — for details, see Redo Logs Panel .
•
Fast Recovery Area — for details, see Fast Recovery Area Panel .
•
Archive Logs — for details, see Archive Logs Panel .
* 
IMPORTANT: The layout of the panels mentioned above is common for both a RAC and database instance.
•
Invalid Objects — for details, see Invalid Objects Panel .
•
Database Backup — for details, see Database Backup Panel .

Tablespaces and Datafiles Panel

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

•
Tablespaces page — displayed by default. When switching to other sections of this panel, accessible by clicking the link View all tablespaces on the upper right side of the screen. For details, see Tablespaces page .
•
Datafiles grid — accessed by clicking the link View all datafiles on the upper right side of the screen. For details, see Datafiles Grid .
•
Tablespace-Specific page — accessed by clicking the name of the requested tablespace on the Tablespaces Summary table. For details, see Tablespace-specific page .
•
Datafile-Specific page — accessed in either of the following methods:
•
Clicking the name of the requested datafile from the Tablespace Details > Datafiles pane, under the tablespace-specific page (see Tablespace Details Section ).
•
Clicking the name of the requested datafile from the Datafiles grid.
For details, see Datafile-specific Page .
Tablespaces page

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

* 
IMPORTANT: By default, all types of tablespaces are monitored. To exclude specific types of tablespaces from monitoring, see Tablespaces Summary Table .

The Tablespaces page contains the following components:

•
Top 10 Tablespaces chart — a representation of the sizes of the tablespaces that have the highest used value, displayed according to the selected sort method. For details, see Top 10 Tablespaces Chart .
•
Tablespaces Summary table — a full list of the tablespaces, with general parameters and individual alarms. For details, see Tablespaces Summary Table .
 
 
Top 10 Tablespaces Chart

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

•
Size
•
Percentage of space usage
 
Table 13. Top 10 Tablespaces Chart
Name
Description

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 .

Tablespaces Summary Table

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

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

 
Table 14. Tablespaces Summary Table
Name
Description

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:

•
PERMANENT
•
TEMPORARY
•
UNDO

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 .

Datafiles Grid

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

 
 
Table 15. Datafiles Grid
Name
Description

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.

Tablespace-specific page

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:

•
Tablespace Properties section — for details, see Tablespace Properties Section .
•
Tablespace Properties alarms — for details, see Tablespace Properties Alarms .
•
Tablespace Properties table — for details, see Tablespace Properties Table .
•
Space Utilization chart — for details, see Space Utilization chart .
•
Tablespace Details section — for details, see Tablespace Details Section .
•
Datafiles table — for details, see Datafiles Table .
•
All Metrics table — for details, see All Metrics Table .
•
Extent map — for details, see .
Tablespace Properties Section

The tablespace properties are provided using the following panes:

•
Tablespace properties alarms
•
Tablespace properties table
Tablespace Properties Alarms
 
Table 16. Tablespace Properties Alarms
Name
Description

Alarms

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

For further details, see DB Alarms .

Tablespace Properties Table
 
Table 17. Tablespace Properties Alarms
Name
Description

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:

•
DICTIONARY — within the Oracle data dictionary
•
LOCAL — within the tablespace itself

Allocation Type

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

•
USER — allocates extents as per the storage clause provided with the object or defaulted at tablespace level.
•
UNIFORM — allocates the uniform sizes for the extents.
•
SYSTEM — automatically allocates system-generated extent sizes.

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.

•
MANUAL — using free lists
•
AUTOMATIC — using bitmaps

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.

•
NOT APPLY — used for tablespaces other than the undo tablespace.
•
GUARANTEE — applies only to undo tablespaces.
•
NOGUARANTEE — applies only to undo tablespaces.

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

Space Utilization chart
 
Table 18. Space Utilization chart
Name
Description

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.

Tablespace Details Section

The tablespace details are provided using the following panes:

•
Datafiles table
•
All Metrics table — for details, see All Metrics Table .
Datafiles Table
 
Table 19. Datafiles Table
Name
Description

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.

All Metrics Table

This table provides the following information for tablespace metrics.

•
Metric — the metric name; can have one of the values listed in the table below.
•
Value — current value
 
Table 20. All Metrics Table
Metric Name
Description

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

Datafile-specific Page

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.

•
Datafile Properties
•
Space Usage — for details, see Space Usage .
•
Fragmentation — for details, see Fragmentation .
Datafile Properties
 
 
Name
Description

Alarms

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

 
Table 21. Datafile Properties
Property Label
Property Description

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:

•
AVAILABLE
•
INVALID

Autoextend

Indicates whether the datafile is auto-extensible.

Space Usage

Details are provided for:

•
File Space Usage
•
Filesystem Space Usage
* 
NOTE: For datafiles managed by ASM, the filesystem space usage cylinder is available only if the ASM instance is installed and configured. For autoextensible datafiles, the file space usage cylinder is not available.
 
Table 22. Space Usage
Name
Description

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.

Fragmentation

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

* 
CAUTION: Fragmentation analysis is a resource-consuming operation. Carrying out this operation is strongly discouraged in production environment with heavy resource contention.
 
Table 23. Fragmentation
Name
Description

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.

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen