« Accessing Oracle from Powershell | Main | Uploading Oracle data to Google App Engine »

March 01, 2008


Feed You can follow this conversation by subscribing to the comment feed for this post.

Colin Pitrat

Do you have some numbers concerning the sleep / spin ratio with different values of _spin_count you tried ?

The question behind this is, what is a good value for this ratio ? Is it a good idea to increase _spin_count if 1% / 0.5% / 0.1% of misses induce a sleep ?

Guy Harrison

I think every system will be different. The chance that increasing the spin count will increase the hit rate is going to be highly dependent on the type of latch and the workload. My approach when we implemented a solution in Spotlight on Oracle (www.quest.com/spotlight) was to measure wait times and as we adjusted the spin count until we found the spin count that resulted in the least waits and the highest throughput.

buy viagra

i like this part of the blog:"In this case, the optimal value for spin_count was probably about 8000. I did these tests on a variety of systems and workloads, and almost always the default spin_count of 2000 was lower than optimal" is very good

The comments to this entry are closed.