How to avoid a salted banana! (SQL tuning)‏

Dear NoCOUG members and friends,

You’re going to enjoy the new issue of the NoCOUG Journal. Click here to download it.

• Lothar Flatz talks about the biggest issue in SQL tuning: the “salted banana.” We predict that the phrase “salted banana” will become as widely known in the Oracle community as “compulsive tuning disorder.” Click here to go directly to Lothar’s article.
• Janis Griffin—a.k.a. the Looney Tuner—explains why the Oracle Database 12c “adaptive optimizer” is the best thing since sliced bread. The Oracle Database 12c query optimizer makes all previous versions of the query optimizer—and the query optimizers of Oracle competitors—seem primitive and foolish in comparison. All previous versions of the query optimizer stick to the plan, even when it is painfully, painfully obvious—after a few records have been retrieved—that the plan is terribly, terribly wrong. But why stick to a full table scan or an index scan if it becomes painfully, painfully obvious—after a few records have been retrieved—that there has been a terrible, terrible miscalculation and that the current plan is terribly, terribly wrong and should be abandoned, even though query execution has already started. If you were looking for a reason to upgrade to Oracle Database 12c, the adaptive optimizer is it. Click here to go directly to Janis’s article.
• Guy Harrison talks up the five biggest trends in database technology. If you read his article, you will be able to respond intelligently when your CIO or enterprise architect asks you for your opinion. Click here to go directly to Guy’s article.
• Iggy Fernandez explains why he doesn’t have a huge problem with the NoSQL fad. According to him, the NoSQL architecture is entirely compatible with the relational model and he points out that RDBMS vendors have already started incorporating these features into their products. Click here to go directly to Iggy’s article.
• Kyle Hailey provides a detailed explanation of the hottest topic in IT: thin provisioning of the entire tech stack—database as well as application. Business is dependent upon IT to deliver required applications and services but these applications and services are dependent upon timely, high-quality refreshes. Using thin provisioning, IT can deliver results faster, quicker, and cheaper. Click here to go directly to Kyle’s article.

Download the latest issue of the NoCOUG Journal.

Renew your 2015 NoCOUG membership.

Register for the winter conference on January 27 featuring Tom Kyte (the patron saint of SQL), Steven Feuerstein (the patron saint of PL/SQL), and Doug Cutting (the patron saint of Hadoop).

Win a free membership for yourself and three friends by correctly identifying the colorful objects on the front cover of the NoCOUG Journal and where the picture was taken.

Forward this message to your colleagues.

Kindest regards,

The volunteers and board members of the longest running and most active Oracle users group in the world