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
Hybrid Columnar Compression
example, 3.4.2

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