Author Archives: Bobby

I have been doing a lot of Oracle and PeopleSoft work this year, but I am trying to continue to develop my MySQL and Amazon Web Services (AWS) knowledge at the same time. My goal is to learn some new … Continue reading →

Quick post. I tried https://livesql.oracle.com/ for the first time. Looks like you can try out the latest version of Oracle for free. You can type in SQL statements in your web browser. There seem to be a boatload of scripts … Continue reading →

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 →