Structured Data

The Core Performance Fundamentals Of Oracle Data Warehousing – Partitioning

Greg Rahn — Mon, 25 Jan 2010 12:00:01 +0000

Partitioning is an essential performance feature for an Oracle data warehouse because partition elimination (or partition pruning) generally results in the elimination of a significant amount of table data to be scanned. This results in a need for less system resources and improved query performance. Someone once told me “the fastest I/O is [...]

The Core Performance Fundamentals Of Oracle Data Warehousing – Table Compression

Greg Rahn — Tue, 19 Jan 2010 12:00:55 +0000

Editor’s note: This blog post does not cover Exadata Hybrid Columnar Compression. The first thing that comes to most people’s mind when database table compression is mentioned is the savings it yields in terms of disk space. While reducing the footprint of data on disk is relevant, I would argue it is the lesser of [...]

Partway Researched With A Chance Of FUD

Greg Rahn — Mon, 04 Jan 2010 12:00:21 +0000

I tend to keep the content of this blog fairly technical and engineering focused, but every now and then I have to venture off and do an editorial post. Recently some of the ParAccel management decided to fire up the FUD machine on the ParAccel blog and take aim at Oracle’s Exadata making the following [...]

2009 Year-End Zeitgeist

Greg Rahn — Mon, 04 Jan 2010 00:09:39 +0000

Another year in the books and another year on the Structured Data blog. Hopefully 2009 treated you well and 2010 will bring good things in addition. I thought I’d throw a few Top 5 lists together to reminisce about 2009. Enjoy! Top 5 Most Visited Blog Posts of 2009 DBMS_STATS, METHOD_OPT and FOR ALL INDEXED COLUMNS Choosing An [...]

The Core Performance Fundamentals Of Oracle Data Warehousing – Balanced Hardware Configuration

Greg Rahn — Tue, 22 Dec 2009 21:00:54 +0000

If you want to build a house that will stand the test of time, you need to build on a solid foundation. The same goes for architecting computer systems that run databases. If the underlying hardware is not sized appropriately it will likely lead to people blaming software. All too often I [...]

Oracle Database 11g Release 2 for HP-UX Itanium and AIX (PPC64) Now Available

Greg Rahn — Tue, 22 Dec 2009 18:04:38 +0000

The HP-UX Itanium and AIX (PPC64) ports of Oracle Database 11g Release 2 can now be downloaded from OTN. Happy Holidays!!! Tweet This Post

The Core Performance Fundamentals Of Oracle Data Warehousing – Introduction

Greg Rahn — Mon, 14 Dec 2009 16:00:20 +0000

At the 2009 Oracle OpenWorld Unconference back in October I lead a chalk and talk session entitled The Core Performance Fundamentals Of Oracle Data Warehousing. Since this was a chalk and talk I spared the audience any powerpoint slides but I had several people request that make it into a presentation so they could [...]

Oracle Database 11g Release 2 for Solaris x86-64 Now Available

Greg Rahn — Wed, 25 Nov 2009 18:54:46 +0000

The Solaris x86-64 port of Oracle Database 11g Release 2 can now be downloaded from OTN. Get it while it’s hot! Tweet This Post

Oracle 11gR2 Database Flash Cache Patch For Oracle Enterprise Linux

Greg Rahn — Wed, 25 Nov 2009 06:32:17 +0000

Just a quick note that there is now a patch for the 11.2 Oracle Enterprise Linux (OEL) database ports to enable the database flash cache (not to be confused with the Exadata flash cache). Go to the My Oracle Support site [link] and search for patch 8974084 – META BUG FOR FLASH CACHE 11.2PL [...]

Oracle OpenWorld Unconference

Greg Rahn — Mon, 05 Oct 2009 05:19:49 +0000

One of the less “traditional” tracks at Oracle OpenWorld is the Oracle Unconference. The Unconference allows for a much more informal setting for sessions and generally is more interactive and audience driven compared to the usually amounts of PowerPoint sessions contain which can cause eyes to bleed. This year I’ve signed up to [...]