Author Archives: Bobby

I noticed that Oracle database 19.3 was available to download so I installed it on a Linux VM under VirtualBox. I cloned my base Oracle Linux 7 VM and did a yum -y update to get it up to the … Continue reading →

This is our last Meetup until our Summer break. Come check out two great presentations. Doug Hood from Oracle will talk about the Oracle In-Memory database feature. We appreciate Oracle providing us with this technical content to support AZORA. AZORA’s … Continue reading →

Monday, I used the coe_xfr_sql_profile.sql script from Oracle Support’s SQLT scripts to resolve a performance issue. I had to set the parameter force_match to TRUE so that the SQL Profile I created would apply to all SQL statements with the … Continue reading →

Back in 2017 I wrote about how I had to disable the result cache after upgrading a database to 11.2.0.4. This week I found one of our top queries and it looked like removing the result cache hints made it … Continue reading →

We had issues deploying changes to a large web farm a few weeks back. We had automated the startup of the 25 web servers using a DevOps tool but when it tried to bring them all up at once it … Continue reading →

I could not create a new Delphix virtual database because I kept getting semaphore limit errors. I ended up reducing the processes parameter value to resolve the issue. I got these errors creating the new VDB: ERROR : SQL> ORA-27154: … Continue reading →

I wrote a Python program that made some fun pictures so I thought I would share them even though this is not really a database post. I practice Python programming by doing Rosetta Code programming tasks that no one has … Continue reading →

Looking at cloud databases has me thinking about the speed of light. Wikipedia says that the speed of light is about 186,000 miles per second. If my calculations are correct that is 5.37 microseconds per mile. The United States is … Continue reading →

I pushed out three new Python scripts that might be helpful to Oracle DBAs. They are in my miscpython repository. remotescript.py – run Unix/Linux commands on a remote server dbversion.py – Get the version from a database – i.e. 11.2.0.4 … Continue reading →

Here are the slides from our March Arizona Oracle User Group (AZORA) meeting: Daniel Morgan Security Master Class We really appreciate Daniel Morgan taking the time to share this information about the increasingly important topic of database security. Also, AZORA … Continue reading →