Author Archives: Bobby

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

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 →

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

Yesterday I was reading over some Kubernetes documentation and ran across the abbreviation MiB. I almost ignored it and kept reading. It seemed to just mean megabytes as in 256 MiB meaning 256 megabytes or 256*1024*1024 bytes. It was here: … Continue reading →

On Red Hat 7 Linux VMs we use a zip of a 19c Oracle home with the latest quarterly database release update applied which at the moment in 19.16, the July 19, 2022 version. Our standard deployment script just unzips … Continue reading →

In an earlier post I showed a Java program that will login to an Oracle database and wait for 350 seconds. I also talked about how we set the Linux parameter net.ipv4.tcp_keepalive_time to 60 seconds but that I needed to … Continue reading →