Chat now with support
Chat with Support

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

Home Page Toolbar

Home Page Toolbar

The Foglight for Oracle Overview dashboard provides the following toolbar buttons.

 
Table 5. Foglight for Oracle Home Page Toolbar
Name
Description
Overview

Opens the Overview view.

Advisories

Opens the Advisories view.

SQL PI

Opens the SQL Performance Investigator (SQL PI) drilldown, which displays performance-related data at the following levels:

•
High-level data — available for all instances.
•
In-depth data, delivered by means of the Cluster view or Instance view tree — available only for instances or RACs that have Performance Analysis installed and configured.
Activity

Opens the Reviewing Instance Usability, which contains the following panels:

•
Real-Time — see Viewing the Foglight for Oracle Real-time Summary Page .
•
Usability — see Reviewing Instance Usability and Reviewing Cluster Usability .
•
Locks — see Reviewing Locks Activity at the Cluster Level and Reviewing Locks Activity at the Instance Level .
•
Sessions — see Viewing Detailed Sessions Data .
•
Overall Datafiles I/O — see Viewing Datafiles I/O Activity at the Cluster Level and Viewing Datafiles I/O Activity at the Instance Level .
•
User-defined Collections — see Viewing User-Defined Collections .
Pluggable Databases

Oracle instance 12C - pluggable only — Opens the Pluggable Databases Drilldown, which contains the following components:

•
Pluggable Databases List table — see Pluggable Databases List table .
•
Overview tab — see Overview tab .
•
Activity within Instance — shows the selected pluggable databases’ activity as part of the entire instance activity. For details, see Activity within Instance/Cluster tab .
Storage

Opens the Storage Drilldown, which contains the following panels:

•
Tablespaces and Datafiles — see Tablespaces and Datafiles Panel .
•
Redo Logs — see Redo Logs Panel .
•
Archive Logs — see Archive Logs Panel .
•
Invalid Objects — see Invalid Objects Panel .
•
Database Backup — see Database Backup Panel .

The Storage panels are common for both RAC and all of the instances.

Configuration

Opens the Configuration drilldown, which contains the panels listed below.

•
SGA — see Reviewing SGA Settings at the RAC Level .
•
Initialization Parameters — see Reviewing the Initialization Parameters .
Alert Log

Opens the Alerts drilldown, which contains the following panels:

•
Error Log — see Reviewing the Alert Log .
•
Alert log — see Reviewing the Alert Log .
Exadata

In RACs that have Exadata configured, opens the Exadata drilldown, which contains the following panels:

•
Summary
•
Performance
•
InfiniBand Topology

Overview view

The upper section of the view includes general information on the monitored instance:

•
Oracle server version
•
Host. For clustered host, the active host is displayed.
•
OS Version
•
Configuration
•
Archive Mode

Each tile is constructed of a title that state the name of the monitored issue and an aggregation of the alarms relevant to that issue.

The tiles are organized by priority:

•
Availability — Shows information and alarms about the availability of the instance. Also includes the monitoring state for that instance.
•
HA/DR — High Availability (HA) and Disaster Recovery (DR) state of the instance. Displays the state of the resources used for availability. For example, Always On, Cluster, Replication, Mirroring, Log Shipping.
•
Storage — Shows the space utilization level for all Data and Log file groups.
•
Infrastructure — Provides general information collected from the server:
•
CPU — Oracle CPU utilization compared to the general host CPU utilization.
•
Memory — Amount of memory Oracle uses compared to other processes and the total memory on the server.
•
Busiest Disk — Utilization of the busiest disk on the monitored server.
•
Operational — Displays the following information:
•
Alarms on failed jobs.
•
Alarms on invalid objects.
•
Alarms on the alert log.
•
Performance — Summarizes general information collected from the SQL PI dashboard. The pie chart displays the average workload divided by resources over time. The graphs display the total workload trend over time.
The Instance Performance tile also displays the following issues:
•
Throughput issues (for example, execution, logons, and transactions per second)
•
Current sessions state (for example, Active, Inactive, and Blocked)

The right panel is used to display either alarms or Top 10 SQLs:

•
Alarms
 
* 
NOTE: Only the three resources would directly be displayed, according to the importance. The state of backup’s alarms is also displayed.
•
Display all active alarms for the underlined instance.
•
Enable sorting by creation time or severity.
•
Top 10 SQLs — Displays the 10 SQLs with the longest duration.

Advisories view

The Advisories view is provided to continually analyze application performance to identify performance inefficiencies, to guide you through problem resolution strategies, and to deliver a step-by-step action plan for maxmizing database performance.

The upper section of the Advisories view includes general information on the monitored instance:

•
Oracle server version
•
Host. For clustered host, the active host is displayed.
•
OS Version
•
Configuration
•
Archive Mode

The lower section of the Advisories view contains the following two elements:

•
Action Plan: Summarizes available advisories that present opportunities to increase the overall performance of your database.
•
Advisories: Lists advisories, action types, and the relevant descriptions. Click each advisory to view detailed analysis results, a complete description of the recommended action to be taken, and the background information of this tuning area.
* 
TIP: Advisories are listed in the order of their priority that considers the severity of the detected deviation and the type of advisory.

SQL Performance Investigator (SQL PI)

The SQL PI view provides the ability to investigate the activity and resource consumption of a selected instance. There are two levels of metrics available:

•
Without SQL PI configured — basic History, lock analysis data, and activity highlights.
•
With SQL PI configured — The ability to perform a more in-depth analysis and investigation of the Instance activity and resource consumption by adding a dimension view of the activity, change tracking analysis, execution plan analysis and compare toll. Performance Tree

The performance tree provides iterative (up to three levels) access to any of the key dimensions associated with Oracle database activity, based on the OLAP multidimensional model and an instance view of the instance activity. Domain nodes offer a hierarchical view of all types of Oracle activity characteristics.

Selecting a dimension from the tree determines what subset of activity is displayed. Iterative drill-down into domains of interest provides increasingly refined focus and diagnosis.

For example, to begin the investigation by first identifying the most active DB User, follow the steps described below:
1
Select the DB Users node, to display the most active database users in the selected time range. That is, the database users who consumed the highest amount of the selected resource.
2
Select the first user, to focus the entire window on that user's activity.
3
Identify the most demanding SQL statement that this specific user has executed, by expanding the user node and then selecting the SQL statement dimension node.
This displays the most active SQL statements executed by this user.
4
Select a specific SQL statement to focus the entire window on the selected statement's activity.
5
Select Machines under the selected SQL Statement, to view the computers on which the statement was run.

In a similar manner, such iterative drilldowns can be carried out into any Oracle dimension of interest, to gain a complete understanding of the causes of its behavior.

The default Oracle dimensions are as follows:

•
SQL Statements — the executed SQL queries
•
PL/SQL Blocks — the blocks that comprise the PL/SQL code used
•
Programs — names of the programs that connected to Oracle and executed the SQL statements
•
OS Users — Operating system users running the client program.
•
DB Users — Oracle login names used for logging in to Oracle.
•
Machines — The machines on which the client executable (connected to Oracle) is running.
•
Actions — the name of the currently executing action, as set by calling the DBMS_ APPLICATION_INFO.SET_ACTION procedure
•
Modules — the name of the currently executing module as set by calling the DBMS_ APPLICATION_INFO.SET_MODULE procedure
•
Client Info — displays the information set by the DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure.
•
Command Types — Executed SQL command type (for example, INSERT and SELECT).
•
Services — displays Oracle's internal services
•
Consumer Groups — displays a collection of users with similar requirements for resource consumption
•
Sessions — Presents the top sessions which consumed the highest active time during the selected time frame.
•
Client PIDs — displays the operating system client process ID.
•
Locked Objects — Displays the objects that experienced locks, the duration of the lock and the type of the lock. The object view can be sorted by selecting a dimension in the performance tree, for example: by selecting a database name only the locked object that occurred on that database will be displayed.
•
Files — displays the Data/Temp files which consumed the highest I/O Wait time during the selected time frame.
•
Disks — displays the disks which were associated with the highest I/O Wait time during the selected time frame.
•
Object I/O — displays the objects (e.g. Tables/Indexes) which were associated with the highest I/O Wait time during the selected time frame.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating