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]
  • ALTER INDEX statement
    • partition attributes [1]
  • ALTER SESSION statement
    • ENABLE PARALLEL DML clause [1]
    • FORCE PARALLEL DDL clause
      • create or rebuild index [1]
      • create table as select [1]
      • move or split partition [1]
    • FORCE PARALLEL DML clause
  • 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
  • Automatic Data Optimization
    • adding ILM policies [1]
    • DBMS_ILM_ADMIN package [1]
    • DBMS_ILM package [1]
    • deleting ILM policies [1]
    • disabling ILM policies [1]
    • for Information Lifecycle Management strategy [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]

B

  • bigfile tablespaces
    • very large databases (VLDBs) [1]
  • binary XML tables
    • partitioning of XMLIndex [1]

C

  • clusters
    • cannot be partitioned [1]
    • indexes on cannot be partitioned [1]
  • COALESCE PARTITION clause [1]
  • collections
  • collection tables
    • performing PMOs on partitions [1]
  • composite hash-hash partitioning [1]
  • composite hash-list partitioning [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
  • 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-hash partitioning
    • performance considerations [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]
    • rules of parallelism [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
  • 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)
  • 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, and [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]
    • controlling with the NO_PARALLEL hint [1]
    • controlling with the PARALLEL hint [1]
    • in-memory parallel execution [1]
    • manually specifying [1]
    • maximum query directive [1]
    • PARALLEL_DEGREE_POLICY initialization parameter [1]
    • parallel execution servers [1]
    • setting DOP with ALTER SESSION statements [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]
  • 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] , [6]
  • 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 VLDBs [1]
  • FOR PARTITION clause [1]
  • fragmentation
    • parallel DDL [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
  • global indexes
    • partitioning
      • summary of index types [1]
  • global nonpartitioned indexes
  • global partitioned indexes
  • global range partitioned indexes
  • granules [1]
  • groups

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
  • Heat Map
    • ALL, DBA, USER, and V$ views [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]
  • hints
    • parallel statement queuing [1]
  • Hybrid Columnar Compression

I

  • I/O
    • asynchronous [1]
    • parallel execution [1]
  • I/O calibration
    • PARALLEL_DEGREE_POLICY initialization parameter [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
    • cluster cannot be partitioned [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
  • Information Lifecycle Management
    • about [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]
    • 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]
  • 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

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]
    • 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]
    • 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
  • LOGGING clause [1]
  • logging mode

M

  • maintenance operations
    • on index partitions [1]
    • on partitioned tables [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]
  • materialized views
    • partitioned [1]
  • maximum query directive
    • degree of parallelism [1]
  • memory
    • configure at 2 levels [1]
  • MEMORY_MAX_TARGET initialization parameter [1]
  • MEMORY_TARGET initialization parameter [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] , [2]
  • MODIFY PARTITION clause [1] , [2] , [3]
  • MODIFY SUBPARTITION clause [1]
  • monitoring
    • parallel processing [1]
  • MOVE PARTITION clause [1] , [2]
  • MOVE PARTITION statement
    • rules of parallelism [1]
  • MOVE SUBPARTITION clause [1] , [2]
  • multiple archiver processes [1]
  • multiple block sizes
    • restrictions on partitioning [1]
  • multiple partitions
  • multitenant container databases
    • parallel statement queuing [1]

N

  • NO_STATEMENT_QUEUING
    • parallel statement queuing hint [1]
  • NOLOGGING clause [1]
  • NOLOGGING mode
  • nonpartitioned indexes [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]
  • 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]
    • degree of parallelism [1]
    • I/O calibration [1]
    • parallel execution [1]
    • parallel statement queuing [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]
    • degree of parallelism [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]
    • 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 calibration [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]
    • PARALLEL_DEGREE_POLICY initialization parameter [1]
    • parallel load [1]
    • parallel propagation [1]
    • parallel recovery [1]
    • parallel replication [1]
    • parameters for establishing resource limits [1]
    • resource manager and statement queue [1]
    • resource parameters [1]
    • statement queue [1]
    • symmetric multiprocessors [1]
    • TAPE_ASYNCH_IO initialization parameter [1]
    • tuning general parameters [1]
    • tuning parameters [1]
    • using a resource plan [1]
    • when not to use [1]
  • PARALLEL hint
    • UPDATE 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 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
    • 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]
    • 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]
    • parallel execution [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]
    • using with resource manager [1]
  • parallel statement queuing
    • PARALLEL_DEGREE_POLICY initialization parameter [1]
  • parallel update [1]
  • parallel UPDATE statement [1]
  • paralllel query
    • integrating with the automatic big table caching [1]
  • parameters
    • Automatic Data Optimization [1]
  • partial indexes
    • on partitioned tables [1]
  • partial partition-wise joins
  • 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 indexes
    • about [1]
    • adding partitions [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]
    • maintenance operations, table of [1]
    • 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]
    • which type to use [1]
  • partitioned tables
    • adding partitions [1]
    • adding subpartitions [1] , [2]
    • coalescing 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 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]
    • global indexes [1]
    • incremental statistics and partition exchange operations [1]
    • index-organized tables [1] , [2] , [3]
    • 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]
    • 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]
  • partition exchange load
    • manageability [1]
  • partitioning
    • about [1] , [2]
    • advantages [1]
    • availability [1]
    • availability, manageability, and performance [1]
    • 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, and [1]
    • data warehouses and scalability [1]
    • default partition [1]
    • default subpartition [1]
    • deferred segments [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]
    • 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]
    • manageability extensions [1]
    • manageability with indexes [1]
    • managing partitions [1]
    • nonprefixed indexes [1] , [2] , [3]
    • Online Transaction Processing (OLTP), and [1]
    • overview [1]
    • partial indexes on partitioned tables [1]
    • Partition Advisor [1]
    • partitioned indexes on composite partitions [1]
    • partition-wise joins [1]
    • performance [1] , [2]
    • 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]
  • partitions
    • equipartitioning
      • examples [1]
      • local indexes [1]
    • global indexes [1] , [2]
    • guidelines for partitioning indexes [1]
    • indexes [1]
    • local indexes [1] , [2]
    • materialized views [1]
    • nonprefixed indexes [1] , [2] , [3]
    • on indexes [1]
    • parallel DDL statements [1]
    • physical attributes [1]
    • prefixed indexes [1]
    • rules of parallelism [1]
  • PARTITIONS clause
    • for hash partitions [1]
  • partition-wise joins
  • 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
  • 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 tablespaces
    • performance considerations [1]
  • REBUILD INDEX PARTITION statement
    • rules of parallelism [1]
  • REBUILD INDEX statement
    • rules of parallelism [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]
  • resource plan
    • using with parallel statement queuing [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
    • rules of parallelism [1]
  • SPLIT PARTITION operations
    • optimizing [1]
  • SPLIT SUBPARTITION operations
    • optimizing [1]
  • splitting multiple partitions [1]
  • SQL statements
    • 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]
  • TAPE_ASYNCH_IO initialization parameter
    • parallel query [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]
  • transactions
    • distributed and parallel DML restrictions [1]
  • triggers
    • restrictions [1]
    • restrictions on parallel DML [1]
  • TRUNCATE PARTITION clause [1] , [3] , [4]
  • 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

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]
    • mirroring with Oracle ASM [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]
    • 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]

W

  • workloads

X

  • XMLType collections
    • partitioning [1]
  • XMLType objects [1]