Index

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

A

ADD PARTITION clause, 4.2.2.1

ADD SUBPARTITION clause, 4.2.2.5.2, 4.2.2.6.2, 4.2.2.7.2

ALTER INDEX statement

for maintaining partitioned indexes, 4.2

partition attributes, 3.3.7

ALTER SESSION statement

ENABLE PARALLEL DML clause, 8.3.3.2

FORCE PARALLEL DDL clause, 8.3.2.7.1, 8.3.5.1

create or rebuild index, 8.3.2.8.1, 8.3.5.1

create table as select, 8.3.2.9.3, 8.3.5.1

move or split partition, 8.3.2.8.2, 8.3.5.1

FORCE PARALLEL DML clause

insert, 8.3.3.4, 8.3.3.4.1, 8.3.5.1

update and delete, 8.3.3.3, 8.3.3.3.1, 8.3.5.1

ALTER TABLE

MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause, 4.2.7.2, 4.2.7.3

ALTER TABLE statement

for maintaining partitions, 4.2

MODIFY DEFAULT ATTRIBUTES clause, 4.2.7.1

NOLOGGING clause, 8.7.5.2

APPEND hint, 8.7.5.2

applications

decision support, 8.1.1

decision support systems (DSS)

parallel SQL, 8.3.2.2

direct-path INSERT, 8.3.3.1.4

parallel DML, 8.3.3.1

ARCH processes

multiple, 8.7.3.5

asynchronous I/O, 8.5.3.4

B

bandwidth, 8.1.1

C

clusters

cannot be partitioned, 1

indexes on

cannot be partitioned, 1

COALESCE PARTITION clause, 4.2.3.1

collections

XMLType, 2.1.7, 4.1.14

composite list-hash partitioning, 2.3.2.5

composite list-list partitioning, 2.3.2.6

composite list-range partitioning, 2.3.2.4

composite partitioning, 2.3.2, 2.3.2

default partition, 4.1.6.2

interval-hash, 4.1.6.5.1

interval-list, 4.1.6.5.2

interval-range, 4.1.6.5.3

list-hash, 4.1.6.4.1

list-list, 4.1.6.4.2

list-range, 4.1.6.4.3

range-hash, 4.1.6.1

range-list, 4.1.6.2

range-range, 4.1.6.3, 4.1.6.3

subpartition template, modifying, 4.2.11

composite range-hash partitioning, 2.3.2.2

composite range-list partitioning, 2.3.2.3

composite range-range partitioning, 2.3.2.1

compression, 3.4

table, 3.4

partitioning, 3.4

constraints

parallel create table, 8.3.2.9

CPU

utilization, 8.1.1

CREATE INDEX statement, 8.7.4

partition attributes, 3.3.7

partitioned indexes, 4.1.1.2

rules of parallelism, 8.3.2.8.1

CREATE TABLE AS SELECT

rules of parallelism

index-organized tables, 8.1.4

CREATE TABLE AS SELECT statement, 8.7.1

rules of parallelism

index-organized tables, 8.3.2.1

CREATE TABLE statement

AS SELECT

decision support systems, 8.3.2.2

rules of parallelism, 8.3.2.9

space fragmentation, 8.3.2.6

temporary storage space, 8.3.2.5

creating partitioned tables, 4.1.1

parallelism, 8.3.2.2

index-organized tables, 8.1.4, 8.3.2.1

D

data

integrity of

parallel DML restrictions, 8.3.3.10

partitioning, 6

data manipulation language

parallel DML, 8.3.3

transaction model for parallel DML, 8.3.3.5

data segment compression

bitmap indexes, 3.4.1

partitioning, 3.4

data warehouse

partitioned tables, 3.5.1

refreshing table data, 8.3.3.1.1, 8.3.3.1.1

database

scalability, 8.3.3.1

database writer process (DBWn)

tuning, 8.7.3.6

DB_BLOCK_SIZE initialization parameter, 8.5.3.2

and parallel query, 8.5.3.2

DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 8.5.3.3

decision support systems (DSS)

parallel DML, 8.3.3.1

parallel SQL, 8.3.2.2, 8.3.3.1

performance, 8.3.3.1

scoring tables, 8.3.3.1.3

DEFAULT keyword

list partitioning, 4.1.4

default partitions, 4.1.4

default subpartition, 4.1.6.2

degree of parallelism, 8.2.3, 8.3.3.3.2

between query operations, 8.2.1.3

DELETE statement

parallel DELETE statement, 8.3.3.3

direct-path INSERT

restrictions, 8.3.3.9

DISABLE ROW MOVEMENT clause, 4.1

DISK_ASYNCH_IO initialization parameter, 8.5.3.4, 8.5.3.4

distributed transactions

parallel DDL restrictions, 8.1.4

parallel DML restrictions, 8.1.4, 8.3.3.12

DROP PARTITION clause, 4.2.4.1

dropping partitioned tables, 4.3

DSS database

partitioning indexes, 3.3.6

E

ENABLE ROW MOVEMENT clause, 4.1, 4.1.1.1

equipartitioning

examples, 3.3.1.1

local indexes, 3.3.1

EXCHANGE PARTITION clause, 4.2.5.1, 4.2.5.7, 4.2.5.8, 4.2.5.9, 4.2.5.10, 4.2.6

EXCHANGE SUBPARTITION clause, 4.2.5.6

EXPLAIN PLAN statement

query parallelization, 8.7.2

extents

parallel DDL, 8.3.2.6

F

FAST_START_PARALLEL_ROLLBACK initialization parameter, 8.5.2.3.2

FOR PARTITION clause, 4.2.8.1

fragmentation

parallel DDL, 8.3.2.6

FREELISTS parameter, 8.7.3.4

full partition-wise joins, 3.2.1

full table scans

parallel execution, 8.1.2

functions

parallel execution, 8.3.4

G

global indexes

partitioning, 3.3.2

managing partitions, 3.3.2.2

summary of index types, 3.3.3

global partitioned indexes

maintenance, 2.5.2.3

granules, 8.2.5

groups, instance, 8.2.7.1

GV$FILESTAT view, 8.6.1

H

hash partitioning, 2.3.1.2

creating tables using, 4.1.3

index-organized tables, 4.1.12.2, 4.1.12.3

multicolumn partitioning keys, 4.1.8

hints

APPEND, 8.7.5.2

NOAPPEND, 8.7.5.2

PARALLEL, 8.7.5.1

historical tables

moving time window, 4.4

I

indexes

cluster

cannot be partitioned, 1

creating in parallel, 8.7.4

global partitioned indexes, 3.3.2

managing partitions, 3.3.2.2

local indexes, 3.3.1

parallel creation, 8.7.4, 8.7.4, 8.7.4

parallel DDL storage, 8.3.2.6

parallel local, 8.7.4

partitioning, 3.3.6

partitions, 1.1, 3.3

updating global indexes, 4.2.1

index-organized tables

parallel CREATE, 8.1.4, 8.3.2.1

parallel queries, 8.3.1.1

partitioning, 4.1, 4.1.12

partitioning secondary indexes, 4.1.12.1

initialization parameters

DB_BLOCK_SIZE, 8.5.3.2

DB_FILE_MULTIBLOCK_READ_COUNT, 8.5.3.3

DISK_ASYNCH_IO, 8.5.3.4

FAST_START_PARALLEL_ROLLBACK, 8.5.2.3.2

LARGE_POOL_SIZE, 8.5.1.7

MEMORY_MAX_TARGET, 8.5.2

MEMORY_TARGET, 8.5.2

PARALLEL_EXECUTION_MESSAGE_SIZE, 8.5.2.1, 8.5.2.2

PARALLEL_MAX_SERVERS, 8.5.1.2.1

PARALLEL_MIN_PERCENT, 8.5.1.4

PARALLEL_MIN_SERVERS, 8.2.4, 8.5.1.5

SHARED_POOL_SIZE, 8.5.1.7, 8.5.1.7

TAPE_ASYNCH_IO, 8.5.3.4

TIMED_STATISTICS, 8.6.1.6

TRANSACTIONS, 8.5.2.3.1

INSERT statement

functionality, 8.7.5.1

parallelizing INSERT ... SELECT, 8.3.3.4

instance groups for parallel operations, 8.2.7.1

instances

instance groups, 8.2.7.1

integrity rules

parallel DML restrictions, 8.3.3.10

interval partitioned tables

dropping partitions, 4.2.4.2

interval partitioning, 2.4.1.1

creating tables using, 4.1.2

performance considerations, 3.5.1

interval-hash partitioning

creating tables using, 4.1.6.5.1

subpartitioning template, 4.1.7.1

interval-list partitioning

creating tables using, 4.1.6.5.2

subpartitioning template, 4.1.7.2

interval-range partitioning

creating tables using, 4.1.6.5.3

I/O

asynchronous, 8.5.3.4

parallel execution, 8.1.1

J

joins

full partition-wise, 3.2.1

partial partition-wise, 3.2.2

partition-wise, 3.2

L

LARGE_POOL_SIZE initialization parameter, 8.5.1.7

list partitioning, 2.3.1.3

adding values to value list, 4.2.9

creating tables using, 4.1.4

DEFAULT keyword, 4.1.4

dropping values from value-list, 4.2.10

list-hash partitioning

creating tables using, 4.1.6.4.1

subpartitioning template, 4.1.7.1

list-list partitioning

creating tables using, 4.1.6.4.2

subpartitioning template, 4.1.7.2

list-range partitioning

creating tables using, 4.1.6.4.3

LOB datatypes

restrictions

parallel DDL, 8.1.4, 8.3.2.1

parallel DML, 8.3.3.9, 8.3.3.9

local indexes, 3.3.1, 3.3.3

equipartitioning, 3.3.1

LOGGING clause, 8.7.3.7

logging mode

parallel DDL, 8.1.4, 8.3.2.1, 8.3.2.3

M

massively parallel systems, 8.1.1

materialized views

partitioned, 1

memory

configure at 2 levels, 8.5.2

MEMORY_MAX_TARGET initialization parameter, 8.5.2

MEMORY_TARGET initialization parameter, 8.5.2

MINIMUM EXTENT parameter, 8.3.2.6

MODIFY DEFAULT ATTRIBUTES clause, 4.2.8.1

using for partitioned tables, 4.2.7.1

MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause

of ALTER TABLE, 4.2.7.2, 4.2.7.3

MODIFY PARTITION clause, 4.2.8.1, 4.2.8.2, 4.2.12, 4.2.14.2.2

MODIFY SUBPARTITION clause, 4.2.8.3

monitoring

parallel processing, 8.6.1

MOVE PARTITION clause, 4.2.8, 4.2.12

MOVE PARTITION statement

rules of parallelism, 8.3.2.8.2

MOVE SUBPARTITION clause, 4.2.8, 4.2.12.2

multiple archiver processes, 8.7.3.5, 8.7.3.5

N

NOAPPEND hint, 8.7.5.2

NOARCHIVELOG mode, 8.7.3.7

NOLOGGING clause, 8.7.1, 8.7.3.7, 8.7.4

with APPEND hint, 8.7.5.2

NOLOGGING mode

parallel DDL, 8.1.4, 8.3.2.1, 8.3.2.3

nonprefixed indexes, 2.5.1, 3.3.1.2, 3.3.4

global partitioned indexes, 3.3.2.1

O

object types

parallel query, 8.3.1.4

restrictions, 8.3.1.4

restrictions

parallel DDL, 8.1.4, 8.3.2.1

parallel DML, 8.3.3.9, 8.3.3.9

OLTP database

batch jobs, 8.3.3.1.5

parallel DML, 8.3.3.1

partitioning indexes, 3.3.6

optimization

partition pruning

indexes, 3.3.5

partitioned indexes, 3.3.5

optimizations

parallel SQL, 8.2.1

Oracle Real Application Clusters

instance groups, 8.2.7.1

P

PARALLEL clause, 8.7.5.1, 8.7.5.3

PARALLEL CREATE INDEX statement, 8.5.2.3

PARALLEL CREATE TABLE AS SELECT statement

resources required, 8.5.2.3

parallel DDL, 8.3.2

extent allocation, 8.3.2.6

partitioned tables and indexes, 8.3.2.1

restrictions

LOBs, 8.1.4, 8.3.2.1

object types, 8.1.4, 8.3.1.4, 8.3.2.1

parallel delete, 8.3.3.3

parallel DELETE statement, 8.3.3.3

parallel DML, 8.3.3

applications, 8.3.3.1

degree of parallelism, 8.3.3.3.2

enabling PARALLEL DML, 8.3.3.2

recovery, 8.3.3.7

restrictions, 8.3.3.9

object types, 8.3.1.4, 8.3.3.9, 8.3.3.9, 8.3.3.9, 8.3.3.9

remote transactions, 8.3.3.12

transaction model, 8.3.3.5

parallel execution

full table scans, 8.1.2

index creation, 8.7.4

interoperator parallelism, 8.2.1.3

intraoperator parallelism, 8.2.1.3

I/O parameters, 8.5.3

resource parameters, 8.5.2

tuning, 8.1

PARALLEL hint, 8.7.5.1

UPDATE and DELETE, 8.3.3.3

parallel query, 8.3.1

index-organized tables, 8.3.1.1

object types, 8.3.1.4

restrictions, 8.3.1.4

parallel SQL

allocating rows to parallel execution servers, 8.2.1.1

instance groups, 8.2.7.1

number of parallel execution servers, 8.2.4

optimizer, 8.2.1

parallel update, 8.3.3.3

parallel UPDATE statement, 8.3.3.3

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 8.5.2.1, 8.5.2.2

PARALLEL_MAX_SERVERS initialization parameter, 8.5.1.2.1

and parallel execution, 8.5.1.2

PARALLEL_MIN_PERCENT initialization parameter, 8.5.1.4

PARALLEL_MIN_SERVERS initialization parameter, 8.2.4, 8.5.1.5

parallelism, 8.1

degree, 8.2.3

interoperator, 8.2.1.3

intraoperator, 8.2.1.3

parameters

FREELISTS, 8.7.3.4

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.1.6

PARTITION BY REFERENCE clause, 4.1.5

PARTITION clause

for composite-partitioned tables, 4.1.6

for hash partitions, 4.1.3

for list partitions, 4.1.4

for range partitions, 4.1.1

partition pruning, 3.1

dynamic, 3.1.4

static, 3.1.3

partitioned indexes, 4

adding partitions, 4.2.2.9

creating local index on composite partitioned table, 4.1.6.1

creating local index on hash partitioned table, 4.1.3.1

creating range partitions, 4.1.1.2

dropping partitions, 4.2.4.3

maintenance operations, 4.2

maintenance operations, table of, 4.2

modifying partition default attributes, 4.2.7.3

modifying real attributes of partitions, 4.2.8.4

moving partitions, 4.2.12.3

rebuilding index partitions, 4.2.14

renaming index partitions/subpartitions, 4.2.15.3

secondary indexes on index-organized tables, 4.1.12.1

splitting partitions, 4.2.16.7

partitioned tables, 4

adding partitions, 4.2.2

adding subpartitions, 4.2.2.5.2, 4.2.2.6.2, 4.2.2.7.2

coalescing partitions, 4.2.3

creating hash partitions, 4.1.3

creating interval partitions, 4.1.2

creating interval-hash partitions, 4.1.6.5.1

creating interval-list partitions, 4.1.6.5.2

creating interval-range partitions, 4.1.6.5.3

creating list partitions, 4.1.4

creating list-hash partitions, 4.1.6.4.1

creating list-list partitions, 4.1.6.4.2

creating list-range partitions, 4.1.6.4.3

creating range partitions, 4.1.1, 4.1.1.2

creating range-hash partitions, 4.1.6.1

creating range-list partitions, 4.1.6.2

creating range-range partitions, 4.1.6.3

creating reference partitions, 4.1.5

data warehouses, 3.5.1

DISABLE ROW MOVEMENT, 4.1

dropping, 4.3

dropping partitions, 4.2.4

ENABLE ROW MOVEMENT, 4.1

exchanging partitions, 4.2.5

exchanging subpartitions, 4.2.5.6, 4.2.5.8, 4.2.5.10

index-organized tables, 4.1, 4.1.12.1, 4.1.12.2, 4.1.12.3

maintenance operations, 4.2

marking indexes UNUSABLE, 4.2.2.2, 4.2.3, 4.2.4.1, 4.2.4.3, 4.2.5, 4.2.6, 4.2.8.1, 4.2.8.1, 4.2.8.2, 4.2.12, 4.2.16, 4.2.17

merging partitions, 4.2.6

modifying default attributes, 4.2.7

modifying real attributes of partitions, 4.2.8

modifying real attributes of subpartitions, 4.2.8.3

moving partitions, 4.2.12

moving subpartitions, 4.2.12.2

multicolumn partitioning keys, 4.1.8

rebuilding index partitions, 4.2.14

redefining partitions online, 4.2.13

renaming partitions, 4.2.15

renaming subpartitions, 4.2.15.2

splitting partitions, 4.2.16

truncating partitions, 4.2.17

truncating subpartitions, 4.2.17.2

updating global indexes automatically, 4.2.1

partitioning

composite, 2.3.2, 2.3.2

composite list-hash, 2.3.2.5

composite list-list, 2.3.2.6

composite list-range, 2.3.2.4

composite range-hash, 2.3.2.2

composite range-list, 2.3.2.3

composite range-range, 2.3.2.1

creating partitions, 4.1

data, 6

data segment compression, 3.4

bitmap indexes, 3.4.1

default partition, 4.1.4

default subpartition, 4.1.6.2

hash, 2.3.1.2

index-organized tables, 4.1, 4.1.12.1, 4.1.12.2, 4.1.12.3

interval, 2.4.1.1

interval-hash, 4.1.6.5.1

interval-list, 4.1.6.5.2

interval-range, 4.1.6.5.3

list, 2.3.1.3, 4.2.9, 4.2.10

list-hash, 4.1.6.4.1

list-list, 4.1.6.4.2

list-range, 4.1.6.4.3

maintaining partitions, 4.2

range, 2.3.1.1

range-hash, 4.1.6.1

range-list, 4.1.6.2

range-range, 4.1.6.3, 4.1.6.3

reference, 2.4.2.1

subpartition templates, 4.1.7

system, 2.1.4

virtual columns, 2.4.2.2

partitions, 1.1

equipartitioning

examples, 3.3.1.1

local indexes, 3.3.1

global indexes, 3.3.2

local indexes, 3.3.1

materialized views, 1

nonprefixed indexes, 2.5.1, 3.3.1.2, 3.3.4

parallel DDL, 8.3.2.1

partition pruning

indexes, 3.3.5

partitioning indexes, 3.3, 3.3.6

physical attributes, 3.3.7

prefixed indexes, 3.3.1.1

pruning, 3.1

rules of parallelism, 8.3.2.8.2

PARTITIONS clause

for hash partitions, 4.1.3

partition-wise joins, 3.2

full, 3.2.1

partial, 3.2.2

performance

DSS database, 8.3.3.1

prefixed and nonprefixed indexes, 3.3.5

predicates

partition pruning

indexes, 3.3.5

prefixed indexes, 3.3.1.1, 3.3.3

PRIMARY KEY constraints, 8.7.4

process monitor process (PMON)

parallel DML process recovery, 8.3.3.7.2

processes

and memory contention in parallel processing, 8.5.1.2.1

pruning

partition, 3.1

pruning partitions

indexes, 3.3.5

Q

queries

ad hoc, 8.3.2.2

R

range partitioning, 2.3.1.1

creating tables using, 4.1.1

index-organized tables, 4.1.12.1

multicolumn partitioning keys, 4.1.8

performance considerations, 3.5.1

range-hash partitioning

creating tables using, 4.1.6.1

subpartitioning template, 4.1.7.1

range-list partitioning

creating tables using, 4.1.6.2

subpartitioning template, 4.1.7.2

range-range partitioning

creating tables using, 4.1.6.3, 4.1.6.3

REBUILD INDEX PARTITION statement

rules of parallelism, 8.3.2.8.1

REBUILD INDEX statement

rules of parallelism, 8.3.2.8.1

REBUILD PARTITION clause, 4.2.12.3, 4.2.14.2.1, 4.2.14.2.1

REBUILD UNUSABLE LOCAL INDEXES clause, 4.2.14.2.2

recovery

parallel DML, 8.3.3.7

reference partitioning, 2.4.2.1

creating tables using, 4.1.5

remote transactions

PDML restrictions, 8.1.4

RENAME PARTITION clause, 4.2.15.1, 4.2.15.3.1

RENAME SUBPARTITION clause, 4.2.15.2

replication

restrictions

parallel DML, 8.3.3.9

resources

consumption, parameters affecting, 8.5.2, 8.5.2.3

limiting for users, 8.5.1.3

limits, 8.5.1.2

parallel query usage, 8.5.2

restrictions

direct-path INSERT, 8.3.3.9

parallel DDL, 8.1.4, 8.3.2.1

parallel DML, 8.3.3.9

remote transactions, 8.3.3.12

row movement clause for partitioned tables, 4.1

S

sar UNIX command, 8.6.4

scalability

batch jobs, 8.3.3.1.5

parallel DML, 8.3.3.1

scans

full table

parallel query, 8.1.2

sessions

enabling parallel DML, 8.3.3.2

SET INTERVAL clause, 4.2.2.4

SHARED_POOL_SIZE initialization parameter, 8.5.1.7

SHARED_POOL_SIZE parameter, 8.5.1.7

skewing parallel DML workload, 8.2.6

SORT_AREA_SIZE initialization parameter

and parallel execution, 8.5.2.1.2

space management

MINIMUM EXTENT parameter, 8.3.2.6

parallel DDL, 8.3.2.4

SPLIT PARTITION clause, 4.2.2.1, 4.2.16

rules of parallelism, 8.3.2.8.2

SQL statements

parallelizing, 8.1.4, 8.2.1

SQL*Loader, 8.1.4

statistics

operating system, 8.6.4

storage

fragmentation in parallel DDL, 8.3.2.6

index partitions, 3.3.7

STORAGE clause

parallel execution, 8.3.2.5

STORE IN clause, 4.1.6.1

SUBPARTITION BY HASH clause

for composite-partitioned tables, 4.1.6

SUBPARTITION clause, 4.2.2.5.1, 4.2.2.6.1, 4.2.2.7.1, 4.2.16.4

for composite-partitioned tables, 4.1.6

subpartition templates, 4.1.7

modifying, 4.2.11

SUBPARTITIONS clause, 4.2.2.5.1, 4.2.16.4

for composite-partitioned tables, 4.1.6

subqueries

in DDL statements, 8.3.2.2

symmetric multiprocessors, 8.1.1

system monitor process (SMON)

parallel DML system recovery, 8.3.3.7.3

system partitioning, 2.1.4

T

table queues, 8.6.1.7

tables

historical, 8.3.3.1.4

index-organized, partitioning, 4.1.12

moving time windows in historical, 4.4

parallel creation, 8.3.2.2

parallel DDL storage, 8.3.2.6

partitions, 1.1

refreshing in data warehouse, 8.3.3.1.1

STORAGE clause with parallel execution, 8.3.2.5

summary, 8.3.2.2

TAPE_ASYNCH_IO initialization parameter, 8.5.3.4, 8.5.3.4

temporary segments

parallel DDL, 8.3.2.6

TIMED_STATISTICS initialization parameter, 8.6.1.6

transactions

distributed

parallel DDL restrictions, 8.1.4

parallel DML restrictions, 8.1.4, 8.3.3.12

TRANSACTIONS initialization parameter, 8.5.2.3.1

triggers

restrictions, 8.3.3.11

parallel DML, 8.3.3.9

TRUNCATE PARTITION clause, 4.2.17, 4.2.17, 4.2.17.1, 4.2.17.1.1, 4.2.17.1.1

TRUNCATE SUBPARTITION clause, 4.2.17.2

two-phase commit, 8.5.2.3.1

U

unique

constraints, 8.7.4

UPDATE GLOBAL INDEX clause

of ALTER TABLE, 4.2.1

UPDATE statement

parallel UPDATE statement, 8.3.3.3

user resources

limiting, 8.5.1.3

V

V$PQ_SESSTAT view, 8.6.1.6

V$PQ_TQSTAT view, 8.6.1.7

V$PX_PROCESS view, 8.6.1.4, 8.6.1.5

V$PX_SESSION view, 8.6.1.2

V$PX_SESSTAT view, 8.6.1.3

V$SESSTAT view, 8.6.4

V$SYSSTAT view, 8.7.3.6

views

GV$FILESTAT, 8.6.1

V$PQ_SESSTAT, 8.6.1.6

V$PQ_TQSTAT, 8.6.1.7

V$PX_PROCESS, 8.6.1.4, 8.6.1.5

V$PX_SESSION, 8.6.1.2

V$PX_SESSTAT, 8.6.1.3

V$SESSTAT, 8.6.4

V$SYSSTAT, 8.7.3.6

virtual column-based partitioning, 2.4.2.2

vmstat UNIX command, 8.6.4

W

workloads

skewing, 8.2.6

X

XMLType collections

partitioning, 4.1.14

XMLType objects, 2.1.7