Use Latch Tuning Configuration to specify the settings you want to use while optimizing the value of the SPIN_COUNT parameter to improve the throughput performance of online transactions.
To open the Latch Tuning Configuration Dialog
Click Tuning | Latch Page | Latch Tuning Progress Page.
Controls in the Latch Tuning Configuration Dialog
| Control | Description |
|---|---|
|
Spin Count parameter |
Use Minimum and Maximum controls to enter your start and end values for SPIN_COUNT. Spotlight will begin by using the Min value, and will increase that value at regular intervals until it reaches the Max value. |
|
Optimization Goal |
Use this option to specify which value you want use as a measure of optimum performance:
|
|
Constraint |
Choose this option if you want to use either of the displayed constraints:
|
|
Adjust latch parameters every... |
Use this option to specify how long to run you Oracle system with a current SPIN_COUNT value before increasing the value to the next level. |
|
Cease after... |
Use this option to specify how long to run the optimization process before ending it. |
|
Maximum permitted CPU utilization |
The action of spinning to obtain a latch consumes CPU resources, and the higher the SPIN_COUNT value, the higher the CPU utilization. Use this option to limit the amount of CPU used when spinning. |
|
Confirm before saving changes to parameters. |
When you choose this option, Spotlight will save the optimized value of SPIN_COUNT only after it asks you to confirm the change. |
|
Restore defaults |
Click to change the settings in this page back to their default values |
|
Start |
Click to begin the optimization process. Spotlight will return you to the Latch Page to view the progress of the optimization. |
|
Cancel |
Click to close this dialog without starting the optimization. |
