478/478
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
insert
[1]
,
[2]
update and delete
[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]
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
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
adding partitions
[1]
composite hash-range partitioning
[1]
composite interval partitioning
creating tables using
[1]
composite list-hash partitioning
performance considerations
[1]
composite list-list partitioning
performance considerations
[1]
composite list-partitioned tables
adding partitions
[1]
composite list partitioning
creating tables using
[1]
composite list-range partitioning
performance considerations
[1]
composite partitioned tables
creating
[1]
composite partitioning
default partition
[1]
interval-hash
[1]
interval-list
[1]
interval-range
[1]
list-hash
[1]
list-list
[1]
list-range
[1]
performance considerations
[1]
range-hash
[1]
range-list
[1]
range-range
[1]
subpartition template, modifying
[1]
composite range-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
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, 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
about
[1]
global indexes
partitioning
summary of index types
[1]
global nonpartitioned indexes
about
[1]
global partitioned indexes
about
[1]
maintenance
[1]
global range partitioned indexes
about
[1]
granules
[1]
groups
instance
[1]
H
hardware-based mirroring
very large databases (VLDBs)
[1]
hardware-based striping
very large databases (VLDBs)
[1]
hash-partitioned tables
adding partitions
[1]
hash partitioning
creating global indexes
[1]
creating tables examples
[1]
creating tables using
[1]
index-organized tables
[1]
multicolumn partitioning keys
[1]
performance considerations
[1]
hash partitions
splitting
[1]
heap-organized partitioned tables
table compression
[1]
HEAT_MAP initialization parameter
disabling
[1]
enabling
[1]
Heat Map
ALL, DBA, USER, and V$ views
[1]
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
example
[1]
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
adding
[1]
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
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]
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
about
[1]
LOGGING clause
[1]
logging mode
parallel DDL
[1]
,
[2]
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
adding
[1]
dropping
[1]
merging
[1]
splitting
[1]
truncating
[1]
multitenant container databases
parallel statement queuing
[1]
N
NO_STATEMENT_QUEUING
parallel statement queuing hint
[1]
NOLOGGING clause
[1]
NOLOGGING mode
parallel DDL
[1]
,
[2]
nonpartitioned indexes
[1]
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
about
[1]
composite
[1]
single-level
[1]
PARTITION_START
partition pruning
[1]
PARTITION_STOP
partition pruning
[1]
Partition Advisor
manageability
[1]
partition bound
range-partitioned tables
[1]
PARTITION BY HASH clause
[1]
PARTITION BY LIST clause
[1]
PARTITION BY RANGE clause
for composite-partitioned tables
[1]
PARTITION BY REFERENCE clause
[1]
PARTITION clause
for composite-partitioned tables
[1]
for hash partitions
[1]
for list partitions
[1]
for range partitions
[1]
partitioned 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
benefits
[1]
,
[2]
full
[1]
,
[2]
parallel execution
[1]
partial
[1]
,
[2]
performance
DSS database
[1]
prefixed and nonprefixed indexes
[1]
very large databases (VLDBs)
[1]
pluggable databases
parallel statement queuing
[1]
predicates
index partition pruning
[1]
prefixed indexes
partition pruning
[1]
processes
memory contention in parallel processing
[1]
process monitor process (PMON)
parallel DML process recovery
[1]
producer operations
[1]
pruning partitions
about
[1]
benefits
[1]
indexes and performance
[1]
Q
queries
ad hoc
[1]
queuing
parallel statements
[1]
R
range-hash partitioning
creating tables using
[1]
subpartitioning template
[1]
range-list partitioning
creating tables using
[1]
subpartitioning template
[1]
range-partitioned tables
adding partitions
[1]
splitting partitions
[1]
,
[2]
range partitioning
creating tables using
[1]
index-organized tables
[1]
multicolumn partitioning keys
[1]
performance considerations
[1]
,
[2]
range-range partitioning
creating tables using
[1]
read-only 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
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]
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
skewing
[1]
X
XMLType collections
partitioning
[1]
XMLType objects
[1]
Scripting on this page enhances content navigation, but does not change the content in any way.