1. Index

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  

A

  • adaptive algorithm 8.2.6
  • adding ILM policies
    • for Automatic Data Optimization 5.2.2.3
  • adding index partitions 4.4.1.9
  • adding multiple partitions 4.4.1.10
  • adding partitions
    • composite hash-partitioned tables 4.4.1.5
    • composite list-partitioned tables 4.4.1.6
    • composite range-partitioned tables 4.4.1.7
    • hash-partitioned tables 4.4.1.2
    • interval-partitioned tables 4.4.1.4
    • list-partitioned tables 4.4.1.3
    • partitioned tables 4.4.1
    • range-partitioned tables 4.4.1.1
    • reference-partitioned tables 4.4.1.8
  • ADD PARTITION clause 4.4.1.1
  • ADD SUBPARTITION clause 4.4.1.5.2, 4.4.1.6.2, 4.4.1.7.2
  • ALTER INDEX statement
    • partition attributes 3.3.8
  • ALTER SESSION statement
  • ALTER TABLE statement
  • applications
  • asynchronous communication
    • parallel execution servers 8.1.4.5
  • asynchronous global index maintenance
    • for dropping and truncating partitions 4.3.2
  • asynchronous I/O 8.6.3.3.4
  • Automatic big table caching
  • Automatic Data Optimization
  • Automatic Data Optimization (ADO)
    • for Information Lifecycle Management strategy 5.2.2
  • automatic list partitioning

B

  • backing up and recovering
    • very large databases (VLDBs) 9
  • bigfile tablespaces
    • very large databases (VLDBs) 10.2.5
  • binary XML tables

C

  • COALESCE PARTITION clause 4.4.2.1
  • collections
  • collection tables
    • performing PMOs on partitions 4.1.17.1
  • composite hash-hash partitioning 2.3.2.7
  • composite hash-list partitioning 2.3.2.8
  • composite hash partitioned tables
  • composite hash-partitioned tables
  • composite hash-range partitioning 2.3.2.9
  • composite interval partitioning
    • creating tables using 4.2.2
  • composite list-hash partitioning 2.3.2.5
    • performance considerations 3.5.4.4
  • composite list-list partitioning 2.3.2.6
    • performance considerations 3.5.4.5
  • composite list-partitioned tables
  • composite list partitioning
    • creating tables using 4.2.3
  • composite list-range partitioning 2.3.2.4
    • performance considerations 3.5.4.6
  • composite partitioned tables
  • composite partitioning 2.3.2
  • composite range-* partitioned tables
  • composite range-hash partitioning 2.3.2.2
    • performance considerations 3.5.4.1
  • composite range-interval partitioning
    • creating tables using 4.2.2
  • composite range-list partitioned tables
  • composite range-list partitioning 2.3.2.3
    • performance considerations 3.5.4.2
  • composite range-partitioned tables
  • composite range-range partitioning 2.3.2.1
    • performance considerations 3.5.4.3
  • compression
    • partitioning 3.4
  • compression table
    • partitioning 3.4
  • concurrent execution of union all 8.5.3.14
  • constraints
  • consumer operations 8.1.4.2
  • CREATE INDEX statement
  • CREATE TABLE AS SELECT statement
  • CREATE TABLE statement
  • creating hash partitioned tables
  • creating indexes on partitioned tables
  • creating interval partitions
    • INTERVAL clause of CREATE TABLE 4.1.2
  • creating partitions 4.1
  • creating segments on demand
  • critical consumer group
    • specifying for parallel statement queuing 8.4.1.5

D

  • data
    • parallel DML restrictions and integrity rules 8.5.3.10
  • databases
  • database writer process (DBWn)
  • data loading
    • incremental in parallel 8.8.7
  • data manipulation language
    • parallel DML operations 8.5.3
    • transaction model for parallel DML operations 8.5.3.5
  • data segment compression
  • data warehouses
    • about 6.1
    • advanced partition pruning 6.3.1.2
    • ARCHIVELOG mode for recovery 9.4.1
    • backing up and recovering 9.1
    • backing up and recovering characteristics 9.1.1
    • backing up tables on individual basis 9.4.7
    • backup and recovery 9.3
    • basic partition pruning 6.3.1.1
    • block change tracking for backups 9.4.3
    • data compression and partitioning 6.4.4
    • differences with online transaction processing backups 9.1.1
    • extract, transform, and load for backup and recovery 9.4.6.1
    • extract, transform, and load strategy 9.4.6.2
    • flashback database and guaranteed restore points 9.4.6.5
    • incremental backups 9.4.6.3
    • incremental backup strategy 9.4.6.4
    • leverage read-only tablespaces for backups 9.4.5
    • manageability 6.4
    • manageability with partition exchange load 6.4.1
    • materialized views and partitioning 6.3.4
    • more complex queries 6.2.4
    • more users querying the system 6.2.3
    • NOLOGGING mode for backup and recovery 9.4.6
    • partitioned tables 3.5.1
    • partitioning 6
    • partitioning and removing data from tables 6.4.3
    • partitioning for large databases 6.2.1
    • partitioning for large tables 6.2.2
    • partitioning for scalability 6.2
    • partitioning materialized views 6.3.4.1
    • partition pruning 6.3.1
    • recovery methodology 9.4
    • recovery point object (RPO) 9.3.2
    • recovery time object (RTO) 9.3.1
    • refreshing table data 8.5.3.1.1
    • RMAN for backup and recovery 9.4.2
    • RMAN multi-section backups 9.4.4
  • DB_BLOCK_SIZE initialization parameter
  • DB_CACHE_SIZE initialization parameter
  • DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter
  • DBMS_HEAT_MAP package
  • DBMS_ILM_ADMIN package
    • Automatic Data Optimization 5.2.2.8
  • DBMS_ILM package
    • Automatic Data Optimization 5.2.2.8
  • decision support system (DSS)
  • default partitions 4.1.4.2
  • default subpartition 4.2.4.2.2
  • deferred segments
  • degree of parallelism
    • adaptive parallelism 8.2.6
    • automatic 8.2.3
    • between query operations 8.1.4.2
    • controlling with initialization parameters and hints 8.2.5
    • determining for auto DOP 8.2.4
    • in-memory parallel execution 8.3
    • manually specifying 8.2.1
    • parallel execution servers 8.2
    • specifying a limit for a consumer group 8.4.1.4
  • DELETE statement
    • parallel DELETE statement 8.5.3.3
  • deleting ILM policies
    • for Automatic Data Optimization 5.2.2.4
  • direct-path INSERT
  • DISABLE_PARALLEL_DML SQL hint 8.5.3.2
  • DISABLE ROW MOVEMENT clause 4.1
  • disabling ILM policies
    • for Automatic Data Optimization 5.2.2.4
  • DISK_ASYNCH_IO initialization parameter
  • distributed transactions
  • DML_LOCKS
  • DROP PARTITION clause 4.4.3.1
  • dropping multiple partitions 4.4.3.4
  • dropping partitioned tables 4.5
  • dropping partitions
    • asynchronous global index maintenance 4.3.2
  • DSS database
    • partitioning indexes 3.3.7

E

F

  • features
    • new for Information Lifecycle Management
    • new for parallel execution
    • new for partitioning
    • new for VLDBs
  • filtering
    • maintenance operations on partitions 4.3.4
  • FOR PARTITION clause 4.4.6.2.1
  • fragmentation
  • full partition-wise join
  • full partition-wise joins 3.2.1, 6.3.2.1
  • full table scans
    • parallel execution 8.1.2
  • functions

G

  • global hash partitioned indexes
  • global indexes
  • global nonpartitioned indexes
  • global partitioned indexes
  • global range partitioned indexes
  • granuless
  • groups

H

  • hardware-based mirroring
    • very large databases (VLDBs) 10.1.1
  • hardware-based striping
    • very large databases (VLDBs) 10.2.1
  • hash-partitioned tables
  • hash partitioning 2.3.1.2
    • creating global indexes 4.1.3.2
    • creating tables examples 4.1.3.1
    • creating tables using 4.1.3
    • index-organized tables 4.1.15.2
    • multicolumn partitioning keys 4.1.10
    • performance considerations 3.5.2
  • hash partitions
  • heap-organized partitioned tables
  • HEAT_MAP initialization parameter
  • Heat Map
    • ALL, DBA, USER, and V$ views 5.2.1.2
    • and automatic data optimization 5.2
    • disabling 5.2.1.1
    • enabling 5.2.1.1
    • for Information Lifecycle Management strategy 5.2.1
    • limitations 5.2.3
    • managing with DBMS_HEAT_MAP subprograms 5.2.1.3
    • managing with Oracle Enterprise Manager 5.5
    • viewing tracking information 5.2.1.2
  • heat map and automatic data optimization
    • implementing an ILM strategy 5.2
  • hints
    • parallel statement queuing 8.4.3
  • Hybrid Columnar Compression
  • hybrid partitioned tables
    • about 2.1.10
    • converting from 4.7.3
    • converting to 4.7.2
    • creating 4.7.1
    • exchanging a partition with a nonpartitioned external table 4.7.6
    • managing 4.7
    • splitting partitions 4.7.5
    • using with ADO 4.7.4

I

  • I/O
  • ILM
    • See: Information Lifecycle Management
  • ILM policies
    • for Automatic Data Optimization 5.2.2.1
  • implementing an ILM system
    • manually with partitioning 5.4
    • using Oracle Database 5.1.2
  • In-Database Archiving
    • limitations 5.3.4
    • managing data visibility 5.3.1
    • ORA_ARCHIVE_STATE 5.3.1
    • ROW ARCHIVAL VISIBILITY 5.3.1
  • indexes
  • index-organized tables
  • index partitions
  • Information Lifecycle Management
  • initialization parameters
  • INSERT statement
    • parallelizing INSERT SELECT 8.5.3.4
  • instance groups
    • for parallel operations 8.1.8
    • limiting the number of instances 8.1.8
  • integrity rules
  • interval-hash partitioning
  • interval-list partitioning
  • interval partitioned tables
  • interval-partitioned tables
  • interval partitioning
  • interval-range partitioning
  • interval-reference partitioned tables

J

  • joins
    • full partition-wise 3.2.1
    • partial partition-wise 3.2.2
    • partition-wise 3.2

K

  • key compression

L

M

  • maintenance operations
    • supported on index partitions 4.3
    • supported on partitioned tables 4.3
  • maintenance operations on partitions
  • manageability
    • data warehouses 6.4
  • managing data validity
    • Temporal Validity 5.3.2
  • managing data visibility
    • In-Database Archiving 5.3.1
  • managing ILM policies
    • for Automatic Data Optimization 5.2.2.1
  • memory
  • MEMORY_MAX_TARGET initialization parameter 8.6.3.2
  • MEMORY_TARGET initialization parameter 8.6.3.2
  • MERGE PARTITION clause 4.4.5
  • MERGE statement
  • MERGE SUBPARTITION clause 4.4.5
  • merging multiple partitions 4.4.5.7
  • MINIMUM EXTENT parameter 8.5.2.6
  • mirroring with Oracle ASM
    • very large databases (VLDBs) 10.1.2
  • MODIFY DEFAULT ATTRIBUTES clause 4.4.6.2.1
  • MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause 4.4.6.1.2
  • modifying
  • MODIFY PARTITION clause 4.4.6.2.1, 4.4.6.2.2, 4.4.9, 4.4.10.2.2
  • MODIFY SUBPARTITION clause 4.4.6.2.3
  • monitoring
  • MOVE PARTITION clause 4.4.6.2, 4.4.9
  • MOVE SUBPARTITION clause 4.4.6.2, 4.4.9.2
  • multi-column list partitioning
  • multiple archiver processes 8.8.4.5
  • multiple block sizes
    • restrictions on partitioning 4.1.16
  • multiple parallelizers 8.1.7
  • multiple partitions

N

  • NO_STATEMENT_QUEUING
    • parallel statement queuing hint 8.4.3
  • NOLOGGING clause 8.8.4.7
  • NOLOGGING mode
  • nonpartitioned indexes 6.3.3.2
  • nonpartitioned tables
    • changing to partitioned tables 4.6
  • non-partitioned tables
    • converting to partitioned tables 4.6.2
  • nonprefixed indexes 2.5.2, 3.3.1.2
    • global partitioned indexes 3.3.2.1
  • nonprefixed indexes_importance 3.3.4

O

  • object types
    • parallel queries 8.5.1.4
    • restrictions on parallel DDL statements 8.5.2.1
    • restrictions on parallel DML operations 8.5.3.9
    • restrictions on parallel queries 8.5.1.4
  • of ALTER TABLE statement 4.4.6.1.2
  • OLTP database
  • Online Transaction Processing (OLTP)
    • about 7.1
    • common partition maintenance operations 7.3.3
    • partitioning, and 7
    • when to partition indexes 7.2.1
  • operating system statistics
    • monitoring for parallel processing 8.7.4
  • operations
    • partition-wise 3.2
  • optimization
    • partitioned indexes 3.3.5
    • partition pruning and indexes 3.3.5
  • optimizations
  • ORA_ARCHIVE_STATE
    • In-Database Archiving 5.3.1
  • Oracle Automatic Storage Management settings
    • very large databases (VLDBs) 10.4
  • Oracle Database File System
    • very large databases (VLDBs) 10.2.6
  • Oracle Database Resource Manager
    • managing parallel statement queue 8.4.1
  • Oracle Real Application Clusters

P

  • PARALLEL_DEGREE_POLICY initialization parameter
    • automatic degree of parallelism 8.2.3
    • controlling automatic DOP 8.2.5
  • PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter 8.6.3.2.1, 8.6.3.2.2
  • PARALLEL_FORCE_LOCAL initialization parameter 8.6.3.1.1
  • PARALLEL_MAX_SERVERS initialization parameter 8.6.3.1.2
  • PARALLEL_MIN_PERCENT initialization parameter 8.6.3.1.3
  • PARALLEL_MIN_SERVERS initialization parameter 8.1.5, 8.6.3.1.4
  • PARALLEL_MIN_TIME_THRESHOLD initialization parameter 8.6.3.1.5
  • PARALLEL_SERVERS_TARGET initialization parameter 8.6.3.1.6
  • PARALLEL clause 8.8.6.1
  • parallel DDL statements 8.5.2
  • parallel delete 8.5.3.3
  • parallel DELETE statement 8.5.3.3
  • parallel DML
    • considerations for parallel execution 8.8.4
  • parallel DML and DDL statements
  • parallel DML operations 8.5.3
  • parallel execution
    • about 8, 8.1, 8.1.4
    • adaptive parallelism 8.2.6
    • bandwidth 8.1.1
    • benefits 8.1.1
    • considerations for parallel DML 8.8.4
    • CPU utilization 8.1.1
    • CREATE TABLE AS SELECT statement 8.8.2
    • DB_BLOCK_SIZE initialization parameter 8.6.3.3.2
    • DB_CACHE_SIZE initialization parameter 8.6.3.3.1
    • DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter 8.6.3.3.3
    • default parameter settings 8.6.1
    • DISK_ASYNCH_IO initialization parameter 8.6.3.3.4
    • forcing for a session 8.6.2
    • full table scans 8.1.2
    • functions 8.5.4
    • fundamental hardware requirements 8.1.3
    • I/O 8.1.1
    • I/O parameters 8.6.3.3
    • index creation 8.8.5
    • initializing parameters 8.6
    • in-memory 8.3
    • inter-operator parallelism 8.1.4.2
    • intra-operator parallelism 8.1.4.2
    • massively parallel systems 8.1.1
    • new features ,
    • Oracle RAC 8.1.8
    • parallel load 8.5.5
    • parallel propagation 8.5.5
    • parallel recovery 8.5.5
    • parallel replication 8.5.5
    • parameters for establishing resource limits 8.6.3.1
    • resource parameters 8.6.3.2
    • symmetric multiprocessors 8.1.1
    • TAPE_ASYNCH_IO initialization parameter 8.6.3.3.4
    • tips for tuning 8.8
    • tuning general parameters 8.6.3
    • tuning parameters 8.6
    • using 8
    • when not to use 8.1.2
  • parallel execution strategy
  • PARALLEL hint
    • UPDATE, MERGE, and DELETE 8.5.3.3
  • parallelism
  • parallelization
    • methods for specifying precedence 8.5.6
    • rules for SQL operations 8.5.6
  • parallel partition-wise joins
    • performance considerations 6.3.2.4
  • parallel processing
    • monitoring 8.7
    • monitoring operating system statistics 8.7.4
    • monitoring session statistics 8.7.2
    • monitoring system statistics 8.7.3
    • monitoring with GV$FILESTAT view 8.7.1
    • monitoring with performance views 8.7.1
  • parallel queries 8.5.1
  • parallel query
    • integrating with the automatic big table caching 8.3.2
    • parallelism type 8.5.1
  • parallel server resources
    • limiting for a consumer group 8.4.1.2
  • parallel servers
    • asynchronous communication 8.1.4.5
  • parallel SQL
    • allocating rows to parallel execution servers 8.1.4.4
    • distribution methods 8.1.4.4
    • instance groups 8.1.8
    • number of parallel execution servers 8.1.5
    • optimizer 8.1.4.1
  • parallel statement queue
    • about 8.4
    • grouping parallel statements 8.4.2
    • hints 8.4.3
    • limiting parallel server resources 8.4.1.2
    • managing for consumer groups 8.4.1
    • managing the order of dequeuing 8.4.1.1
    • managing with Oracle Database Resource Manager 8.4.1
    • NO_STATEMENT_QUEUING hint 8.4.3
    • PARALLEL_DEGREE_POLICY 8.4
    • sample scenario for managing parallel statements 8.4.1.6
    • setting order of parallel statements 8.4.1
    • specifying a critical consumer group 8.4.1.5
    • specifying a DOP limit for a consumer group 8.4.1.4
    • specifying a timeout for a consumer group 8.4.1.3
    • STATEMENT_QUEUING hint 8.4.3
    • using BEGIN_SQL_BLOCK to group statements 8.4.2
  • parallel update 8.5.3.3
  • parallel UPDATE statement 8.5.3.3
  • parameters
    • Automatic Data Optimization 5.2.2.7
  • partial indexes
    • on partitioned tables 2.5.6
  • partial partition-wise joins 6.3.2.2
  • PARTITION_START
    • partition pruning 3.1.3
  • PARTITION_STOP
    • partition pruning 3.1.3
  • Partition Advisor
  • partition bound
  • PARTITION BY HASH clause 4.1.3
  • PARTITION BY LIST clause 4.1.4
  • PARTITION BY RANGE clause 4.1.1
    • for composite-partitioned tables 4.2
  • PARTITION BY REFERENCE clause 4.1.5
  • PARTITION clause
    • for composite-partitioned tables 4.2
    • for hash partitions 4.1.3
    • for list partitions 4.1.4
    • for range partitions 4.1.1
  • partitioned external tables
  • partitioned indexes
    • about 2.5
    • adding partitions 4.4.1.9
    • administration 4
    • composite partitions 2.5.7
    • creating hash-partitioned global 4.1.3.2
    • creating local index on composite partitioned table 4.2.4.1.3
    • creating local index on hash partitioned table 4.1.3.1
    • creating range partitions 4.1.1.3
    • dropping partitions 4.4.3.3
    • key compression 4.1.13
    • maintenance operations 4.3, 4.4
    • maintenance operations that can be performed 4.3
    • modifying partition default attributes 4.4.6.1.3
    • modifying real attributes of partitions 4.4.6.2.4
    • moving partitions 4.4.9.3
    • Online Transaction Processing (OLTP) 7.2.1
    • rebuilding index partitions 4.4.10
    • renaming index partitions/subpartitions 4.4.11.3
    • secondary indexes on index-organized tables 4.1.15.1
    • splitting partitions 4.4.12.7
    • views 4.8
    • which type to use 2.5.1
  • partitioned tables
    • adding partitions 4.4.1
    • adding subpartitions 4.4.1.5.2, 4.4.1.6.2, 4.4.1.7.2
    • administration 4
    • coalescing partitions 4.4.2
    • converting to from non-partitioned tables 4.6.2
    • creating automatic list partitions 4.1.4.3
    • creating composite 4.2
    • creating composite interval 4.2.2
    • creating composite list 4.2.3
    • creating hash partitions 4.1.3
    • creating interval-hash partitions 4.2.2.1
    • creating interval-list partitions 4.2.2.2
    • creating interval partitions 4.1.2
    • creating interval-range partitions 4.2.2.3
    • creating list-hash partitions 4.2.3.1
    • creating list-list partitions 4.2.3.2
    • creating list partitions 4.1.4
    • creating list-range partitions 4.2.3.3
    • creating multi-column list partitions 4.1.4.4
    • creating range-hash partitions 4.2.4.1
    • creating range-list partitions 4.2.4.2
    • creating range partitions 4.1.1, 4.1.1.3
    • creating range-range partitions 4.2.4.3
    • creating reference partitions 4.1.5
    • data warehouses 3.5.1
    • DISABLE ROW MOVEMENT 4.1
    • dropping 4.5
    • dropping partitions 4.4.3
    • ENABLE ROW MOVEMENT 4.1
    • exchanging partitions and subpartitions 4.4.4
    • exchanging partitions of a referenced-partition table 4.4.4.4
    • exchanging partitions with a cascade option 4.4.4.12
    • exchanging subpartitions 4.4.4.7, 4.4.4.9, 4.4.4.11
    • filtering maintenance operations 4.3.4
    • FOR EXCHANGE WITH 4.4.4.1
    • global indexes 7.3.2
    • incremental statistics and partition exchange operations 4.4.4
    • index-organized tables 4.1, 4.1.15.1, 4.1.15.2, 4.1.15.3
    • in-memory column store 4.1.7
    • INTERVAL clause of CREATE TABLE 4.1.2
    • interval-reference 4.1.6
    • local indexes 7.3.1
    • maintenance operations 4.4
    • maintenance operations that can be performed 4.3
    • maintenance operations with global indexes 7.3.2
    • maintenance operations with local indexes 7.3.1
    • marking indexes UNUSABLE 4.4.12
    • merging partitions 4.4.5
    • modifying default attributes 4.4.6.1
    • modifying real attributes of partitions 4.4.6.2
    • modifying real attributes of subpartitions 4.4.6.2.3
    • moving partitions 4.4.9
    • moving subpartitions 4.4.9.2
    • multicolumn partitioning keys 4.1.10
    • partition bound 4.1.1.1
    • partitioning columns 4.1.1.1
    • partitioning keys 4.1.1.1
    • read-only status 4.1.8
    • rebuilding index partitions 4.4.10
    • redefining partitions online 4.6.1
    • renaming partitions 4.4.11
    • renaming subpartitions 4.4.11.2
    • splitting partitions 4.4.12
    • truncating partitions 4.4.13
    • truncating partitions with the cascade option 4.4.13.4
    • truncating subpartitions 4.4.13.3
    • updating global indexes automatically 4.3.1
    • views 4.8
  • partition exchange load
  • partition granules 8.1.4.3.2
  • partitioning
  • partitioning and data compression
  • partitioning and materialized views
  • partitioning columns
  • partitioning keys
  • partitioning materialized views
  • partitioning of XMLIndex
  • partition maintenance operations 7.3.1, 7.3.2
    • merging older partitions 7.3.3.2
    • moving older partitions 7.3.3.2
    • Online Transaction Processing (OLTP) 7.3.3
    • removing old data 7.3.3.1
  • partition pruning
  • partitions 1.1
  • PARTITIONS clause
    • for hash partitions 4.1.3
  • partition-wise joins 3.2
  • partition-wise operations 3.2
  • performance
    • DSS database 8.5.3.1
    • prefixed and nonprefixed indexes 3.3.5
    • very large databases (VLDBs) 10.2
  • predicates
    • index partition pruning 3.3.5
  • prefixed indexes 3.3.1.1, 3.3.3
    • partition pruning 3.3.5
  • processes
    • memory contention in parallel processing 8.6.3.1.2
  • process monitor process (PMON)
  • producer operations 8.1.4.2
  • pruning partitions

Q

  • queries
  • queuing
    • parallel statements 8.4

R

  • range-hash partitioning
  • range-list partitioning
  • range-partitioned tables
  • range partitioning 2.3.1.1
  • range-range partitioning
  • read-only status
    • tables, partitions, and subpartitions 4.1.8
  • read-only tablespaces
    • performance considerations 3.5.8
  • REBUILD PARTITION clause 4.4.9.3, 4.4.10.2.1
  • REBUILD UNUSABLE LOCAL INDEXES clause 4.4.10.2.2
  • recovery
  • reference-partitioned tables
  • reference partitioning
  • RENAME PARTITION clause 4.4.11.1, 4.4.11.3.1
  • RENAME SUBPARTITION clause 4.4.11.2
  • replication
    • restrictions on parallel DML 8.5.3.9
  • resources
  • restrictions
    • direct-path INSERT 8.5.3.9
    • parallel DDL statements 8.5.2.1
    • parallel DML operations 8.5.3.9
    • parallel DML operations and remote transactions 8.5.3.12
  • ROW ARCHIVAL VISIBILITY
    • In-Database Archiving 5.3.1
  • row-level compression tiering
    • Automatic Data Optimization 5.2.2.6
  • row movement clause for partitioned tables 4.1

S

  • scalability
  • scalability and manageability
    • very large databases (VLDBs) 10.3
  • scans
    • parallel query on full table 8.1.2
  • segment-level compression tiering
    • Automatic Data Optimization 5.2.2.5
  • segments
  • sessions
    • enabling parallel DML operations 8.5.3.2
  • session statistics
    • monitoring for parallel processing 8.7.2
  • SET INTERVAL clause 4.4.1.4
  • SHARED_POOL_SIZE initialization parameter 8.6.3.1.7
  • single-level partitioning 2.3.1
  • skewing parallel DML workload 8.1.6
  • SORT_AREA_SIZE initialization parameter
  • space management
  • SPLIT PARTITION clause 4.4.1.1, 4.4.12
  • SPLIT PARTITION operations
  • SPLIT SUBPARTITION operations
  • splitting multiple partitions 4.4.12.8
  • splitting partitions and subpartitions 4.4.12
  • SQL statementsSQL statements
  • STATEMENT_QUEUING
    • parallel statement queuing hint 8.4.3
  • statistics
  • storage
    • fragmentation in parallel DDL 8.5.2.6
    • index partitions 3.3.8
  • STORAGE clause
  • storage management
    • very large databases (VLDBs) 10
  • STORE IN clause
  • stripe and mirror everything
    • very large databases (VLDBs) 10.3.1
  • striping
    • Information Lifecycle Management 10.2.3
    • partitioning placement 10.2.4
  • striping with Oracle ASM
    • very large databases (VLDBs) 10.2.2
  • SUBPARTITION BY HASH clause
    • for composite-partitioned tables 4.2
  • SUBPARTITION clause 4.4.1.5.1, 4.4.1.6.1, 4.4.1.7.1, 4.4.12.4
    • for composite-partitioned tables 4.2
  • SUBPARTITIONS clause 4.4.1.5.1, 4.4.12.4
    • for composite-partitioned tables 4.2
  • subpartition templates 4.2.5
  • subqueries
  • system monitor process (SMON)
  • system partitioning 2.1.5
  • system statistics
    • monitoring for parallel processing 8.7.3

T

  • table compression
  • table queues
    • monitoring parallel processing 8.7.1.7
  • tables
  • tables for exchange
  • TAPE_ASYNCH_IO initialization parameter
  • temporal validity
    • creating a table with 5.3.3
  • Temporal Validity
    • DBMS_FLASHBACK_ARCHIVE package ENABLE_AT_VALID_TIME procedure 5.3.2
    • limitations 5.3.4
    • managing data validity 5.3.2
    • valid-time period 5.3.2
  • temporary segments
  • time-based information
    • Information Lifecycle Management 5
  • transactions
    • distributed and parallel DML restrictions 8.5.3.12
  • triggers
  • TRUNCATE PARTITION clause 4.4.13, 4.4.13.1, 4.4.13.1.1
  • TRUNCATE SUBPARTITION clause 4.4.13.3
  • truncating multiple partitions 4.4.13.2
  • truncating partitions
    • asynchronous global index maintenance 4.3.2
    • cascade option 4.4.13.4
    • marking indexes UNUSABLE 4.4.13
  • truncating segments
  • two-phase commit 8.6.3.2.3.1
  • types of parallelism 8.5

U

  • UNION ALL
  • UPDATE GLOBAL INDEX clause
  • UPDATE statement
    • parallel UPDATE statement 8.5.3.3
  • updating indexes automatically 4.3.1
  • user resources

V

  • V$PQ_SESSTAT view
    • monitoring parallel processing 8.7.1.6
  • V$PQ_TQSTAT view
    • monitoring parallel processing 8.7.1.7
  • V$PX_BUFFER_ADVICE view
    • monitoring parallel processing 8.7.1.1
  • V$PX_PROCESS_SYSSTAT view
    • monitoring parallel processing 8.7.1.5
  • V$PX_PROCESS view
    • monitoring parallel processing 8.7.1.4
  • V$PX_SESSION view
    • monitoring parallel processing 8.7.1.2
  • V$PX_SESSTAT view
    • monitoring parallel processing 8.7.1.3
  • V$RSRC_CONS_GROUP_HISTORY view
    • monitoring parallel processing 8.7.1.8
  • V$RSRC_CONSUMER_GROUP view
    • monitoring parallel processing 8.7.1.9
  • V$RSRC_PLAN_HISTORY view
    • monitoring parallel processing 8.7.1.11
  • V$RSRC_PLAN view
    • monitoring parallel processing 8.7.1.10
  • V$RSRC_SESSION_INFO view
    • parallel statement queuing metrics 8.7.1.12
  • V$RSRCMGRMETRIC view
    • parallel statement queuing statistics 8.7.1.13
  • V$SESSTAT view 8.7.4
  • V$SYSSTAT view 8.8.4.6
  • valid-time period
    • Temporal Validity 5.3.2
  • very large databases (VLDBs)
    • about 1
    • backing up and recovering 9
    • backup tools 9.2.3
    • backup types 9.2.2
    • bigfile tablespaces 10.2.5
    • database structures for recovering data 9.2.1
    • hardware-based mirroring 10.1.1
    • hardware-based striping 10.2.1
    • high availability 10.1
    • introduction 1
    • mirroring with Oracle ASM 10.1.2
    • new features ,
    • Oracle Automatic Storage Management settings 10.4
    • Oracle Backup and Recovery 9.2
    • Oracle Database File System 10.2.6
    • Oracle Data Pump 9.2.3, 9.2.3.2
    • Oracle Recovery Manager 9.2.3.1
    • partitioning, and 1.2
    • performance 10.2
    • physical and logical backups 9.2.2
    • RAID 0 striping 10.2.1.1
    • RAID 1 mirroring 10.1.1.1
    • RAID 5 mirroring 10.1.1.2
    • RAID 5 striping 10.2.1.2
    • RMAN 9.2.3
    • scalability and manageability 10.3
    • storage management 10
    • stripe and mirror everything 10.3.1
    • striping with Oracle ASM 10.2.2
    • user-managed backups 9.2.3, 9.2.3.3
  • views
    • parallel processing monitoring 8.7.1
    • partitioned tables and indexes 4.8
    • V$SESSTAT 8.7.4
    • V$SYSSTAT 8.8.4.6
  • views for ILM policies
    • Automatic Data Optimization 5.2.2.9
  • virtual column-based partitioning
  • virtual column partitioning
    • performance considerations 3.5.7
  • VLDBs
    • very large databases 1

W

  • workloads

X

  • XMLType collections
  • XMLType objects 2.1.11