Chat now with support
Chat with Support

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

Dump File

The Dump File collection retrieves the contents of the Oracle dump file.

Oracle

None (on-demand collection).

Dump File Name

The name of the dump file

Message

The dump file message

Event Wait

The Event Wait collection retrieves the instance wait events (workload) that took place within the specified time range.

Oracle

Realtime Collection

20

Online

60

Offline

300

Event ID

The wait event’s ID

Event Name

The wait event’s name

PDB

In multitenant architectures, the name of the pluggable database.

Wait Time

The elapsed time of the selected wait event, plotted over time

Exadata Cell Flashcache

The Exadata Cell Flashcache collection retrieves performance, utilization and usage statistics about the Exadata cell flashcache.

Oracle

Realtime Collection

60

Online

300

Offline

900

Cell ID

The Cell ID, provided by the hardware vendor.

Flashcache hit ratio

The ratio, within the total physical disk requests, of physical disks requests that were resolved from the Flashcache, thereby saving the need to carry out physical disk reads.

Flashcache I/O Errors

The number of IO errors that were encountered on the Flashcache

Flashcache Keep read request misses (Keep Objects)

The number of read IO requests for 'keep' objects that did not find all data in Flashcache and therefore had to perform physical read operations.

Flashcache Keep read requests (Total)

The number of read IO requests for 'keep' objects that were resolved from the Flashcache, thereby saving the need to carry out physical disk reads.

Flashcache read request misses (Total)

The total number of read IO requests that did not find all the requested data in the Flashcache, and therefore had to perform read from disks.

Flashcache read requests (Keep objects)

The number of read IO requests that were resolved from the Flashcache, thereby saving the need to carry out physical disk reads.

Flashcache usage (Keep objects)

The amount of space (number of megabytes) used for 'keep' objects on the Flashcache.

Flashcache usage (total)

The number of megabytes used on the Flashcache.

MB of Flashcache misses

The total amount of data (number of megabytes) read from disks because not all requested data was found in the Flashcache.

MB Pushed out of the Flashcache for Keep objects

The amount (megabytes) of data pushed out of the Flashcache because the space limit for storing 'keep' objects has been exceeded.

MB Pushed out of the Flashcache for Keep objects rate

The rate (megabytes/second) at which data was pushed out of the Flashcache because the space limit for storing 'keep' objects has been exceeded.

MB read from Flashcache

The total amount of data (number of megabytes) from the Flashcache during the specified time range.

MB written to Flashcache

The total amount of data (number of megabytes) written to the Flashcache during the specified time range.

Exadata Cell General

The Exadata Cell General collection retrieves general information and status about the Exadata cell.

Oracle

Realtime Collection

60

Online

300

Offline

900

BMC Type

Name and version of the Baseboard Management Controller (BMC).

Cell ID

The Cell ID, provided by the hardware vendor.

Cell Model

The brand and model of the cell hardware, as provided by the vendor.

Cell Name

The Exadata cell name.

Cell Offload Efficiency

The cell's offload efficiency.

Cell Offload Processing is a procedure used by the oracle database server to push query predicates (that limit data retrieved by the query using filters and join conditions) to the Exadata cell.

Cell Status

The Exadata cell status.

CPUs

The total number of CPU units on the cell.

Interconnects

The total number of network interconnection cards (NICs).

Kernel Version

The host kernel's software version.

OS Version

The Exadata cell's OS version.

Power Supplies (Working/Total)

The total number of power supplies on the Exadata cell, displayed as working/total.

Temperature

The server's temperature (Celsius degrees), as provided by the Baseboard Management Controller (BMC).

Temperature Status

The server's temperature status, as provided by the Baseboard Management Controller (BMC).

Total Fans

The total number of fans on the Exadata cell.

Up Since

Calculates the last cell restart or start time, based on the cell_uptime

Uptime

The time period that has elapsed since the cell was last restarted.

Working Fans

The total number of working fans on the Exadata cell.

Related Documents