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 1
adding ILM policies
- for Automatic Data Optimization 1
adding index partitions 1
adding multiple partitions 1
adding partitions
- composite hash-partitioned tables 1
- composite list-partitioned tables 1
- composite range-partitioned tables 1
- hash-partitioned tables 1
- interval-partitioned tables 1
- list-partitioned tables 1
- partitioned tables 1
- range-partitioned tables 1
- reference-partitioned tables 1
ADD PARTITION clause 1
ADD SUBPARTITION clause 1 , 2 , 3
ALTER INDEX statement
- partition attributes 1
ALTER SESSION statement
- ENABLE PARALLEL DML clause 1
- FORCE PARALLEL DDL clause 1 , 2
- FORCE PARALLEL DML clause 1 , 2
ALTER TABLE statement
- MODIFY DEFAULT ATTRIBUTES clause 1
- MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause 1 , 2
applications
- decision support system (DSS)
  - parallel SQL 1
- direct-path INSERT 1
- parallel DML operations 1
asynchronous communication
- parallel execution servers 1
asynchronous global index maintenance
- for dropping and truncating partitions 1
asynchronous I/O 1
Automatic big table caching
- about 1
Automatic Data Optimization
- adding ILM policies 1
- and heat map 1
- DBMS_ILM_ADMIN package 1
- DBMS_ILM package 1
- deleting ILM policies 1
- disabling ILM policies 1
- ILM ADO parameters 1
- limitations 1
- managing ILM policies 1
- managing with Oracle Enterprise Manager 1
- monitoring DBA and ILM policy views 1
- row-level compression tiering 1
- segment-level compression tiering 1
- views for ILM policies 1
Automatic Data Optimization (ADO)
- for Information Lifecycle Management strategy 1
automatic list partitioning
- creating tables using 1

B

backing up and recovering
- very large databases (VLDBs) 1
bigfile tablespaces
- very large databases (VLDBs) 1
binary XML tables
- partitioning of XMLIndex 1

C

COALESCE PARTITION clause 1
collections
- tables 1
- XMLType 1 , 2
collection tables
- performing PMOs on partitions 1
composite hash-hash partitioning 1
composite hash-list partitioning 1
composite hash partitioned tables
- creating 1
composite hash-partitioned tables
- adding partitions 1
composite hash-range partitioning 1
composite interval partitioning
- creating tables using 1
composite list-hash partitioning
- performance considerations 1
composite list-list partitioning
- performance considerations 1
composite list-partitioned tables
- adding partitions 1
composite list partitioning
- creating tables using 1
composite list-range partitioning
- performance considerations 1
composite partitioned tables
- creating 1
composite partitioning
- default partition 1
- interval-hash 1
- interval-list 1
- interval-range 1
- list-hash 1
- list-list 1
- list-range 1
- performance considerations 1
- range-hash 1
- range-list 1
- range-range 1
- subpartition template, modifying 1
composite range-* partitioned tables
- creating 1
composite range-hash partitioning
- performance considerations 1
composite range-interval partitioning
- creating tables using 1
composite range-list partitioned tables
- creating 1
composite range-list partitioning
- performance considerations 1
composite range-partitioned tables
- adding partitions 1
composite range-range partitioning
- performance considerations 1
compression
- partitioning 1
compression table
- partitioning 1
concurrent execution of union all 1
constraints
- parallel create table 1
consumer operations 1
CREATE INDEX statement
- partition attributes 1
- partitioned indexes 1
CREATE TABLE AS SELECT statement
- decision support system 1
CREATE TABLE statement
- AS SELECT
  - rules of parallelism 1
  - space fragmentation 1
  - temporary storage space 1
- parallelism 1
creating hash partitioned tables
- examples 1
creating indexes on partitioned tables
- restrictions 1
creating interval partitions
- INTERVAL clause of CREATE TABLE 1
creating partitions 1
creating segments on demand
- maintenance procedures 1
critical consumer group
- specifying for parallel statement queuing 1

D

data
- parallel DML restrictions and integrity rules 1
databases
- partitioning, and 1
- scalability 1
database writer process (DBWn)
- tuning 1
data loading
- incremental in parallel 1
data manipulation language
- parallel DML operations 1
- transaction model for parallel DML operations 1
data segment compression
- bitmap indexes 1
- example 1
- partitioning 1
data warehouses
- about 1
- advanced partition pruning 1
- ARCHIVELOG mode for recovery 1
- backing up and recovering 1
- backing up and recovering characteristics 1
- backing up tables on individual basis 1
- backup and recovery 1
- basic partition pruning 1
- block change tracking for backups 1
- data compression and partitioning 1
- differences with online transaction processing backups 1
- extract, transform, and load for backup and recovery 1
- extract, transform, and load strategy 1
- flashback database and guaranteed restore points 1
- incremental backups 1
- incremental backup strategy 1
- leverage read-only tablespaces for backups 1
- manageability 1
- manageability with partition exchange load 1
- materialized views and partitioning 1
- more complex queries 1
- more users querying the system 1
- NOLOGGING mode for backup and recovery 1
- partitioned tables 1
- partitioning 1
- partitioning and removing data from tables 1
- partitioning for large databases 1
- partitioning for large tables 1
- partitioning for scalability 1
- partitioning materialized views 1
- partition pruning 1
- recovery methodology 1
- recovery point object (RPO) 1
- recovery time object (RTO) 1
- refreshing table data 1
- RMAN for backup and recovery 1
- RMAN multi-section backups 1
DB_BLOCK_SIZE initialization parameter
- parallel query 1
DB_CACHE_SIZE initialization parameter
- parallel query 1
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter
- parallel query 1
DBMS_HEAT_MAP package
- subprograms for Heat MAP 1
DBMS_ILM_ADMIN package
- Automatic Data Optimization 1
DBMS_ILM package
- Automatic Data Optimization 1
decision support system (DSS)
- parallel DML operations 1
- parallel SQL 1 , 2
- performance 1
- scoring tables 1
default partitions 1
default subpartition 1
deferred segments
- partitioning 1
degree of parallelism
- adaptive parallelism 1
- automatic 1
- between query operations 1
- controlling with initialization parameters and hints 1
- determining for auto DOP 1
- in-memory parallel execution 1
- manually specifying 1
- parallel execution servers 1
- specifying a limit for a consumer group 1
DELETE statement
- parallel DELETE statement 1
deleting ILM policies
- for Automatic Data Optimization 1
direct-path INSERT
- restrictions 1
DISABLE_PARALLEL_DML SQL hint 1
DISABLE ROW MOVEMENT clause 1
disabling ILM policies
- for Automatic Data Optimization 1
DISK_ASYNCH_IO initialization parameter
- parallel query 1
distributed transactions
- parallel DML restrictions 1
DML_LOCKS
- parallel DML 1
DROP PARTITION clause 1
dropping multiple partitions 1
dropping partitioned tables 1
dropping partitions
- asynchronous global index maintenance 1
DSS database
- partitioning indexes 1

E

ENABLE_PARALLEL_DML SQL hint 1
ENABLE ROW MOVEMENT clause 1 , 2
equipartitioning
- examples 1
- local indexes 1
EXCHANGE PARTITION clause 1 , 2 , 3 , 4 , 5
EXCHANGE SUBPARTITION clause 1
exchanging partitions
- cascade option 1
extents
- parallel DDL statements 1
extract, transform, and load
- data warehouses 1

F

features
- new for Information Lifecycle Management 1
- new for parallel execution 1
- new for partitioning 1
- new for VLDBs 1
filtering
- maintenance operations on partitions 1
FOR PARTITION clause 1
fragmentation
- parallel DDL 1
full partition-wise join
- querying 1
full partition-wise joins
- composite - composite 1
- composite - single-level 1
- single-level - single-level 1
full table scans
- parallel execution 1
functions
- parallel DML and DDL statements 1
- parallel execution 1
- parallel queries 1

G

global hash partitioned indexes
- about 1
global indexes
- partitioning
  - summary of index types 1
global nonpartitioned indexes
- about 1
global partitioned indexes
- about 1
- maintenance 1
global range partitioned indexes
- about 1
granuless
- parallelism 1
groups
- instance 1

H

hardware-based mirroring
- very large databases (VLDBs) 1
hardware-based striping
- very large databases (VLDBs) 1
hash-partitioned tables
- adding partitions 1
hash partitioning
- creating global indexes 1
- creating tables examples 1
- creating tables using 1
- index-organized tables 1
- multicolumn partitioning keys 1
- performance considerations 1
hash partitions
- splitting 1
heap-organized partitioned tables
- table compression 1
HEAT_MAP initialization parameter
- disabling 1
- enabling 1
Heat Map
- ALL, DBA, USER, and V$ views 1
- and automatic data optimization 1
- disabling 1
- enabling 1
- for Information Lifecycle Management strategy 1
- limitations 1
- managing with DBMS_HEAT_MAP subprograms 1
- managing with Oracle Enterprise Manager 1
- viewing tracking information 1
heat map and automatic data optimization
- implementing an ILM strategy 1
hints
- parallel statement queuing 1
Hybrid Columnar Compression
- example 1

I

I/O
- asynchronous 1
- parallel execution 1
ILM
- See: Information Lifecycle Management
ILM policies
- for Automatic Data Optimization 1
implementing an ILM system
- manually with partitioning 1
- using Oracle Database 1
In-Database Archiving
- limitations 1
- managing data visibility 1
- ORA_ARCHIVE_STATE 1
- ROW ARCHIVAL VISIBILITY 1
indexes
- advanced compression with partitioning 1
- creating in parallel 1
- global partitioned 1
- global partitioned indexes
  - managing partitions 1
- local indexes 1
- local partitioned 1
- manageability with partitioning 1
- nonpartitioned 1
- parallel creation 1
- parallel DDL storage 1
- parallel local 1
- partitioned 1
- partitioning 1
- partitioning guidelines 1
- partitions 1
- updating automatically 1
- updating global indexes 1
- when to partition 1
index-organized tables
- hash-partitioned 1
- list-partitioned 1
- parallel queries 1
- partitioning 1 , 2
- partitioning secondary indexes 1
- range-partitioned 1
index partitions
- adding 1
Information Lifecycle Management
- about 1
- and HEAT_MAP initialization parameter 1
- application transparency 1
- assigning classes to storage tiers 1
- auditing 1
- benefits of an online archive 1
- controlling access to data 1
- creating data access 1
- creating migration policies 1
- creating storage tiers 1
- data retention 1
- defining compliance policies 1
- defining data classes 1
- enforceable compliance policies 1
- enforcing compliance policies 1
- expiration 1
- fine-grained 1
- heat map and automatic data optimization 1
- immutability 1
- implemented with Automatic Data Optimization 1
- implementing a system manually with partitioning 1
- implementing using Oracle Database 1
- implementing with Heat Map 1
- introduction 1
- lifecycle of data 1
- limitations 1
- low-cost storage 1
- moving data using partitioning 1
- Oracle Database, and 1
- partitioning 1
- partitioning, and 1
- privacy 1
- regulatory requirements 1
- striping 1
- structured and unstructured data 1
- time-based information 1
Information Lifecycle Management (ILM)
- new features 1
initialization parameters
- MEMORY_MAX_TARGET 1
- MEMORY_TARGET 1
- PARALLEL_EXECUTION_MESSAGE_SIZE 1 , 2
- PARALLEL_FORCE_LOCAL 1
- PARALLEL_MAX_SERVERS 1
- PARALLEL_MIN_PERCENT 1
- PARALLEL_MIN_SERVERS 1 , 2
- PARALLEL_MIN_TIME_THRESHOLD 1
- PARALLEL_SERVERS_TARGET 1
- SHARED_POOL_SIZE 1
INSERT statement
- parallelizing INSERT SELECT 1
instance groups
- for parallel operations 1
- limiting the number of instances 1
integrity rules
- parallel DML restrictions 1
interval-hash partitioning
- creating tables using 1
- subpartitioning template 1
interval-list partitioning
- creating tables using 1
- subpartitioning template 1
interval partitioned tables
- dropping partitions 1
interval-partitioned tables
- adding partitions 1
- splitting partitions 1
interval partitioning
- creating tables using 1
- manageability 1
- performance considerations 1 , 2
interval-range partitioning
- creating tables using 1
interval-reference partitioned tables
- creating 1

J

joins
- full partition-wise 1
- partial partition-wise 1
- partition-wise 1

K

key compression
- partitioning indexes 1

L

list-hash partitioning
- creating tables using 1
- subpartitioning template 1
list-list partitioning
- creating tables using 1
- subpartitioning template 1
list-partitioned tables
- adding partitions 1
- creating 1 , 2
- splitting partitions 1 , 2
list partitioning
- adding values to value list 1
- creating tables using 1
- dropping values from value-list 1
- index-organized tables 1
- modifying 1
- performance considerations 1
list-range partitioning
- creating tables using 1
LOB data types
- restrictions on parallel DDL statements 1
- restrictions on parallel DML operations 1
local indexes
- equipartitioning 1
local partitioned indexes
- about 1
LOGGING clause 1
logging mode
- parallel DDL 1 , 2

M

maintenance operations
- supported on index partitions 1
- supported on partitioned tables 1
maintenance operations on partitions
- filtering 1
manageability
- data warehouses 1
managing data validity
- Temporal Validity 1
managing data visibility
- In-Database Archiving 1
managing ILM policies
- for Automatic Data Optimization 1
memory
- configure at 2 levels 1
MEMORY_MAX_TARGET initialization parameter 1
MEMORY_TARGET initialization parameter 1
MERGE statement
- parallel MERGE statement 1
merging multiple partitions 1
MINIMUM EXTENT parameter 1
mirroring with Oracle ASM
- very large databases (VLDBs) 1
MODIFY DEFAULT ATTRIBUTES clause
- using for partitioned tables 1
MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause
- of ALTER TABLE statement 1
MODIFY PARTITION clause 1 , 2 , 3 , 4
MODIFY SUBPARTITION clause 1
monitoring
- parallel processing 1 , 2
MOVE PARTITION clause 1 , 2
MOVE SUBPARTITION clause 1 , 2
multi-column list partitioning
- creating tables using 1
multiple archiver processes 1
multiple block sizes
- restrictions on partitioning 1
multiple parallelizers 1
multiple partitions
- adding 1
- dropping 1
- merging 1
- splitting 1
- truncating 1
multitenant container databases
- parallel statement queuing 1

N

NO_STATEMENT_QUEUING
- parallel statement queuing hint 1
NOLOGGING clause 1
NOLOGGING mode
- parallel DDL 1 , 2
nonpartitioned indexes 1
nonpartitioned tables
- changing to partitioned tables 1
non-partitioned tables
- converting to partitioned tables 1
nonprefixed indexes
- global partitioned indexes 1
nonprefixed indexes_importance 1

O

object types
- parallel queries 1
- restrictions on parallel DDL statements 1
- restrictions on parallel DML operations 1
- restrictions on parallel queries 1
of ALTER TABLE statement 1
OLTP database
- batch jobs 1
- parallel DML operations 1
- partitioning indexes 1
Online Transaction Processing (OLTP)
- about 1
- common partition maintenance operations 1
- partitioning, and 1
- when to partition indexes 1
operating system statistics
- monitoring for parallel processing 1
optimization
- partitioned indexes 1
- partition pruning and indexes 1
optimizations
- parallel SQL 1
ORA_ARCHIVE_STATE
- In-Database Archiving 1
Oracle Automatic Storage Management settings
- very large databases (VLDBs) 1
Oracle Database File System
- very large databases (VLDBs) 1
Oracle Database Resource Manager
- managing parallel statement queue 1
Oracle Real Application Clusters
- instance groups 1

P

PARALLEL_DEGREE_POLICY initialization parameter
- automatic degree of parallelism 1
- controlling automatic DOP 1
PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter 1 , 2
PARALLEL_FORCE_LOCAL initialization parameter 1
PARALLEL_MAX_SERVERS initialization parameter
- parallel execution 1
PARALLEL_MIN_PERCENT initialization parameter 1
PARALLEL_MIN_SERVERS initialization parameter 1 , 2
PARALLEL_MIN_TIME_THRESHOLD initialization parameter 1
PARALLEL_SERVERS_TARGET initialization parameter 1
PARALLEL clause 1
parallel DDL statements
- extent allocation 1
- partitioned tables and indexes 1
- restrictions on LOBs 1
- restrictions on object types 1 , 2
parallel delete 1
parallel DELETE statement 1
parallel DML
- considerations for parallel execution 1
parallel DML and DDL statements
- functions 1
parallel DML operations
- applications 1
- enabling PARALLEL DML 1
- recovery 1
- restrictions 1
- restrictions on LOB data types 1
- restrictions on object types 1 , 2
- restrictions on remote transactions 1
- transaction model 1
parallel execution
- about 1 , 2 , 3
- adaptive parallelism 1
- bandwidth 1
- benefits 1
- considerations for parallel DML 1
- CPU utilization 1
- CREATE TABLE AS SELECT statement 1
- DB_BLOCK_SIZE initialization parameter 1
- DB_CACHE_SIZE initialization parameter 1
- DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter 1
- default parameter settings 1
- DISK_ASYNCH_IO initialization parameter 1
- forcing for a session 1
- full table scans 1
- functions 1
- fundamental hardware requirements 1
- I/O 1
- I/O parameters 1
- index creation 1
- initializing parameters 1
- in-memory 1
- inter-operator parallelism 1
- intra-operator parallelism 1
- massively parallel systems 1
- new features 1
- Oracle RAC 1
- parallel load 1
- parallel propagation 1
- parallel recovery 1
- parallel replication 1
- parameters for establishing resource limits 1
- resource parameters 1
- symmetric multiprocessors 1
- TAPE_ASYNCH_IO initialization parameter 1
- tips for tuning 1
- tuning general parameters 1
- tuning parameters 1
- using 1
- when not to use 1
parallel execution strategy
- implementing 1
PARALLEL hint
- UPDATE, MERGE, and DELETE 1
parallelism
- about 1
- adaptive 1
- degree 1
- inter-operator 1
- intra-operator 1
- other types 1
- parallel DDL statements 1
- parallel DML operations 1
- parallel execution of functions 1
- parallel queries 1
- types 1
parallelization
- methods for specifying precedence 1
- rules for SQL operations 1
parallel partition-wise joins
- performance considerations 1
parallel processing
- monitoring 1
- monitoring operating system statistics 1
- monitoring session statistics 1
- monitoring system statistics 1
- monitoring with GV$FILESTAT view 1
- monitoring with performance views 1
parallel queries
- functions 1
- index-organized tables 1
- object types 1
- restrictions on object types 1
parallel query
- integrating with the automatic big table caching 1
- parallelism type 1
parallel server resources
- limiting for a consumer group 1
parallel servers
- asynchronous communication 1
parallel SQL
- allocating rows to parallel execution servers 1
- distribution methods 1
- instance groups 1
- number of parallel execution servers 1
- optimizer 1
parallel statement queue
- about 1
- grouping parallel statements 1
- hints 1
- limiting parallel server resources 1
- managing for CDBs and PDBs 1
- managing for consumer groups 1
- managing the order of dequeuing 1
- managing with Oracle Database Resource Manager 1
- NO_STATEMENT_QUEUING hint 1
- PARALLEL_DEGREE_POLICY 1
- sample scenario for managing parallel statements 1
- setting order of parallel statements 1
- specifying a critical consumer group 1
- specifying a DOP limit for a consumer group 1
- specifying a timeout for a consumer group 1
- STATEMENT_QUEUING hint 1
- using BEGIN_SQL_BLOCK to group statements 1
parallel update 1
parallel UPDATE statement 1
parameters
- Automatic Data Optimization 1
partial indexes
- on partitioned tables 1
partial partition-wise joins
- about 1
- composite 1
- single-level 1
PARTITION_START
- partition pruning 1
PARTITION_STOP
- partition pruning 1
Partition Advisor
- manageability 1
partition bound
- range-partitioned tables 1
PARTITION BY HASH clause 1
PARTITION BY LIST clause 1
PARTITION BY RANGE clause
- for composite-partitioned tables 1
PARTITION BY REFERENCE clause 1
PARTITION clause
- for composite-partitioned tables 1
- for hash partitions 1
- for list partitions 1
- for range partitions 1
partitioned external tables
- creating 1
partitioned indexes
- about 1
- adding partitions 1
- administration 1
- composite partitions 1
- creating hash-partitioned global 1
- creating local index on composite partitioned table 1
- creating local index on hash partitioned table 1
- creating range partitions 1
- dropping partitions 1
- key compression 1
- maintenance operations 1 , 2
- maintenance operations that can be performed 1
- modifying partition default attributes 1
- modifying real attributes of partitions 1
- moving partitions 1
- Online Transaction Processing (OLTP) 1
- rebuilding index partitions 1
- renaming index partitions/subpartitions 1
- secondary indexes on index-organized tables 1
- splitting partitions 1
- views 1
- which type to use 1
partitioned tables
- adding partitions 1
- adding subpartitions 1 , 2 , 3
- administration 1
- coalescing partitions 1
- converting to from non-partitioned tables 1
- creating automatic list partitions 1
- creating composite 1
- creating composite interval 1
- creating composite list 1
- creating hash partitions 1
- creating interval-hash partitions 1
- creating interval-list partitions 1
- creating interval partitions 1
- creating interval-range partitions 1
- creating list-hash partitions 1
- creating list-list partitions 1
- creating list partitions 1
- creating list-range partitions 1
- creating multi-column list partitions 1
- creating range-hash partitions 1
- creating range-list partitions 1
- creating range partitions 1 , 2
- creating range-range partitions 1
- creating reference partitions 1
- data warehouses 1
- DISABLE ROW MOVEMENT 1
- dropping 1
- dropping partitions 1
- ENABLE ROW MOVEMENT 1
- exchanging partitions and subpartitions 1
- exchanging partitions with a cascade option 1
- exchanging subpartitions 1 , 2 , 3
- filtering maintenance operations 1
- FOR EXCHANGE WITH 1
- global indexes 1
- incremental statistics and partition exchange operations 1
- index-organized tables 1 , 2 , 3 , 4
- in-memory column store 1
- INTERVAL clause of CREATE TABLE 1
- interval-reference 1
- local indexes 1
- maintenance operations 1
- maintenance operations that can be performed 1
- maintenance operations with global indexes 1
- maintenance operations with local indexes 1
- marking indexes UNUSABLE 1
- merging partitions 1
- modifying default attributes 1
- modifying real attributes of partitions 1
- modifying real attributes of subpartitions 1
- moving partitions 1
- moving subpartitions 1
- multicolumn partitioning keys 1
- partition bound 1
- partitioning columns 1
- partitioning keys 1
- read-only status 1
- rebuilding index partitions 1
- redefining partitions online 1
- renaming partitions 1
- renaming subpartitions 1
- splitting partitions 1
- truncating partitions 1
- truncating partitions with the cascade option 1
- truncating subpartitions 1
- updating global indexes automatically 1
- views 1
partition exchange load
- manageability 1
partition granules 1
partitioning
- about 1
- administration of indexes 1
- administration of tables 1
- advanced index compression 1
- advantages 1
- availability 1 , 2
- basics 1
- benefits 1
- bitmap indexes 1
- collections in XMLType and object data 1
- composite 1
- composite list-hash 1
- composite list-list 1
- composite list-range 1
- composite range-hash 1
- composite range-list 1
- composite range-range 1
- concepts 1
- creating a partitioned index 1
- creating a partitioned table 1
- creating indexes on partitioned tables 1
- databases, and 1
- data segment compression 1 , 2
- data segment compression example 1
- data warehouses 1
- data warehouses and scalability 1
- default partition 1
- default subpartition 1
- deferred segments 1
- EXCHANGE PARTITION clause 1
- exchanging a hash partitioned table 1
- exchanging a range partitioned table 1
- exchanging interval partitions 1
- extensions 1
- global hash partitioned indexes 1
- global indexes 1
- global nonpartitioned indexes 1
- global partitioned indexes 1
- global range partitioned indexes 1
- guidelines for indexes 1
- hash 1
- Hybrid Columnar Compression example 1
- indexes 1 , 2 , 3
- index-organized tables 1 , 2 , 3 , 4 , 5
- Information Lifecycle Management 1
- Information Lifecycle Management, and 1
- interval 1 , 2
- interval-hash 1
- interval-list 1
- interval-range 1
- key 1
- key extensions 1
- list 1 , 2 , 3
- list-hash 1
- list-list 1
- list-range 1
- LOB data 1
- local indexes 1
- local partitioned indexes 1
- maintaining partitions 1
- maintenance procedures for segment creation 1
- manageability 1 , 2
- manageability extensions 1
- manageability with indexes 1
- managing partitions 1
- modifying attributes 1
- modifying list partitions 1
- new features 1
- nonprefixed indexes 1 , 2 , 3
- Online Transaction Processing (OLTP) 1
- overview 1 , 2
- partial indexes on partitioned tables 1
- Partition Advisor 1
- partitioned indexes on composite partitions 1
- partition-wise joins 1
- performance 1 , 2 , 3
- performance considerations 1
- performance considerations for composite 1
- performance considerations for composite list-hash 1
- performance considerations for composite list-list 1
- performance considerations for composite list-range 1
- performance considerations for composite range-hash 1
- performance considerations for composite range-list 1
- performance considerations for composite range-range 1
- performance considerations for hash 1
- performance considerations for interval 1
- performance considerations for list 1
- performance considerations for range 1
- performance considerations for virtual columns 1
- placement with striping 1
- prefixed indexes 1 , 2
- pruning 1 , 2
- range 1
- range-hash 1
- range-list 1
- range-range 1
- reference 1
- removing data from tables 1
- restrictions for multiple block sizes 1
- segments 1
- single-level 1
- strategies 1 , 2
- subpartition templates 1
- system 1 , 2 , 3 , 4
- tables 1 , 2
- truncating segments 1
- type of index to use 1
- very large databases (VLDBs), and 1
- virtual columns 1
partitioning and data compression
- data warehouses 1
partitioning and materialized views
- data warehouses 1
partitioning columns
- range-partitioned tables 1
partitioning keys
- range-partitioned tables 1
partitioning materialized views
- data warehouses 1
partitioning of XMLIndex
- binary XML tables 1
partition maintenance operations
- merging older partitions 1
- moving older partitions 1
- Online Transaction Processing (OLTP) 1
- removing old data 1
partition pruning
- about 1
- benefits 1
- collection tables 1
- data type conversions 1
- dynamic 1
- dynamic with bind variables 1
- dynamic with nested loop joins 1
- dynamic with star transformation 1
- dynamic with subqueries 1
- function calls 1
- identifying 1
- information for pruning 1
- PARTITION_START 1
- PARTITION_STOP 1
- static 1
- tips and considerations 1
- with zone maps 1
partitions
- advanced index compression 1
- equipartitioning
  - examples 1
  - local indexes 1
- global indexes 1 , 2
- guidelines for partitioning indexes 1
- indexes 1
- local indexes 1
- nonprefixed indexes 1 , 2 , 3
- on indexes 1
- parallel DDL statements 1
- physical attributes 1
- prefixed indexes 1
PARTITIONS clause
- for hash partitions 1
partition-wise joins
- benefits 1 , 2
- full 1 , 2
- parallel execution 1
- partial 1 , 2
performance
- DSS database 1
- prefixed and nonprefixed indexes 1
- very large databases (VLDBs) 1
pluggable databases
- parallel statement queuing 1
predicates
- index partition pruning 1
prefixed indexes
- partition pruning 1
processes
- memory contention in parallel processing 1
process monitor process (PMON)
- parallel DML process recovery 1
producer operations 1
pruning partitions
- about 1
- benefits 1
- indexes and performance 1

Q

queries
- ad hoc 1
queuing
- parallel statements 1

R

range-hash partitioning
- creating tables using 1
- subpartitioning template 1
range-list partitioning
- creating tables using 1
- subpartitioning template 1
range-partitioned tables
- adding partitions 1
- splitting partitions 1 , 2
range partitioning
- creating tables using 1
- index-organized tables 1
- multicolumn partitioning keys 1
- performance considerations 1 , 2
range-range partitioning
- creating tables using 1
read-only status
- tables, partitions, and subpartitions 1
read-only tablespaces
- performance considerations 1
REBUILD PARTITION clause 1 , 2
REBUILD UNUSABLE LOCAL INDEXES clause 1
recovery
- parallel DML operations 1
reference-partitioned tables
- adding partitions 1
reference partitioning
- creating tables using 1
- key extension 1
RENAME PARTITION clause 1 , 2
RENAME SUBPARTITION clause 1
replication
- restrictions on parallel DML 1
resources
- consumption, parameters affecting 1 , 2
- limiting for users 1
- limits 1
- parallel query usage 1
restrictions
- direct-path INSERT 1
- parallel DDL statements 1
- parallel DML operations 1
- parallel DML operations and remote transactions 1
ROW ARCHIVAL VISIBILITY
- In-Database Archiving 1
row-level compression tiering
- Automatic Data Optimization 1
row movement clause for partitioned tables 1

S

scalability
- batch jobs 1
- parallel DML operations 1
scalability and manageability
- very large databases (VLDBs) 1
scans
- parallel query on full table 1
segment-level compression tiering
- Automatic Data Optimization 1
segments
- creating on demand 1
- deferred 1
- partitioning 1
- truncating 1
sessions
- enabling parallel DML operations 1
session statistics
- monitoring for parallel processing 1
SET INTERVAL clause 1
SHARED_POOL_SIZE initialization parameter 1
single-level partitioning 1
skewing parallel DML workload 1
SORT_AREA_SIZE initialization parameter
- parallel execution 1
space management
- MINIMUM EXTENT parameter 1
- parallel DDL 1
SPLIT PARTITION clause 1 , 2
SPLIT PARTITION operations
- optimizing 1
SPLIT SUBPARTITION operations
- optimizing 1
splitting multiple partitions 1
splitting partitions and subpartitions 1
SQL statementsSQL statements
- data flow operations 1
- parallelizing 1
STATEMENT_QUEUING
- parallel statement queuing hint 1
statistics
- operating system 1
storage
- fragmentation in parallel DDL 1
- index partitions 1
STORAGE clause
- parallel execution 1
storage management
- very large databases (VLDBs) 1
STORE IN clause 1
stripe and mirror everything
- very large databases (VLDBs) 1
striping
- Information Lifecycle Management 1
- partitioning placement 1
striping with Oracle ASM
- very large databases (VLDBs) 1
SUBPARTITION BY HASH clause
- for composite-partitioned tables 1
SUBPARTITION clause
- for composite-partitioned tables 1
SUBPARTITIONS clause
- for composite-partitioned tables 1
subpartition templates
- modifying 1
subqueries
- in DDL statements 1
system monitor process (SMON)
- parallel DML system recovery 1
system partitioning 1
system statistics
- monitoring for parallel processing 1

T

table compression
- partitioning 1
table queues
- monitoring parallel processing 1
tables
- creating and populating in parallel 1
- creating composite partitioned 1
- full partition-wise joins 1 , 2
- historical 1
- index-organized, partitioning 1
- parallel creation 1
- parallel DDL storage 1
- partial partition-wise joins 1 , 2
- partitioning 1
- partitions 1
- refreshing in data warehouse 1
- STORAGE clause with parallel execution 1
- summary 1
- when to partition 1
tables for exchange
- with partitioned tables 1
TAPE_ASYNCH_IO initialization parameter
- parallel query 1
temporal validity
- creating a table with 1
Temporal Validity
- DBMS_FLASHBACK_ARCHIVE package ENABLE_AT_VALID_TIME procedure 1
- limitations 1
- managing data validity 1
- valid-time period 1
temporary segments
- parallel DDL 1
time-based information
- Information Lifecycle Management 1
transactions
- distributed and parallel DML restrictions 1
triggers
- restrictions 1
- restrictions on parallel DML 1
TRUNCATE PARTITION clause 1 , 2 , 3
TRUNCATE SUBPARTITION clause 1
truncating multiple partitions 1
truncating partitions
- asynchronous global index maintenance 1
- cascade option 1
- marking indexes UNUSABLE 1
truncating segments
- partitioning 1
two-phase commit 1
types of parallelism 1

U

UNION ALL
- concurrent execution 1
UPDATE GLOBAL INDEX clause
- of ALTER TABLE 1
UPDATE statement
- parallel UPDATE statement 1
updating indexes automatically 1
user resources
- limiting 1

V

V$PQ_SESSTAT view
- monitoring parallel processing 1
V$PQ_TQSTAT view
- monitoring parallel processing 1
V$PX_BUFFER_ADVICE view
- monitoring parallel processing 1
V$PX_PROCESS_SYSSTAT view
- monitoring parallel processing 1
V$PX_PROCESS view
- monitoring parallel processing 1
V$PX_SESSION view
- monitoring parallel processing 1
V$PX_SESSTAT view
- monitoring parallel processing 1
V$RSRC_CONS_GROUP_HISTORY view
- monitoring parallel processing 1
V$RSRC_CONSUMER_GROUP view
- monitoring parallel processing 1
V$RSRC_PLAN_HISTORY view
- monitoring parallel processing 1
V$RSRC_PLAN view
- monitoring parallel processing 1
V$RSRC_SESSION_INFO view
- parallel statement queuing metrics 1
V$RSRCMGRMETRIC view
- parallel statement queuing statistics 1
V$SESSTAT view 1
V$SYSSTAT view 1
valid-time period
- Temporal Validity 1
very large databases (VLDBs)
- about 1
- backing up and recovering 1
- backup tools 1
- backup types 1
- bigfile tablespaces 1
- database structures for recovering data 1
- hardware-based mirroring 1
- hardware-based striping 1
- high availability 1
- introduction 1
- mirroring with Oracle ASM 1
- new features 1
- Oracle Automatic Storage Management settings 1
- Oracle Backup and Recovery 1
- Oracle Database File System 1
- Oracle Data Pump 1 , 2
- Oracle Recovery Manager 1
- partitioning, and 1
- performance 1
- physical and logical backups 1
- RAID 0 striping 1
- RAID 1 mirroring 1
- RAID 5 mirroring 1
- RAID 5 striping 1
- RMAN 1
- scalability and manageability 1
- storage management 1
- stripe and mirror everything 1
- striping with Oracle ASM 1
- user-managed backups 1 , 2
views
- parallel processing monitoring 1
- partitioned tables and indexes 1
- V$SESSTAT 1
- V$SYSSTAT 1
views for ILM policies
- Automatic Data Optimization 1
virtual column-based partitioning
- about 1
- key extension 1
- using for the subpartitioning key 1
virtual column partitioning
- performance considerations 1
VLDBs
- very large databases 1

W

workloads
- skewing 1

X

XMLType collections
- partitioning 1
XMLType objects 1