Top 60 Oracle Blogs

Recent comments

April 2010

quotes from Stockholm ...

I spent an afternoon at the Nobel Museum in Stockholm and found myself writing notes furiously at the very first exhibit. "The mere formulation of a problem is often far more essential than it's solution, which may be merely a matter of mathematical or experimental skill. To raise a new question, new possibilities, to regard old problems from a new angle requires creative imagination and marks

Oracle Plan Stability (Stored Outlines) in PeopleSoft Global Payroll

A longer version of this posting, with experimental results, is available on my website.

In PeopleSoft for the Oracle DBA, I wrote a page (p. 291) explaining why stored outlines were not suitable for use in PeopleSoft.  Five years later, my view has not significantly changed.  Essentially, stored outlines work best with shared SQL, and there isn't much shared SQL in PeopleSoft, because a lot of it is dynamically generated.

RAC Synchonous Alert File Reader

So you have 3 alert files from your 3 node RAC and you are trying to see what happened in the cluster as a whole. The Rac Synchro Reader will let you view the alert files of all 3 nodes side by side, with the timestamps aligned. When you scroll one alert file the others will scroll to a matching timestamp.

Windows executable. Others have found it works with the Listener logfiles, too. Tested for alertfiles from version 9 and 10.

Analyzing a SQL Trace File with SQL Statements

As of Oracle Database 11g the DBMS_SQLTUNE package provides the SELECT_SQL_TRACE function. Its purpose is to load the content of a SQL trace file into a SQL tuning set. But, as it often happens, a feature can be (mis)used for another purpose. The aim of this post is to show how to take advantage of [...]

On the Difficulty of Data Migrations (Especially to NoSQL Databases)

(Originally posted at Pythian Blog)

I’ve been reading a lot of NoSQL blogs recently, and one thing that bothers me is that many of the leading NoSQL bloggers seem to have very different experience in operations that I’ve had.

Here’s an example:
Over at the O’Reilly community blogs, Andy Oram interviewed two MongoDB experts about migrating from a relational databases to MongoDB.

Here’s what the experts said:

Slightly OT - How to Pour A Perfect Beer: Duvel

See video

DW Introduction

Greg Rahn has been writing a short series on “Core Performance Fundamentals of Oracle Data Warehousing”. Here’s his catalogue of the first four or five articles in the series.

New Oracle OakTable Website

Just a short note to say the Oracle OakTable have launched a wonderful new website: Not only does it look great, but among its many features is a latest news section based on blog feeds from fellow OakTable members, new technical articles, clips and videos, latest twitter updates and is simply a great single location to find [...]


New Features, New Defaults, New Side-Effects

11.2 provides a new feature, deferred segment creation, which is the default for Enterprise Edition databases, whilst this feature is rather nice in some restricted circumstances, there are a couple of side effects which may catch the unwary and in some cases make previously valid operations significantly more difficult.