Log Buffer #209, A Carnival of the Vanities for DBAs

Posted in: Technical Track

Welcome to Log Buffer, the weekly news update of happenings in the database world.

A big shout out to Pythian team members Andrey, Gwen, Fahd, and Don for their submissions. We have lots of news and recommended reading this week so let’s get going with Log Buffer #209.

Andrey Goryunov’s top picks:

Dion Cho, the Oracle Performance Storyteller, provides an explanation of parallel DML execution plan.

Christian Antognini, recently updated his Edition-Based Redefinition paper about new feature of to specify a default edition at the service level.

Tanel Poder, on Core IT for Geeks and Pros, shares a description and his understanding of ‘asynch descriptor resize’ wait event in Oracle 11gR2.

Gwen Shapira’s faves:

Michael Dinh describes how he solved a tricky grid control issue.

Uwe Hesse, The Oracle Instructor, instructs us about real-time automatic block media recovery with Data Guard in 11gR2. Uwe’s blog is the latest addition to Gwen’s blog roll, as she finds everything he writes is interesting and well explained.

Peter Zaitsev asks you to STOP optimizing your innodb tables, he has a much better way of rearranging them.

Seth Godin doesn’t write about Oracle, but Gwen thinks we all want to know who is the world’s worst boss.

Jonathan Lewis hates ANSI style joins and tells you why. Gwen is ashamed to admit that she find ANSI joins far more readable, but after reading Jonathan’s post, she’ll stay away from them.

Bruce Schneier, the security expert wrote a moving article about the wrong ways to handle big security issues. Not specific to databases at all, but worth reading.

Kevin Closson writes about “enable NUMA support” initialization parameter.

Pythian’s Edwin Sarmiento did an excellent job explaining the basic concepts and terms for disaster recovery planning. Edwin is our resident MSSQL expert, but this post will interest any IT professional.

Marcus Monning wrote to us about Mumbai – his home-made database browser/performance analyzer. Its a pretty impressive tool, especially for a hobby project and Gwen encourages you to check it out. It is difficult to teach an old dog new tricks and at the end of the day, she’s still using SQL*PLUS.

Don Seiler humbly suggests his own blog post from this week on the Oracle upgrade bug. Could be a big time-saver for a lot of folks out there. Post a comment if you agree.

And lastly, we have DB2 news from Fahd Mirza:

Matthias Nicola finds a gem about XML capabilities of DB2, and touches upon DB2 pureXML.

What is production data? Yes, we speak this word hundreds of time weekly at our jobs, but have we ever thought about it? Well, Data and Technology blog slices and dices this question.

SECADM authority is a huge step forward taken by DB2, appreciated by Dave Beulke.

Henrik Loeser uploads an enlightening video about how long it takes to build workload optimized systems.

Neal Fishman discusses the implication of changing a data structure.

That’s it for this week. Thanks for reading!

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

VP Business Development
Vanessa is an experienced business development professional with over 15 years’ experience in all aspects of the business development and marketing disciplines. She brings endless energy, drive, and a results-oriented approach to creating Pythian’s strategic partnerships and business initiatives. In her spare time, Vanessa pursues her passion for great food, wine, and artisan cheeses as an accredited Cheese Sommelier and Cordon Bleu-trained chef. Her weekly Friday afternoon cheese tastings at Pythian’s Ottawa office aren’t to be missed!

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *