Interval-Reference-Partitioning: Partition-Merge and Row-Movement
As often, I use this blog to answer questions of training participants. This time, it’s the question what happens on interval-reference-partitioned tables when merging partitions or when updates cause row movement.
Which node is the OCR master node (AKA “OCR writer”) in a RAC?
There are several ways to answer this question: Look for “OCR master” in the log files of crsd and check olsnodes for the node ID Check which node did the most recent automatic OCR backup
ORACLE_MAINTAINED database users, part 2
Some time ago I wrote on ORACLE_MAINTAINED database users in Oracle 12c. Next question is: how are these users connected to database features and can the users be dropped – and if yes, how?