Author Archives: Bobby

About Bobby

I live in Chandler, Arizona with my wife and three daughters. I work for US Foods, the second largest food distribution company in the United States. I have worked in the Information Technology field since 1989. I have a passion for Oracle database performance tuning because I enjoy challenging technical problems that require an understanding of computer science. I enjoy communicating with people about my work.

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

MiB – not Men in Black!

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

Posted in Uncategorized | 2 Comments

Gold image for 19.16 install on RHEL 8

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

Posted in Uncategorized | Leave a comment

netstat -o shows that (ENABLE=BROKEN) turns on TCP keepalive

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

Posted in Uncategorized | Leave a comment