Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

Latch Tuning Progress Page

When you click Start Optimizing to find the optimum value for SPIN_COUNT, this page tracks the progress of the attempt.

To open the Latch Tuning Progress Page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click Tuning | Latch Page | Latch Tuning Progress.

Controls on the Latch Tuning Progress Page

Control Description
Latch Tuning Progress Information Tracks the progress of the optimization attempt.

Current Spin Count

The current value of the SPIN_COUNT parameter.

Start optimizing

Start the optimization by opening the Latch Tuning Configuration Dialog.


During optimization, you can cancel the process when you reach an acceptable value for SPIN_COUNT.

Cancel and Restore

Cancel the optimization process right now and restore SPIN_COUNT to its original value.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating