Category Archives: Uncategorized

This is a follow up to an earlier post about the 350 second timeout that is built into Amazon Web Services’ (AWS) Gateway Load Balancer (GWLB). The earlier post was about Debezium (DBZ) using its Oracle Connector to pull data … Continue reading →

I am trying to learn about Docker by installing it on an Oracle Linux 7 VM on top of VirtualBox on my work laptop. My work laptop uses Zscaler. I had a bunch of certificate issues and ended up learning … Continue reading →

When I run the following Java program on an AWS EC2 Linux virtual machine connecting to an Oracle database in my company’s internal network it hangs forever. When I run it on a Linux machine on our internal network it … Continue reading →

This is all old stuff, but I want to record a simple thing I found. I was following Oracle’s support document for setting up audit table cleanup using the DBMS_AUDIT_MGMT package. I used this document: SCRIPT: Basic example to manage … Continue reading →

Finally got around to installing Oracle 21c on my laptop. I installed it on Oracle’s Linux version 7 running in VirtualBox. There are other posts out there, so I won’t get too detailed. I noticed this post: https://oracle-base.com/articles/21c/oracle-db-21c-installation-on-oracle-linux-7 But I … Continue reading →

We had an application that created 500,000 tables and 500,000 sequences and the vendor sent us a cleanup script that we thought would drop the tables but not the sequences. It took us a few attempts to get a cleanup … Continue reading →

I have been working hard on an issue that happened after we patched an Oracle database to the 19.13 patch set which just came out in October. The application experienced a ton of latch: shared pool waits, and the patch … Continue reading →

I just finished another production tuning exercise that is like two recent posts: Two New ASH FORCE_MATCHING_SIGNATURE scripts Tuning Example With Outline Hints and SQL Profile The biggest new thing was that I ran the ashtopelapsed.sql script that I mentioned … Continue reading →

I was tuning a parallel query and was a little surprised to find that an outline hint from EXPLAIN PLAN and dbms_xplan.display did not contain a PARALLEL hint. So, a query I was testing did not run in parallel with … Continue reading →

I tuned a production query this week using outline hints and a SQL profile. This is like other examples I have posted but may have enough differences to be worth documenting here. A query in a batch job was taking … Continue reading →