Author Archives: Bobby

I ran across a stackoverflow question and it gave me an idea for a simpler use of Python to graph some Oracle database performance information. I looked at my PythonDBAGraphs scripts and I’m not sure that it is worth modifying … Continue reading →

I have experimented with the Rosetta Code website as a way to learn more about computer technology. I have mentioned my exploration of the edX and OCW web sites in earlier posts so I thought I would mention Rosetta Code or … Continue reading →

The next Arizona Oracle User Group meeting is January 26th in Scottsdale. Signup on this meetup link. Copied from invitation: When:  January 26, 2017 (Thursday) 12:30 pm – 4:00 pm Where:  Republic Services 1st Floor Training Rooms 14400 N 87th … Continue reading →

Before I left for vacation I noticed this blog post about setting up a network on VirtualBox: “CREATING A TEST LAB USING VIRTUALBOX / NAT NETWORKING”(DOES NOT EXIST). Now that I am back in the office I thought I would … Continue reading →

Delphix is sponsoring a user webinar on Wednesday from 10 to 11 am California time. I and a couple of other technical Delphix users will take part in a panel discussion. The webinar will give you a good chance to hear about other users’ experience … Continue reading →

I’m on call this week. Here are the steps that I took to speed up a query today. First I got an AWR report and found the top query. Also, someone from support told me to look at November 11 before … Continue reading →

I needed to write a new script that was running on a Red Hat Linux 6 virtual machine and that would connect to databases using SQL*Plus. I was going to write a bash shell script but decided to use Python instead … Continue reading →

I created a new GitHub public repository with my SQL scripts. Here is the URL: https://github.com/bobbydurrett/OracleDatabaseTuningSQL I’ve experimented with GitHub for my Python graphing scripts but wasn’t sure about putting the SQL out there. I don’t really have any comments … Continue reading →

I ran into a situation last week where a developer complained that a query sometimes ran for 3 or more seconds but normally runs much less than 1 second. I had just been to a local AZORA user group meeting … Continue reading →

We bumped a Linux 11.2.0.4 database up to a 12 gigabyte SGA and the login time went up to about 2.5 seconds. Then a Linux admin configured 12 gigabytes of HugePages to fit the SGA and login time went down to … Continue reading →