Chat now with support
Chat with Support

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


Extensions to result sets that provide the mechanism for working with individual rows, or a small block of rows, in a table.

Because a cursor points to a currently selected set of records, they can be used by only one connection at a time. However, the compiled plan to which the cursor is linked can be used simultaneously by multiple connections.


Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data.

Using Data Guard’s set of services for creating, maintaining, managing, and monitoring one or more standby databases, enables production Oracle databases to survive disasters and data corruptions. These standby databases are then maintained as transactionally-consistent copies of the production database. If the production database is unavailable due to outage (either planned or unplanned), these copies enable Data Guard to switch any standby database to the production role, thereby minimizing the downtime associated with the outage.


A Dataflow displays the current level of activity. As the rate of data transfer increases, so too does the speed of the flow. If the statistic that the flow represents moves to another threshold, the flow may change color. The combination of movement and color makes it easy to spot congested areas. A graph above the flow shows how the load has varied over time.


A deadlock occurs when two or more session are waiting for data locked by each other, resulting in a situation where all sessions are being blocked.

Oracle automatically detects and resolves deadlocks by rolling back the statement associated with the transaction that detects the deadlock.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating