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