Category Archives: Uncategorized

I got a chance to use my onewait Python based graph to help with a performance problem. I’m looking at slow write time from the log writer on Thursday mornings. Here is the graph with the database name erased: We … Continue reading →

I decided to get rid of the Github repository that I had experimented with and to create a new one. The old one had a dump of all my SQL scripts but without any documentation. But, I have updated my … Continue reading →

We have had problems with set of databases over the past few weeks. Our team does not support these databases, but my director asked me to help. These are 11.2.0.1 Windows 64 bit Oracle databases running on Windows 2008. The incident … Continue reading →

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 →

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 →

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 →

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 →

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 →

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 →

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 →