Category Archives: Uncategorized

Math Resources

I feel like I have not been posting very much on this blog lately. I have been focused on things outside of Oracle performance so I haven’t had a lot of new scripts to post.  I have been quietly updating my … Continue reading

Posted in Uncategorized | 3 Comments

General troubleshooting lessons from recent Delphix issue

Delphix support helped me resolve an issue yesterday and the experience gave me the idea of writing this post about several general computer issue troubleshooting tips that I have learned down through the years. Never mind that I ignored these … Continue reading

Posted in Uncategorized | Leave a comment

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