Search

Top 60 Oracle Blogs

Recent comments

December 2013

OSP #2c: Build a Standard Platform from the Bottom-Up

This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.

OSP #2c: Build a Standard Platform from the Bottom-Up

This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.

OSP #2c: Build a Standard Platform from the Bottom-Up

This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.

New Version Of XPLAN_ASH Utility

A new version of the XPLAN_ASH tool (detailed analysis of a single SQL statement execution) is available for download. The previous post includes links to video tutorials explaining what the tool is about.

As usual the latest version can be downloaded here.

The new version comes with numerous improvements and new features. The most important ones are:

  • Real-Time SQL Monitoring info included
  • Complete coverage including recursive SQL
  • Improved performance
  • 12c compatible
  • Simplified usage

UKOUG Tech13 : Monday

I’ve mentioned a couple of times before, I’m only attending Monday of UKOUG Tech13. One of my colleagues quit, so there is no DBA at work today while I’m out on a jolly. :)

My session was at 09:00, which meant getting up at 05:00 to get the train to Manchester. While I was on the train I did a final run-through of my presentation and surfed the net on the train WiFi. I left the house in the dark. It was still dark by the time I got to Manchester. The winter is so depressing!

Missing UKOUG Tech13 — But Still in Manchester at OakTable World UK 2013

class="l-submain">
class="l-submain-h g-html i-cf">

This is the first year since 2006 that I don’t present or attend the UKOUG Technology annual conference. Sad, but I had to withdraw because I didn’t believe UKOUG had been making the right choices in the past little while. The trigger was the introduction of the limit of six presentations per company to present at the conference. I believe this doesn’t really serve the conference, attendees or my company well (which I’m so passionate about,) nor my colleagues that I’m so proud to work with.

Rowids

I have, in the past, used the dbms_rowid package to create rowids from block addresses (typically faking the first and last rowids that could appear in an extent); but I’ve just been sent a piece of information by Valentin Nikotin that’s going to make me go back and check whether what I’ve done with the package will always give me the correct results. Here’s a little demonstration code that highlights the issue: