DBMS_STREAMS_ADM.SET_TAGA 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.
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.
This morning while applying the most recent Database Bundle Patch (DBBP) the datapatch invocation finished with an error.
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.
ORA-8102 on ALTER TABLE SHRINK SPACE with default column optimizationEncountered ORA-8102 while executing a regular database maintenance routine.
This post analyzes the problem, builds a test case to reproduce it, and shows how the problem can be avoided.
V$SQL_PLAN_MONITOR.STARTS is higher than expected due to NLJ batching/PrefetchingRecently one of our developers asked me to explain why V$SQL_PLAN_MONITOR.STARTS is higher than expected for one particular query.
I have upgraded one of data warehouse databases from 11g to 12c this week and noticed changes in behaviour of the PX Auto DOP feature.
Encountered a wrong results issue caused by Bug 20214168 - Wrong Results using aggregations of CASE expression with fix of bug 20003240 present. This post discusses possible ways to get around it.
We use the DBaaS (Database as a Service) functionality of EM Cloud Control 12c. After facing with multiple issues, it was decided to update EM and install Oracle recommended plugins and patches. This post discusses the issues that I came across during the update exercise.
Materialized view log space is not decreased after materialized view refresh is done. This post discusses how to reclaim the space.