Oracle Notes

Sharing Oracle technology knowledge and experiences.

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

Posted by sdefilip on August 6, 2010

Welcome to Log Buffer, the weekly roundup of database industry news.  I’m guest hosting this week’s edition, Log Buffer #198[S D1] [S2] , normally published by Pythian.  If you want to host your own version of Log Buffer, reach out to the Log Buffer coordinator.

Lots of good “stuff” out there on the technical blogs this week so here are some interesting ones:

In “Kerry Osborne’s Oracle Blog”, Kerry discusses the use of SQL Profiles

which contain sets of hints.

The memory_target parameter, how it behaves and how it relates to other memory structures, is the topic of Steve Karam’s on his “Oracle Alchemist” blog.

On “Mark Rittman’s Oracle Weblog”, Mark Rittman informs us how we can now add incremental patches to an RPD within OBIEE 11GgR1, through the use of XML patch files.

Scalability and the Oracle conflicts of interest that can be brought about by managing it are illustrated by

Jonathan Lewis on Oracle Scratchpad.

Tanel Poder offers his article on Troubleshooting Exadata V2 Smart Scan Performance in his “Core IT for Geeks and Pros” blog.

In a series of posts on the topic of the SQL Server 2008 Optimiser: Constructing a Plan, Part 1 & Part 2, on the “SQL Server Blogspot on the Web”, Paul White provides detail on how to get SQL code and queries to perform at their best.

Simon Sabin discusses Creating a Unique Constraint on a Column That Allows Nulls on “Simon’s SQL Blog”.

Distributed Transactions and Two-Phase Commit in PostgreSQL is the subject of Joshua Tolley’s informative post on “The Endpoint” blog.

Dimitri Fontaine talks about Querying the Catalog to plan an upgrade, on Planet PostgreSQL.  In more news, PostgreSQL 9.0 beta 4 is out and ready for testing.

On the “MySQL Performance Blog”,  Baron Shwartz cautions Why You Can’t Rely on a Replica for Disaster Recovery.

[S D1]


One Response to “Log Buffer #198, A Carnival of the Vanities for DBAs”

  1. […] to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #198 is generously published by Sam DeFilippis, who manages Oracle Notes blogs, with latest postings on […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: