Author Archives: Bobby

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 →

I created a new graph in my PythonDBAGraphs to show how a plan change affected execution time. The legend in the upper left is plan hash value numbers. Normally I run the equivalent as a sqlplus script and just look … Continue reading →

http://www.meetup.com/Arizona-Oracle-User-Group/events/233723129/ Phoenix area readers – I just found out that Oracle performance specialist and Delphix employee Tim Gorman will be speaking at the Arizona User Group meeting tomorrow in Scottsdale.  I am looking forward to it. Bobby