Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.7.5.41 - 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) Reviewing Overall Activity Reviewing RAC Historic Activity Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert and Error Logs Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

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.
•
Disk I/O — 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 Client 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.

Viewing Historical Metrics

The History section view is divided into two sections that are correlated to each other:

•
Resource consumption charts — This section displays data in five different charts:
•
Workload chart — Displays the instance resource activity over the selected time frame by emphasizing the resources by colors.
•
Baseline chart — Displays the instance workload compared to the baseline over time.
•
Breakdown chart — Activity of the instance by second.
•
Resource Breakdown Pie chart — Displays the resource breakdown usage by % of the total instance activity.
•
All wait events pop up — Displays details of the wait events that the instance is waiting on during the selected time range.
•
Overview section- Displays a graphical representation of the metrics highlighted in the Workload related Metrics table below.
•
Workload related Metrics - A table that displays a variety of resource consumption metrics which can give an in-depth of the instance activity, each resource holds its default metrics.

Selecting each dimension in the performance tree together with a specific resource effects the data displayed for each Level.

•
For example, by selecting the Lock resource the Instance view dimension will present only locks related data, the SQL Statements dimension will present only the statements that were experiencing locks and DB users the were experiencing locks and so on through all the dimensions and resources.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating