Subscribe to Blog via Email
Join 974 other subscribersArchives
Category Archives: Uncategorized
350 Second Timeout Causes ORA-03135 Errors in AWS DMS
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
Posted in Uncategorized
2 Comments
Docker Sample Application behind Zscaler
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
Posted in Uncategorized
2 Comments
350 second AWS timeout causes JDBC call to hang
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
Posted in Uncategorized
2 Comments
Do SET_AUDIT_TRAIL_LOCATION before INIT_CLEANUP
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
Posted in Uncategorized
2 Comments
Oracle 21c Laptop Install
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
Posted in Uncategorized
Leave a comment
Dropping sequences whose name starts with ISEQ$$
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
Posted in Uncategorized
Leave a comment
latch: shared pool waits after patching to 19.13
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
Posted in Uncategorized
10 Comments
Tweaked script to show top SQL by force matching signature
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
Posted in Uncategorized
2 Comments
Outline Hint from dbms_xplan does not contain PARALLEL hint
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
Posted in Uncategorized
Leave a comment
Tuning Example With Outline Hints and SQL Profile
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
Posted in Uncategorized
Leave a comment