Category Archives: Rac

FAN callouts for In-Memory Instance distribution with RAC, PDB and preferred/available service

The context: In my previous blog post: In-Memory Instance distribution with RAC and Multitenant Environment, I checked if we can influence (get rid of the default behaviour) how the In-Memory is distributed across all the Instances per PDB. I checked because: … Continue reading

Posted in In-Memory, Rac | 1 Comment

In-Memory Instance distribution with RAC and Multitenant Environment

In a previous post (see In-Memory Instance distribution with RAC databases: I want at least one instance that contains all the data) I provided a way to get rid of the default In-Memory Instance distribution on a RAC (non CDB) … Continue reading

Posted in In-Memory, Rac | 1 Comment

In-Memory Instance distribution with RAC databases: I want at least one instance that contains all the data

As you may know, with a RAC database, by default all objects populated into In-memory will be distributed across all of the IM column stores in the cluster. It is also possible to have all the data appear in the … Continue reading

Posted in In-Memory, Rac | 3 Comments

Watch out for optimizer_adaptive_features as It may have a huge negative impact

Let me describe how I discovered that the optimizer_adaptive_features may have a huge negative impact (specially on RAC databases). I upgraded a 11gR2 database to 12.1.0.2 and then I converted this database to a PDB. To do so I launched … Continue reading

Posted in Performance, Rac | 7 Comments

Issue installing the 11gR2 database software after the 12.1.0.2 clusterware setup

If you don’t plan to install the 11gR2 database software after a 12.1.0.2 clusterware installation, I guess there is no need for you to read this post. I just want to share the issue I got and the way you could … Continue reading

Posted in Rac | 1 Comment

Modify the Private Network Information in Oracle Clusterware with HAIP in place

The MOS note “How to Modify Private Network Information in Oracle Clusterware (Doc ID 283684.1)” explains how to change the private Network information with the interconnect made of a single interface (then producing downtime). So what’s about changing the interconnect … Continue reading

Posted in Rac | Leave a comment

RAC Attack at Oracle OpenWorld 2013: Don’t be afraid !

You’ll attend Oracle OpenWorld 2013 and: You want to install a 12c RAC using oracle Virtual Box on your laptop. Or you just want to have a talk or share your experience with some people around this technology. So, you … Continue reading

Posted in Rac | Leave a comment