Author Archives: Bobby

I was on call again last week and Sunday night I used a SQL Profile to fix a performance problem. We rolled out some updates Saturday night and the modified query ran fine in some cases, but others ran for … Continue reading →

We have the slides from the two talks at our May 17th AZORA Meetup. Here are Stephen Andert’s slides: Networking is NOT just cables and fiber! Here are Doug Hood’s slides in three parts: Using SQL and PLSQL for Mid-Tier … Continue reading →

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 →