Author Archives: Bobby

In my previous post I mentioned that I took a machine learning class based on Python and a library called PyTorch. Since the class ended, I have been working on a useful application of the PyTorch library and machine learning … Continue reading →

Purpose – Document AI Resources In this post, I will describe the AI training resources that I am using in my quest to catch up with the current state of the art. My goal is to document the resources that … Continue reading →

I was trying to tune a MySQL query this week. I ran the same query against Oracle with the same data and got a much faster runtime on Oracle. I couldn’t get MySQL to do a range scan on the … Continue reading →

I wrote a script called archivelogspace.py to help size our Oracle archive log filesystems to support replication tools such as Fivetran, DMS, or GoldenGate which need a certain number of hours or days of archive log history at all times. … Continue reading →

I keep running into situations on Oracle databases where I need to dump out the privileges an Oracle user has. I have been just manually putting together SQL statements like: This captures the three kinds of grants the user could … Continue reading →

I was in a short programming contest at work for three days last week. My team got second place! We used a LangChain vector store in a MongoDB Atlas cluster so I thought I would at least document the links … Continue reading →

This is a follow up to my earlier post about installing various MySQL versions from source: https://www.bobbydurrettdba.com/2019/05/22/mysql-source-installs-for-each-rds-version/ So, I am an Oracle database administrator. I have been for about 30 years starting with Oracle 7. But for the past few … Continue reading →

Friday, we had to do a full restore and recovery of a production Oracle database. We used a script like this: We ran it like this: The only tricky thing was getting the allocate channel commands right to work with … Continue reading →

I said in my previous post that I put LOB space scripts in my GitHub repository and I wanted to explain a little more here. I have two databases that were growing rapidly and the top segment in each was … Continue reading →

I do not have time to write a post explaining these now, but I wanted to note that I am posting LOB space related scripts here: https://github.com/bobbydurrett/OracleDatabaseTuningSQL/tree/master/lob Bobby