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.

Cloning 10.2.0.3 Oracle Home on fully patched 11.31 HP-UX hangs

I based this blog post on information that I learned from this Oracle Support document: Runinstaller And Emctl Do Not Work After Upgrading HP-UX 11.31 To 11.31 Update3 (Sep 2008) (Doc ID 780102.1) My situation was slightly different from what … Continue reading

Posted in Uncategorized | Leave a comment

Another python graph – one wait event

Here is another graph that I created in Python with Pyplot: This is onewait.py in my PythonDBAGraphs repository. myplot.py has the plotting code.  db.py has the database access code. I blanked out the database name in the example graph to hide … Continue reading

Posted in Uncategorized | 3 Comments

Trying Python and Pyplot for Database Performance Graphs

In the past I have used Excel to graph things related to Oracle database performance. I am trying out Python and the Pyplot library as an alternative to Excel.  I took a graph that I had done in Excel and rewrote it in … Continue reading

Posted in Uncategorized | 4 Comments

Github Repository

I am experimenting with Github. I have created a repository for my Oracle database related scripts. Here is my Github URL: https://github.com/bobbydurrett/PythonDBAGraphs You can clone this repository locally if you have git installed using this command: git clone https://github.com/bobbydurrett/PythonDBAGraphs I’ve had … Continue reading

Posted in Uncategorized | Leave a comment

Update hinted for wrong index

I worked with our support team to improve the performance of a PeopleSoft Financials update statement yesterday. The update statement had an index hint already in it but the index was not the best one of the available indexes. Here … Continue reading

Posted in Uncategorized | Leave a comment

Tested 1000 Select Statements on New Exadata X5

I finished testing 1000 select statements on our new Exadata X5 to see if they would run faster or slower than on our older Exadata V2.  Our current production V2 has 12 nodes and the new X5 has only 2. … Continue reading

Posted in Uncategorized | Leave a comment

OakTable video of myself and others

You can find the full length video of my Delphix talk that I did at OakTable World on Tuesday here: url Also, the OakTable folks have updated the OakTable World agenda page with video of all the talks. This has … Continue reading

Posted in Uncategorized | Leave a comment

Final day – OpenWorld and Delphix Sync

This morning was my last day of Oracle OpenWorld sessions and this afternoon and evening finished off my day with Delphix Sync. The first talk was my only NoSQL talk. It was interesting because the claim was that NoSQL was … Continue reading

Posted in Uncategorized | 2 Comments

Wednesday OpenWorld

Well, it was a long day but it ended in a fun way. Today I was back to the normal OpenWorld sessions starting with the general session. It was eye-opening because the speakers described a new CPU chip that they … Continue reading

Posted in Uncategorized | Leave a comment

Tuesday OakTable World – brain fried!

Instead of going to the normal OpenWorld events today I went to OakTable World.  Now my brain is fried from information overload. 🙂 It started at 8 am with a nice talk about hash joins and Bloom filters.  Toon Koppelaars … Continue reading

Posted in Uncategorized | 4 Comments