In-memory Column Store and Distribute for Service Options in Oracle 12cR2 Database
Distribute for Service: A New Feature in (12cR2) Today, we are going to understand a new feature introduced in Oracle Database 12cR2. The feature is called, Distribute for Service. What this new feature allows you to do, is to limit the objects/tables getting populated into a in-memory column store in a RAC environment. By Default in a RAC environment, a table or an object is broken up into pieces and each piece is populated into a in-memory column store across the RAC cluster. If you do not want to allow this, and may be you want to have the application access a specific RAC node, where this table as a whole is populated, then you can use distribute for service feature combined with service specific features of Oracle RAC environment. Let us consider a 2-node RAC environment which has 3 services. ( IM1, IM2 & IM_ALL ) IM1 runs on only node 1 IM2 runs on only node 2 IM_ALL runs on node1 and node2 There is a global view called, "gv$im_segments...