Chat now with support
Chat with Support

Spotlight on Oracle 10.10 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Troubleshooting: Connection Problems

Latches Page

Latches shows latch statistics information for all latches that have ever been used.

To open the Latches page

  1. Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
  2. Click Activity | Latches.

Latch Activity Grid

Shows absolute get, miss, and sleep rates for each latch in the instance.

Column Description

Latch name

The name, or a brief description of, the latch.

Latches

The number of instances of this latch that have ever been used.

Gets/s

The rate at which the latch is obtained.

% Gets

100 * (latch gets for a particular latch) / (total latch gets for all latches)

This value is NOT calculated as a percentage of total gets for a particular latch.

Sleeps/s

The rate at which sleeps occurred when a latch was attempted.

% Sleeps

100 * (latch sleeps for a particular latch) / (total latch sleeps for all latches)

This value is NOT calculated as a percentage of total sleeps for a particular latch.

Sleep rate

( Sleeps * 100 ) / Gets

Misses/s

The rate at which the first try to obtain the latch failed.

% Misses

100 * (latch misses for a particular latch) / (total latch misses for all latches)

This value is NOT calculated as a percentage of total misses for a particular latch.

Miss rate

( Misses * 100 ) / Gets

Latch Category

The category this latch belongs to.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating