opatch and libpicl on Solaris SPARC
This morning while applying the most recent Database Bundle Patch (DBBP) the datapatch invocation finished with an error.
Oracle¶
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.
ORA-8102 on ALTER TABLE SHRINK SPACE with default column optimization
Encountered 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/Prefetching
Recently one of our developers asked me to explain why V$SQL_PLAN_MONITOR.STARTS is higher than expected for one particular query.
12c: PX Auto DOP without IO Calibration
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.
Bug 20214168 - Wrong Results using aggregations of CASE expression with fix of bug 20003240 present
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.
EM 12.1.0.4 Installing recommended plugins and patches
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.
Reclaim unused space from MLOG$ segments after materialized view refresh
Materialized view log space is not decreased after materialized view refresh is done. This post discusses how to reclaim the space.
Edition-based redefinition: adjunct schemas
In this blog post I would like to describe one of the basic component of Edition-based redefinition (EBR): adjunct schemas.
Function-Based index changed its definition after a rebuild
One of our developers has discovered a problem when an index column's data type changed after the index was rebuilt.