Skip Headers
Oracle® Database VLDB and Partitioning Guide
11g Release 2 (11.2)

Part Number E16541-05
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
View PDF

Index

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

A

ADD PARTITION clause, 4.2.2.1
ADD SUBPARTITION clause, 4.2.2.5.2, 4.2.2.6.2, 4.2.2.7.2
adding index partitions, 4.2.2.9
adding partitions
composite hash-partitioned tables, 4.2.2.5
composite list-partitioned tables, 4.2.2.6
composite range-partitioned tables, 4.2.2.7
hash-partitioned tables, 4.2.2.2
interval-partitioned tables, 4.2.2.4
list-partitioned tables, 4.2.2.3
partitioned tables, 4.2.2
range-partitioned tables, 4.2.2.1
reference-partitioned tables, 4.2.2.8
ALTER INDEX statement
for maintaining partitioned indexes, 4.2
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
MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause, 4.2.7.2, 4.2.7.3
ALTER TABLE statement
for maintaining partitions, 4.2
MODIFY DEFAULT ATTRIBUTES clause, 4.2.7.1
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 I/O, 8.5.3.4
Auditing
Compliance & Security, 5.4.3.4

B

bigfile tablespaces
very large databases (VLDBs), 10.2.5

C

clusters
cannot be partitioned, 1
indexes on
cannot be partitioned, 1
COALESCE PARTITION clause, 4.2.3.1
collections
XMLType, 2.1.7, 4.1.15
Compliance & Security
Auditing, 5.4.3.4
Current Status, 5.4.3.1
Digital Signatures and Immutability, 5.4.3.2
Information Lifecycle Management Assistant, 5.4.3
Privacy & Security, 5.4.3.3
composite hash-partitioned tables
adding partitions, 4.2.2.5
composite list-hash partitioning, 2.3.2.5
composite list-list partitioning, 2.3.2.6
composite list-partitioned tables
adding partitions, 4.2.2.6
composite list-range partitioning, 2.3.2.4
composite partitioning, 2.3.2, 2.3.2
default partition, 4.1.6.2
interval-hash, 4.1.6.5.1
interval-list, 4.1.6.5.2
interval-range, 4.1.6.5.3
list-hash, 4.1.6.4.1
list-list, 4.1.6.4.2
list-range, 4.1.6.4.3
range-hash, 4.1.6.1
range-list, 4.1.6.2
range-range, 4.1.6.3, 4.1.6.3
subpartition template, modifying, 4.2.11
composite range-hash partitioning, 2.3.2.2
composite range-list partitioning, 2.3.2.3
composite range-partitioned tables
adding partitions, 4.2.2.7
composite range-range partitioning, 2.3.2.1
compression, 3.4
compression table, 3.4
partitioning, 3.4
constraints
parallel create table, 8.3.2.9
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.1.4, 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
index-organized tables, 8.1.4
parallelism and index-organized tables, 8.3.2.1
Current Status
Compliance & Security, 5.4.3.1

D

data
integrity of
parallel DML restrictions, 8.3.3.10
data compression
and partitioning, 6.3.3.4, 6.4.5
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
partitioning, 3.4
data warehouse
about, 6.1
advanced partition pruning, 6.3.1.2
and partition pruning, 6.3.1
and partitioning, 6
ARCHIVELOG mode for recovery, 9.5
backing up and recovering, 9.1
backing up and recovering characteristics, 9.1.1
backing up tables on individual basis, 9.11
backup and recovery, 9.3
basic partition pruning, 6.3.1.1
block change tracking for backups, 9.7
differences with online transaction processing backups, 9.1.1
extract, transform, and load for backup and recovery, 9.10.1
extract, transform, and load strategy, 9.10.2
flashback database and guaranteed restore points, 9.10.5
incremental backup strategy, 9.10.4
incremental backups, 9.10.3
leverage read-only tablespaces for backups, 9.9
manageability with partition exchange load, 6.4.1
NOLOGGING mode for backup and recovery, 9.10
partitioned tables, 3.5.1
partitioning for large databases, 6.2.1
partitioning for large tables, 6.2.2
partitioning for scalability, 6.2
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.6
RMAN multi-section backups, 9.8
database writer process (DBWn)
tuning, 8.7.3.6
databases
and partitioning, 1.4
scalability, 8.3.3.1
DB_BLOCK_SIZE initialization parameter
and parallel query, 8.5.3.2
DB_CACHE_SIZE initialization parameter
and parallel query, 8.5.3.1
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter
and paralle query, 8.5.3.3
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.6.2
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, 8.2.3.3
DOP, 8.1.4
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
specifying a limit for a consumer group, 8.2.4.1.4
DELETE statement
parallel DELETE statement, 8.3.3.3
Digital Signatures and Immutability
Compliance & Security, 5.4.3.2
direct-path INSERT
restrictions, 8.3.3.9
DISABLE ROW MOVEMENT clause, 4.1
DISK_ASYNCH_IO initialization parameter
and parallel query, 8.5.3.4
distributed transactions
parallel DDL restrictions, 8.1.4
parallel DML restrictions, 8.1.4, 8.3.3.12
DOP
degree of parallelism, 8.1.4
DROP PARTITION clause, 4.2.4.1
dropping partitioned tables, 4.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
Event Scan History
Lifecycle Management, 5.4.2.3
EXCHANGE PARTITION clause, 4.2.5.1, 4.2.5.7, 4.2.5.8, 4.2.5.9, 4.2.5.10, 4.2.6
EXCHANGE SUBPARTITION clause, 4.2.5.6
EXPLAIN PLAN statement
query parallelization, 8.7.2
extents
parallel DDL statements, 8.3.2.6
extract, transform, and load
data warehouse, 9.10.1

F

FAST_START_PARALLEL_ROLLBACK initialization parameter, 8.5.2.3.2
features
new, Preface
FOR PARTITION clause, 4.2.8.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
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 indexes
partitioning, 3.3.2
managing partitions, 3.3.2.2
summary of index types, 3.3.3
global partitioned indexes
maintenance, 2.5.2.3
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 tables using, 4.1.3
index-organized tables, 4.1.13.2, 4.1.13.3
multicolumn partitioning keys, 4.1.8
hash-partitioned tables
adding partitions, 4.2.2.2
hints
APPEND, 8.7.5.2
NOAPPEND, 8.7.5.2
PARALLEL, 8.7.5.1
parallel statement queuing, 8.2.4.3
historical tables
moving time window, 4.4

I

ILM
see Information Lifecycle Management
implementing an ILM system
manually, 5.5
using Oracle Database, 5.2
index partitions
adding, 4.2.2.9
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.6
partitions, 1.1, 3.3
updating global indexes, 4.2.1
index-organized tables
parallel CREATE, 8.1.4, 8.3.2.1
parallel queries, 8.3.1.1
partitioning, 4.1, 4.1.13
partitioning secondary indexes, 4.1.13.1
Information Lifecycle Management
about, 5.1
and Oracle Database, 5.1.1
and regulatory requirements, 5.1.2
and unstructured data, 5.1.1.1
Assistant, 5.4
benefits of an online archive, 5.3
creating data access, 5.2.3
creating migration policies, 5.2.3
creating storage tiers, 5.2.2
defining compliance policies, 5.2.4
defining data classes, 5.2.1
enforcing compliance policies, 5.2.4
graphical user interface, 5.4
implementing a system manually, 5.5
implementing using Oracle Database, 5.2
introduction, 5
striping, 10.2.3
Information Lifecycle Management (ILM)
and partitioning, 1.3
Information Lifecycle Management Assistant
about, 5.4
Compliance & Security, 5.4.3
Lifecycle Management, 5.4.2
Lifecycle Setup, 5.4.1
Reports, 5.4.4
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.4.2
interval partitioning, 2.4.1.1
creating tables using, 4.1.2
performance considerations, 3.5.1
interval-hash partitioning
creating tables using, 4.1.6.5.1
subpartitioning template, 4.1.7.1
interval-list partitioning
creating tables using, 4.1.6.5.2
subpartitioning template, 4.1.7.2
interval-partitioned tables
adding partitions, 4.2.2.4
interval-range partitioning
creating tables using, 4.1.6.5.3
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
partition-wise, 3.2

L

Lifecycle Events
Lifecycle Management, 5.4.2.2
Lifecycle Events Calendar
Lifecycle Management, 5.4.2.1
Lifecycle Management
Event Scan History, 5.4.2.3
Information Lifecycle Management Assistant, 5.4.2
Lifecycle Events, 5.4.2.2
Lifecycle Events Calendar, 5.4.2.1
Lifecycle Setup
Information Lifecycle Management Assistant, 5.4.1
Lifecycle Definitions, 5.4.1.2
Lifecycle Tables, 5.4.1.3
Logical Storage Tiers, 5.4.1.1
Preferences, 5.4.1.4
list partitioning, 2.3.1.3
adding values to value list, 4.2.9
creating tables using, 4.1.4
DEFAULT keyword, 4.1.4
dropping values from value-list, 4.2.10
list-hash partitioning
creating tables using, 4.1.6.4.1
subpartitioning template, 4.1.7.1
list-list partitioning
creating tables using, 4.1.6.4.2
subpartitioning template, 4.1.7.2
list-partitioned tables
adding partitions, 4.2.2.3
list-range partitioning
creating tables using, 4.1.6.4.3
LOB datatypes
restrictions on parallel DDL statements, 8.1.4, 8.3.2.1
restrictions on parallel DML operations, 8.3.3.9, 8.3.3.9
local indexes, 3.3.1, 3.3.3
equipartitioning, 3.3.1
LOGGING clause, 8.7.3.7
logging mode
parallel DDL, 8.1.4, 8.3.2.1, 8.3.2.3

M

material views
manageability with partitioning, 6.4.3
materialized views
and partitioning, 6.3.3.5
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
MINIMUM EXTENT parameter, 8.3.2.6
mirroring with Oracle ASM
very large databases (VLDBs), 10.1.2
MODIFY DEFAULT ATTRIBUTES clause, 4.2.8.1
using for partitioned tables, 4.2.7.1
MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause
of ALTER TABLE, 4.2.7.2, 4.2.7.3
MODIFY PARTITION clause, 4.2.8.1, 4.2.8.2, 4.2.12, 4.2.14.2.2
MODIFY SUBPARTITION clause, 4.2.8.3
monitoring
parallel processing, 8.6.1
monitoring with Oracle Enterprise Manager
very large databases (VLDBs), 10.5
MOVE PARTITION clause, 4.2.8, 4.2.12
MOVE PARTITION statement
rules of parallelism, 8.3.2.8.2
MOVE SUBPARTITION clause, 4.2.8, 4.2.12.2
multiple archiver processes, 8.7.3.5, 8.7.3.5

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.1.4, 8.3.2.1, 8.3.2.3
nonpartitioned indexes, 6.3.3.2
nonprefixed indexes, 2.5.1, 3.3.1.2, 3.3.4
global partitioned indexes, 3.3.2.1

O

object types
parallel queries, 8.3.1.4
restrictions on parallel DDL statements, 8.1.4, 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)
and partitioning, 7.1
common partition maintenance operations, 7.3.3
when to partition indexes, 7.2.1
operating system statistics
monitoring for parallel processing, 8.6.4
optimization
partition pruning
indexes, 3.3.5
partitioned indexes, 3.3.5
optimizations
parallel SQL, 8.2.1
Oracle ASM settings
very large databases (VLDBs), 10.4
Oracle Database File System
very large databases (VLDBs), 10.2.6
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.1.4, 8.3.2.1
restrictions on object types, 8.1.4, 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 datatypes, 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
and I/O calibration, 8.2.3.6
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
interoperator parallelism, 8.2.1.3
intraoperator parallelism, 8.2.1.3
I/O, 8.1.1
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 parameters, 8.5.2
SQL statements, 8.1.4
SQL*Loader, 8.1.4
symmetric multiprocessors, 8.1.1
TAPE_ASYNCH_IO initialization parameter, 8.5.3.4
tuning general parameters, 8.5
tuning parameters, 8.4
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 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
and PARALLEL_DEGREE_POLICY, 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 consumer groups, 8.2.4.1
managing the order of dequeuing, 8.2.4.1.1
managing with resource manager, 8.2.4.1
NO_STATEMENT_QUEUING hint, 8.2.4.3
sample scenario for managing parallel statements, 8.2.4.1.5
setting order of parallel statements, 8.2.4.1
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
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
and I/O calibration, 8.2.3.6
degree of parallelism, 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
and 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
adaptive, 8.2.3.5
degree, 8.2.3
interoperator, 8.2.1.3
intraoperator, 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
rules for SQL operations, 8.3.5.1
parameters
FREELISTS, 8.7.3.4
partial partition-wise joins, 6.3.2.2
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.6
PARTITION BY REFERENCE clause, 4.1.5
PARTITION clause
for composite-partitioned tables, 4.1.6
for hash partitions, 4.1.3
for list partitions, 4.1.4
for range partitions, 4.1.1
partition exchange load
and 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, 3.1
dynamic, 3.1.4
static, 3.1.3
partitioned indexes, 4
adding partitions, 4.2.2.9
and Online Transaction Processing (OLTP), 7.2.1
creating local index on composite partitioned table, 4.1.6.1
creating local index on hash partitioned table, 4.1.3.1
creating range partitions, 4.1.1.2
dropping partitions, 4.2.4.3
maintenance operations, 4.2
maintenance operations, table of, 4.2
modifying partition default attributes, 4.2.7.3
modifying real attributes of partitions, 4.2.8.4
moving partitions, 4.2.12.3
rebuilding index partitions, 4.2.14
renaming index partitions/subpartitions, 4.2.15.3
secondary indexes on index-organized tables, 4.1.13.1
splitting partitions, 4.2.16.7
partitioned tables, 4
adding partitions, 4.2.2
adding subpartitions, 4.2.2.5.2, 4.2.2.6.2, 4.2.2.7.2
coalescing partitions, 4.2.3
creating hash partitions, 4.1.3
creating interval partitions, 4.1.2
creating interval-hash partitions, 4.1.6.5.1
creating interval-list partitions, 4.1.6.5.2
creating interval-range partitions, 4.1.6.5.3
creating list partitions, 4.1.4
creating list-hash partitions, 4.1.6.4.1
creating list-list partitions, 4.1.6.4.2
creating list-range partitions, 4.1.6.4.3
creating range partitions, 4.1.1, 4.1.1.2
creating range-hash partitions, 4.1.6.1
creating range-list partitions, 4.1.6.2
creating range-range partitions, 4.1.6.3
creating reference partitions, 4.1.5
data warehouses, 3.5.1
DISABLE ROW MOVEMENT, 4.1
dropping, 4.3
dropping partitions, 4.2.4
ENABLE ROW MOVEMENT, 4.1
exchanging partitions, 4.2.5
exchanging subpartitions, 4.2.5.6, 4.2.5.8, 4.2.5.10
index-organized tables, 4.1, 4.1.13.1, 4.1.13.2, 4.1.13.3
maintenance operations, 4.2
maintenance operations with global indexes, 7.3.2
maintenance operations with local indexes, 7.3.1
marking indexes UNUSABLE, 4.2.2.2, 4.2.3, 4.2.4.1, 4.2.4.3, 4.2.5, 4.2.6, 4.2.8.1, 4.2.8.1, 4.2.8.2, 4.2.12, 4.2.16, 4.2.17
merging partitions, 4.2.6
modifying default attributes, 4.2.7
modifying real attributes of partitions, 4.2.8
modifying real attributes of subpartitions, 4.2.8.3
moving partitions, 4.2.12
moving subpartitions, 4.2.12.2
multicolumn partitioning keys, 4.1.8
rebuilding index partitions, 4.2.14
redefining partitions online, 4.2.13
renaming partitions, 4.2.15
renaming subpartitions, 4.2.15.2
splitting partitions, 4.2.16
truncating partitions, 4.2.17
truncating subpartitions, 4.2.17.2
updating global indexes automatically, 4.2.1
partitioned tables with global indexes, 7.3.2
partitioned tables with local indexes, 7.3.1
partitioning
about, 1.1
advantages, 1.1
and data compression, 6.3.3.4, 6.4.5
and data warehouse, 6
and databases, 1.4
and Information Lifecycle Management (ILM), 1.3
and materialized views, 6.3.3.5
and Online Transaction Processing (OLTP), 7.1
and very large databases (VLDBs), 1.2
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
creating partitions, 4.1
data segment compression, 3.4
bitmap indexes, 3.4.1
data warehouse and scalability, 6.2
default partition, 4.1.4
default subpartition, 4.1.6.2
hash, 2.3.1.2
index-organized tables, 4.1, 4.1.13.1, 4.1.13.2, 4.1.13.3
interval, 2.4.1.1
interval-hash, 4.1.6.5.1
interval-list, 4.1.6.5.2
interval-range, 4.1.6.5.3
list, 2.3.1.3, 4.2.9, 4.2.10
list-hash, 4.1.6.4.1
list-list, 4.1.6.4.2
list-range, 4.1.6.4.3
maintaining partitions, 4.2
manageability with indexes, 6.4.2
manageability with material views, 6.4.3
placement with striping, 10.2.4
range, 2.3.1.1
range-hash, 4.1.6.1
range-list, 4.1.6.2
range-range, 4.1.6.3, 4.1.6.3
reference, 2.4.2.1
removing data from tables, 6.4.4
statistics gathering, 6.4.6
subpartition templates, 4.1.7
system, 2.1.4
virtual columns, 2.4.2.2
partitions, 1.1
equipartitioning
examples, 3.3.1.1
local indexes, 3.3.1
global indexes, 3.3.2, 6.3.3.3
local indexes, 3.3.1, 6.3.3.1
materialized views, 1
nonprefixed indexes, 2.5.1, 3.3.1.2, 3.3.4
on indexes, 6.3.3
parallel DDL statements, 8.3.2.1
partition pruning
indexes, 3.3.5
partitioning indexes, 3.3, 3.3.6
physical attributes, 3.3.7
prefixed indexes, 3.3.1.1
pruning, 3.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
predicates
partition pruning
indexes, 3.3.5
prefixed indexes, 3.3.1.1, 3.3.3
PRIMARY KEY constraints, 8.7.4
Privacy & Security
Compliance & Security, 5.4.3.3
process monitor process (PMON)
parallel DML process recovery, 8.3.3.7.2
processes
and memory contention in parallel processing, 8.5.1.2.1
pruning partitions
about, 3.1
indexes, 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.13.1
multicolumn partitioning keys, 4.1.8
performance considerations, 3.5.1
range-hash partitioning
creating tables using, 4.1.6.1
subpartitioning template, 4.1.7.1
range-list partitioning
creating tables using, 4.1.6.2
subpartitioning template, 4.1.7.2
range-partitioned tables
adding partitions, 4.2.2.1
range-range partitioning
creating tables using, 4.1.6.3, 4.1.6.3
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.12.3, 4.2.14.2.1, 4.2.14.2.1
REBUILD UNUSABLE LOCAL INDEXES clause, 4.2.14.2.2
recovery
parallel DML operations, 8.3.3.7
reference partitioning, 2.4.2.1
creating tables using, 4.1.5
reference-partitioned tables
adding partitions, 4.2.2.8
RENAME PARTITION clause, 4.2.15.1, 4.2.15.3.1
RENAME SUBPARTITION clause, 4.2.15.2
replication
restrictions on parallel DML, 8.3.3.9
Reports
Information Lifecycle Management Assistant, 5.4.4
resource manager
managing parallel statement queue, 8.2.4.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.1.4, 8.3.2.1
parallel DML operations, 8.3.3.9
remote transactions, 8.3.3.12
row movement clause for partitioned tables, 4.1

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
session statistics
monitoring for parallel processing, 8.6.2
sessions
enabling parallel DML operations, 8.3.3.2
SET INTERVAL clause, 4.2.2.4
SHARED_POOL_SIZE initialization parameter, 8.5.1.7
skewing parallel DML workload, 8.2.7
SORT_AREA_SIZE initialization parameter
and 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.2.1, 4.2.16
rules of parallelism, 8.3.2.8.2
SQL statements
parallel execution, 8.1.4
parallelizing, 8.2.1
SQL*Loader
parallel execution, 8.1.4
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.6.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.6
SUBPARTITION clause, 4.2.2.5.1, 4.2.2.6.1, 4.2.2.7.1, 4.2.16.4
for composite-partitioned tables, 4.1.6
subpartition templates, 4.1.7
modifying, 4.2.11
SUBPARTITIONS clause, 4.2.2.5.1, 4.2.16.4
for composite-partitioned tables, 4.1.6
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.4
system statistics
monitoring for parallel processing, 8.6.3

T

table queues
monitoring parallel processing, 8.6.1.7
tables
creating and populating in parallel, 8.7.1
full partition-wise joins, 3.2.1, 6.3.2.1
gathering statistics on partitioned, 6.4.6
historical, 8.3.3.1.4
index-organized, partitioning, 4.1.13
moving time windows in historical, 4.4
parallel creation, 8.3.2.2
parallel DDL storage, 8.3.2.6
partial partition-wise joins, 3.2.2, 6.3.2.2
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
TAPE_ASYNCH_IO initialization parameter
and parallel query, 8.5.3.4
temporary segments
parallel DDL, 8.3.2.6
TIMED_STATISTICS initialization parameter, 8.6.1.6
transactions
distributed
parallel DDL restrictions, 8.1.4
parallel DML restrictions, 8.1.4, 8.3.3.12
TRANSACTIONS initialization parameter, 8.5.2.3.1
triggers
restrictions, 8.3.3.11
parallel DML, 8.3.3.9
TRUNCATE PARTITION clause, 4.2.17, 4.2.17, 4.2.17.1, 4.2.17.1.1, 4.2.17.1.1
TRUNCATE SUBPARTITION clause, 4.2.17.2
two-phase commit, 8.5.2.3.1
types of parallelism, 8.3

U

unique constraints, 8.7.4
UPDATE GLOBAL INDEX clause
of ALTER TABLE, 4.2.1
UPDATE statement
parallel UPDATE statement, 8.3.3.3
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
monitoring parallel processing, 8.6.1.12
V$SESSTAT view, 8.6.4
V$SYSSTAT view, 8.7.3.6
very large databases (VLDBs)
and partitioning, 1.2
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
monitoring with Oracle Enterprise Manager, 10.5
Oracle ASM settings, 10.4
Oracle Backup and Recovery, 9.2
Oracle Database File System, 10.2.6
performance, 10.2
physical and logical backups, 9.2.2
scalability and manageability, 10.3
storage management, 10
stripe and mirror everything, 10.3.1
striping with Oracle ASM, 10.2.2
views
parallel processing monitoring, 8.6.1
V$SESSTAT, 8.6.4
V$SYSSTAT, 8.7.3.6
virtual column-based partitioning, 2.4.2.2
vmstat UNIX command, 8.6.4

W

workloads
skewing, 8.2.7

X

XMLType collections
partitioning, 4.1.15
XMLType objects, 2.1.7