A lot of log.* files in dirbdb directory
After adding ENABLEMONITORING in the GLOBALS file, I noticed that the $OGG_HOME/dirbdb directory started growing.
2016¶
A lot of
Excluding DDL in Integrated Extract using DBMS_STREAMS_ADM.SET_TAG
A couple of months ago I had to configure an Oracle GoldenGate Integrated Extract to exclude specific DDL statements from replication.
Having worked a lot with Oracle Streams, I decided to utilize DBMS_STREAMS_ADM.SET_TAG for that task.
Incorrect handling of unused columns during GoldenGate initial load using Direct Bulk Load to SQL*Loader
Today I faced an interesting issue performing a GoldenGate initial load with a Direct Bulk Load to SQL*Loader. The issue was related to the incorrect handling of unused columns during such loads and can cause incorrect data getting loaded into a database under certain conditions.
opatch and libpicl on Solaris SPARC
This morning while applying the most recent Database Bundle Patch (DBBP) the datapatch invocation finished with an error.
Asynchronous Global Index Maintenance effects
I think Asynchronous Global Index Maintenance is one of the most exciting features in Oracle Database 12c. This post is about one particular case when that feature can cause performance issues.