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.3.1

ADD SUBPARTITION clause, 4.2.3.5.2, 4.2.3.6.2, 4.2.3.7.2

adding index partitions, 4.2.3.9

adding partitions

composite hash-partitioned tables, 4.2.3.5

composite list-partitioned tables, 4.2.3.6

composite range-partitioned tables, 4.2.3.7

hash-partitioned tables, 4.2.3.2

interval-partitioned tables, 4.2.3.4

list-partitioned tables, 4.2.3.3

partitioned tables, 4.2.3

range-partitioned tables, 4.2.3.1

reference-partitioned tables, 4.2.3.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.8.1

MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause, 4.2.8.2, 4.2.8.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 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.4.1

collection tables

performing PMOs on partitions, 4.1.15.1

collections

tables, 4.1.15.1

XMLType, 2.1.8, 4.1.15

Compliance & Security

Auditing, 5.4.3.4

Current Status, 5.4.3.1

Digital Signatures and Immutability, 5.4.3.2

fine-grained auditing policies, 5.4.3.4.1

Information Lifecycle Management Assistant, 5.4.3

policy notes, 5.4.3.5

Privacy & Security, 5.4.3.3

viewing auditing records, 5.4.3.4.2

composite hash-partitioned tables

adding partitions, 4.2.3.5

composite interval partitioning

creating tables using, 4.1.6.5

composite list partitioning

creating tables using, 4.1.6.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.3.6

composite list-range partitioning, 2.3.2.4

performance considerations, 3.5.4.6

composite partitioned tables

creating, 4.1.6

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

performance considerations, 3.5.4

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.12

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.3.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

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.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

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.12.3

Current Status

Compliance & Security, 5.4.3.1

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.5

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.4

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

statistics management, 6.4.6

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

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

deferred segments

partitioning, 4.1.12.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

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

parallel query, 8.5.3.4

distributed transactions

parallel DDL restrictions, 8.1.4

parallel DML restrictions, 8.1.4, 8.3.3.12

distributed transactions and parallel DML restrictions, 8.1.4

DOP

See degree of parallelism

DROP PARTITION clause, 4.2.5.1

dropping partitioned tables, 4.3

dropping partitions

marked UNUSABLE, 4.2.5.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.6.1, 4.2.6.7, 4.2.6.8, 4.2.6.9, 4.2.6.10, 4.2.7

EXCHANGE SUBPARTITION clause, 4.2.6.6

exchanging partitions

marking indexes UNUSABLE, 4.2.6

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.9.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.5.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.13.2

multicolumn partitioning keys, 4.1.8

performance considerations, 3.5.2

hash partitions

splitting, 4.2.17.4

hash-partitioned tables

adding partitions, 4.2.3.2

heap-organized partitioned tables

table compression, 4.1.10

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.3.9

index subpartitions

marked UNUSABLE, 4.2.9.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.13.2

list-partitioned, 4.1.13.3

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

range-partitioned, 4.1.13.1

Information Lifecycle Management

about, 5.1

application transparency, 5.1.1

assigning classes to storage tiers, 5.2.2.1

Assistant, 5.4

auditing, 5.2.4.4

benefits of an online archive, 5.3

controlling access to data, 5.2.3.1

creating data access, 5.2.3

creating migration policies, 5.2.3

creating storage tiers, 5.2.2

data retention, 5.2.4.1

defining compliance policies, 5.2.4

defining data classes, 5.2.1

enforceable compliance policies, 5.1.1

enforcing compliance policies, 5.2.4

expiration, 5.2.4.5

fine-grained, 5.1.1

graphical user interface, 5.4

immutability, 5.2.4.2

implementing a system manually, 5.5

implementing using Oracle Database, 5.2

introduction, 5

lifecycle of data, 5.2.1.2

low-cost storage, 5.1.1

moving data using partitioning, 5.2.3.2

Oracle Database, and, 5.1.1

partitioning, 5.2.1.1

partitioning, and, 1.3

privacy, 5.2.4.3

regulatory requirements, 5.1.2

striping, 10.2.3

structured and unstructured data, 5.1.1.1

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.5.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.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.3.4

splitting partitions, 4.2.17.3

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, 3.2.2

partition-wise, 3.2

K

key compression

partitioning indexes, 4.1.11

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.10

creating tables using, 4.1.4

DEFAULT keyword, 4.1.4

dropping values from value-list, 4.2.11

index-organized tables, 4.1.13.3

performance considerations, 3.5.3

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.3.3

splitting partitions, 4.2.17.2, 4.2.17.5

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 index subpartitions

marking indexes UNUSABLE, 4.2.9.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.1.4, 8.3.2.1, 8.3.2.3

M

manageability

data warehouses, 6.4

material views

manageability with partitioning, 6.4.3

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

MINIMUM EXTENT parameter, 8.3.2.6

mirroring with Oracle ASM

very large databases (VLDBs), 10.1.2

MODIFY DEFAULT ATTRIBUTES clause, 4.2.9.1

using for partitioned tables, 4.2.8.1

MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause

of ALTER TABLE statement, 4.2.8.2, 4.2.8.3

MODIFY PARTITION clause, 4.2.9.1, 4.2.9.2, 4.2.13, 4.2.15.2.2

MODIFY SUBPARTITION clause, 4.2.9.3

modifying partition attributes

marking indexes UNUSABLE, 4.2.9.1

monitoring

parallel processing, 8.6.1

very large databases (VLDBs) with Oracle Enterprise Manager, 10.5

MOVE PARTITION clause, 4.2.9, 4.2.13

MOVE PARTITION statement

rules of parallelism, 8.3.2.8.2

MOVE SUBPARTITION clause, 4.2.9, 4.2.13.2

multiple archiver processes, 8.7.3.5, 8.7.3.5

multiple block sizes

restrictions on partitioning, 4.1.14

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.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.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)

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

Oracle Automatic Storage Management 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

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

SQL statements, 8.1.4

SQL*Loader, 8.1.4

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 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

parallel execution, 8.1

PARALLEL_DEGREE_POLICY, 8.2.4

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

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

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

FREELISTS, 8.7.3.4

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.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

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.3.9

composite partitions, 2.5.6

creating hash-partitioned global, 4.1.3.2

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.5.3

key compression, 4.1.11

maintenance operations, 4.2

maintenance operations that can be performed, 4.2.1

maintenance operations, table of, 4.2.1

modifying partition default attributes, 4.2.8.3

modifying real attributes of partitions, 4.2.9.4

moving partitions, 4.2.13.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.13.1

splitting partitions, 4.2.17.7

which type to use, 2.5.1

partitioned tables, 4

adding partitions, 4.2.3

adding subpartitions, 4.2.3.5.2, 4.2.3.6.2, 4.2.3.7.2

coalescing partitions, 4.2.4

creating composite, 4.1.6

creating composite interval, 4.1.6.5

creating composite list, 4.1.6.4

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.5

ENABLE ROW MOVEMENT, 4.1

exchanging partitions, 4.2.6

exchanging subpartitions, 4.2.6.6, 4.2.6.8, 4.2.6.10

global indexes, 7.3.2

index-organized tables, 4.1, 4.1.13.1, 4.1.13.2, 4.1.13.3

INTERVAL clause of CREATE TABLE, 4.1.2

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.3.2, 4.2.4, 4.2.7, 4.2.13, 4.2.17

merging partitions, 4.2.7

modifying default attributes, 4.2.8

modifying real attributes of partitions, 4.2.9

modifying real attributes of subpartitions, 4.2.9.3

moving partitions, 4.2.13

moving subpartitions, 4.2.13.2

multicolumn partitioning keys, 4.1.8

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.2.14

renaming partitions, 4.2.16

renaming subpartitions, 4.2.16.2

splitting partitions, 4.2.17

truncating partitions, 4.2.18

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.6.2

deferred segments, 4.1.12.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

indexes, 2.1.3.2, 2.5, 3.3

index-organized tables, 2.1.4, 4.1, 4.1.13.1, 4.1.13.2, 4.1.13.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.6.5.1

interval-list, 4.1.6.5.2

interval-range, 4.1.6.5.3

key, 2.1.2

key extensions, 2.4.2

list, 2.3.1.3, 4.2.10, 4.2.11

list-hash, 4.1.6.4.1

list-list, 4.1.6.4.2

list-range, 4.1.6.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.12.3

manageability, 2.2.2

manageability with indexes, 6.4.2

manageability with material views, 6.4.3

managing partitions, 3.3.2.2

mangeability extensions, 2.4.1

nonprefixed indexes, 3.3.1.2, 3.3.2.1, 3.3.4

Online Transaction Processing (OLTP), and, 7

overview, 2.1

Partition Advisor, 2.4.1.2

partitioned indexes on composite partitions, 2.5.6

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.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

restrictions for multiple block sizes, 4.1.14

segments, 4.1.12

single-level, 2.3.1

statistics gathering, 6.4.6

strategies, 2.3, 3.5

subpartition templates, 4.1.7

system, 2.1.5, 2.4, 2.4.1, 2.4.2

tables, 2.1.3, 2.1.3.1

truncating segments, 4.1.12.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.5

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

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

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

Privacy & Security

Compliance & Security, 5.4.3.3

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.13.1

multicolumn partitioning keys, 4.1.8

performance considerations, 3.5.1, 3.5.6

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.3.1

splitting partitions, 4.2.17.1, 4.2.17.6

range-range partitioning

creating tables using, 4.1.6.3, 4.1.6.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.13.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.3.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

Reports

Information Lifecycle Management Assistant, 5.4.4

resource manager

managing parallel statement queue, 8.2.4.1

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.1.4, 8.3.2.1

parallel DML operations, 8.3.3.9

parallel DML operations and 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

segments

creating on demand, 4.1.12.3

deferred, 4.1.12.1

partitioning, 4.1.12

truncating, 4.1.12.2

session statistics

monitoring for parallel processing, 8.6.2

sessions

enabling parallel DML operations, 8.3.3.2

SET INTERVAL clause, 4.2.3.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.3.1, 4.2.17

rules of parallelism, 8.3.2.8.2

SPLIT PARTITION operations

optimizing, 4.2.17.8

SPLIT SUBPARTITION operations

optimizing, 4.2.17.8

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.3.5.1, 4.2.3.6.1, 4.2.3.7.1, 4.2.17.4

for composite-partitioned tables, 4.1.6

subpartition templates, 4.1.7

modifying, 4.2.12

SUBPARTITIONS clause, 4.2.3.5.1, 4.2.17.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.5

system statistics

monitoring for parallel processing, 8.6.3

T

table compression

partitioning, 4.1.10

table queues

monitoring parallel processing, 8.6.1.7

tables

creating and populating in parallel, 8.7.1

creating composite partitioned, 4.1.6

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

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

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

distributed parallel and DDL restrictions, 8.1.4

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 partitions

marking indexes UNUSABLE, 4.2.18

truncating segments

partitioning, 4.1.12.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.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

monitoring parallel processing, 8.6.1.12

V$SESSTAT view, 8.6.4

V$SYSSTAT view, 8.7.3.6

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

monitoring with Oracle Enterprise Manager, 10.5

Oracle Automatic Storage Management settings, 10.4

Oracle Backup and Recovery, 9.2

Oracle Data Pump, 9.2.3, 9.2.3.3

Oracle Database File System, 10.2.6

Oracle Enterprise Manager, 9.2.3, 9.2.3.2

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.4

views

parallel processing monitoring, 8.6.1

V$SESSTAT, 8.6.4

V$SYSSTAT, 8.7.3.6

virtual column partitioning

performance considerations, 3.5.7

virtual column-based partitioning

about, 4.1.9

key extension, 2.4.2.2

using for the subpartitioning key, 4.1.9

vmstat UNIX command, 8.6.4

W

workloads

skewing, 8.2.7

X

XMLType collections

partitioning, 4.1.15

XMLType objects, 2.1.8