Category Archives: Uncategorized

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 →

So,  I play one computer game – Nethack.  I have a page on the blog if you want some information about it.  I just finished building a 32 bit Linux virtual machine running on VMware player for the purpose of … Continue reading →

I wasn’t sure if people would find a post on a bug that interesting.  If you don’t have the same bug I’m not sure what you would get out of it.  But, it is what I’m working on. Here are … Continue reading →