Author Archives: Bobby

I wrote a Python program that made some fun pictures so I thought I would share them even though this is not really a database post. I practice Python programming by doing Rosetta Code programming tasks that no one has … Continue reading →

Looking at cloud databases has me thinking about the speed of light. Wikipedia says that the speed of light is about 186,000 miles per second. If my calculations are correct that is 5.37 microseconds per mile. The United States is … Continue reading →

I pushed out three new Python scripts that might be helpful to Oracle DBAs. They are in my miscpython repository. remotescript.py – run Unix/Linux commands on a remote server dbversion.py – Get the version from a database – i.e. 11.2.0.4 … Continue reading →

Here are the slides from our March Arizona Oracle User Group (AZORA) meeting: Daniel Morgan Security Master Class We really appreciate Daniel Morgan taking the time to share this information about the increasingly important topic of database security. Also, AZORA … Continue reading →

Next Thursday Daniel Morgan from TidalScale will be giving a free Oracle Database Security Master Class for our March Arizona Oracle User Group meeting. See the details in our Meetup link: Please RSVP so that we know how many people … Continue reading →

I was on call last week and I got a ticket about a batch job that was failing on a MERGE statement with an ORA-30926 error. Our support team worked around it by deleting some duplicate rows in a table … Continue reading →

I am learning about MySQL performance tuning. I read the Performance Schema chapter of the MySQL 5.7 manual and I have a MySQL 5.7.20 database running under Linux. I have a test table and I am running a simple query … Continue reading →

Last week I was asked to help with a performance problem that looked a lot like a problem I fixed in July with a SQL Profile. The query whose plan I fixed back in July was modified by a minor … Continue reading →

Here are slides from the January 2019 AZORA Meeting with Charles Kim and Viscosity: Oracle Database 12.2 New Features Oracle Database 18c New Features Thank you to Charles and Viscosity for making our meeting a big success, and thanks for … Continue reading →

MIT, the Massachusetts Institute of Technology, has published a free set of three undergraduate level Algorithms classes that I recommend to the readers of this blog. These are links to the three classes in the order that they should be … Continue reading →