Author Archives: Bobby

It has been two years or more since I first thought about moving my blog to Amazon Web Services (AWS) from iPage, the hosting company that this blog has always been on. My company uses AWS for a number of … Continue reading →

I have more to do but I have bobbydurrettdba.com pointing to an Amazon EC2 virtual machine. Seems faster. I still have email forwarding done on iPage and they still have the domain registration and dns. I plan to work on … Continue reading →

I am moving this blog from iPage to AWS starting now. This page, bobbydurrettdba.com, might be down, or you might see certificate errors. This is just me. I will put up an all clear post when it is done. Bobby

I put together a quick testcase to show myself how to use DBMS_RLS on 11.2.0.4 to mask a column. If you would like to run it or see the output it is here: test case zip. I ran the test … Continue reading →

I did a little research yesterday and I am writing this post to document what I learned so I can remember it and since I could not easily find this information. I have a database that uses shared servers and … Continue reading →

I have some Python scripts that I use to access a bunch of databases to gather information such as the size of the database. Usually it is not that important how long they take so I have been running queries … Continue reading →

I guess I have had a desk in an office since around Summer 1990 when I first reported for work in San Bernardino. I have moved offices multiple times including across the country twice and did not have a desk … Continue reading →

Quick note to myself. If I am tuning a query by its SQL_ID I use these scripts: From AWR: findsql.sql – finds SQL_ID of queries that match certain strings sqlstat.sql – shows execution history of SQL_ID getplans.sql – shows all … Continue reading →

I wanted to write a quick post to document how to format nice columns in Python. Mainly I want to remember this myself and if I put it on my blog, I can find it quickly. There are probably better … Continue reading →

I resolved another production performance issue with a SQL Profile yesterday. I have several posts about SQL Profiles, so I do not want to be redundant, but this case was a little different because it was not clear that I … Continue reading →