Monthly Archives: December 2013

After I did my previous post on how adding a column to a table with more than 255 columns can cause a ton of row chaining the question came up about Exadata and the form of compression we use on … Continue reading →

I put together an example of how to do an exchange partition to meet a specific need in our environment.  It might be helpful to others though your situation may vary.  It is a self-contained test script in a zip. … Continue reading →

Production issue We have some production tables with more than 255 columns and are experiencing performance degradation on queries that access certain columns.  I was able to show that a full table scan with a where clause condition including one … Continue reading →

I thought I would start this blog post before I finished this testing so I wouldn’t forget what I’m doing along the way.  Usually I just write something up after I’m done and then I may forget all I’ve done … Continue reading →

This week I am reviewing my accomplishments for 2013 and thinking of possible goals for 2014 in preparation for my annual performance review.  After reviewing my notes about what I did this year and brainstorming about what I want to … Continue reading →