Author Archives: Bobby

I’m at the East Coast Oracle Users Conference and wanted to write a blog post about the first day, which is now done.  Rather than summarize all the sessions I thought I would focus on what struck me the most … Continue reading →

I just found out that my alternate talk for the East Coast Oracle Users Conference is needed.  So, I’ll be doing my Exadata talk on Wednesday and my Intro to SQL Tuning talk Thursday.  This makes the conference even more … Continue reading →

I was working on a package that we use to gather statistics on the partition level after data is loaded and found some quirks that apply when the partition has subpartitions. You can’t use dbms_stats.gather_table_stats to gather stats on just … Continue reading →

I got the following Facebook message about the East Coast Oracle Users Conference which starts in less than two weeks: It’s Friday and ECO is just 12 days away. Looking forward to seeing everyone! Please spread this discount code to … Continue reading →

I was getting some bad spam users registering on this blog so I disabled the ability to register.  You don’t really get any benefit from registering so I’m saving people time and blocking spam.  Anyone can leave a comment without … Continue reading →

I had a situation where I wanted to compare the temp space used by two similar insert statements on a test system.  One was filling up the temporary tablespace and the other wasn’t. select sql_id,sample_time, sum(TEMP_SPACE_ALLOCATED)/(1024*1024*1024) gig from DBA_HIST_ACTIVE_SESS_HISTORY where … Continue reading →

Quick post of a query I just used to diagnose a problem with a SQL statement that had a lot of db file sequential read waits.  This uses ASH data to see which segment the waits were on the most. … Continue reading →

I spent the past four days in SQL Server 2012 performance tuning class with four of my coworkers.  It was so surreal walking into the Microsoft offices on the first day.  I kind of felt guilty after all these years … Continue reading →

Prepping for my Intro to SQL tuning talk on Monday I did a little further research on one of my examples.  It is a concept I’ve known about for a while and I feel like it is profound evidence for … Continue reading →

Spent several hours practicing my Introduction to SQL Tuning talk yesterday and it has made me think through the things I’m saying.  I don’t want to lead anyone astray by my talk, or the things I’ve posted on this blog.  … Continue reading →