I have a 9.2 server that occasionally becomes CPU bound. Disk wait is
nominal and there's no memory pressure. The workload is almost all reads
and the cache hit rate is high.
For some one minute periods, my monitoring shows around 1.5k to 2k access
share locks out of a total of 7.5 to 8k transactions. What's the best
strategy for finding out if that is creating a bottleneck?