There was a very long, detailed and useful discussion about locks on the forum two days ago. A search will find it. It covers all your queries.