Author Archives: Bobby

About Bobby

I live in Chandler, Arizona with my wife and three daughters. I work for US Foods, the second largest food distribution company in the United States. I have worked in the Information Technology field since 1989. I have a passion for Oracle database performance tuning because I enjoy challenging technical problems that require an understanding of computer science. I enjoy communicating with people about my work.

Post Collaborate and on call week post

So, I was at the Collaborate 2018 Oracle user group conference last week and I am on call this week. I have not posted anything about the conference so I thought I would try to get something out there. I … Continue reading

Posted in Uncategorized | Leave a comment

Getting geared up for Collaborate 2018 #C18LV

I’m leaving for Las Vegas a week from this Sunday for the Collaborate 2018 conference #C18LV. I’m doing the same two talks that I did in Denver at RMOUG Training Days. Here are the times and locations for the talks if … Continue reading

Posted in Uncategorized | Leave a comment

Had to set parallel_max_servers to 2 for Delphix clone

This is a quick note about a problem I had creating a Delphix virtual database clone of a production database. This is an older 11.1.0.7 HP-UX Itanium database. I tried to make a new virtual database copy of the production … Continue reading

Posted in Uncategorized | Leave a comment

Does an automated cloud data warehouse need partitioning and indexes?

This is a late post inspired by my time at RMOUG Training Days 2018. I attended two RMOUG Training Days presentations about automated cloud data warehouse database systems. The first was about Snowflake. The second was about Oracle’s coming Autonomous … Continue reading

Posted in Uncategorized | Leave a comment

Pushing predicates into MySQL subqueries

I am just getting started looking at MySQL performance tuning but I thought I would share something that I may have figured out. I’m working with a query that does a count and a group by in a subquery and … Continue reading

Posted in Uncategorized | Leave a comment

Follow up from RMOUG Training Days talks

I have uploaded a zip of my two RMOUG Training Days talks here: zip During the Toastmasters talk there was a question about finding a club in your area. Here is how to find a Toastmasters club near you. Go … Continue reading

Posted in Uncategorized | Leave a comment

Early morning RMOUG post

Well, it is early Wednesday morning here at the Westin hotel in Denver where the RMOUG Training Days conference is being held. I can’t sleep anyway so I thought I would write-up some of my impressions of yesterday’s presentations. I … Continue reading

Posted in Uncategorized | Leave a comment

Should I use SQL or Python?

We had an outage on an important application last Thursday. A particular SQL statement locked up our database with library cache: mutex X waits. I worked with Oracle support to find a bug that caused the issue and we came up … Continue reading

Posted in Uncategorized | 3 Comments

RMOUG Training Days 2018 early registration deadline rapidly approaching

The deadline for early registration for RMOUG Training Days 2018 is rapidly approaching. The deadline is January 12. The early registration fee is $385 for RMOUG members and $450 for non-members. There is a packed agenda over the three-day event. The hotel costs … Continue reading

Posted in Uncategorized | Leave a comment

Both talks accepted for Collaborate 18

IOUG accepted both my Toastmasters and Python talks for Collaborate 18. RMOUG also accepted them both so I will be doing these two talks in both February and April. I am a little surprised because I have had talks rejected by IOUG … Continue reading

Posted in Uncategorized | 2 Comments