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

Posted in: Technical Track

With the weather taking extremes turns, technology is providing the much-needed warmth through the blogs. This Log Buffer Edition is sizzling with few of the hand-picked blog posts in Log Buffer #259.

Oracle:

Love Day has passed but love is still in the air and has been captured by Vanessa in a scintillating post.

Tuning is in the eye of the beholder… Memory is memory right? Glenn Fawcett has a brilliant post.

Temporary tablespaces are shared objects and they are associated to an user or whole database (using default temporary tablespace).  Riyaj sheds light from the RAC angle.

Jonathan Lewis shares an interesting little conundrum about subquery factoring that hasn’t changed in the recent (11.2.0.3) patch for subquery factoring.

Are you finding queries to identify free space, the size of segments or details of extents in your database are very slow? Martin answers.

Nial Litchfield does a fine product review post.

SQL Server:

Thomas LaRock ponders deeply over The Internet, where facts go to die.

Michael Swart expounds over careful hashing. Cryptographic hashing functions like MD5 or SHA-1 are examples of one-way functions.

Kevin Kline informs us that we might be in luck.

Crazy Ballmer’s Database Hut is having the fire sale of the century! Brent Ozar blogs.

So, what is the BI Semantic Model? Chris Webb answers.

MySQL:

Jonas Oreland can’t help to think of austin powers when seeing one billion queries per minute.

Ronald Bradford shares his MySQL security essential presentation.

Andrew Morgan writes down about 1 Billion queries per minute and much more on MySQL Cluster 7.2 GA.

Mikael Ronström talks about scalability enhancements of MySQL Cluster 7.2.

Anders Karlsson thinks that SQL_MODE is useless…

email

Author

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 *