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

Jun 21, 2013 / By Fahd Mirza

Tags: , , ,

Close your eyes and imagine an affordable holiday featuring islands, pools, simmering white sandy beaches, and clubs. Chances are that you’re thinking about a resort in Hawaii, Fiji or French Polynesia. Now picture such a trip right now. I’ll give you a second. Still wondering? Yep, it’s this edition of Log buffer. :)

Oracle:

Bobby has hacked a script together Tuesday night to figure out how to fit all his production data files and temp files on a development server for a RMAN restore of a production backup onto a new server.

SQL Gone Bad – But Plan Not Changed? Kerry has more.

During OOW’12, the ADF BC team announced a new tuning property for ADF BC with DB pooling enabled, coming in the next releases – jbo.ampool.connection_threshold. The main idea is to keep connected JDBC connections until predefined threshold limit is reached. Once limit is reached, ADF BC will be returning least used JDBC connections back to the pool.

Here’s a little quiz by JL: If I take the average row length of the rows in a table, multiply by the number of rows, and convert the result to the equivalent number of blocks, how can the total volume of data in the table be greater than the total number of blocks below the table high water mark ?

Glenn has produced a gem of a script for analyzing the IOPS at the Exadata Cell level.

SQL Server:

Eric Ligman has posted a nice collection of eBooks available in PDF, EPUB and MOBI formats. The books cover Office, Office 365, SharePoint, SQL Server, System Center, Visual Studio, Web Development, Windows, Windows Azure, and Windows Server.

Jes Schultz Borland is stepping outside the comfort zone.

When using table variable, please note that table variable doesn’t support transaction rollback.

The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood, so let’s talk about the basics.

Steve Hughes is exploring Excel 2013 for BI.

MySQL:

Chris Calnder was testing out the latest MySQL 5.6 on Windows (having used the auto-installer) and happened to notice his RAM usage (via Windows Task Manager) was reporting quite a high value.

Ike Walker is executing complex deletes with common_schema.

Johan Andersson is Benchmarking the Performance Impact of Foreign Keys in MySQL Cluster 7.3 GA.

Maybe you experienced some strange behavior with MySQL: Everything is installed correctly and should work. But it does not.

MySQL team has recently attended several conferences and events in EMEA.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>