Oracle and CMT

Oracle and CMT are often a natural choice. Whenever you have many parallel requests and the latency isn´t a key performance indicator, you should give it a try. But sometimes there are loads, that should scale well on CMT systems but they don´t scale well. In most cases there are some quirks in the SQL statements that makes the code single- or few-threaded. Glenn Fawcett summarized some great tips for Oracle and CMT in a series of blog articles to overcome such problems. (via: Stefan Hinker)