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 multiuser

algorithm for, 25.4.7.1

definition, 25.4.7

affinity

parallel DML, 25.7.2

partitions, 25.7

aggregates, 8.2.1, 18.6.5

computability check, 18.1.3.4

ALL_PUBLISHED_COLUMNS view, 16.9.5

ALTER INDEX statement

partition attributes, 5.6.7

ALTER MATERIALIZED VIEW statement, 8.3

ALTER SESSION statement

ENABLE PARALLEL DML clause, 25.3.3.3

FORCE PARALLEL DDL clause, 25.4.5.4.1, 25.4.5.7

create or rebuild index, 25.4.5.5.1, 25.4.5.7

create table as select, 25.4.5.6.3, 25.4.5.7

move or split partition, 25.4.5.5.2, 25.4.5.7

FORCE PARALLEL DML clause

insert, 25.4.5.3, 25.4.5.3.1, 25.4.5.7

update and delete, 25.4.5.2, 25.4.5.2.1, 25.4.5.7

ALTER TABLE statement

NOLOGGING clause, 25.8.10.2

altering dimensions, 10.6

amortization

calculating, 22.5

analysis tools

described, 23.2.3

analytic functions, 22.3.5

concepts, 21.1

analyzing data

for parallel processing, 25.6.7

APPEND hint, 25.8.10.2

applications

data warehouses

star queries, 19.3

decision support, 25.1

decision support systems (DSS), 6.1.1

parallel SQL, 25.3.2.2

direct-path INSERT, 25.3.3.2.4

parallel DML, 25.3.3.2

ARCH processes

multiple, 25.8.8.6

architecture

data warehouse, 1.2

MPP, 25.7.2

SMP, 25.7.2

asynchronous AutoLog publishing

latency for, 16.6.2, 16.6.2

location of staging database, 16.6.2, 16.6.2

requirements for, 16.6.1.1, 16.6.1.3

setting database initialization parameters for, 16.6.3.4

asynchronous Autolog publishing

source database performance impact, 16.6.2, 16.6.2, 16.6.2

Asynchronous Change Data Capture

columns of built-in Oracle datatypes supported by, 16.11.4

asynchronous Change Data Capture

archived redo log files and, 16.11.1

ARCHIVELOGMODE and, 16.11.1

supplemental logging, 16.11.2

supplemental logging and, 16.2.2

asynchronous change sets

disabling, 16.9.2.2

enabling, 16.9.2.2

exporting, 16.9.4.1

importing, 16.9.4.1

managing, 16.9.2

recovering from capture errors, 16.9.2.4

example of, 16.9.2.4.1, 16.9.2.4.2

removing DDL, 16.9.2.4.2

specifying ending values for, 16.9.2.1

specifying starting values for, 16.9.2.1

stopping capture on DDL, 16.9.2.3

excluded statements, 16.9.2.3

asynchronous change tables

exporting, 16.9.4.1

importing, 16.9.4.1

asynchronous HotLog publishing

latency for, 16.6.2

location of staging database, 16.6.2

requirements for, 16.6.1.1

setting database initialization parameters for, 16.6.3.2, 16.6.3.3, 16.6.3.4, 16.6.3.4

asynchronous Hotlog publishing

source database performance impact, 16.6.2

asynchronous I/O, 25.5.3.4

attributes, 2.2, 10.2

Automatic Storage Management, 4.2

B

bandwidth, 25.1

bind variables

with query rewrite, 18.3.10

bitmap indexes, 6.1

nulls and, 6.1.3

on partitioned tables, 6.1.4

parallel query and DML, 6.1.1, 6.1.1

bitmap join indexes, 6.1.5

B-tree indexes, 6.2

bitmap indexes versus, 6.1.2

build methods, 8.3.4

business intelligence

queries, 24

business rules

violation of, 14.4.1

C

capture errors

recovering from, 16.9.2.4

cardinality

degree of, 6.1.2

CASE expressions, 21.15

cell referencing, 22.2.4

Change Data Capture, 12.2.3

asynchronous

Streams apply process and, 16.6.4

Streams capture process and, 16.6.4

benefits for subscribers, 16.1.3.2

choosing a mode, 16.6.2

effects of stopping on DDL, 16.9.2.3

latency, 16.6.2

location of staging database, 16.6.2

modes of data capture

asynchronous AutoLog, 16.2.2.3

asynchronous Distributed HotLog, 16.2.2.2

asynchronous HotLog, 16.2.2.1

synchronous, 16.2.1

Oracle Data Pump and, 16.9.4

removing from database, 16.12

restriction on direct-path INSERT statement, 16.10.1

setting up, 16.6

source database performance impact, 16.6.2

static data dictionary views, 16.5

supported export utility, 16.9.4

supported import utility, 16.9.4

systemwide triggers installed by, 16.12

Change Data Capture publisher

default tablespace for, 16.6.1.2

change sets

defined, 16.3

effects of disabling, 16.9.2.2

managing asynchronous, 16.9.2

synchronous Change Data Capture and, 16.3

valid combinations with change sources, 16.3.1

change sources

asynchronous AutoLog Change Data Capture and, 16.2.2.3

asynchronous Distributed HotLog Change Data Capture and, 16.2.2.2

database instance represented, 16.3.1

defined, 16.1.3.1, 16.1.3.1

HOTLOG_SOURCE, 16.2.2.1

SYNC_SOURCE, 16.2.1

valid combinations with change sets, 16.3.1

change tables

adding a column to, 16.9.5

control columns, 16.9.3.2

defined, 16.1.3.1

dropping, 16.9.3.6

dropping with active subscribers, 16.9.3.6

effect of SQL DROP USER CASCADE statement on, 16.9.3.6

exporting, 16.9.4

granting subscribers access to, 16.9.3.4

importing, 16.9.4

importing for Change Data Capture, 16.9.4.3

managing, 16.9.3

purging all in a named change set, 16.9.3.5

purging all on staging database, 16.9.3.5

purging by name, 16.9.3.5

purging of unneeded data, 16.9.3.5

source tables referenced by, 16.9.3.1

tablespaces created in, 16.9.3.1

change-value selection, 16.1.1

columns

cardinality, 6.1.2

COMMIT_TIMESTAMP$

control column, 16.9.3.2

common joins, 18.1.3.1.1

COMPLETE clause, 8.3.7

complete refresh, 15.3.1

complex queries

snowflake schemas, 19.3.1

composite

columns, 20.6

partitioning, 5.1.1.4

partitioning methods, 5.1.1.4

performance considerations, 5.1.3.4, 5.1.3.6

compression

See data segment compression, 8.3.3

concatenated groupings, 20.7

concatenated ROLLUP, 20.10.1

concurrent users

increasing the number of, 25.5.1.2

configuration

bandwidth, 4.1.1

constraints, 7.1, 10.4

foreign key, 7.3.2

parallel create table, 25.4.5.6

RELY, 7.3.3

states, 7.2

unique, 7.3.1

view, 7.3.7, 18.3.5

with partitioning, 7.3.6

with query rewrite, 18.6.1

control columns

used to indicate changed columns in a row, 16.9.3.3

controls columns

COMMIT_TIMESTAMP$, 16.9.3.2

CSCN$, 16.9.3.2

OPERATION$, 16.9.3.2

ROW_ID$, 16.9.3.2

RSID$, 16.9.3.2

SOURCE_COLMAP$, 16.9.3.2

interpreting, 16.9.3.3

SYS_NC_OID$, 16.9.3.2

TARGET_COLMAP$, 16.9.3.2

interpreting, 16.9.3.3

TIMESTAMP$, 16.9.3.2

USERNAME$, 16.9.3.2

XIDSEQ$, 16.9.3.2

XIDSLT$, 16.9.3.2

XIDUSN$, 16.9.3.2

cost-based rewrite, 18.1.1

CPU

utilization, 25.1

CREATE DIMENSION statement, 10.2

CREATE INDEX statement, 25.8.9

partition attributes, 5.6.7

rules of parallelism, 25.4.5.5.1

CREATE MATERIALIZED VIEW statement, 8.3

enabling query rewrite, 17.2

CREATE SESSION privilege, 16.6.1.1

CREATE TABLE AS SELECT

rules of parallelism

index-organized tables, 25.1.3

CREATE TABLE AS SELECT statement, 25.6.4, 25.8.4

rules of parallelism

index-organized tables, 25.3.2.1

CREATE TABLE privilege, 16.6.1.1

CREATE TABLE statement

AS SELECT

decision support systems, 25.3.2.2

rules of parallelism, 25.4.5.6

space fragmentation, 25.3.2.6

temporary storage space, 25.3.2.5

parallelism, 25.3.2.2

index-organized tables, 25.1.3, 25.3.2.1

CSCN$

control column, 16.9.3.2

CUBE clause, 20.3

partial, 20.3.3

when to use, 20.3.1

cubes

hierarchical, 9.2.1

CUME_DIST function, 21.2.3

D

data

integrity of

parallel DML restrictions, 25.3.3.10

partitioning, 5.1

purging, 15.2.3, 15.2.3

sufficiency check, 18.1.3.2

transformation, 14.3

transportation, 13.2.1

data compression

See data segment compression, 8.3.3

data cubes

hierarchical, 20.7.1

data densification, 21.16

time series calculation, 21.17

with sparse data, 21.16.2

data dictionary

asynchronous change data capture and, 16.7.4

data extraction

with and without Change Data Capture, 16.1.2

data manipulation language

parallel DML, 25.3.3

transaction model for parallel DML, 25.3.3.4

data marts, 1.2.3

data mining, 23.1

data rules

violation of, 14.4.2

data segment compression, 3.2.3.1

bitmap indexes, 5.1.4.1

materialized views, 8.3.3

partitioning, 3.2.3.1, 5.1.4

data transformation

multistage, 14.1.1.1

pipelined, 14.1.1.2

data warehouse, 8.1

architectures, 1.2

dimension tables, 8.1.6

dimensions, 19.3

fact tables, 8.1.6

logical design, 2.2

partitioned tables, 5.1.3.1

physical design, 3.1

refresh tips, 15.3.9

refreshing table data, 25.3.3.2.1, 25.3.3.2.1

star queries, 19.3

database

scalability, 25.3.3.2

staging, 8.1

database initialization parameters

adjusting when Streams values change, 16.6.4

database writer process (DBWn)

tuning, 25.8.8.7

DATE datatype

partition pruning, 5.5.1.3

partitioning, 5.5.1.3

date folding

with query rewrite, 18.3.4

DB_BLOCK_SIZE initialization parameter, 25.5.3.2

and parallel query, 25.5.3.2

DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 25.5.3.3

DBA role, 16.6.1.1

DBA_DATA_FILES view, 25.6.7.7

DBA_EXTENTS view, 25.6.7.7

DBMS_ADVISOR.TUNE_MVIEW package, 8.3.5

DBMS_CDC_PUBLISH package, 16.1.3.1

privileges required to use, 16.6.1.1

DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE PL/SQL procedure, 16.9.3.6

DBMS_CDC_PUBLISH.PURGE PL/SQL procedure, 16.9.3.5, 16.9.3.5

DBMS_CDC_PUBLISH.PURGE_CHANG_SET PL/SQL procedure, 16.9.3.5

DBMS_CDC_PUBLISH.PURGE_CHANGE_TABLE PL/SQL procedure, 16.9.3.5

DBMS_CDC_SUBSCRIBE package, 16.1.3.2

DBMS_CDC_SUBSCRIBE.PURGE_WINDOW PL/SQL procedure, 16.9.3.5

DBMS_ERROR package, 14.4.2.2

DBMS_JOB PL/SQL package, 16.9.3.5

DBMS_MVIEW package, 15.3.5, 15.3.5

EXPLAIN_MVIEW procedure, 8.7.1

EXPLAIN_REWRITE procedure, 18.5.2

REFRESH procedure, 15.3, 15.3.6

REFRESH_ALL_MVIEWS procedure, 15.3

REFRESH_DEPENDENT procedure, 15.3

DBMS_STATS package, 18.1.1

decision support systems (DSS)

bitmap indexes, 6.1.1

disk striping, 25.7.1

parallel DML, 25.3.3.2

parallel SQL, 25.3.2.2, 25.3.3.2

performance, 25.3.3.2

scoring tables, 25.3.3.2.3

default partition, 5.1.1.3

degree of cardinality, 6.1.2

degree of parallelism, 25.2.1, 25.4.2, 25.4.5, 25.4.5.2.2

and adaptive multiuser, 25.4.7

between query operations, 25.2.4.3

parallel SQL, 25.4.3

DELETE statement

parallel DELETE statement, 25.4.5.2

DENSE_RANK function, 21.2.1

densification

data, 21.16

design

logical, 3.1

physical, 3.1

dimension levels

skipping, 10.2

dimension tables, 2.4, 8.1.6

normalized, 10.2.3

dimensional modeling, 2.2

dimensions, 2.4.2, 10.1, 10.4

altering, 10.6

analyzing, 20.1.1

creating, 10.2

definition, 10.1

dimension tables, 8.1.6

dropping, 10.7

hierarchies, 2.4.2.1

hierarchies overview, 2.4.2.1

multiple, 20.1.1

skipping levels, 10.2

star joins, 19.3

star queries, 19.3

validating, 10.5

with query rewrite, 18.6.2

direct-path INSERT

restrictions, 25.3.3.9

direct-path INSERT statement

Change Data Capture restriction, 16.10.1

disk affinity

parallel DML, 25.7.2

partitions, 25.7

disk redundancy, 4.1.3

disk striping

affinity, 25.7

DISK_ASYNCH_IO initialization parameter, 25.5.3.4, 25.5.3.4

distributed transactions

parallel DDL restrictions, 25.1.3

parallel DML restrictions, 25.1.3, 25.3.3.12

DML access

subscribers, 16.9.3.4

DML_LOCKS initialization parameter, 25.5.2.3.4

downstream capture, 16.7.4

drilling down, 10.1

hierarchies, 10.1

DROP MATERIALIZED VIEW statement, 8.3

prebuilt tables, 8.4

dropping

dimensions, 10.7

materialized views, 8.6

dropping change tables, 16.9.3.6

DSS database

partitioning indexes, 5.6.6

E

ENFORCED mode, 17.2.3

ENQUEUE_RESOURCES initialization parameter, 25.5.2.3.4

entity, 2.2

equipartitioning

examples, 5.6.1.1

local indexes, 5.6.1

error logging, 14.4

table, 14.4.2.2

errors

handling, 14.4

scenarios, 14.5.3

ORA-31424, 16.9.3.6

ORA-31496, 16.9.3.6

ETL. See extraction, transformation, and loading (ETL), 11.1

EXCHANGE PARTITION statement, 7.3.6

EXECUTE privilege, 16.6.1.1

EXECUTE_CATALOG_ROLE privilege, 16.6.1.1

execution plans

parallel operations, 25.6.4

star transformations, 19.4.2.2

EXPAND_GSET_TO_UNION hint, 18.3.7.2, 18.6.10.4

EXPLAIN PLAN statement, 18.5.1, 25.6.3

partition pruning, 5.5.1.3

query parallelization, 25.8.7

star transformations, 19.4.2.2

exporting

a change table, 16.9.4

asynchronous change sets, 16.9.4.1

asynchronous change tables, 16.9.4.1

EXP utility, 12.3.1.3

expression matching

with query rewrite, 18.3.9

extents

parallel DDL, 25.3.2.6

external tables, 14.2.2

extraction, transformation, and loading (ETL), 11.1

overview, 11.1

process, 7.1

extractions

data files, 12.3.1

distributed operations, 12.3.2

full, 12.2.1

incremental, 12.2.1.2

OCI, 12.3.1.2

online, 12.2.2.1

overview, 12.1

physical, 12.2.2

Pro*C, 12.3.1.2

SQL*Plus, 12.3.1.1

F

fact tables, 2.4, 2.4.1

star joins, 19.3

star queries, 19.3

facts, 10.1

FAST clause, 8.3.7

fast refresh, 15.3.2

restrictions, 8.3.7.1

with UNION ALL, 15.3.18

FAST_START_PARALLEL_ROLLBACK initialization parameter, 25.5.2.3.2

features, new, Preface

files

ultralarge, 3.2.2

filling gaps

with data, 21.16.6

FIRST_ROWS(n) hint, 25.8.13

FIRST_VALUE function, 21.3.7

FIRST/LAST functions, 21.6

FOR loops, 22.3.1

FORCE clause, 8.3.7

foreign key

constraints, 7.3.2

joins

snowflake schemas, 19.3.1

fragmentation

parallel DDL, 25.3.2.6

FREELISTS parameter, 25.8.8.5

frequent itemsets, 21.11

full partition-wise joins, 5.2.1

full table scans

parallel execution, 25.1.2

functions

analytic, 22.3.5

COUNT, 6.1.3

CUME_DIST, 21.2.3

DENSE_RANK, 21.2.1

FIRST_VALUE, 21.3.7

FIRST/LAST, 21.6

GROUP_ID, 20.4.4

GROUPING, 20.4

GROUPING_ID, 20.4.3

LAG/LEAD, 21.5

LAST_VALUE, 21.3.7

linear regression, 21.9

NTILE, 21.2.5

parallel execution, 25.3.4

PERCENT_RANK, 21.2.4

RANK, 21.2.1

ranking, 21.2

RATIO_TO_REPORT, 21.4.1

REGR_AVGX, 21.9.2

REGR_AVGY, 21.9.2

REGR_COUNT, 21.9.1

REGR_INTERCEPT, 21.9.3

REGR_SLOPE, 21.9.3

REGR_SXX, 21.9.5

REGR_SXY, 21.9.5

REGR_SYY, 21.9.5

reporting, 21.4

ROW_NUMBER, 21.2.6

WIDTH_BUCKET, 21.13, 21.13.1

window, 22.3.5

windowing, 21.3

G

global

indexes, 25.8.8.3

global indexes

partitioning, 5.6.2

managing partitions, 5.6.2.2

summary of index types, 5.6.3

GRANT statement, 16.9.3.4

granules, 25.2.5

GROUP_ID function, 20.4.4

grouping

compatibility check, 18.1.3.3

conditions, 18.6.6

GROUPING function, 20.4

when to use, 20.4.2

GROUPING_ID function, 20.4.3

GROUPING_SETS expression, 20.5

groups, instance, 25.4.3.6

GT GlossaryTitle, Glossary

GV$FILESTAT view, 25.6.7

H

hash partitioning, 5.1.1.2

HASH_AREA_SIZE initialization parameter

and parallel execution, 25.5.2.1.1

hierarchical cubes, 9.2.1, 20.10.1

in SQL, 20.10

hierarchies, 10.1

how used, 2.4.2.1

multiple, 10.2.2

overview, 2.4.2.1, 2.4.2.1

rolling up and drilling down, 10.1

high boundary

defined, 16.1.3.2

hints

APPEND, 25.8.10.2

EXPAND_GSET_TO_UNION, 18.3.7.2, 18.6.10.4

FIRST_ROWS(n), 25.8.13

NOAPPEND, 25.8.10.2

NOWRITE, 18.6.10.1

PARALLEL, 25.4.3.1, 25.8.2, 25.8.10.1

PARALLEL_INDEX, 25.4.3.1

query rewrite, 17.2, 18.6.10.1

REWRITE, 18.6.10.1

REWRITE_OR_ERROR, 18.6.10.2

histograms

creating with user-defined buckets, 21.15.1

HOTLOG_SOURCE change sources, 16.2.2.1

hypothetical rank, 21.8

I

importing

a change table, 16.9.4, 16.9.4.3

asynchronous change sets, 16.9.4.1

asynchronous change tables, 16.9.4.1

data into a source table, 16.9.4.3

indexes

bitmap indexes, 6.1.4

bitmap join, 6.1.5

B-tree, 6.2

cardinality, 6.1.2

creating in parallel, 25.8.9

global, 25.8.8.3

global partitioned indexes, 5.6.2

managing partitions, 5.6.2.2

local, 25.8.8.3

local indexes, 5.6.1

nulls and, 6.1.3

parallel creation, 25.8.9, 25.8.9, 25.8.9

parallel DDL storage, 25.3.2.6

parallel local, 25.8.9

partitioned tables, 6.1.4

partitioning, 5.1.2, 5.6.6

partitions, 5.6

index-organized tables

parallel CREATE, 25.1.3, 25.3.2.1

parallel queries, 25.3.1.1

initcdc.sql script, 16.12

initialization parameters

DB_BLOCK_SIZE, 25.5.3.2

DB_FILE_MULTIBLOCK_READ_COUNT, 25.5.3.3

DISK_ASYNCH_IO, 25.5.3.4

DML_LOCKS, 25.5.2.3.4

ENQUEUE_RESOURCES, 25.5.2.3.4

FAST_START_PARALLEL_ROLLBACK, 25.5.2.3.2

HASH_AREA_SIZE, 25.5.2.1.1

JOB_QUEUE_PROCESSES, 15.3.9

LARGE_POOL_SIZE, 25.5.1.5

LOG_BUFFER, 25.5.2.3.3

NLS_LANGUAGE, 5.5.1

NLS_SORT, 5.5.1

OPTIMIZER_MODE, 15.3.11, 17.2.1

PARALLEL_ADAPTIVE_MULTI_USER, 25.4.7

PARALLEL_EXECUTION_MESSAGE_SIZE, 25.5.2.1, 25.5.2.2

PARALLEL_MAX_SERVERS, 15.3.11, 25.2.2.1, 25.5.1.1.1

PARALLEL_MIN_PERCENT, 25.4.3.5, 25.5.1.1, 25.5.1.8

PARALLEL_MIN_SERVERS, 25.2.2, 25.2.2.1, 25.5.1.4

PGA_AGGREGATE_TARGET, 15.3.11

QUERY_REWRITE_ENABLED, 17.2, 17.2.1

QUERY_REWRITE_INTEGRITY, 17.2.1

SHARED_POOL_SIZE, 25.5.1.5, 25.5.1.5

STAR_TRANSFORMATION_ENABLED, 19.4.1

TAPE_ASYNCH_IO, 25.5.3.4

TIMED_STATISTICS, 25.6.7.6

TRANSACTIONS, 25.5.2.3.1

INSERT statement

functionality, 25.8.10.1

parallelizing INSERT ... SELECT, 25.4.5.3

instance groups for parallel operations, 25.4.3.6

instances

instance groups, 25.4.3.6

integrity constraints, 7.1

integrity rules

parallel DML restrictions, 25.3.3.10

invalidating

materialized views, 9.4

I/O

asynchronous, 25.5.3.4

parallel execution, 25.1

itemsets

frequent, 21.11

J

Java

used by Change Data Capture, 16.12

JOB_QUEUE_PROCESSES initialization parameter, 15.3.9

join compatibility, 18.1.3.1

joins

full partition-wise, 5.2.1

partial partition-wise, 5.2.2

partition-wise, 5.2

star joins, 19.3

star queries, 19.3

K

key lookups, 14.5.1

keys, 8.1.6, 19.3

L

LAG/LEAD functions, 21.5

LARGE_POOL_SIZE initialization parameter, 25.5.1.5

LAST_VALUE function, 21.3.7

level relationships, 2.4.2.1

purpose, 2.4.2.1.2

levels, 2.4.2, 2.4.2.1.1

levels in a dimension

skipping, 10.2

linear regression functions, 21.9

list partitioning, 5.1.1.3

LOB datatypes

restrictions

parallel DDL, 25.1.3, 25.3.2.1

parallel DML, 25.3.3.9, 25.3.3.9

local indexes, 5.6.1, 5.6.3, 6.1.1, 6.1.4, 25.8.8.3

equipartitioning, 5.6.1

locks

parallel DML, 25.3.3.8

LOG_BUFFER initialization parameter

and parallel execution, 25.5.2.3.3

logging

error, 14.4

LOGGING clause, 25.8.8.8

logging mode

parallel DDL, 25.1.3, 25.3.2.1, 25.3.2.3

logical design, 3.1

logs

materialized views, 8.3.9

lookup tables

See dimension tables, 8.1.6, 8.1.6

low boundary

defined, 16.1.3.2

M

manual

refresh, 15.3.5

manual refresh

with DBMS_MVIEW package, 15.3.5

massively parallel processing (MPP)

affinity, 25.7, 25.7.2

massively parallel systems, 25.1

materialized view logs, 8.3.9

materialized views

aggregates, 8.2.1

altering, 9.6

build methods, 8.3.4

checking status, 15.3.13

containing only joins, 8.2.2

creating, 8.3

data segment compression, 8.3.3

delta joins, 18.1.3.1.3

dropping, 8.4, 8.6

invalidating, 9.4

logs, 12.2.3.3

multiple, 18.2.8

naming, 8.3.2

nested, 8.2.3

OLAP, 9.2

OLAP cubes, 9.2.1

Partition Change Tracking (PCT), 9.1.1

partitioned tables, 15.4

partitioning, 9.1

prebuilt, 8.3

query rewrite

hints, 17.2, 18.6.10.1

matching join graphs, 8.3.6

parameters, 17.2.1

privileges, 17.2.4

refresh dependent, 15.3.8

refreshing, 8.3.7, 15.3

refreshing all, 15.3.7

registration, 8.4

restrictions, 8.3.6.1

rewrites

enabling, 17.2

schema design, 8.1.7

schema design guidelines, 8.1.7

security, 9.5, 9.5

set operators, 9.2.4

storage characteristics, 8.3.3

types of, 8.2

uses for, 8.1

with VPD, 9.5.1

MAXVALUE keyword

partitioned tables and indexes, 5.5.1.1

measures, 8.1.6, 19.3

memory

configure at 2 levels, 25.5.2

MERGE statement, 15.2.1

Change Data Capture restriction, 16.10.1

MINIMUM EXTENT parameter, 25.3.2.6

MODEL clause, 22.1

cell referencing, 22.2.4

data flow, 22.1.1

keywords, 22.2.3

parallel execution, 22.4.1

rules, 22.2.5

monitoring

parallel processing, 25.6.7

refresh, 15.3.12

mortgage calculation, 22.5

MOVE PARTITION statement

rules of parallelism, 25.4.5.5.2

multiple archiver processes, 25.8.8.6, 25.8.8.6

multiple hierarchies, 10.2.2

multiple materialized views, 18.2.8

MV_CAPABILITIES_TABLE table, 8.7.1.2

N

National Language Support (NLS)

DATE datatype and partitions, 5.5.1.3

nested materialized views, 8.2.3

refreshing, 15.3.17

restrictions, 8.2.3.4

net present value

calculating, 22.5

NEVER clause, 8.3.7

new features, Preface

NLS_LANG environment variable, 5.5.1

NLS_LANGUAGE parameter, 5.5.1

NLS_SORT parameter

no effect on partitioning keys, 5.5.1

NOAPPEND hint, 25.8.10.2

NOARCHIVELOG mode, 25.8.8.8

nodes

disk affinity in Real Application Clusters, 25.7

NOLOGGING clause, 25.8.4, 25.8.8.8, 25.8.9

with APPEND hint, 25.8.10.2

NOLOGGING mode

parallel DDL, 25.1.3, 25.3.2.1, 25.3.2.3

nonprefixed indexes, 5.6.1.2, 5.6.4

global partitioned indexes, 5.6.2.1

nonvolatile data, 1.1.3

NOPARALLEL attribute, 25.8.2

NOREWRITE hint, 17.2, 18.6.10.1

NTILE function, 21.2.5

nulls

indexes and, 6.1.3

partitioned tables and indexes, 5.5.1.2

O

object types

parallel query, 25.3.1.4

restrictions, 25.3.1.4

restrictions

parallel DDL, 25.1.3, 25.3.2.1

parallel DML, 25.3.3.9, 25.3.3.9

OLAP, 23.1

applications, 23.2.4

functions, 23.2.4

materialized views, 9.2

OLAP cubes

materialized views, 9.2.1

OLTP database

batch jobs, 25.3.3.2.5

parallel DML, 25.3.3.2

partitioning indexes, 5.6.6

ON COMMIT clause, 8.3.7

ON DEMAND clause, 8.3.7

OPERATION$

control column, 16.9.3.2

optimization

partition pruning

indexes, 5.6.5

partitioned indexes, 5.6.5

optimizations

parallel SQL, 25.2.4

query rewrite

enabling, 17.2

hints, 17.2, 18.6.10.1

matching join graphs, 8.3.6

query rewrites

privileges, 17.2.4

optimizer

with rewrite, 17.1

OPTIMIZER_MODE initialization parameter, 15.3.11, 17.2.1

ORA-31424 error, 16.9.3.6

ORA-31496 error, 16.9.3.6

Oracle Data Pump

using with Change Data Capture, 16.9.4

Oracle Real Application Clusters

disk affinity, 25.7

instance groups, 25.4.3.6

ORDER BY clause, 8.3.8

outer joins

with query rewrite, 18.6.3

P

packages

DBMS_ADVISOR, 8.1.4

DBMS_CDC_PUBLISH, 16.1.2

DBMS_CDC_SUBSCRIBE, 16.1.2

DBMS_DIMENSION, 10.3.2

DBMS_ERROR, 14.4.2.2

DBMS_ERRORLOG, 14.4.2.2, 14.5.3

DBMS_MVIEW, 8.7.1.1, 15.3

DBMS_STATS, 18.1.1

paragraph tags

GT GlossaryTitle, Glossary

PARALLEL clause, 25.8.10.1, 25.8.10.3

parallelization rules, 25.4.5

PARALLEL CREATE INDEX statement, 25.5.2.3

PARALLEL CREATE TABLE AS SELECT statement

resources required, 25.5.2.3

parallel DDL, 25.3.2

extent allocation, 25.3.2.6

parallelization rules, 25.4.5

partitioned tables and indexes, 25.3.2.1

restrictions

LOBs, 25.1.3, 25.3.2.1

object types, 25.1.3, 25.3.1.4, 25.3.2.1

parallel delete, 25.4.5.2

parallel DELETE statement, 25.4.5.2

parallel DML, 25.3.3

applications, 25.3.3.2

bitmap indexes, 6.1.1

degree of parallelism, 25.4.5, 25.4.5.2.2

enabling PARALLEL DML, 25.3.3.3

lock and enqueue resources, 25.3.3.8

parallelization rules, 25.4.5

recovery, 25.3.3.6

restrictions, 25.3.3.9

object types, 25.3.1.4, 25.3.3.9, 25.3.3.9, 25.3.3.9, 25.3.3.9

remote transactions, 25.3.3.12

transaction model, 25.3.3.4

parallel execution

full table scans, 25.1.2

index creation, 25.8.9

interoperator parallelism, 25.2.4.3

intraoperator parallelism, 25.2.4.3

I/O parameters, 25.5.3

plans, 25.6.4

query optimization, 25.8.12

resource parameters, 25.5.2

rewriting SQL, 25.8.3

solving problems, 25.8.2

tuning, 25.1

PARALLEL hint, 25.4.3.1, 25.8.2, 25.8.10.1

parallelization rules, 25.4.5

UPDATE and DELETE, 25.4.5.2

parallel partition-wise joins

performance considerations, 5.2.4

parallel query, 25.3.1

bitmap indexes, 6.1.1

index-organized tables, 25.3.1.1

object types, 25.3.1.4

restrictions, 25.3.1.4

parallelization rules, 25.4.5

parallel SQL

allocating rows to parallel execution servers, 25.2.4.1

degree of parallelism, 25.4.3

instance groups, 25.4.3.6

number of parallel execution servers, 25.2.2

optimizer, 25.2.4

parallelization rules, 25.4.5

shared server, 25.2.2

parallel update, 25.4.5.2

parallel UPDATE statement, 25.4.5.2

PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 25.4.7

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 25.5.2.1, 25.5.2.2

PARALLEL_INDEX hint, 25.4.3.1

PARALLEL_MAX_SERVERS initialization parameter, 15.3.11, 25.2.2.1, 25.5.1.1.1

and parallel execution, 25.5.1.1

PARALLEL_MIN_PERCENT initialization parameter, 25.4.3.5, 25.5.1.1, 25.5.1.8

PARALLEL_MIN_SERVERS initialization parameter, 25.2.2, 25.2.2.1, 25.5.1.4

PARALLEL_THREADS_PER_CPU initialization parameter, 25.4.9

parallelism, 25.1

degree, 25.2.1, 25.4.2

degree, overriding, 25.8.2

enabling for tables and queries, 25.4.6

interoperator, 25.2.4.3

intraoperator, 25.2.4.3

parameters

FREELISTS, 25.8.8.5

partition

default, 5.1.1.3

Partition Change Tracking (PCT), 9.1.1, 15.4.1, 18.2.7

with Pmarkers, 18.2.7.4

partition pruning, 5.1.5

dynamic, 5.1.5.4

static, 5.1.5.3

techniques, 5.1.5.5

partitioned outer join, 21.16

partitioned tables

data warehouses, 5.1.3.1

materialized views, 15.4

partitioning, 12.2.3.2

composite, 5.1.1.4, 5.1.1.4

data, 5.1

data segment compression, 5.1.4

bitmap indexes, 5.1.4.1

hash, 5.1.1.2

indexes, 5.1.2

list, 5.1.1.3

materialized views, 9.1

prebuilt tables, 9.1.3

range, 5.1.1.1, 5.1.1.1

range-list, 5.1.3.6

partitions

affinity, 25.7

bitmap indexes, 6.1.4

DATE datatype, 5.5.1.3

equipartitioning

examples, 5.6.1.1

local indexes, 5.6.1

global indexes, 5.6.2

local indexes, 5.6.1

multicolumn keys, 5.5.1.4

nonprefixed indexes, 5.6.1.2, 5.6.4

parallel DDL, 25.3.2.1

partition bounds, 5.5

partition pruning

DATE datatype, 5.5.1.3

disk striping and, 25.7.1

indexes, 5.6.5

partitioning indexes, 5.6, 5.6.6

partitioning keys, 5.4, 5.4

physical attributes, 5.6.7

prefixed indexes, 5.6.1.1

pruning, 5.1.5

range partitioning

disk striping and, 25.7.1

restrictions

datatypes, 5.5.1.3

rules of parallelism, 25.4.5.5.2

partition-wise joins, 5.2

benefits of, 5.2.3

full, 5.2.1

partial, 5.2.2

PERCENT_RANK function, 21.2.4

performance

DSS database, 25.3.3.2

prefixed and nonprefixed indexes, 5.6.5

PGA_AGGREGATE_TARGET initialization parameter, 15.3.11

physical design, 3.1

structures, 3.2.1

pivoting, 14.5.4, 14.5.4

plans

star transformations, 19.4.2.2

PL/SQL packages

DBMS_JOB, 16.9.3.5

PL/SQL procedures

DBMS_CDC_PUBLISH_DROP_CHANGE_TABLE, 16.9.3.6

DBMS_CDC_PUBLISH.PURGE, 16.9.3.5, 16.9.3.5

DBMS_CDC_PUBLISH.PURGE_CHANGE_SET, 16.9.3.5

DBMS_CDC_PUBLISH.PURGE_CHANGE_TABLE, 16.9.3.5

DBMS_CDC_SUBSCRIBE.PURGE_WINDOW, 16.9.3.5

Pmarkers

with PCT, 18.2.7.4

prebuilt materialized views, 8.3

predicates

partition pruning

indexes, 5.6.5

prefixed indexes, 5.6.1.1, 5.6.3

PRIMARY KEY constraints, 25.8.9

privileges required

to publish change data, 16.6.1.1

process monitor process (PMON)

parallel DML process recovery, 25.3.3.6.2

processes

and memory contention in parallel processing, 25.5.1.1.1

pruning

partition, 5.1.5

partitions, 25.7.1

pruning partitions

DATE datatype, 5.5.1.3

EXPLAIN PLAN, 5.5.1.3

indexes, 5.6.5

publication

defined, 16.1.3.1

publisher

definition, 16.1.3.1

publishers

components associated with, 16.1.3.1

defined, 16.1.3

determining the source tables, 16.1.3.1

privileges for reading views, 16.5

purpose, 16.1.3.1

table partitioning properties and, 16.9.3.1

tasks, 16.1.3.1

publishing

asynchronous AutoLog mode

step-by-step example, 16.7.4

asynchronous HotLog mode

step-by-step example, 16.7.2

synchronous mode

step-by-step example, 16.7.1

publishing change data

preparations for, 16.6

privileges required, 16.6.1.1

purging change tables

automatically, 16.9.3.5

by name, 16.9.3.5

in a named changed set, 16.9.3.5

on the staging database, 16.9.3.5

publishers, 16.9.3.5

subscribers, 16.9.3.5

purging data, 15.2.3

Q

queries

ad hoc, 25.3.2.2

enabling parallelism for, 25.4.6

star queries, 19.3

query delta joins, 18.1.3.1.2

query optimization, 25.8.12

parallel execution, 25.8.12

query rewrite

advanced, 18.4

checks made by, 18.1.3

controlling, 17.2.2

correctness, 17.2.3

date folding, 18.3.4

enabling, 17.2, 17.2

hints, 17.2, 18.6.10.1

matching join graphs, 8.3.6

methods, 18.1

parameters, 17.2.1

privileges, 17.2.4

restrictions, 8.3.6.2

using equivalences, 18.4

using GROUP BY extensions, 18.3.7.1

using nested materialized views, 18.3.1

using PCT, 18.2.7

VPD, 9.5.1.1

when it occurs, 17.1.1

with bind variables, 18.3.10

with DBMS_MVIEW package, 18.5.2

with expression matching, 18.3.9

with inline views, 18.3.2

with partially stale materialized views, 18.3.9.1

with selfjoins, 18.3.3

with set operator materialized views, 18.3.6

with view constraints, 18.3.5

query tools

described, 23.2.3

QUERY_REWRITE_ENABLED initialization parameter, 17.2, 17.2.1

QUERY_REWRITE_INTEGRITY initialization parameter, 17.2.1

R

range partitioning, 5.1.1.1, 5.1.1.1

key comparison, 5.5.1, 5.5.1.4

partition bounds, 5.5

performance considerations, 5.1.3.1

range-list partitioning, 5.1.3.6

RANK function, 21.2.1

ranking functions, 21.2

RATIO_TO_REPORT function, 21.4.1

REBUILD INDEX PARTITION statement

rules of parallelism, 25.4.5.5.1

REBUILD INDEX statement

rules of parallelism, 25.4.5.5.1

recovery

from asynchronous change set capture errors, 16.9.2.4

parallel DML, 25.3.3.6

redo buffer allocation retries, 25.5.2.3.3

redo log files

archived

asynchronous Change Data Capture and, 16.11.1

determining which are no longer needed by Change Data Capture, 16.11.1

reference tables

See dimension tables, 8.1.6

refresh

monitoring, 15.3.12

options, 8.3.7

scheduling, 15.3.14

with UNION ALL, 15.3.18

refreshing

materialized views, 15.3

nested materialized views, 15.3.17

partitioning, 15.1

REGR_AVGX function, 21.9.2

REGR_AVGY function, 21.9.2

REGR_COUNT function, 21.9.1

REGR_INTERCEPT function, 21.9.3

REGR_R2 function, 21.9.4

REGR_SLOPE function, 21.9.3

REGR_SXX function, 21.9.5

REGR_SXY function, 21.9.5

REGR_SYY function, 21.9.5

regression

detecting, 25.6.1

RELY constraints, 7.3.3

remote transactions

PDML restrictions, 25.1.3

removing

Change Data Capture from source database, 16.12

replication

restrictions

parallel DML, 25.3.3.9

reporting functions, 21.4

resources

consumption, parameters affecting, 25.5.2, 25.5.2.3

limiting for users, 25.5.1.3

limits, 25.5.1.1

parallel query usage, 25.5.2

restrictions

direct-path INSERT, 25.3.3.9

fast refresh, 8.3.7.1

nested materialized views, 8.2.3.4

parallel DDL, 25.1.3, 25.3.2.1

parallel DML, 25.3.3.9

remote transactions, 25.3.3.12

partitions

datatypes, 5.5.1.3

query rewrite, 8.3.6.2

result set, 19.4.2

REVOKE statement, 16.9.3.4

REWRITE hint, 17.2, 18.6.10.1, 18.6.10.1

REWRITE_OR_ERROR hint, 18.6.10.2

rewrites

hints, 18.6.10.1

parameters, 17.2.1

privileges, 17.2.4

query optimizations

hints, 17.2, 18.6.10.1

matching join graphs, 8.3.6

rmcdc.sql script, 16.12

rolling up hierarchies, 10.1

ROLLUP, 20.2

concatenated, 20.10.1

partial, 20.2.3

when to use, 20.2.1

root level, 2.4.2.1.1

ROW_ID$

control column, 16.9.3.2

ROW_NUMBER function, 21.2.6

RSID$

control column, 16.9.3.2

rules

in MODEL clause, 22.2.5

in SQL modeling, 22.2.5

order of evaluation, 22.2.6

S

sar UNIX command, 25.6.10

scalability

batch jobs, 25.3.3.2.5

parallel DML, 25.3.3.2

scalable operations, 25.8.6

scans

full table

parallel query, 25.1.2

schema-level export operations, 16.9.4.1

schema-level import operations, 16.9.4.1

schemas, 19.1

design guidelines for materialized views, 8.1.7

snowflake, 2.3

star, 2.3

third normal form, 19.1, 19.2

scripts

initcdc.sql for Change Data Capture, 16.12

rmcdc.sql for Change Data Capture, 16.12

SELECT_CATALOG_ROLE privilege, 16.5, 16.6.1.1

sessions

enabling parallel DML, 25.3.3.3

set operators

materialized views, 9.2.4

shared server

parallel SQL execution, 25.2.2

SHARED_POOL_SIZE initialization parameter, 25.5.1.5

SHARED_POOL_SIZE parameter, 25.5.1.5

simultaneous equations, 22.5

skewing parallel DML workload, 25.4.4

SKIP WHEN NULL clause, 10.2

skipping levels in a dimension, 10.2

SMP architecture

disk affinity, 25.7.2

snowflake schemas, 19.3.1

complex queries, 19.3.1

SORT_AREA_SIZE initialization parameter

and parallel execution, 25.5.2.1.2

source database

defined, 16.1.3.1

source systems, 12.1

source tables

importing for Change Data Capture, 16.9.4.3

referenced by change tables, 16.9.3.1

SOURCE_COLMAP$

control column, 16.9.3.2

interpreting, 16.9.3.3

space management

MINIMUM EXTENT parameter, 25.3.2.6

parallel DDL, 25.3.2.4

sparse data

data densification, 21.16.2

SPLIT PARTITION clause

rules of parallelism, 25.4.5.5.2

SQL modeling, 22.1

cell referencing, 22.2.4

keywords, 22.2.3

order of evaluation, 22.2.6

performance, 22.4

rules, 22.2.5

rules and restrictions, 22.3.7

SQL statements

parallelizing, 25.1.3, 25.2.4

SQL*Loader, 25.1.3

staging

areas, 1.2.2

databases, 8.1

files, 8.1

staging database

defined, 16.1.3.1

STALE_TOLERATED mode, 17.2.3

star joins, 19.3

star queries, 19.3

star transformation, 19.4.2

star schemas

advantages, 2.3.1

defining fact tables, 2.4.1.1

dimensional model, 2.3.1, 19.3

star transformations, 19.4.2

restrictions, 19.4.2.6

STAR_TRANSFORMATION_ENABLED initialization parameter, 19.4.1

statistics, 18.6.9

estimating, 25.6.4

operating system, 25.6.10

storage

fragmentation in parallel DDL, 25.3.2.6

index partitions, 5.6.7

STORAGE clause

parallel execution, 25.3.2.5

Streams apply parallelism value

determining, 16.6.4.1, 16.6.4.2

Streams apply process

asynchronous Change Data Capture and, 16.6.4

Streams capture parallelism value

determining, 16.6.4.1, 16.6.4.2

Streams capture process

asynchronous Change Data Capture and, 16.6.4

striping, 4.1.2

subpartition

mapping, 5.1.3.5

template, 5.1.3.5

subqueries

in DDL statements, 25.3.2.2

subscriber view

defined, 16.1.3.2

returning DML changes in order, 16.9.3.2, 16.9.3.2

subscribers

access to change tables, 16.9.3.4

ALL_PUBLISHED_COLUMNS view, 16.9.5

components associated with, 16.1.3.2

controlling access to tables, 16.9.3.4

defined, 16.1.3

DML access, 16.9.3.4

privileges, 16.1.3.2

purpose, 16.1.3.2

retrieve change data from the subscriber views, 16.1.3.2

tasks, 16.1.3.2

subscribing

step-by-step example, 16.8

subscription windows

defined, 16.1.3.2

subscriptions

changes to change tables and, 16.9.5

defined, 16.1.3.2

effect of SQL DROP USER CASCADE statement on, 16.9.3.6

summary management

components, 8.1.5

summary tables, 2.4.1

supplemental logging

asynchronous Change Data Capture, 16.11.2

asynchronous Change Data Capture and, 16.2.2

symmetric multiprocessors, 25.1

SYNC_SET predefined change set, 16.3

SYNC_SOURCE change source, 16.2.1

synchronous Change Data Capture

change sets and, 16.3

synchronous change sets

disabling, 16.9.2.2

enabling, 16.9.2.2

synchronous publishing

latency for, 16.6.2

location of staging database, 16.6.2

requirements for, 16.7.1

setting database initialization parameters for, 16.6.3.1

source database performance impact, 16.6.2

SYS_NC_OID$

control column, 16.9.3.2

system monitor process (SMON)

parallel DML system recovery, 25.3.3.6.3

T

table differencing, 16.1.1

table partitioning

publisher and, 16.9.3.1

table queues, 25.6.7.9

tables

detail tables, 8.1.6

dimension tables (lookup tables), 8.1.6

dimensions

star queries, 19.3

enabling parallelism for, 25.4.6

external, 14.2.2

fact tables, 8.1.6

star queries, 19.3

historical, 25.3.3.2.4

lookup, 19.3

parallel creation, 25.3.2.2

parallel DDL storage, 25.3.2.6

refreshing in data warehouse, 25.3.3.2.1

STORAGE clause with parallel execution, 25.3.2.5

summary, 25.3.2.2

tablespace

specifying default for Change Data Capture publisher, 16.6.1.2

tablespaces

change tables and, 16.9.3.1

transportable, 12.2.2.2, 13.2.3, 13.2.3.2

TAPE_ASYNCH_IO initialization parameter, 25.5.3.4, 25.5.3.4

TARGET_COLMAP$

control column, 16.9.3.2

interpreting, 16.9.3.3

temporary segments

parallel DDL, 25.3.2.6

text match, 18.2.1

with query rewrite, 18.6.4

third normal form

queries, 19.2.1

schemas, 19.2

time series calculations, 21.17

TIMED_STATISTICS initialization parameter, 25.6.7.6

TIMESTAMP$

control column, 16.9.3.2

timestamps, 12.2.3.1

TO_DATE function

partitions, 5.5.1.3

transactions

distributed

parallel DDL restrictions, 25.1.3

parallel DML restrictions, 25.1.3, 25.3.3.12

TRANSACTIONS initialization parameter, 25.5.2.3.1

transformations, 14.1

scenarios, 14.5

SQL and PL/SQL, 14.3.1

SQL*Loader, 14.2.1

transportable tablespaces, 12.2.2.2, 13.2.3, 13.2.3.2

transportation

definition, 13.1

distributed operations, 13.2.2

flat files, 13.2.1

triggers, 12.2.3.3

installed by Change Data Capture, 16.12

restrictions, 25.3.3.11

parallel DML, 25.3.3.9

TRUSTED mode, 17.2.3

two-phase commit, 25.5.2.3.1

U

ultralarge files, 3.2.2

unique

constraints, 7.3.1, 25.8.9

identifier, 2.2, 3.2

update frequencies, 8.1.9

UPDATE statement, 22.2.8

parallel UPDATE statement, 25.4.5.2

update windows, 8.1.9

UPSERT ALL statement, 22.2.8

UPSERT statement, 22.2.8

user resources

limiting, 25.5.1.3

USERNAME$

control column, 16.9.3.2

V

V$FILESTAT view

and parallel query, 25.6.7.7

V$PARAMETER view, 25.6.7.8

V$PQ_SESSTAT view, 25.6.5, 25.6.7.6

V$PQ_SYSSTAT view, 25.6.5

V$PQ_TQSTAT view, 25.6.6, 25.6.7.9

V$PX_PROCESS view, 25.6.7.4, 25.6.7.5

V$PX_SESSION view, 25.6.7.2

V$PX_SESSTAT view, 25.6.7.3

V$SESSTAT view, 25.6.7.10, 25.6.10

V$SYSSTAT view, 25.5.2.3.3, 25.6.7.10, 25.8.8.7

validating dimensions, 10.5

VALUES LESS THAN clause, 5.5

MAXVALUE, 5.5.1.1

view constraints, 7.3.7, 18.3.5

views

DBA_DATA_FILES, 25.6.7.7

DBA_EXTENTS, 25.6.7.7

GV$FILESTAT, 25.6.7

V$FILESTAT, 25.6.7.7

V$PARAMETER, 25.6.7.8

V$PQ_SESSTAT, 25.6.5, 25.6.7.6

V$PQ_SYSSTAT, 25.6.5

V$PQ_TQSTAT, 25.6.6, 25.6.7.9

V$PX_PROCESS, 25.6.7.4, 25.6.7.5

V$PX_SESSION, 25.6.7.2

V$PX_SESSTAT, 25.6.7.3

V$SESSTAT, 25.6.7.10, 25.6.10

V$SYSSTAT, 25.6.7.10, 25.8.8.7

vmstat UNIX command, 25.6.10

VPD

and materialized views, 9.5.1

restrictions with materialized views, 9.5.1.2

W

WIDTH_BUCKET function, 21.13, 21.13.1

window functions, 22.3.5

windowing functions, 21.3

workloads

distribution, 25.6.6

skewing, 25.4.4

X

XIDSEQ$

control column, 16.9.3.2

XIDSLT$

control column, 16.9.3.2

XIDUSN$

control column, 16.9.3.2