Submitted by dave on Thu, 07/10/2025 - 11:47
Analysis of a slow replication configuration can be daunting. There are a lot of moving parts and it may not be clear where bottlenecks are appearing.
For traditional GoldenGate configurations, each Replicat process creates 1 connection to the database. If a replicat is consistently showing lag times, a performance check may be needed. This performance check can be made by using information from Replicat process and the Database the process is running against.
Submitted by dave on Mon, 11/25/2024 - 14:45
I’ve seen it done on Oracle before like replicating 11 -> 10 or 11->9. The intermediate format for GoldenGate has been standard forever, so as long as you have GG binaries certified to connect to each database then theoretically it should be possible to get them to interact with these intermediate files and extract or replicate as needed.
Submitted by dave on Mon, 09/30/2024 - 16:16
I'm a fan of SQL Developer, have been for years. I especially like User Defined Reports.
Time for some shameless self promotion!
- Here is a presentation I gave to East Coast OUG on 2014 - SQL Developer Reporting. It covers general SQL Developer reporting features and a deep dive into User Defined Reports.
Submitted by dave on Wed, 02/14/2024 - 16:10
Certificates can be a pain.
So if you're trying to use UTL_HTTP or APEX_WEB_SERVICE to reach https destinations you'll be on the hook for obtaining certificates for the target server.
I had access to all the certificates separately and loaded them into a nice fresh new wallet. Unfortunately I couldn't get this to work. I'm working an SR with Oracle now but there doesn't seem to be much expertise on troubleshooting issues, even with
Submitted by dave on Fri, 12/22/2023 - 11:59
General form
#!/bin/bash
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
export ORACLE_SID=orclcdb1
export PATH=$ORACLE_HOME/bin:$PATH
while [ true ]
do
sqlplus -s / as sysdba >> output.txt << EOF
SELECT * FROM DUAL;
EXIT
EOF
sleep 10
done
Session Serialization Example
Submitted by dave on Mon, 06/19/2023 - 12:43
A script to check the query execution time as well as the time to retrieve all records via a FOR cur IN construct:
Submitted by dave on Wed, 04/27/2022 - 10:16
I run a few websites from a VM on my Synology NAS. The VM has the typical LAMP setup for running Wordpress and Drupal sites. As it is not exposed directly to the internet, Apache serves up all sites on port 80 and I configured the Synology "Application Portal" to forward both port 80/443 requests to it. Application Portal (nginx behind the curtain) also provides handling of SSL Certs on port 443.
So I created 2 Synology Application Portal entries - one to for serving up incoming 80 to ApacheHost:80, and one for serving up incoming 443 to ApacheHost:80.
Submitted by dave on Wed, 11/10/2021 - 11:35
I opened an SR recently while I was trying to get a feature to work in 19c... was politely directed to this resource... A listing of Oracle features and what version they're available in...
Not sure when this was made available but I hope they keep it up - I much prefer this to trying to find this info in My Oracle Support docs.
Apex App - Features and Licensing Lookup
Pages
