Skip Headers
Oracle® Database VLDB and Partitioning Guide
12c Release 1 (12.1)

E17613-20
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X 

A

adaptive algorithm, 8.2.3.5
ADD PARTITION clause, 4.2.4.1
ADD SUBPARTITION clause, 4.2.4.5.2, 4.2.4.6.2, 4.2.4.7.2
adding ILM policies
for Automatic Data Optimization, 5.2.2.1
adding index partitions, 4.2.4.9
adding multiple partitions, 4.2.4.10
adding partitions
composite hash-partitioned tables, 4.2.4.5
composite list-partitioned tables, 4.2.4.6
composite range-partitioned tables, 4.2.4.7
hash-partitioned tables, 4.2.4.2
interval-partitioned tables, 4.2.4.4
list-partitioned tables, 4.2.4.3
partitioned tables, 4.2.4
range-partitioned tables, 4.2.4.1
reference-partitioned tables, 4.2.4.8
ALTER INDEX statement
for maintaining partitioned indexes, 4.2.1
partition attributes, 3.3.7
ALTER SESSION statement
ENABLE PARALLEL DML clause, 8.3.3.2
FORCE PARALLEL DDL clause, 8.3.2.7.1, 8.3.5.1
create or rebuild index, 8.3.2.8.1, 8.3.5.1
create table as select, 8.3.2.9.3, 8.3.5.1
move or split partition, 8.3.2.8.2, 8.3.5.1
FORCE PARALLEL DML clause
insert, 8.3.3.4, 8.3.3.4.1, 8.3.5.1
update and delete, 8.3.3.3, 8.3.3.3.1, 8.3.5.1
ALTER TABLE statement
for maintaining partitions, 4.2.1
MODIFY DEFAULT ATTRIBUTES clause, 4.2.9.1
MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause, 4.2.9.2, 4.2.9.3
NOLOGGING clause, 8.7.5.2
APPEND hint, 8.7.5.2
applications
decision support system (DSS)
parallel SQL, 8.3.2.2
direct-path INSERT, 8.3.3.1.4
parallel DML operations, 8.3.3.1
ARCH processes
multiple, 8.7.3.5
asynchronous communication
parallel execution servers, 8.2.2
asynchronous global index maintenance
for dropping and truncating partitions, 4.2.3
asynchronous I/O, 8.5.3.4
Automatic Data Optimization
adding ILM policies, 5.2.2.1
DBMS_ILM package, 5.2.2.5
DBMS_ILM_ADMIN package, 5.2.2.5
deleting ILM policies, 5.2.2.1
disabling ILM policies, 5.2.2.1
for Information Lifecycle Management strategy, 5.2.2
ILM ADO parameters, 5.2.2.4
limitations, 5.2.3
managing ILM policies, 5.2.2.1
managing with Oracle Enterprise Manager, 5.5
monitoring DBA and ILM policy views, 5.2.2.6
row-level compression tiering, 5.2.2.3
segment-level compression tiering, 5.2.2.2
views for ILM policies, 5.2.2.6

B

bigfile tablespaces
very large databases (VLDBs), 10.2.5
binary XML tables
partitioning of XMLIndex, 4.1.16.2

C

clusters
cannot be partitioned, 1
indexes on cannot be partitioned, 1
COALESCE PARTITION clause, 4.2.5.1
collection tables
performing PMOs on partitions, 4.1.16.1
collections
tables, 4.1.16.1
XMLType, 2.1.8, 4.1.16
composite hash-hash partitioning, 2.3.2.7
composite hash-partitioned tables
adding partitions, 4.2.4.5
composite interval partitioning
creating tables using, 4.1.7.5
composite list partitioning
creating tables using, 4.1.7.4
composite list-hash partitioning, 2.3.2.5
performance considerations, 3.5.4.4
composite list-list partitioning, 2.3.2.6
performance considerations, 3.5.4.5
composite list-partitioned tables
adding partitions, 4.2.4.6
composite list-range partitioning, 2.3.2.4
performance considerations, 3.5.4.6
composite partitioned tables
creating, 4.1.7
composite partitioning, 2.3.2, 2.3.2
default partition, 4.1.7.2
interval-hash, 4.1.7.5.1
interval-list, 4.1.7.5.2
interval-range, 4.1.7.5.3
list-hash, 4.1.7.4.1
list-list, 4.1.7.4.2
list-range, 4.1.7.4.3
performance considerations, 3.5.4
range-hash, 4.1.7.1
range-list, 4.1.7.2
range-range, 4.1.7.3, 4.1.7.3
subpartition template, modifying, 4.2.13
composite range-hash partitioning, 2.3.2.2
performance considerations, 3.5.4.1
composite range-list partitioning, 2.3.2.3
performance considerations, 3.5.4.2
composite range-partitioned tables
adding partitions, 4.2.4.7
composite range-range partitioning, 2.3.2.1
performance considerations, 3.5.4.3
compression
partitioning, 3.4
compression table
partitioning, 3.4, 3.4
concurrent execution of union all, 8.3.3.14
constraints
parallel create table, 8.3.2.9
consumer operations, 8.2.1.3
CREATE INDEX statement, 8.7.4
partition attributes, 3.3.7
partitioned indexes, 4.1.1.2
rules of parallelism, 8.3.2.8.1
CREATE TABLE AS SELECT statement
decision support system, 8.3.2.2
rules of parallelism and index-organized tables, 8.3.2.1
CREATE TABLE statement
AS SELECT
rules of parallelism, 8.3.2.9
space fragmentation, 8.3.2.6
temporary storage space, 8.3.2.5
creating partitioned tables, 4.1.1
parallelism, 8.3.2.2
parallelism and index-organized tables, 8.3.2.1
creating hash partitioned tables
examples, 4.1.3.1
creating indexes on partitioned tables
restrictions, 2.5.5
creating interval partitions
INTERVAL clause of CREATE TABLE, 4.1.2
creating partitions, 4.1
creating segments on demand
maintenance procedures, 4.1.13.3
critical consumer group
specifying for parallel statement queuing, 8.2.4.1.5

D

data
parallel DML restrictions and integrity rules, 8.3.3.10
data loading
incremental in parallel, 8.7.6
data manipulation language
parallel DML operations, 8.3.3
transaction model for parallel DML operations, 8.3.3.5
data segment compression
bitmap indexes, 3.4.1
example, 3.4.2
partitioning, 3.4
data warehouses
about, 6.1
advanced partition pruning, 6.3.1.2
ARCHIVELOG mode for recovery, 9.4.1
backing up and recovering, 9.1
backing up and recovering characteristics, 9.1.1
backing up tables on individual basis, 9.4.7
backup and recovery, 9.3
basic partition pruning, 6.3.1.1
block change tracking for backups, 9.4.3
data compression and partitioning, 6.4.4
differences with online transaction processing backups, 9.1.1
extract, transform, and load for backup and recovery, 9.4.6.1
extract, transform, and load strategy, 9.4.6.2
flashback database and guaranteed restore points, 9.4.6.5
incremental backup strategy, 9.4.6.4
incremental backups, 9.4.6.3
leverage read-only tablespaces for backups, 9.4.5
manageability, 6.4
manageability with partition exchange load, 6.4.1
materialized views and partitioning, 6.3.4
more complex queries, 6.2.4
more users querying the system, 6.2.3
NOLOGGING mode for backup and recovery, 9.4.6
partition pruning, 6.3.1
partitioned tables, 3.5.1
partitioning and removing data from tables, 6.4.3
partitioning for large databases, 6.2.1
partitioning for large tables, 6.2.2
partitioning for scalability, 6.2
partitioning materialized views, 6.3.4.1
partitioning, and, 6
recovery methodology, 9.4
recovery point object (RPO), 9.3.2
recovery time object (RTO), 9.3.1
refreshing table data, 8.3.3.1.1, 8.3.3.1.1
RMAN for backup and recovery, 9.4.2
RMAN multi-section backups, 9.4.4
database writer process (DBWn)
tuning, 8.7.3.6
databases
partitioning, and, 1.4
scalability, 8.3.3.1
DB_BLOCK_SIZE initialization parameter
parallel query, 8.5.3.2
DB_CACHE_SIZE initialization parameter
parallel query, 8.5.3.1
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter
parallel query, 8.5.3.3
DBMS_HEAT_MAP package
subprograms for Heat MAP, 5.2.1.3
DBMS_ILM package
Automatic Data Optimization, 5.2.2.5
DBMS_ILM_ADMIN package
Automatic Data Optimization, 5.2.2.5
decision support system (DSS)
parallel DML operations, 8.3.3.1
parallel SQL, 8.3.2.2, 8.3.3.1
performance, 8.3.3.1
scoring tables, 8.3.3.1.3
DEFAULT keyword
list partitioning, 4.1.4
default partitions, 4.1.4
default subpartition, 4.1.7.2
deferred segments
partitioning, 4.1.13.1
degree of parallelism, 8.3.3.3.2
adaptive parallelism, 8.2.3.5
automatic, 8.2.3.2
between query operations, 8.2.1.3
controlling with initialization parameters and hints, 8.2.3.3
controlling with the NO_PARALLEL hint, 8.2.3.3.2
controlling with the PARALLEL hint, 8.2.3.3.2
in-memory parallel execution, 8.2.3.4
manually specifying, 8.2.3.1
maximum query directive, 8.3.1.5.2
parallel execution servers, 8.2.3
PARALLEL_DEGREE_POLICY initialization parameter, 8.2.3.6
setting DOP with ALTER SESSION statements, 8.2.3.3.1
specifying a limit for a consumer group, 8.2.4.1.4
DELETE statement
parallel DELETE statement, 8.3.3.3
deleting ILM policies
for Automatic Data Optimization, 5.2.2.1
direct-path INSERT
restrictions, 8.3.3.9
DISABLE ROW MOVEMENT clause, 4.1
disabling ILM policies
for Automatic Data Optimization, 5.2.2.1
DISK_ASYNCH_IO initialization parameter
parallel query, 8.5.3.4
distributed transactions
parallel DML restrictions, 8.3.3.12
DROP PARTITION clause, 4.2.6.1
dropping multiple partitions, 4.2.6.4
dropping partitioned tables, 4.3
dropping partitions
asynchronous global index maintenance, 4.2.3
marked UNUSABLE, 4.2.6.3
DSS database
partitioning indexes, 3.3.6

E

ENABLE ROW MOVEMENT clause, 4.1, 4.1.1.1
equipartitioning
examples, 3.3.1.1
local indexes, 3.3.1
EXCHANGE PARTITION clause, 4.2.7.1, 4.2.7.7, 4.2.7.8, 4.2.7.9, 4.2.7.10, 4.2.8
EXCHANGE SUBPARTITION clause, 4.2.7.6
exchanging partitions
cascade option, 4.2.7.11
marking indexes UNUSABLE, 4.2.7
EXPLAIN PLAN statement
query parallelization, 8.7.2
extents
parallel DDL statements, 8.3.2.6
extract, transform, and load
data warehouses, 9.4.6.1

F

FAST_START_PARALLEL_ROLLBACK initialization parameter, 8.5.2.3.2
features
new for VLDBs, Preface
FOR PARTITION clause, 4.2.10.1
fragmentation
parallel DDL, 8.3.2.6
FREELISTS parameter, 8.7.3.4
full partition-wise joins, 3.2.1, 6.3.2.1
composite - composite, 3.2.1.3
composite - single-level, 3.2.1.2
single-level - single-level, 3.2.1.1
full table scans
parallel execution, 8.1.2
functions
parallel DML and DDL statements, 8.3.4.2
parallel execution, 8.3.4
parallel queries, 8.3.4.1

G

global hash partitioned indexes
about, 2.5.3.2
global indexes
marked UNUSABLE, 4.2.6.1
partitioning, 3.3.2, 3.3.2.2
summary of index types, 3.3.3
global nonpartitioned indexes
about, 2.5.4
global partitioned indexes
about, 2.5.3
maintenance, 2.5.3.3
global range partitioned indexes
about, 2.5.3.1
granules, 8.2.6
groups
instance, 8.2.8.1

H

hardware-based mirroring
very large databases (VLDBs), 10.1.1
hardware-based striping
very large databases (VLDBs), 10.2.1
hash partitioning, 2.3.1.2
creating global indexes, 4.1.3.2
creating tables examples, 4.1.3.1
creating tables using, 4.1.3
index-organized tables, 4.1.14.2
multicolumn partitioning keys, 4.1.9
performance considerations, 3.5.2
hash partitions
splitting, 4.2.17.4
hash-partitioned tables
adding partitions, 4.2.4.2
heap-organized partitioned tables
table compression, 4.1.11
Heat Map
ALL, DBA, USER, and V$ views, 5.2.1.2
disabling, 5.2.1.1
enabling, 5.2.1.1
for Information Lifecycle Management strategy, 5.2.1
limitations, 5.2.3
managing with DBMS_HEAT_MAP subprograms, 5.2.1.3
managing with Oracle Enterprise Manager, 5.5
viewing tracking information, 5.2.1.2
HEAT_MAP initialization parameter
disabling, 5.2.1.1
enabling, 5.2.1.1
hints
APPEND, 8.7.5.2
NOAPPEND, 8.7.5.2
PARALLEL, 8.7.5.1
parallel statement queuing, 8.2.4.3
Hybrid Columnar Compression
example, 3.4.2

I

ILM
See Information Lifecycle Management
ILM policies
for Automatic Data Optimization, 5.2.2.1
implementing an ILM system
manually with partitioning, 5.4
using Oracle Database, 5.1.2
In-Database Archiving
limitations, 5.3.3
managing data visibility, 5.3.1
ORA_ARCHIVE_STATE, 5.3.1
ROW ARCHIVAL VISIBILITY, 5.3.1
index partitions
adding, 4.2.4.9
index subpartitions
marked UNUSABLE, 4.2.10.1
indexes
cluster cannot be partitioned, 1
creating in parallel, 8.7.4
global partitioned, 6.3.3.3
global partitioned indexes, 3.3.2
managing partitions, 3.3.2.2
local indexes, 3.3.1
local partitioned, 6.3.3.1
manageability with partitioning, 6.4.2
nonpartitioned, 6.3.3.2
parallel creation, 8.7.4, 8.7.4, 8.7.4
parallel DDL storage, 8.3.2.6
parallel local, 8.7.4
partitioned, 6.3.3
partitioning, 3.3
partitioning guidelines, 3.3.6
partitions, 1.1
updating automatically, 4.2.2
updating global indexes, 4.2.2
when to partition, 2.1.3.2
index-organized tables
hash-partitioned, 4.1.14.2
list-partitioned, 4.1.14.3
parallel CREATE, 8.3.2.1
parallel queries, 8.3.1.1
partitioning, 4.1, 4.1.14
partitioning secondary indexes, 4.1.14.1
range-partitioned, 4.1.14.1
Information Lifecycle Management
about, 5.1
application transparency, 5.1.1
assigning classes to storage tiers, 5.1.2.2.1
auditing, 5.1.2.4.4
benefits of an online archive, 5.1.1.3
controlling access to data, 5.1.2.3.1
creating data access, 5.1.2.3
creating migration policies, 5.1.2.3
creating storage tiers, 5.1.2.2
data retention, 5.1.2.4.1
defining compliance policies, 5.1.2.4
defining data classes, 5.1.2.1
enforceable compliance policies, 5.1.1
enforcing compliance policies, 5.1.2.4
expiration, 5.1.2.4.5
fine-grained, 5.1.1
immutability, 5.1.2.4.2
implemented with Automatic Data Optimization, 5.2.2
implementing a system manually with partitioning, 5.4
implementing using Oracle Database, 5.1.2
implementing with Heat Map, 5.2.1
introduction, 5
lifecycle of data, 5.1.2.1.2
limitations, 5.2.3
low-cost storage, 5.1.1
moving data using partitioning, 5.1.2.3.2
Oracle Database, and, 5.1.1
partitioning, 5.1.2.1.1
partitioning, and, 1.3
privacy, 5.1.2.4.3
regulatory requirements, 5.1.1.2
striping, 10.2.3
structured and unstructured data, 5.1.1.1
initialization parameters
FAST_START_PARALLEL_ROLLBACK, 8.5.2.3.2
MEMORY_MAX_TARGET, 8.5.2
MEMORY_TARGET, 8.5.2
PARALLEL_EXECUTION_MESSAGE_SIZE, 8.5.2.1, 8.5.2.2
PARALLEL_FORCE_LOCAL, 8.5.1.1
PARALLEL_MAX_SERVERS, 8.5.1.2
PARALLEL_MIN_PERCENT, 8.5.1.3
PARALLEL_MIN_SERVERS, 8.2.5, 8.5.1.4
PARALLEL_MIN_TIME_THRESHOLD, 8.5.1.5
PARALLEL_SERVERS_TARGET, 8.5.1.6
SHARED_POOL_SIZE, 8.5.1.7
TIMED_STATISTICS, 8.6.1.6
TRANSACTIONS, 8.5.2.3.1
INSERT statement
functionality, 8.7.5.1
parallelizing INSERT SELECT, 8.3.3.4
instance groups
for parallel operations, 8.2.8.1
limiting the number of instances, 8.2.8.1
integrity rules
parallel DML restrictions, 8.3.3.10
interval partitioned tables
dropping partitions, 4.2.6.2
interval partitioning
creating tables using, 4.1.2
manageability, 2.4.1.1
performance considerations, 3.5.1, 3.5.5
interval-hash partitioning
creating tables using, 4.1.7.5.1
subpartitioning template, 4.1.8.1
interval-list partitioning
creating tables using, 4.1.7.5.2
subpartitioning template, 4.1.8.2
interval-partitioned tables
adding partitions, 4.2.4.4
splitting partitions, 4.2.17.3
interval-range partitioning
creating tables using, 4.1.7.5.3
interval-reference partitioned tables
creating, 4.1.6
I/O
asynchronous, 8.5.3.4
parallel execution, 8.1.1
I/O calibration
PARALLEL_DEGREE_POLICY initialization parameter, 8.2.3.6

J

joins
full partition-wise, 3.2.1
partial partition-wise, 3.2.2, 3.2.2
partition-wise, 3.2

K

key compression
partitioning indexes, 4.1.12

L

list partitioning, 2.3.1.3
adding values to value list, 4.2.11
creating tables using, 4.1.4
DEFAULT keyword, 4.1.4
dropping values from value-list, 4.2.12
index-organized tables, 4.1.14.3
performance considerations, 3.5.3
list-hash partitioning
creating tables using, 4.1.7.4.1
subpartitioning template, 4.1.8.1
list-list partitioning
creating tables using, 4.1.7.4.2
subpartitioning template, 4.1.8.2
list-partitioned tables
adding partitions, 4.2.4.3
splitting partitions, 4.2.17.2, 4.2.17.5
list-range partitioning
creating tables using, 4.1.7.4.3
LOB data types
restrictions on parallel DDL statements, 8.3.2.1
restrictions on parallel DML operations, 8.3.3.9, 8.3.3.9
local index subpartitions
marking indexes UNUSABLE, 4.2.10.2
local indexes, 3.3.1, 3.3.3
equipartitioning, 3.3.1
local partitioned indexes
about, 2.5.2
LOGGING clause, 8.7.3.7
logging mode
parallel DDL, 8.3.2.1, 8.3.2.3

M

maintenance operations
on index partitions, 4.2.1
on partitioned tables, 4.2.1
manageability
data warehouses, 6.4
managing data validity
Temporal Validity, 5.3.2
managing data visibility
In-Database Archiving, 5.3.1
managing ILM policies
for Automatic Data Optimization, 5.2.2.1
materialized views
partitioned, 1
maximum query directive
degree of parallelism, 8.3.1.5.2
memory
configure at 2 levels, 8.5.2
MEMORY_MAX_TARGET initialization parameter, 8.5.2
MEMORY_TARGET initialization parameter, 8.5.2
merging multiple partitions, 4.2.8.7
MINIMUM EXTENT parameter, 8.3.2.6
mirroring with Oracle ASM
very large databases (VLDBs), 10.1.2
MODIFY DEFAULT ATTRIBUTES clause, 4.2.10.1
using for partitioned tables, 4.2.9.1
MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause
of ALTER TABLE statement, 4.2.9.2, 4.2.9.3
MODIFY PARTITION clause, 4.2.10.1, 4.2.10.2, 4.2.14, 4.2.15.2.2
MODIFY SUBPARTITION clause, 4.2.10.3
modifying partition attributes
marking indexes UNUSABLE, 4.2.10.1
monitoring
parallel processing, 8.6.1
MOVE PARTITION clause, 4.2.10, 4.2.14
MOVE PARTITION statement
rules of parallelism, 8.3.2.8.2
MOVE SUBPARTITION clause, 4.2.10, 4.2.14.2
multiple archiver processes, 8.7.3.5, 8.7.3.5
multiple block sizes
restrictions on partitioning, 4.1.15
multiple partitions
adding, 4.2.4.10
dropping, 4.2.6.4
merging, 4.2.8.7
splitting, 4.2.17.8
truncating, 4.2.18.4
multitenant container databases
parallel statement queuing, 8.2.4.1.6

N

NO_STATEMENT_QUEUING
parallel statement queuing hint, 8.2.4.3
NOAPPEND hint, 8.7.5.2
NOARCHIVELOG mode, 8.7.3.7
NOLOGGING clause, 8.7.3.7, 8.7.4
parallel execution
with APPEND hint, 8.7.5.2
NOLOGGING mode
parallel DDL, 8.3.2.1, 8.3.2.3
nonpartitioned indexes, 6.3.3.2
nonprefixed indexes, 2.5.2, 3.3.1.2
global partitioned indexes, 3.3.2.1
nonprefixed indexes_importance, 3.3.4

O

object types
parallel queries, 8.3.1.4
restrictions on parallel DDL statements, 8.3.2.1
restrictions on parallel DML operations, 8.3.3.9, 8.3.3.9
restrictions on parallel queries, 8.3.1.4
OLTP database
batch jobs, 8.3.3.1.5
parallel DML operations, 8.3.3.1
partitioning indexes, 3.3.6
Online Transaction Processing (OLTP)
about, 7.1
common partition maintenance operations, 7.3.3
partitioning, and, 7
when to partition indexes, 7.2.1
operating system statistics
monitoring for parallel processing, 8.6.4
optimization
partition pruning and indexes, 3.3.5
partitioned indexes, 3.3.5
optimizations
parallel SQL, 8.2.1
ORA_ARCHIVE_STATE
In-Database Archiving, 5.3.1
Oracle Automatic Storage Management settings
very large databases (VLDBs), 10.4
Oracle Database File System
very large databases (VLDBs), 10.2.6
Oracle Database Resource Manager
managing parallel statement queue, 8.2.4.1
Oracle Real Application Clusters
instance groups, 8.2.8.1

P

PARALLEL clause, 8.7.5.1, 8.7.5.3
PARALLEL CREATE INDEX statement, 8.5.2.3
PARALLEL CREATE TABLE AS SELECT statement
resources required, 8.5.2.3
parallel DDL statements, 8.3.2
extent allocation, 8.3.2.6
partitioned tables and indexes, 8.3.2.1
restrictions on LOBs, 8.3.2.1
restrictions on object types, 8.3.1.4, 8.3.2.1
parallel delete, 8.3.3.3
parallel DELETE statement, 8.3.3.3
parallel DML
considerations for parallel execution, 8.7.3
parallel DML and DDL statements
functions, 8.3.4.2
parallel DML operations, 8.3.3
applications, 8.3.3.1
degree of parallelism, 8.3.3.3.2
enabling PARALLEL DML, 8.3.3.2
recovery, 8.3.3.7
restrictions, 8.3.3.9
restrictions on LOB data types, 8.3.3.9
restrictions on object types, 8.3.1.4, 8.3.3.9, 8.3.3.9, 8.3.3.9
restrictions on remote transactions, 8.3.3.12
transaction model, 8.3.3.5
parallel execution
about, 8.1
adaptive parallelism, 8.2.3.5
bandwidth, 8.1.1
benefits, 8.1.1
considerations for parallel DML, 8.7.3
CPU utilization, 8.1.1
CREATE TABLE AS SELECT statement, 8.7.1
DB_BLOCK_SIZE initialization parameter, 8.5.3.2
DB_CACHE_SIZE initialization parameter, 8.5.3.1
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 8.5.3.3
default parameter settings, 8.4.1
DISK_ASYNCH_IO initialization parameter, 8.5.3.4
EXPLAIN PLAN statement, 8.7.2
forcing for a session, 8.4.2
full table scans, 8.1.2
functions, 8.3.4
fundamental hardware requirements, 8.1.3
index creation, 8.7.4
initializing parameters, 8.4
in-memory, 8.2.3.4
inter-operator parallelism, 8.2.1.3
intra-operator parallelism, 8.2.1.3
I/O, 8.1.1
I/O calibration, 8.2.3.6
I/O parameters, 8.5.3
massively parallel systems, 8.1.1
NOLOGGING clause, 8.7.1
parallel load, 8.3.5
parallel propagation, 8.3.5
parallel recovery, 8.3.5
parallel replication, 8.3.5
PARALLEL_DEGREE_POLICY initialization parameter, 8.2.3.6
parameters for establishing resource limits, 8.5.1
resource manager and statement queue, 8.1
resource parameters, 8.5.2
statement queue, 8.1
symmetric multiprocessors, 8.1.1
TAPE_ASYNCH_IO initialization parameter, 8.5.3.4
tuning general parameters, 8.5
tuning parameters, 8.4
using a resource plan, 8.1
when not to use, 8.1.2
PARALLEL hint, 8.7.5.1
UPDATE and DELETE, 8.3.3.3
parallel partition-wise joins
performance considerations, 6.3.2.4
parallel processing
monitoring operating system statistics, 8.6.4
monitoring session statistics, 8.6.2
monitoring system statistics, 8.6.3
monitoring with GV$FILESTAT view, 8.6.1
monitoring with performance views, 8.6.1
parallel queries, 8.3.1
functions, 8.3.4.1
index-organized tables, 8.3.1.1
object types, 8.3.1.4
restrictions on object types, 8.3.1.4
parallel query
parallelism type, 8.3.1
parallel server resources
limiting for a consumer group, 8.2.4.1.2
parallel servers
asynchronous communication, 8.2.2
parallel SQL
allocating rows to parallel execution servers, 8.2.1.1
instance groups, 8.2.8.1
number of parallel execution servers, 8.2.5
optimizer, 8.2.1
parallel statement queue
about, 8.2.4
grouping parallel statements, 8.2.4.2
hints, 8.2.4.3
limiting parallel server resources, 8.2.4.1.2
managing for CDBs and PDBs, 8.2.4.1.6
managing for consumer groups, 8.2.4.1
managing the order of dequeuing, 8.2.4.1.1
managing with Oracle Database Resource Manager, 8.2.4.1
NO_STATEMENT_QUEUING hint, 8.2.4.3
parallel execution, 8.1
PARALLEL_DEGREE_POLICY, 8.2.4
sample scenario for managing parallel statements, 8.2.4.1.7
setting order of parallel statements, 8.2.4.1
specifying a critical consumer group, 8.2.4.1.5
specifying a DOP limit for a consumer group, 8.2.4.1.4
specifying a timeout for a consumer group, 8.2.4.1.3
STATEMENT_QUEUING hint, 8.2.4.3
using BEGIN_SQL_BLOCK to group statements, 8.2.4.2
using with resource manager, 8.1
parallel statement queuing
PARALLEL_DEGREE_POLICY initialization parameter, 8.2.3.6
parallel update, 8.3.3.3
parallel UPDATE statement, 8.3.3.3
PARALLEL_DEGREE_POLICY initialization parameter
automatic degree of parallelism, 8.2.3.2
controlling automatic DOP, 8.2.3.3
degree of parallelism, 8.2.3.6
I/O calibration, 8.2.3.6
parallel execution, 8.2.3.6
parallel statement queuing, 8.2.3.6
PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 8.5.2.1, 8.5.2.2
PARALLEL_FORCE_LOCAL initialization parameter, 8.5.1.1
PARALLEL_MAX_SERVERS initialization parameter, 8.5.1.2
parallel execution, 8.5.1.2
PARALLEL_MIN_PERCENT initialization parameter, 8.5.1.3
PARALLEL_MIN_SERVERS initialization parameter, 8.2.5, 8.5.1.4
PARALLEL_MIN_TIME_THRESHOLD initialization parameter, 8.5.1.5
PARALLEL_SERVERS_TARGET initialization parameter, 8.5.1.6
parallelism
about, 8.1
adaptive, 8.2.3.5
degree, 8.2.3
inter-operator, 8.2.1.3
intra-operator, 8.2.1.3
other types, 8.3
parallel DDL statements, 8.3
parallel DML operations, 8.3
parallel execution of functions, 8.3
parallel queries, 8.3
types, 8.3
parallelization
methods for specifying precedence, 8.3.5.1
rules for SQL operations, 8.3.5.1
parameters
Automatic Data Optimization, 5.2.2.4
FREELISTS, 8.7.3.4
partial indexes
on partitioned tables, 2.5.6
partial partition-wise joins, 6.3.2.2
about, 3.2.2
composite, 3.2.2.2
single-level, 3.2.2.1
Partition Advisor
manageability, 2.4.1.2
partition bound
range-partitioned tables, 4.1.1.1
PARTITION BY HASH clause, 4.1.3
PARTITION BY LIST clause, 4.1.4
PARTITION BY RANGE clause, 4.1.1
for composite-partitioned tables, 4.1.7
PARTITION BY REFERENCE clause, 4.1.5
PARTITION clause
for composite-partitioned tables, 4.1.7
for hash partitions, 4.1.3
for list partitions, 4.1.4
for range partitions, 4.1.1
partition exchange load
manageability, 6.4.1
partition maintenance operations, 7.3.1, 7.3.2
merging older partitions, 7.3.3.2
moving older partitions, 7.3.3.2
Online Transaction Processing (OLTP), 7.3.3
removing old data, 7.3.3.1
partition pruning
about, 3.1
benefits, 3.1.1
collection tables, 3.1.6.3
data type conversions, 3.1.6.1
dynamic, 3.1.5
dynamic with bind variables, 3.1.5.1
dynamic with nested loop joins, 3.1.5.4
dynamic with star transformation, 3.1.5.3
dynamic with subqueries, 3.1.5.2
function calls, 3.1.6.2
identifying, 3.1.3
information for pruning, 3.1.2
PARTITION_START, 3.1.3
PARTITION_STOP, 3.1.3
static, 3.1.4
tips and considerations, 3.1.6
PARTITION_START
partition pruning, 3.1.3
PARTITION_STOP
partition pruning, 3.1.3
partitioned indexes, 4
about, 2.5
adding partitions, 4.2.4.9
composite partitions, 2.5.7
creating hash-partitioned global, 4.1.3.2
creating local index on composite partitioned table, 4.1.7.1
creating local index on hash partitioned table, 4.1.3.1
creating range partitions, 4.1.1.2
dropping partitions, 4.2.6.3
key compression, 4.1.12
maintenance operations, 4.2
maintenance operations that can be performed, 4.2.1
maintenance operations, table of, 4.2.1, 4.2.1
modifying partition default attributes, 4.2.9.3
modifying real attributes of partitions, 4.2.10.4
moving partitions, 4.2.14.3
Online Transaction Processing (OLTP), 7.2.1
rebuilding index partitions, 4.2.15
renaming index partitions/subpartitions, 4.2.16.3
secondary indexes on index-organized tables, 4.1.14.1
splitting partitions, 4.2.17.7
which type to use, 2.5.1
partitioned tables, 4
adding partitions, 4.2.4
adding subpartitions, 4.2.4.5.2, 4.2.4.6.2, 4.2.4.7.2
coalescing partitions, 4.2.5
creating composite, 4.1.7
creating composite interval, 4.1.7.5
creating composite list, 4.1.7.4
creating hash partitions, 4.1.3
creating interval partitions, 4.1.2
creating interval-hash partitions, 4.1.7.5.1
creating interval-list partitions, 4.1.7.5.2
creating interval-range partitions, 4.1.7.5.3
creating list partitions, 4.1.4
creating list-hash partitions, 4.1.7.4.1
creating list-list partitions, 4.1.7.4.2
creating list-range partitions, 4.1.7.4.3
creating range partitions, 4.1.1, 4.1.1.2
creating range-hash partitions, 4.1.7.1
creating range-list partitions, 4.1.7.2
creating range-range partitions, 4.1.7.3
creating reference partitions, 4.1.5
data warehouses, 3.5.1
DISABLE ROW MOVEMENT, 4.1
dropping, 4.3
dropping partitions, 4.2.6
ENABLE ROW MOVEMENT, 4.1
exchanging partitions and subpartitions, 4.2.7
exchanging partitions with a cascade option, 4.2.7.11
exchanging subpartitions, 4.2.7.6, 4.2.7.8, 4.2.7.10
global indexes, 7.3.2
incremental statistics and partition exchange operations, 4.2.7
index-organized tables, 4.1, 4.1.14.1, 4.1.14.2, 4.1.14.3
INTERVAL clause of CREATE TABLE, 4.1.2
interval-reference, 4.1.6
local indexes, 7.3.1
maintenance operations, 4.2
maintenance operations that can be performed, 4.2.1
maintenance operations with global indexes, 7.3.2
maintenance operations with local indexes, 7.3.1
marking indexes UNUSABLE, 4.2.4.2, 4.2.5, 4.2.8, 4.2.14, 4.2.17
merging partitions, 4.2.8
modifying default attributes, 4.2.9
modifying real attributes of partitions, 4.2.10
modifying real attributes of subpartitions, 4.2.10.3
moving partitions, 4.2.14
moving subpartitions, 4.2.14.2
multicolumn partitioning keys, 4.1.9
partition bound, 4.1.1.1
partitioning columns, 4.1.1.1
partitioning keys, 4.1.1.1
rebuilding index partitions, 4.2.15
redefining partitions online, 4.4
renaming partitions, 4.2.16
renaming subpartitions, 4.2.16.2
splitting partitions, 4.2.17
truncating partitions, 4.2.18
truncating partitions with the cascade option, 4.2.18.3
truncating subpartitions, 4.2.18.2
updating global indexes automatically, 4.2.2
partitioning
about, 1.1, 2
advantages, 1.1
availability, 2.2.3
availability, manageability, and performance, 3
basics, 2.1.1
benefits, 2.2
bitmap indexes, 3.4.1
collections in XMLType and object data, 2.1.8
composite, 2.3.2, 2.3.2
composite list-hash, 2.3.2.5
composite list-list, 2.3.2.6
composite list-range, 2.3.2.4
composite range-hash, 2.3.2.2
composite range-list, 2.3.2.3
composite range-range, 2.3.2.1
concepts, 2
creating a partitioned index, 4.1
creating a partitioned table, 4.1
creating indexes on partitioned tables, 2.5.5
data segment compression, 3.4, 3.4.1
data segment compression example, 3.4.2
data warehouses and scalability, 6.2
data warehouses, and, 6
databases, and, 1.4
default partition, 4.1.4
default subpartition, 4.1.7.2
deferred segments, 4.1.13.1
extensions, 2.4
global hash partitioned indexes, 2.5.3.2
global indexes, 3.3.2
global nonpartitioned indexes, 2.5.4
global partitioned indexes, 2.5.3
global range partitioned indexes, 2.5.3.1
guidelines for indexes, 3.3.6
hash, 2.3.1.2
Hybrid Columnar Compression example, 3.4.2
indexes, 2.1.3.2, 2.5, 3.3
index-organized tables, 2.1.4, 4.1, 4.1.14.1, 4.1.14.2, 4.1.14.3
Information Lifecycle Management, 2.1.6
Information Lifecycle Management, and, 1.3
interval, 2.4.1.1, 2.4.1.2
interval-hash, 4.1.7.5.1
interval-list, 4.1.7.5.2
interval-range, 4.1.7.5.3
key, 2.1.2
key extensions, 2.4.2
list, 2.3.1.3, 4.2.11, 4.2.12
list-hash, 4.1.7.4.1
list-list, 4.1.7.4.2
list-range, 4.1.7.4.3
LOB data, 2.1.7
local indexes, 3.3.1
local partitioned indexes, 2.5.2
maintaining partitions, 4.2
maintenance procedures for segment creation, 4.1.13.3
manageability, 2.2.2
manageability extensions, 2.4.1
manageability with indexes, 6.4.2
managing partitions, 3.3.2.2
nonprefixed indexes, 3.3.1.2, 3.3.2.1, 3.3.4
Online Transaction Processing (OLTP), and, 7
overview, 2.1
partial indexes on partitioned tables, 2.5.6
Partition Advisor, 2.4.1.2
partitioned indexes on composite partitions, 2.5.7
partition-wise joins, 2.2.1.2
performance, 2.2.1, 3.5
performance considerations, 3.5
performance considerations for composite, 3.5.4
performance considerations for composite list-hash, 3.5.4.4
performance considerations for composite list-list, 3.5.4.5
performance considerations for composite list-range, 3.5.4.6
performance considerations for composite range-hash, 3.5.4.1
performance considerations for composite range-list, 3.5.4.2
performance considerations for composite range-range, 3.5.4.3
performance considerations for hash, 3.5.2
performance considerations for interval, 3.5.5
performance considerations for list, 3.5.3
performance considerations for range, 3.5.6
performance considerations for virtual columns, 3.5.7
placement with striping, 10.2.4
prefixed indexes, 3.3.1.1, 3.3.2.1
pruning, 2.2.1.1, 3.1
range, 2.3.1.1
range-hash, 4.1.7.1
range-list, 4.1.7.2
range-range, 4.1.7.3, 4.1.7.3
reference, 2.4.2.1
removing data from tables, 6.4.3
restrictions for multiple block sizes, 4.1.15
segments, 4.1.13
single-level, 2.3.1
strategies, 2.3, 3.5
subpartition templates, 4.1.8
system, 2.1.5, 2.4, 2.4.1, 2.4.2
tables, 2.1.3, 2.1.3.1
truncating segments, 4.1.13.2
type of index to use, 2.5.1
very large databases (VLDBs), and, 1.2
virtual columns, 2.4.2.2
partitioning and data compression
data warehouses, 6.4.4
partitioning and materialized views
data warehouses, 6.3.4
partitioning columns
range-partitioned tables, 4.1.1.1
partitioning keys
range-partitioned tables, 4.1.1.1
partitioning materialized views
data warehouses, 6.3.4.1
partitioning of XMLIndex
binary XML tables, 4.1.16.2
partitions, 1.1
equipartitioning
examples, 3.3.1.1
local indexes, 3.3.1
global indexes, 3.3.2, 6.3.3.3
guidelines for partitioning indexes, 3.3.6
indexes, 3.3
local indexes, 3.3.1, 6.3.3.1
materialized views, 1
nonprefixed indexes, 2.5.2, 3.3.1.2, 3.3.4
on indexes, 6.3.3
parallel DDL statements, 8.3.2.1
physical attributes, 3.3.7
prefixed indexes, 3.3.1.1
rules of parallelism, 8.3.2.8.2
PARTITIONS clause
for hash partitions, 4.1.3
partition-wise joins, 3.2
benefits, 6.3.2, 6.3.2.3
full, 3.2.1, 6.3.2.1
parallel execution, 6.3.2.4
partial, 3.2.2, 6.3.2.2
performance
DSS database, 8.3.3.1
prefixed and nonprefixed indexes, 3.3.5
very large databases (VLDBs), 10.2
pluggable databases
parallel statement queuing, 8.2.4.1.6
predicates
index partition pruning, 3.3.5
prefixed indexes, 3.3.1.1, 3.3.3
partition pruning, 3.3.5
PRIMARY KEY constraints, 8.7.4
process monitor process (PMON)
parallel DML process recovery, 8.3.3.7.2
processes
memory contention in parallel processing, 8.5.1.2.1
producer operations, 8.2.1.3
pruning partitions
about, 3.1
benefits, 3.1.1
indexes and performance, 3.3.5

Q

queries
ad hoc, 8.3.2.2
query parallelization
EXPLAIN PLAN statement, 8.7.2
queuing
parallel statements, 8.2.4

R

range partitioning, 2.3.1.1
creating tables using, 4.1.1
index-organized tables, 4.1.14.1
multicolumn partitioning keys, 4.1.9
performance considerations, 3.5.1, 3.5.6
range-hash partitioning
creating tables using, 4.1.7.1
subpartitioning template, 4.1.8.1
range-list partitioning
creating tables using, 4.1.7.2
subpartitioning template, 4.1.8.2
range-partitioned tables
adding partitions, 4.2.4.1
splitting partitions, 4.2.17.1, 4.2.17.6
range-range partitioning
creating tables using, 4.1.7.3, 4.1.7.3
read-only tablespaces
performance considerations, 3.5.8
REBUILD INDEX PARTITION statement
rules of parallelism, 8.3.2.8.1
REBUILD INDEX statement
rules of parallelism, 8.3.2.8.1
REBUILD PARTITION clause, 4.2.14.3, 4.2.15.2.1, 4.2.15.2.1
REBUILD UNUSABLE LOCAL INDEXES clause, 4.2.15.2.2
recovery
parallel DML operations, 8.3.3.7
reference partitioning
creating tables using, 4.1.5
key extension, 2.4.2.1
reference-partitioned tables
adding partitions, 4.2.4.8
RENAME PARTITION clause, 4.2.16.1, 4.2.16.3.1
RENAME SUBPARTITION clause, 4.2.16.2
replication
restrictions on parallel DML, 8.3.3.9
resource plan
using with parallel statement queuing, 8.1
resources
consumption, parameters affecting, 8.5.2, 8.5.2.3
limiting for users, 8.5.1.2.2
limits, 8.5.1.2
parallel query usage, 8.5.2
restrictions
direct-path INSERT, 8.3.3.9
parallel DDL statements, 8.3.2.1
parallel DML operations, 8.3.3.9
parallel DML operations and remote transactions, 8.3.3.12
ROW ARCHIVAL VISIBILITY
In-Database Archiving, 5.3.1
row movement clause for partitioned tables, 4.1
row-level compression tiering
Automatic Data Optimization, 5.2.2.3

S

sar UNIX command, 8.6.4
scalability
batch jobs, 8.3.3.1.5
parallel DML operations, 8.3.3.1
scalability and manageability
very large databases (VLDBs), 10.3
scans
parallel query on full table, 8.1.2
segment-level compression tiering
Automatic Data Optimization, 5.2.2.2
segments
creating on demand, 4.1.13.3
deferred, 4.1.13.1
partitioning, 4.1.13
truncating, 4.1.13.2
session statistics
monitoring for parallel processing, 8.6.2
sessions
enabling parallel DML operations, 8.3.3.2
SET INTERVAL clause, 4.2.4.4
SHARED_POOL_SIZE initialization parameter, 8.5.1.7
single-level partitioning, 2.3.1
skewing parallel DML workload, 8.2.7
SORT_AREA_SIZE initialization parameter
parallel execution, 8.5.2.1.2
space management
MINIMUM EXTENT parameter, 8.3.2.6
parallel DDL, 8.3.2.4
SPLIT PARTITION clause, 4.2.4.1, 4.2.17
rules of parallelism, 8.3.2.8.2
SPLIT PARTITION operations
optimizing, 4.2.17.9
SPLIT SUBPARTITION operations
optimizing, 4.2.17.9
splitting multiple partitions, 4.2.17.8
SQL statements
parallelizing, 8.2.1
STATEMENT_QUEUING
parallel statement queuing hint, 8.2.4.3
statistics
operating system, 8.6.4
storage
fragmentation in parallel DDL, 8.3.2.6
index partitions, 3.3.7
STORAGE clause
parallel execution, 8.3.2.5
storage management
very large databases (VLDBs), 10
STORE IN clause, 4.1.7.1
stripe and mirror everything
very large databases (VLDBs), 10.3.1
striping
Information Lifecycle Management, 10.2.3
partitioning placement, 10.2.4
striping with Oracle ASM
very large databases (VLDBs), 10.2.2
SUBPARTITION BY HASH clause
for composite-partitioned tables, 4.1.7
SUBPARTITION clause, 4.2.4.5.1, 4.2.4.6.1, 4.2.4.7.1, 4.2.17.4
for composite-partitioned tables, 4.1.7
subpartition templates, 4.1.8
modifying, 4.2.13
SUBPARTITIONS clause, 4.2.4.5.1, 4.2.17.4
for composite-partitioned tables, 4.1.7
subqueries
in DDL statements, 8.3.2.2
system monitor process (SMON)
parallel DML system recovery, 8.3.3.7.3
system partitioning, 2.1.5
system statistics
monitoring for parallel processing, 8.6.3

T

table compression
partitioning, 4.1.11
table queues
monitoring parallel processing, 8.6.1.7
tables
creating and populating in parallel, 8.7.1
creating composite partitioned, 4.1.7
full partition-wise joins, 3.2.1, 6.3.2.1
historical, 8.3.3.1.4
index-organized, partitioning, 4.1.14
parallel creation, 8.3.2.2
parallel DDL storage, 8.3.2.6
partial partition-wise joins, 3.2.2, 6.3.2.2
partitioning, 2.1.3
partitions, 1.1
refreshing in data warehouse, 8.3.3.1.1
STORAGE clause with parallel execution, 8.3.2.5
summary, 8.3.2.2
when to partition, 2.1.3.1
TAPE_ASYNCH_IO initialization parameter
parallel query, 8.5.3.4
Temporal Validity
DBMS_FLASHBACK_ARCHIVE package ENABLE_AT_VALID_TIME procedure, 5.3.2
limitations, 5.3.3
managing data validity, 5.3.2
valid-time period, 5.3.2
temporary segments
parallel DDL, 8.3.2.6
TIMED_STATISTICS initialization parameter, 8.6.1.6
transactions
distributed and parallel DML restrictions, 8.3.3.12
TRANSACTIONS initialization parameter, 8.5.2.3.1
triggers
restrictions, 8.3.3.11
restrictions on parallel DML, 8.3.3.9
TRUNCATE PARTITION clause, 4.2.18, 4.2.18, 4.2.18.1, 4.2.18.1.1, 4.2.18.1.1
TRUNCATE SUBPARTITION clause, 4.2.18.2
truncating multiple partitions, 4.2.18.4
truncating partitions
asynchronous global index maintenance, 4.2.3
cascade option, 4.2.18.3
marking indexes UNUSABLE, 4.2.18
truncating segments
partitioning, 4.1.13.2
two-phase commit, 8.5.2.3.1
types of parallelism, 8.3

U

UNION ALL
concurrent execution, 8.3.3.14
unique constraints, 8.7.4
UPDATE GLOBAL INDEX clause
of ALTER TABLE, 4.2.2
UPDATE statement
parallel UPDATE statement, 8.3.3.3
updating indexes automatically, 4.2.2
user resources
limiting, 8.5.1.2.2

V

V$PQ_SESSTAT view
monitoring parallel processing, 8.6.1.6
V$PQ_TQSTAT view
monitoring parallel processing, 8.6.1.7
V$PX_BUFFER_ADVICE view
monitoring parallel processing, 8.6.1.1
V$PX_PROCESS view
monitoring parallel processing, 8.6.1.4
V$PX_PROCESS_SYSSTAT view
monitoring parallel processing, 8.6.1.5
V$PX_SESSION view
monitoring parallel processing, 8.6.1.2
V$PX_SESSTAT view
monitoring parallel processing, 8.6.1.3
V$RSRC_CONS_GROUP_HISTORY view
monitoring parallel processing, 8.6.1.8
V$RSRC_CONSUMER_GROUP view
monitoring parallel processing, 8.6.1.9
V$RSRC_PLAN view
monitoring parallel processing, 8.6.1.10
V$RSRC_PLAN_HISTORY view
monitoring parallel processing, 8.6.1.11
V$RSRC_SESSION_INFO view
parallel statement queuing metrics, 8.6.1.12
V$RSRCMGRMETRIC view
parallel statement queuing statistics, 8.6.1.13
V$SESSTAT view, 8.6.4
V$SYSSTAT view, 8.7.3.6
valid-time period
Temporal Validity, 5.3.2
very large databases (VLDBs)
about, 1
backing up and recovering, 9
backup tools, 9.2.3
backup types, 9.2.2
bigfile tablespaces, 10.2.5
database structures for recovering data, 9.2.1
hardware-based mirroring, 10.1.1
hardware-based striping, 10.2.1
high availability, 10.1
mirroring with Oracle ASM, 10.1.2
Oracle Automatic Storage Management settings, 10.4
Oracle Backup and Recovery, 9.2
Oracle Data Pump, 9.2.3, 9.2.3.2
Oracle Database File System, 10.2.6
Oracle Recovery Manager, 9.2.3.1
partitioning, and, 1.2
performance, 10.2
physical and logical backups, 9.2.2
RAID 0 striping, 10.2.1.1
RAID 1 mirroring, 10.1.1.1
RAID 5 mirroring, 10.1.1.2
RAID 5 striping, 10.2.1.2
RMAN, 9.2.3
scalability and manageability, 10.3
storage management, 10
stripe and mirror everything, 10.3.1
striping with Oracle ASM, 10.2.2
user-managed backups, 9.2.3, 9.2.3.3
views
parallel processing monitoring, 8.6.1
V$SESSTAT, 8.6.4
V$SYSSTAT, 8.7.3.6
views for ILM policies
Automatic Data Optimization, 5.2.2.6
virtual column partitioning
performance considerations, 3.5.7
virtual column-based partitioning
about, 4.1.10
key extension, 2.4.2.2
using for the subpartitioning key, 4.1.10
vmstat UNIX command, 8.6.4

W

workloads
skewing, 8.2.7

X

XMLType collections
partitioning, 4.1.16
XMLType objects, 2.1.8