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 do next year I thought of four categories to (more...)
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:
I like it because it encourages me to embrace my (more...)
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 * from dba_tables; Table created. SQL> SQL> select degree (more...)
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 of this table in the window of time we (more...)
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” waits from my profiling SQL code.
Normally a profile (more...)
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 so I’m sure someone could use it unless they (more...)
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 indicate whether two plans are the same.
I’m on call this week so I didn’t plan to do any blog posting but I had an interesting performance issue this morning that I thought would be helpful to document. This is somewhat redundant to earlier posts but maybe another real example would be helpful to others (and (more...)