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

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
 

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
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating