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 1
    • performance considerations 1
  • composite list-list partitioning 1
    • performance considerations 1
  • composite list-partitioned tables
    • adding partitions 1
  • composite list partitioning
    • creating tables using 1
  • composite list-range partitioning 1
    • performance considerations 1
  • composite partitioned tables
    • creating 1
  • composite partitioning 1
    • 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 1
    • performance considerations 1
  • composite range-interval partitioning
    • creating tables using 1
  • composite range-list partitioned tables
    • creating 1
  • composite range-list partitioning 1
    • performance considerations 1
  • composite range-partitioned tables
    • adding partitions 1
  • composite range-range partitioning 1
    • 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
  • 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 1, 2
    • 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 1, 2
      • 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 1
    • 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
  • hybrid partitioned tables
    • about 1
    • converting from 1
    • converting to 1
    • creating 1
    • managing 1
    • splitting partitions 1
    • using with ADO 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 1
      • 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 1
    • 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 1, 2
    • 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 PARTITION clause 1
  • MERGE statement
    • parallel MERGE statement 1
  • MERGE SUBPARTITION clause 1
  • merging multiple partitions 1
  • MINIMUM EXTENT parameter 1
  • mirroring with Oracle ASM
    • very large databases (VLDBs) 1
  • MODIFY DEFAULT ATTRIBUTES clause 1
    • using for partitioned tables 1
  • MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause 1
    • of ALTER TABLE statement 1
  • modifying
    • partitioning 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

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 1, 2
    • 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
  • operations
    • partition-wise 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 1
    • 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 1
    • 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 1
    • 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, 2, 3
    • 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 1
    • 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 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 1
    • 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 1
    • 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
    • modifying the strategy 1
    • new features 1, 2, 3
    • 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 1, 2
    • 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 1
    • advanced index compression 1
    • equipartitioning
      • examples 1
      • local indexes 1
    • global indexes 1, 2
    • guidelines for partitioning indexes 1
    • indexes 1
    • local indexes 1, 2
    • 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 1
    • benefits 1, 2
    • full 1, 2
    • parallel execution 1
    • partial 1, 2
  • partition-wise operations 1
  • performance
    • DSS database 1
    • prefixed and nonprefixed indexes 1
    • very large databases (VLDBs) 1
  • predicates
    • index partition pruning 1
  • prefixed indexes 1, 2
    • 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 1
    • 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
    • partitions 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 1, 2, 3, 4
    • for composite-partitioned tables 1
  • SUBPARTITIONS clause 1, 2
    • for composite-partitioned tables 1
  • subpartition templates 1
    • 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, 2, 3
    • 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