Who's online

There are currently 0 users and 26 guests online.

Recent comments

May 2012

Quick Reference README File For SLOB – The Silly Little Oracle Benchmark

This is just a quick blog entry with the main README file from SLOB – The Silly Little Oracle Benchmark. I frequently findings myself referring folks to the README so I thought I’d make it convenient. I’ve also uploaded this in PDF form here.

IOsaturationtoolkit-v2 with Exadata IORM and AWESOME text graph

I’ve got a new version of IOsaturation toolkit which you can download here and it has a cool script called “smartscanloop” that shows you the Smart Scan MB/s per database across the Exadata  compute nodes.. it’s a per 2secs sample so that’s a pretty fine grained perf data and near real time text graph. Very useful for doing IORM demos and monitoring what database is currently hogging the IO resources and since it’s presented in a consolidated view you don’t have to go to each Enterprise Manager performance page and have a bunch of browser windows open.

[Oracle] Index key compression

SAP supports index key compression since Oracle 10.2. This feature is very useful in some cases, so let's take a closer look how it works and in which cases it can improve your performance or save disk space.


How does it work theoretical?

Index compression is implemented at index leaf block level (only available for b-tree indexes). Each unique combination of the compressed column values is stored in an "internal" (=prefix) table and replaced in the index row by a pointer to that prefix table entry.

The benefit of compression depends on the number of unique combinations:

  • Few unique value combinations - good compression
  • Many unique value combinations - bad compression (and maybe more space is needed)


MOATS-like sqlplus “top” utility for RAC


So, you think MOATS was cool?! Check this out by Jagjeet Singh :)


Oracle E-Learning Resources

There is a lot of new stuff out there nowadays, regarding products and/or functionality or others. This is also true for Oracle and in short it’s not easy to follow all those innovations and/or new products. So from time to time I have a watch on stuff that interests me on the YouTube Oracle E-Learning

Read More…


Here’s a final warning of the busy time I’m having next week. It starts with the E4 conference in Dallas (full  agenda here),my topic is “Due Diligence examining Exadata”.  Then it’s on to Minneapolis where I’ll be doing a one-day event on finding and reading Execution Plans (Agenda andRegistration).

UKOUG Conference 2012

Event date: 
Mon, 2012-12-03 - Wed, 2012-12-05

OUG Scotland Conference 2012

Event date: 
Wed, 2012-06-13

Six topic areas, 30 sessions, several Oak Table speakers, and a keynote from Tom Kyte.

Oracle’s Timeline, Copious Benchmarks And Internal Deployments Prove Exadata Is The Worlds First (Best?) OLTP Machine – Part II

There Is No Such Thing As “Pure OLTP”
There is no such thing as “pure OLTP.” How true! And that’s why you are supposed to buy Exadata for your Oracle OLTP/ERP deployment—at least that’s what I’ve heard.

Part I of this series on the topic of Oracle OLTP/ERP on Exadata Database Machine has brought quite a bit of feedback my way.  Most of the feedback came from independent consultants who have built a practice around Exadata. I did, however, hear from an Oracle customer that has chosen to migrate their Oracle Database 10g ERP system from a cluster of old AMD 2300 “Barcelona” Opteron-based servers (attached to a circa 2007 technology SAN) to Exadata. This customer also cited the fact that there is no such thing as “pure OLTP” and since it is a fact I don’t refute it.

Death of the Enterprise Architect?

Last week I read an interesting article about how cloud computing is changing the role of the enterprise architect and it got me thinking about the bad rap many architects are getting in the brave new agile, cloud, big data world.

From what I’ve been reading, there’s been a bit of a straw man argument going on — enterprise architects are often described as uber-control freaks who attempt to dictate software architectures in a repressive way to implementation teams. Mention the term “reference architecture” and you’ll often raise the hackles of the new developer-led world.

To be sure, there are many enterprise architects who match that description. And they’re the ones who give architects a bad name, just like undisciplined developers can give agile a bad rap too.