Oracle Data Guard, 1-10
configure IM column store, 13-5
Oracle Data Pump
In-Memory Column Store, 1-23
Oracle Database In-Memory
See Database In-Memory
Oracle Engineered Systems, 12-8, 12-10
Oracle Enterprise Manager Cloud Control
In-Memory Column Store, A-1
Oracle RAC, 12-1
Auto DOP, 12-12
deploying IM column stores, 12-1
distribution and duplication of data, 12-4
distribution by rowid, 12-7
distribution of partitions, 12-4, 12-5
distribution of subpartitions, 12-6
duplication, 12-8, 12-10, 12-11
IM column store, 12-1
IM FastStart, 12-13
In-Memory data affinity, 12-11
serial queries, 12-11
services, 12-14–12-16
shared-nothing architecture, 12-1
Oracle Real Application Clusters (Oracle RAC),
1-10, 12-1
See also Oracle RAC
P
parallel queries, 12-11, 12-12
Oracle RAC, 12-11
PARALLEL_DEGREE_LIMIT
initialization parameter,
12-12
PARALLEL_DEGREE_POLICY initialization
parameter, 12-11, 12-12
PARALLEL_INSTANCE_GROUP initialization
parameter, 12-14, 12-15, 13-5
PARALLEL_MIN_TIME_THRESHOLD
initialization
parameter, 12-12
partition exchange loads, 10-5
partitioned tables, 12-10, 12-11
distributing in Oracle RAC, 12-4–12-6
repopulating, 10-5
policies, ADO, 4-1, 4-11, 4-13
POPULATE procedure, 6-1, 6-6, 6-8
POPULATE_WAIT function, 6-1, 6-6, 6-8
population, In-Memory
about, 6-1, 6-5, 6-6, 6-8
forcing, 6-8
ineligible objects, 5-2
initiating, 6-1, 6-5, 6-6, 6-8
purpose, 5-1
primary databases, Active Data Guard, 13-1,
13-2, 13-5
prioritization, of In-Memory population, 5-6, 6-1,
11-5
PRIORITY clause of CREATE TABLE, 5-6, 11-5
Q
queries, analytic, 1-1, 1-2, 1-5, 1-8
query transformations
In-Memory Aggregation, 9-1
R
REPOPULATE procedure, 6-1, 6-8
repopulation
controlling, 10-10
data loading, 10-2
definition, 10-1
direct path loads, 10-4
double buffering, 10-3, 10-9
factors affecting, 10-9
IMEUs, 7-8
partition exchange load, 10-5
staleness threshold, 10-3
threshold-based, 10-3, 10-7
trickle, 10-3, 10-7
tutorial, 10-11
when it occurs, 10-7
REPORT_SQL_MONITOR_XML function, 8-12
row format, 2-1
rowids
distributing by in Oracle RAC, 12-7
S
SecureFiles LOBs, 11-1, 11-2
services, Oracle RAC, 12-14–12-17
SGA (system global area)
In-Memory Area, 1-2, 2-1, 3-1, 5-29
In-Memory Column Store, 2-1
SGA_TARGET initialization parameter, 2-5
SIMD, 2-28
SIMD vector processing, 1-5, 2-26, 2-27, 5-29,
9-1
SMUs
See Snapshot Metadata Units (SMUs)
Snapshot Metadata Units (SMUs), 2-17,
10-1–10-3, 10-7
In-Memory Compression Units (IMCUs), 2-17
transaction journals, 2-17
Space Management Worker Processes (Wnnn),
2-20, 6-5, 7-7, 10-7, 10-11, 11-1, 11-2
SRVCTL, 12-17
standby databases, Active Data Guard, 13-1,
13-2, 13-5
star queries, 8-1, 9-7, 12-10, 12-11
storage mirroring, 12-8
subpartitioned tables, 12-6
SYS_IME virtual columns, 7-4, 7-12
Index
Index-5