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

Posted in: Technical Track

With the rapid advancement in the database technologies, the legacy systems are either being upgraded or replaced. Or, in some cases, technologists are finding ways to support them in new ways, showing us the flexible nature of databases and the belief of professionals that the sky is the limit. For this Log Buffer Edition, we go even beyond.


Why is a full table scan selected? Will the execution plan provide a clue? Charles Hooper answers.

Martin shows us how to use vi-style editing in SQL*Plus.

The Oracle Security guy Pete Finnigan blogs about Oracle, Proxy, Obfuscation, Cookie Law, Talks, and more!

Greg Rahn has a great post about Linux 6 Transparent Huge Pages and Hadoop Workloads.

Dominic Delmolino is impressed with the solutions to his little problem: generating a symmetric Pascal matrix using SQL.

SQL Server:

Pinal Dave writes an insightful follow up of $rowguid and $IDENTITY.

What does the ALLOW_ROW_LOCKS  and ALLOW_PAGE_LOCKS mean on the CREATE INDEX statement ? What is the cost\benefit of  ON|OFF? Is there a performance gain? Jack Vamvas answers.

Kevin Kline is suggesting two TechNet radio sessions you don’t want to miss.

Simple time series calculations, such as comparing sales in the current year with the previous year, are easy to do in DAX and well-documented. Chris Webb has more.


Michael McLaughlin discusses the single wildcard operator with respect to MySQL and Oracle.

This post by Mayank Prasad aims to provide detailed steps to get gprof data for MySQL client and server.

Ronald Speelman demonstrates how to generate meaningful test data using a MySQL function.

Shlomi Noach is blogging about a real-world experience concerning MySQL connections.

Ernie Souhrada is on character sets and disappearing tables.



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 *