Subscribe to Blog via Email
Join 970 other subscribersArchives
Search Results for: Python
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
X86-64 Assembly Book
I have written earlier blog posts about my diversion from studying Oracle to studying computer science. Here are some relevant posts: url1,url2,url3,url4. After finishing the math for computer science online class and book that I was working on I stared working … Continue reading
Posted in Uncategorized
3 Comments
Submitted two abstracts for Oracle OpenWorld 2017
I submitted two abstracts for Oracle OpenWorld 2017. I have two talks that I have thought of putting together: Python for the Oracle DBA Toastmasters for the Oracle DBA I want to do these talks because they describe two things that I … Continue reading
Posted in Uncategorized
2 Comments
Rosetta Code
I have experimented with the Rosetta Code website as a way to learn more about computer technology. I have mentioned my exploration of the edX and OCW web sites in earlier posts so I thought I would mention Rosetta Code or … Continue reading
Posted in Uncategorized
Leave a comment
I put my SQL scripts on GitHub
I created a new GitHub public repository with my SQL scripts. Here is the URL: https://github.com/bobbydurrett/OracleDatabaseTuningSQL I’ve experimented with GitHub for my Python graphing scripts but wasn’t sure about putting the SQL out there. I don’t really have any comments … Continue reading
Posted in Uncategorized
Leave a comment
New graph: Average Active Sessions per minute
I am working on a production issue. I do not think that we have a database issue but I am graphing some performance metrics to make sure. I made a new graph in my PythonDBAGraphs program. It shows the average number … Continue reading
Posted in Uncategorized
2 Comments
Modified IO CPU+IO Elapsed Graph (sigscpuio)
Still tweaking my Python based Oracle database performance tuning graphs. I kind of like this new version of my “sigscpuio” graph: The earlier version plotted IO, CPU, and Elapsed time summed over a group of force matching signatures. It showed … Continue reading
Posted in Uncategorized
Leave a comment
Graph frequently executed SQL by FORCE_MATCHING_SIGNATURE
I made a new graph in my PythonDBAGraphs program. Here is an example with real data but the database name blanked out: My graphs are all sized for 1920 x 1080 monitors so I can see all the detail in … Continue reading
Posted in Uncategorized
Leave a comment
Understanding query slowness after platform change
We are moving a production database from 10.2 Oracle on HP-UX 64 bit Itanium to 11.2 Oracle on Linux on 64 bit Intel x86. So, we are upgrading the database software from 10.2 to 11.2. We are also changing endianness … Continue reading
Posted in Uncategorized
Leave a comment