Author Archives: Bobby

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 →

This is a good blog post.  I’ve come back to it multiple times to get perspective on my career and involvement in the Oracle community: Tim Hall blog post on why you shouldn’t try to become an Oracle ACE I … Continue reading →

I encourage people that I work with to put a small number like 8 as the parallel degree when they want to create tables or indexes to use parallel query.  For example: SQL> create table test parallel 8 as select … Continue reading →

Yesterday I was trying to figure out if any queries on a particular production database were using subpartition statistics on a certain table.  We are having trouble getting the statistics gathering job to finish gathering stats on all the subpartitions … Continue reading →

I was testing a script that did a lot of very short SQL statements and running many of them at the same time to bog down the CPU on the database server.  I kept seeing high “SQL*Net message from client” … Continue reading →

Hopefully this is not too redundant to previous posts but I’ve found that I keep using a particular script to debug performance issues and I thought I’d share it and explain what I use it for.  It’s helpful to me … Continue reading →

Today I saw two different plans with the same plan hash value but different numbers of partitions.  So, the partition numbers must not factor into the plan hash value.  So, you can’t count on the plan hash value to fully … Continue reading →