Author Archives: Bobby

This is the sftp version of the ftp script I published in an earlier post. It logs into a remote host using sftp and backs up a remote directory recursively backing up all subdirectories. This one uses Paramiko instead of … Continue reading →

A few days or weeks ago I saw a Twitter post about database links failing on Oracle databases next year. So, I have researched this issue. My company has a bunch of Oracle databases with a web of database links … Continue reading →

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 →

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 →

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 →

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 →

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 →

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 →

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 →

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 →