Author Archives: Bobby

Quick note to myself. If I am tuning a query by its SQL_ID I use these scripts: From AWR: findsql.sql – finds SQL_ID of queries that match certain strings sqlstat.sql – shows execution history of SQL_ID getplans.sql – shows all … Continue reading →

I wanted to write a quick post to document how to format nice columns in Python. Mainly I want to remember this myself and if I put it on my blog, I can find it quickly. There are probably better … Continue reading →

I resolved another production performance issue with a SQL Profile yesterday. I have several posts about SQL Profiles, so I do not want to be redundant, but this case was a little different because it was not clear that I … Continue reading →

1. Introduction I just finished moving and upgrading an Oracle database from 11.2.0.4 on HP Unix Itanium to 19c on x86-64 Linux on VMWare along with an army of coworkers on our project team. I want to use this post … Continue reading →

I read all the Arthur Conan Doyle Sherlock Holmes stories and have recently watched a couple Star Trek The Next Generation stories with the android Data pretending to be Holmes and it gave me the idea for this post about … Continue reading →

I helped resolve an Oracle database performance problem yesterday and I thought I would capture what I did in this blog post. It is a “simple” problem in that the solution was easy once I understood the issue and because … Continue reading →

I got rid of the old sqlstat.sql, sqlstat2.sql and sqlstat3.sql scripts in my GitHub repository and fixed an issue that was in sqlstat3.sql. Now the current version is just called sqlstat.sql. This one script should work well in all the … Continue reading →

I got an email asking how to send an alert email from a Python script. Here is an example based on a script I have setup: You need to replace “PUT YOUR SMTP SERVER HERE” with the host name of … Continue reading →

Every quarter I download the latest patch set from Oracle’s support site by using the Recommended Patch Advisor. But the January 2020 patch sets did not show up. The RPA still recommends the October 2019 patch sets. The Recommended Patch … Continue reading →

Wrote a quick and dirty script to scan the listener log for incoming connections and produce a count of how many connections came from which host. Here is the URL: https://github.com/bobbydurrett/miscpython/blob/master/gethostcounts.py All it does is hack out the ip address … Continue reading →