Chat now with support
Chat with Support

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

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.

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.

Blocking History

The Lock Analysis displays all locks that took place within the selected time range.

The lock analysis feature is integrated as part of the performance tree and it displays all the lock trees including further details for both the blocker and the blocked session including:

•
Lock event start date
•
Session Identifier – [Sid,SERIAL#]
•
Session Identifier of the blocker
•
Locked Object Name
•
Status
•
Lock Duration
•
Program
•
DB User
•
SQL Text
•
Client Machine

Activity Highlights

The Activity Highlights are provided for fast performance analysis and allow users focus on the most significant dimensions that are relevant for the resource selected in the selected time range.

This pane comprises the following elements:

•
Summary — Summarizes the instance consumption time by % of the total instance activity.
•
Activity Highlights table — Displays the activity highlights, resource breakdown usage, and the top wait event that the instance is waiting on within the selected time range.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating