Chat now with support
Chat mit Support

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

Logical Reads

The number of data blocks read by Oracle, which were already present in the buffer cache, thereby saving input/output read operations.

This value is also referred to as session logical reads and is the total of Current Reads plus Consistent Reads.

Metric

A unit of measurement that can be applied to a database. Metrics can help gauge the performance of a system.

A metric is an individual piece of information that Foglight for Oracle collects about the performance of a system. The information may be a numeric value (a number or percentage), a string of text, or some other piece of data.

Every time the Foglight for Oracle dashboard is refreshed, the cartridge retrieves the latest value of the metric, which can then be displayed in a drilldown or on the home page.

Network Wait

Network wait events occur when a session spends time waiting for messages to be sent or received over the network interface.

Network performance, which is measured in number (per second) of packets sent and received, can be used just like disk statistics to detect overload or non-optimal performance within a network or a network interface. For more information, see SQL *net.

Excessive network wait can result from either:

OLTP

Online Transaction Processing. OLTP allows real-time processing of SQL transactions, in order to support Customer Relationship Management (CRM), ERP, and other time-critical applications. OLTP is characterized by high rates of index lookups, single row modifications, and frequent commits.

Because real-time transaction processing is being increasingly carried out on a network and may include more than one company, OLTP databases use client/server processing and allow transactions to run on different platforms in a network.

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen