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

Posted in: Technical Track

An ideal summer day is when the sun is shining, the warm sunshine refreshes your body, the light breeze becomes naught with your hair, the birds sitting on intoxicated leaves smile at you, and you to top all of that you get the latest hot issue of the Log Buffer. Yes to put cherry on your cake, Log Buffer #227 is here.


David Kurts tells us about applying Hints to Objects inside Database Views.

Jonathan Lewis answers another burning question on on multi-column bitmap indexes and the inability of Oracle to create a bitmap index join when (to the human eye) the strategy was an obvious choice.

A blog post about the mapping of Physical Disk, LUNS, Cell Disks, and Grid Disks in Exadata by lovely Oracle.

Assume that you had a detail table that contained several attributes for each of the unique key values.  How would one go about finding all of the unique key values that share the same set of attributes? Charles Hooper answers.

Randolf Geist gives a short heads-up note regarding a bug that obviously has been introduced with

SQL Server:

Mark Broadbent has posted a tribute to the blogger Jen Stirrup, how has just been recognized by Microsoft by their MVP Award program and become a Most Valuable Professional.

ROW_NUMBER() can be used to generate a sequential number for each row in the result set. Unlike RANK() and DENSE_RANK(), ROW_NUMBER() in case of ties it does not generate same number, it simply ignores the tie and generates sequential numbers for each of the tied rows. Vishal gives an example.

Jason Brimhall is giving a interesting spin in the realm of SQL statistics.

Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next version of SQL Server, codenamed “Denali“. James Serra has an interest overview.

Wes Brown is looking at assembling a basic data dictionary from the column level meta data stored in SQL Server.

Pradeep Adiga sheds light on SavetoSQLServer method error in his blogpost with a story to tell.


Mark Atwood shares his valuable thoughts on node.js and libdrizzle.

Michael “Monty” Widenus blogs about his last MariaDB 5.3 feature before they go beta and that is Progress reporting for ALTER TABLE, LOAD DATA INFILE etc.

In order to optimally size the amount of RAM to allocate to a set of new machines for running MTR, Jonathan Perkin ran a few tests to check the memory usage of an MTR run for mysql-trunk and cluster-7.1.

By far, the most popular way for PDI users to load data into LucidDB is to use the PDI Streaming Loader. Nicholas Goodman has a good blog post about this.

Haidong Ji has presented a comparison of HandlerSocket and mysql client libraries with Python.

Happy Summer !!!



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.

2 Comments. Leave new

Pythian Group: Log Buffer #227, A Carnival of the Vanities for DBAs | Weez.com
July 2, 2011 3:09 pm

[…] to top all of that you get the latest hot issue of the Log Buffer. Yes to put cherry on your cake, Log Buffer #227 is […]

Log Buffers of July | Oracle Administrators Blog - by Aman Sood
January 28, 2012 4:57 am

[…] Log Buffer #227, A Carnival of the Vanities for DBAs […]


Leave a Reply

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