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

Posted in: Technical Track

Log writer process of Oracle is one of the most revered background processes, a real work horse, and a real charming darling that keeps the whole Oracle database system consistent and humming beautifully. Many technologies in Oracle sprout from this good old process. Consistency is the key in database systems as well as in Log Buffers. And yes, the coolest 2012 PASS Summit is also there.


Celine Beck is giving us some cool highlights about Oracle AutoVue Key from OOW12.

Solve the SQL mini-challenge and attend the November 15 NoCOUG conference for free. Iggy Fernandez has more.

Christina McKeon shares some powerful lessons in data from the US presidential elections.

Shivmohan Purohit shows how to find files versions and locations.

Andrejus Baranovskis implemented a one use case where it was required to compare current row status with the data returned by another query (no master-detail relationship).

SQL Server:

Chris Web had a lot of fun using data explorer, and he was pleased and quite surprised. Now he is trying to have a look at its future.

Ryan Adams makes a live blog of the PASS Summit 2012 keynote from day 2.

In SSIS, there are two tasks than can be used to execute SQL statements: Execute T-SQL Statement and Execute SQL. What is the difference between the two? James Serra answers.

One of the most positive experiences Kevin Kline can have, as a former leader of the PASS organization, is when he sees a neophyte become a passionate support and champion for the community.

Welcome to the 2012 PASS Summit. Yep, so you made it.


Being a MySQL DBA is more than just being able to understand the explain command to optimize a query, Keith Larson opines.

MySQL Connector/Net 6.6, a new version of the all-managed .NET driver for MySQL, has been released, informs Reggie Burnet.

VISUAL EXPLAIN will become a standard tool in your DBA toolbox, but you will need later versions of both MySQL Workbench and MySQL Server. Dave Stokes has more.

What is the largest amount of data that you store in MySQL? Peter Zaitsev inquires.

Kristian Köhntopp is wondering: Dude, where is my memory?

Interested in working with Fahd? Schedule a tech call.

About the Author

I am in love with Oracle blogging since 2007. The 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 enabled me to get 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. These days for the last some 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 *