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.
In this blog post I would like to describe one of the basic component of Edition-based redefinition (EBR): adjunct schemas.
One of our developers has discovered a problem when an index column's data type changed after the index was rebuilt.
I have recently investigated an issue with high session cursor cache count statistics in one of 11.2.0.4 databases.
I found that some of sessions have extremely high values of these statistics.
Found a case when a query joining parent and child tables did not eliminate the parent table when it seemingly could.