Subscribe to Blog via Email
Join 1,048 other subscribersArchives
Author Archives: Bobby
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