tag:blogger.com,1999:blog-684183198890094283.post6748578157990797717..comments2023-11-05T06:12:59.718-05:00Comments on S.Lott-Software Architect: Multithreading -- Fear, Uncertainty and DoubtS.Lotthttp://www.blogger.com/profile/06337323642834330176noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-684183198890094283.post-47618244175768355332011-06-07T19:26:30.802-04:002011-06-07T19:26:30.802-04:00Sometimes, even when its a black box, people get t...Sometimes, even when its a black box, people get themselves into trouble. The classic example that I have run into is Oracle parallel execution. Just to show that "its not just me", check out<br /><br />Expert Oracle Database Architecture: 9i and 1…<br />by Thomas Kyte<br />Chapter 14: Parallel Execution<br />Section: When to Use Parallel Execution<br />"Parallel execution is essentially nonscalable solution. It was designed to <br />allow an individual user or a particular SQL statement to consume all resources <br />of a database. If you have a feature that allows an indiividual to make use of <br />everything that is available, and then you allow two individuals to use that <br />feature, you'll have obvious contention issues."Robert Lucentehttps://www.blogger.com/profile/12434992671749777590noreply@blogger.com