Search

Top 60 Oracle Blogs

Recent comments

November 2013

Using Oozie in Kerberized Cluster

In general, most Hadoop ecosystem tools work rather transparently in a kerberized cluster. Most of the time things “just work”. This includes Oozie. Still, when things don’t “just work”, they tend to fail with slightly alarming and highly ambiguous error messages. Here are few tips for using Oozie when your Hadoop cluster is kerberized. Note that this is a client/user guide. I assume you already followed the documentation on how to configure the Oozie server in the kerberized cluster (or you are using Cloudera Manager, which magically configures it for you).

Oracle ACE Director

Oracle ACE Program

Few days ago Oracle accepted my Oracle ACE Director nomination! In this short post I would like to thank the people that actively supported the nomination.

Oracle Midlands : Event #1

Mike McKay-Dirden recently wrote to me asking if I would speak at a new event he’s trying to establish called Oracle Midlands. You can read his thoughts about it on the about page. It’s similar to the types of things the Pythian guys do with the local meetups.

The first event is on January 7th in Birmingham, with myself and Pete Finnigan speaking. It’s a free event, which is being sponsored by those kind people at Red Gate Software.

Data Simplicity

Complexity costs us a lot. Managing data in databases is a big chunk of that cost. Applications voraciously consume ever-larger quantities of data, driving storage spend and increased IT budget scrutiny. Delivering application environments is already so complex that the teams of experts dedicated to that delivery demand many control points, and much coordination. The flood of data and the complex delivery process makes delivery of environments slower and more difficult, and can lengthen refresh times so much that stale data becomes the norm. Complexity also grows as IT tries to accommodate the flood of data while their application owners expect Service Level Agreements, backup/recovery protections, and compliance requirements to remain constant.

MobaXterm 6.6

I’ve sung the praises of MobaXterm many times. Just a quick note to say version 6.6 came out a few days ago. The download and change log are here.

If you are using a desktop PC running windows, but spend your life connecting UNIX and Linux servers, like most DBAs and sys admins, you really need this in your life! It’s so much better than anything I’ve ever used before. Even those really expensive desktop X emulators (you know who you are)! What’s more, it’s a self contained .exe, so no need for installation. Just unzip and go. Perfect on a memory stick!

Cheers

Tim…

Why Data Agility is more valuable than schema consolidation.

If you’ve been an Oracle data professional for any length of time, you’ve undoubtedly had a conversation about reducing your total number of databases by consolidating applications schemas from each individual database into separate schemas in one monolith database. Certainly, in the days before shared dictionaries, pluggable databases, and thin cloning this argument could be made easily because of the high price of the database license. Consolidation is a winning argument, but doing it at the cost of data agility turns it into a loser. Let’s explore why.

The argument For Schema Consolidation

Convert Raw/Hex to Timestamp

Just filing this away on my own blog because it seems that I always have hard finding it via google.  Here’s some code to convert raw/hex values into timestamps.  (I’ve come across this need in two situations: [1] bind variables recorded in trace files or sql monitor and [2] hi/low values in column statistics.)

As a query, without creating any objects in the database:

Convert Raw/Hex to Timestamp

Just filing this away on my own blog because it seems that I always have hard finding it via google.  Here’s some code to convert raw/hex values into timestamps.  (I’ve come across this need in two situations: [1] bind variables recorded in trace files or sql monitor and [2] hi/low values in column statistics.)

As a query, without creating any objects in the database:

12c Invisible Columns (The Invisible Man)

Oracle 12c introduced the ability to make user specified columns “Invisible” such that they’re invisible by default and have to be explicitly referenced to be accessed. So a simple SELECT * won’t display columns defined as invisible, but they will be displayed if explicitly referenced in the SELECT column list. From an indexing perspective, columns […]

Delete Archived Logs from Standby

This is a little surprising to me because it’s so simple – but I couldn’t find a script anywhere on oracle support or on the internet which elegantly (IMHO) cleaned up archived logs on a standby system.  (Specifically, a RAC/thread aware script.)

There are a few scripts published: