To improve the processing of online transactions within an Oracle system, you can change the SPIN_COUNT (or _SPIN_COUNT) value that Oracle uses when assigning latches to processes. The value of SPIN_COUNT specifies the number of times that a process actively tries to obtain a latch before it temporarily goes into sleep mode.
You can use the Latch Tuning page to find the optimum value for SPIN_COUNT. Tuning The Value of SPIN_COUNT
To open the Latch Page
Click Tuning | Latch.
Charts on the Latch page
A chart that plots two types of information against time:
A process continues the cycle of spinning and sleeping until it obtains the latch.
A chart that shows the amount of time (in milliseconds) that sessions have spent waiting on various events per second.
It is the same as the Activity | Waits Page | Event Waits chart.
A chart that shows the percentage of time that the CPU spends in the user mode and in the privileged (kernel) mode.
This is the same as the Operating System | OS Performance Page | CPU Utilization chart.
A chart that shows the rate of database calls made to all connected sessions.
It is the same as the Activity | Summary Page | Call Rates chart.