Subscribe to Blog via Email
Join 996 other subscribersArchives
Category Archives: Uncategorized
Catching Myself up on AI: Useful Resources
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
Posted in Uncategorized
Leave a comment
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
3 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
1 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