Subscribe to Blog via Email
Join 1,048 other subscribersArchives
Author Archives: Bobby
SQL Profile to fix slow inserts
I was on call Sunday and got paged about a job that normally runs for 10 to 15 minutes but had run for 5 hours already. I used the coe_xfr_sql_profile.sql script from SQLT to speed up an insert statement that was … Continue reading
Posted in Uncategorized
2 Comments
Two Talks Accepted for RMOUG Training Days
I got two talks accepted for RMOUG Training Days in February. I mentioned these two titles in a earlier post: Python for the Oracle DBA Toastmasters for the Oracle DBA These two talks are about topics that interest me so I … Continue reading
Posted in Uncategorized
3 Comments
Submitted two talks to Collaborate 18
I submitted my two talks to Collaborate 18 through IOUG. These are the same two that I submitted to RMOUG Training Days. Hopefully one of the talks will get accepted at one of the two conferences but I don’t know. … Continue reading
Posted in Uncategorized
1 Comment
Python sortedcontainers has me thinking
I was looking at the Python sortedcontainers package and it got me thinking. It is a long convoluted story and I am not sure that I can explain it clearly in a short blog post. I tried to explain all this … Continue reading
Posted in Uncategorized
2 Comments
Submitted two abstracts to RMOUG Training Days 2018
I finally broke down and submitted my two talks to the RMOUG Training Days 2018. I’m not sure how likely I am to get my talks accepted but I learned a lot just through constructing my two abstracts. I have … Continue reading
Posted in Uncategorized
4 Comments
Duplicate blog to laptop VM
I started to write this blog post and then realized that in the process of making a copy of my blog on my laptop I whacked my connection to WordPress. But, it was easy to resolve it by disconnecting Jetpack … Continue reading
Posted in Uncategorized
Leave a comment
Quick Python script to backup remote directory using ftp
I looked around for some other ways to do this but decided to just code this up in Python. It connects to a remote Linux server using ftp and recursively copies all the files and directories back to a Windows machine. … Continue reading
Posted in Uncategorized
3 Comments
Added save and restore data function to PythonDBAGraphs
I pushed out a quick change to PythonDBAGraphs to automatically save the data for any graph that you make so that you can redraw the graph later. This is better than saving an image file because the redrawn graph lets you … Continue reading
Posted in Uncategorized
Leave a comment
Python for the Oracle DBA – Connects to everything
In my introduction to my Python for the Oracle DBA topic I said that Python can connect to everything that an Oracle DBA needs. I want to use this post to expand on that and talk about the Python modules and … Continue reading
Posted in Uncategorized
6 Comments
Python for the Oracle DBA – Easy to use
In my earlier post I said that Python is easy to use. I want to fill in some details in this post. I have two main points: Python is not easy to learn Python is easy to use after you … Continue reading
Posted in Uncategorized
9 Comments