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.

Monday OpenWorld

It was a good first full day at Oracle OpenWorld.  It started with the keynote led by Oracle’s CEO.  Of course he was very upbeat about Oracle’s products.  But, I found his comments about the economy and the way it … Continue reading

Posted in Uncategorized | Leave a comment

Reviewing Delphix blog posts before OpenWorld

I just finished reviewing my Delphix blog posts in preparation for the talks that I will give during OpenWorld. I find myself referring back to my blog to help me remember what I have done in the past. I was thinking that … Continue reading

Posted in Uncategorized | 2 Comments

Toastmaster Talk – DBA Toolkit

Here is a YouTube video of a short Toastmasters talk of mine about a DBA topic.  It was probably too technical for the audience but may interest the readers of this blog. Here was a post about a similar topic: https://www.bobbydurrettdba.com/2012/06/22/working-on-performance-toolkit/ … Continue reading

Posted in Uncategorized | 2 Comments

My Delphix presentation at OakTable World

It is official.  I will be doing my Delphix presentation at OakTable World during the Oracle OpenWorld conference at the end of this month.  My talk is at 9 am on Tuesday, October 27. I will describe our journey as … Continue reading

Posted in Uncategorized | 1 Comment

AZORA – Arizona Oracle User Group new location

The Arizona Oracle User Group has moved tomorrow’s meeting to Oracle’s offices on Camelback road: Meetup link with meeting details Bobby

Posted in Uncategorized | Leave a comment

Plan change monitor prevents user impact from bad plan

This morning a colleague of mine noticed an alert from our plan change monitor and prevented any impact on the users by forcing a SQL’s plan to its normal fast plan before the users could be affected.  I want to … Continue reading

Posted in Uncategorized | 11 Comments

Reminder: Great free computer science and Python programming class starts Wednesday

I mentioned this class earlier in a blog post but I wanted to remind people who read this blog that the class is starting again on Wednesday.  Here is the URL for the class: link The class is completely free and … Continue reading

Posted in Uncategorized | Leave a comment

Memory added based on buffer pool advisory did not give desired result

Development asked me to look at ways to cut the run time of a series of PeopleSoft payroll batch jobs so I took an AWR report of the entire 4 hour period.  Based on the waits, the percentage of the elapsed time … Continue reading

Posted in Uncategorized | 2 Comments

Script to get previous month’s AWR report

We keep 6 weeks of history in the AWR on our databases, but I want to capture some information for long-term trending. What I really want to do is capture some metrics and put them in some database tables to … Continue reading

Posted in Uncategorized | Leave a comment

Applied July Patch Sets To Test Databases

I applied the current July patch sets to a 11.2 and a 12.1 test database.  Now I have a 11.2.0.4.7 and a 12.1.0.2.4 test database.  It is helpful to have test databases that are on the most current patch sets and … Continue reading

Posted in Uncategorized | Leave a comment