Category Archives: Uncategorized

Simple MySQL Range Scan Test

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

Posted in Uncategorized | 2 Comments

Archivelog Space Needed Python Script

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

Posted in Uncategorized | 5 Comments

User Privileges Script

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

Posted in Uncategorized | Leave a comment

MongoDB Atlas LangChain Vector Store

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

Posted in Uncategorized | Leave a comment

Install MySQL 5.7.38 from source on Oracle Linux 8

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

Posted in Uncategorized | Leave a comment

Full Database Restore and Recovery

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

Posted in Uncategorized | Leave a comment

LOB Space Scripts

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

Posted in Uncategorized | 2 Comments

LOB Scripts in my GitHub Repository

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

Posted in Uncategorized | Leave a comment

December 26 Plan Change

On December 26th, which is a holiday for my company this year, our team got a page that a plan had changed on an important 11.2.0.3 HP Unix platform Oracle database. The new plan was inefficient but did not cause … Continue reading

Posted in Uncategorized | 2 Comments

US Foods IT Hiring

US Foods IT Jobs: url My company is hiring a number of IT positions with more to come soon. Bobby

Posted in Uncategorized | Leave a comment