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

Posted in: Technical Track

The purpose of technology is to make life easier and more quality-oriented. It is this virtue of technology that makes it evergreen and sustainable. Its unique feature is its innovative nature. Technology blogging is a way for the technologists to rant about technology and throw light at known and unknown corners with new angles. This Log Buffer Edition covers those angles and more. Enjoy!


Oracle:

Chris Antongnini blogs about the purpose of COMMIT_WAIT and COMMIT_LOGGING parameters from the real world.

What happens to tablespaces that are read-only on the source during an RMAN duplication (not for standby)? Martin Bach asks.

Charles Hooper takes another view at the failed logon attempts.

According to Dominic Delmolino, there’s convincing and then there’s curiosity.

Karen Morton is not sure about the best practices.

SQL Server:

Chris Shaw tells us what the MVP Award is not.

There are six performance tuning mistakes you don’t want to make, according to Thomas LaRock.

James Serra blogs about SQL Server 2012: multidimensional vs tabular.

Many companies came pretty close to needing to implement their DR plans yesterday, and many of them probably didn’t even realize it.

Jack Vamvas lucidly explains a technical glitch.

MySQL:

Ovais Tariq is discussing join optimizations in MySQL 5.6 and MariaDB 5.5.

How important can a primary key be for MySQL performance?

How should Mondrian get table and column statistics? Julian Hyde asks.

Have you ever wanted to get a list of indexes and their columns for all tables in a MySQL database without having to iterate over SHOW INDEXES FROM ‘[table]‘? Aaron Brown shows a couple of ways.

Frederik Konietzny describes how to setup gitorious on ubuntu server 11.10.

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

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

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