Chat now with support
Chat with Support

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

Viewing Datafiles I/O Activity at the Instance Level

The Overall Datafiles I/O Activity panel displays the I/O activity of all datafiles on the instance. This panel includes the following sections:

•
Total Physical I/O Chart
•
Datafiles I/O Summary Table
Total Physical I/O Chart

The Total physical I/O chart provides a graphic representation of the physical I/O activity within the instance’s datafiles. This representation is displayed in either of the following methods:

•
Baseline — displays the total physical I/O activity, including both physical reads and writes.
•
Breakdown — displays the physical activity, divided by physical reads and physical writes.
Datafiles I/O Summary Table

The Datafiles I/O Summary table displays all of the I/O activity details of all datafiles on the instance. Clicking the datafile’s name displays the Physical I/O Activity page, which presents the datafile’s physical read and writes, plotted over the selected time range, along with the instance physical reads and writes. In multi-tenant architectures, the PDB column identifies the pluggable databases that use the datafiles.

* 
IMPORTANT: To view the specific datafile’s storage data, click the link Datafile Storage, on the upper right side of the Physical I/O Activity page. For details, see Datafile-specific Page .

Viewing User-Defined Collections

Use the User-defined Collections panel to see customized collections, which were created using the User-defined Collections view in the Databases Administration dashboard, either during the most recent sample (Last Sample) or plotted over the specified time range (Selected Period).

* 
IMPORTANT: The User-defined Collections panel is used only for displaying the user-defined collections; any creation or management operation of these collections is carried out using the User-defined Collections view in the Databases Administration dashboard, at the whole cluster or single instance levels only (not from within a RAC node). For details, see Configuring User-defined Collections .

This panel comprises the following sections:

•
The Collections column, on the left of the panel — displays all of the names of the existing user-defined collections.
•
SQL text grid — displays the text of the user-defined SQL query.
By default, this grid displays the query’s short text. To display the query’s full text, click View full text (a toggle).
•
The collection details table — displays all of the fields contained in the query.
Each of the table’s columns shows the field’s display name, while each row represents the records taken at each sample.

Pluggable Databases Drilldown

The Pluggable Databases drilldown contains the Pluggable Databases pane, which displays a table of all pluggable databases (PDB), as well as the container databases (CDB), which are monitored in the instance. For details, see Pluggable Databases List table .

Selecting a row in the table displays the details of the selected container in the following panes:

•
Overview — shows general details about the selected database, such as name, availability, and workload. For details, see Overview tab .
•
Activity within Instance/RAC — shows the activity of the instance as part of the overall instance or RAC activity. For details, see Activity within Instance/Cluster tab .

Pluggable Databases List table

The Pluggable Databases List table includes the following columns:

•
Sev — indicates the pluggable database maximum severity level
•
Name — the pluggable database name
•
ID — the ID number of the pluggable database
•
Up Since — displays the date and time when the pluggable database was last started
•
Workload (% of Instance) — the percentage the pluggable database’s workload constitutes within the entire instance/RAC
•
CPU (% of Instance) — the percentage the pluggable database’s CPU consumption constitutes within the entire instance/RAC
•
I/O (% of Instance) — the percentage the pluggable database’s I/O activity constitutes within the entire instance/RAC
•
Shares — the portion of the system's CPU resources that is allocated to the selected pluggable database
 
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating