Re: Locking Strategy

On Fri, 01 Jul 2005 12:03:28 +0800, edmond interested us by writing:

> Appreciate if anyone could share their experience. Thx a lot.

My experience - it depends. It depends on the business problem, the database design, the other apps that are interfering, the hardware and memory, and the ability of the developer to actually understand and use SQL. (see O'Reilly - Mastering Oracle SQL for more on this last.)

For me, attempting to apply any single thing as a silver bullet Rule of Thumb (RoT) will eventually turn RoTten and the result will be relegated to myth status.

If you are willing to invest a bit of time and money, there are several good books that show you how to analyze this for your situation - the top of my list being 'Effective Oracle by Design', because it provides both the tools to measure and the explanations about why and how to measure.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***