Category Archives: Uncategorized

Introduction This post describes a way to use a Large Language Model (LLM) to investigate Oracle database problems. In this approach, the LLM repeatedly generates SELECT statements based on previous queries and their results. Each query provides additional context, allowing … Continue reading →

DBAs spend a lot of time reviewing reports about the health of their databases. I’ve used an LLM to speed up that process. I took a daily report about our Oracle databases and used an LLM to generate a short … Continue reading →

I am working on an Oracle 19c database running on a RHEL 7 VM. I have been trying to roll back this patch: I have it sitting on top of 19.5 The Opatch rollback command ran fine, but Datapatch threw … Continue reading →

I recently migrated my WordPress blog from Amazon Linux 2 to Amazon Linux 2023 to take advantage of newer software versions. The process was mostly smooth, but I wanted to document a few things I ran into—especially around encryption setup. … Continue reading →

1. Introduction I set out to use Machine Learning to monitor Oracle databases but ultimately chose not to. The most valuable lesson I learned was the importance of visualizing my data to determine the best approach. By examining real production … Continue reading →

Sunday four batch jobs that normally run in an hour had been stuck for 3 hours and had not completed the first unit of work out of many. Earlier in the day the on call DBA had applied a SQL … Continue reading →

Introduction Everyone who has heard the old saying “a picture is worth a thousand words” appreciates its simple wisdom. With Oracle databases you have situations where a graph of the output of a SQL query is easier to understand than … Continue reading →

I am not a very good blogger. Only four posts in 2024. I will need to pick it up because I just increased my spend on AWS for this blog. This site kept going down and I finally spent a … Continue reading →

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 →