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.

SQL Profile to fix slow inserts

I was on call Sunday and got paged about a job that normally runs for 10 to 15 minutes but had run for 5 hours already. I used the coe_xfr_sql_profile.sql script from SQLT to speed up an insert statement that was … Continue reading

Posted in Uncategorized | 2 Comments

Two Talks Accepted for RMOUG Training Days

I got two talks accepted for RMOUG Training Days in February. I mentioned these two titles in a earlier post: Python for the Oracle DBA Toastmasters for the Oracle DBA These two talks are about topics that interest me so I … Continue reading

Posted in Uncategorized | 3 Comments

Submitted two talks to Collaborate 18

I submitted my two talks to Collaborate 18 through IOUG. These are the same two that I submitted to RMOUG Training Days. Hopefully one of the talks will get accepted at one of the two conferences but I don’t know. … Continue reading

Posted in Uncategorized | 1 Comment

Python sortedcontainers has me thinking

I was looking at the Python sortedcontainers package and it got me thinking. It is a long convoluted story and I am not sure that I can explain it clearly in a short blog post. I tried to explain all this … Continue reading

Posted in Uncategorized | 2 Comments

Submitted two abstracts to RMOUG Training Days 2018

I finally broke down and submitted my two talks to the RMOUG Training Days 2018. I’m not sure how likely I am to get my talks accepted but I learned a lot just through constructing my two abstracts. I have … Continue reading

Posted in Uncategorized | 4 Comments

Duplicate blog to laptop VM

I started to write this blog post and then realized that in the process of making a copy of my blog on my laptop I whacked my connection to WordPress. But, it was easy to resolve it by disconnecting Jetpack … Continue reading

Posted in Uncategorized | Leave a comment

Quick Python script to backup remote directory using ftp

I looked around for some other ways to do this but decided to just code this up in Python. It connects to a remote Linux server using ftp and recursively copies all the files and directories back to a Windows machine. … Continue reading

Posted in Uncategorized | 3 Comments

Added save and restore data function to PythonDBAGraphs

I pushed out a quick change to PythonDBAGraphs to automatically save the data for any graph that you make so that you can redraw the graph later. This is better than saving an image file because the redrawn graph lets you … Continue reading

Posted in Uncategorized | Leave a comment

Python for the Oracle DBA – Connects to everything

In my introduction to my Python for the Oracle DBA topic I said that Python can connect to everything that an Oracle DBA needs. I want to use this post to expand on that and talk about the Python modules and … Continue reading

Posted in Uncategorized | 6 Comments

Python for the Oracle DBA – Easy to use

In my earlier post I said that Python is easy to use. I want to fill in some details in this post. I have two main points: Python is not easy to learn Python is easy to use after you … Continue reading

Posted in Uncategorized | 9 Comments