Skip Headers

Oracle® Database Data Warehousing Guide
10g Release 1 (10.1)

Part Number B10736-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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, 24.4.7.1
definition, 24.4.7
affinity
parallel DML, 24.7.2
partitions, 24.7
aggregates, 8.2.1, 18.5.5
computability check, 18.3.3.4
ALL_PUBLISHED_COLUMNS view, 16.10.4
ALTER, 18.2
ALTER INDEX statement
partition attributes, 5.3.7.7
ALTER MATERIALIZED VIEW statement, 8.3
ALTER SESSION statement
ENABLE PARALLEL DML clause, 24.3.3.3
FORCE PARALLEL DDL clause, 24.4.5.4.1, 24.4.5.7
create or rebuild index, 24.4.5.5.1, 24.4.5.7
create table as select, 24.4.5.6.3, 24.4.5.7
move or split partition, 24.4.5.5.2, 24.4.5.7
FORCE PARALLEL DML clause
insert, 24.4.5.3, 24.4.5.3.1, 24.4.5.7
update and delete, 24.4.5.2, 24.4.5.2.1, 24.4.5.7
ALTER TABLE statement
NOLOGGING clause, 24.8.10.2
altering dimensions, 10.6
amortization
calculating, 22.5
analytic functions
concepts, 21.1
analyzing data
for parallel processing, 24.6.7
APPEND hint, 24.8.10.2
applications
data warehouses
star queries, 19.3
decision support, 24.1
decision support systems (DSS), 6.1.1
parallel SQL, 24.3.2.2
direct-path INSERT, 24.3.3.2.4
parallel DML, 24.3.3.2
ARCH processes
multiple, 24.8.8.6
architecture
data warehouse, 1.2
MPP, 24.7.2
SMP, 24.7.2
asychronous AutoLog publishing
requirements for, 16.6.1.1, 16.6.1.3
asynchronous AutoLog publishing
latency for, 16.6.2
location of staging database, 16.6.2
setting database initialization parameters for, 16.6.3.3
asynchronous Autolog publishing
source database performace impact, 16.6.2
Asynchronous Change Data Capture
columns of built-in Oracle datatypes supported by, 16.9.3
asynchronous Change Data Capture
archived redo log files and, 16.9.1
ARCHIVELOGMODE and, 16.9.1
supplemental logging, 16.9.2
supplemental logging and, 16.2.2
asynchronous change sets
disabling, 16.10.1.2
enabling, 16.10.1.2
exporting, 16.10.3
importing, 16.10.3
managing, 16.10.1
recovering from capture errors, 16.10.1.4
example of, 16.10.1.4.1, 16.10.1.4.2
removing DDL, 16.10.1.4.2
specifying ending values for, 16.10.1.1
specifying starting values for, 16.10.1.1
stopping capture on DDL, 16.10.1.3
excluded statements, 16.10.1.3
asynchronous change tables
exporting, 16.10.3
importing, 16.10.3
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.3
asynchronous Hotlog publishing
source database performace impact, 16.6.2
asynchronous I/O, 24.5.3.4
attributes, 2.2, 10.2
AutoLog change sets, 16.3
Automatic Storage Management, 4.2

B

bandwidth, 5.1.1, 24.1
bind variables
with query rewrite, 18.3.6
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
block range granules, 5.2.1
B-tree indexes, 6.2
bitmap indexes versus, 6.1.2
build methods, 8.3.4

C

capture errors
recovering from, 16.10.1.4
cardinality
degree of, 6.1.2
CASE expressions, 21.14
cell referencing, 22.2.4
Change Data Capture, 12.2.3
asynchronous
Streams apply process and, 16.6.3.6
Streams capture process and, 16.6.3.6
benefits for subscribers, 16.1.3.2
choosing a mode, 16.6.2
effects of stopping on DDL, 16.10.1.3
latency, 16.6.2
location of staging database, 16.6.2
modes of data capture
asynchronous AutoLog, 16.2.2.2
asynchronous HotLog, 16.2.2.1
synchronous, 16.2.1
Oracle Data Pump and, 16.10.3
removing from database, 16.11
restriction on direct-path INSERT statement, 16.11.1
setting up, 16.6
source database performance impact, 16.6.2
static data dictionary views, 16.5
supported export utility, 16.10.3
supported import utility, 16.10.3
systemwide triggers installed by, 16.11
Change Data Capture publisher
default tablespace for, 16.6.1.2
change sets
AutoLog, 16.3
AutoLog change sources and, 16.3
defined, 16.3
effects of disabling, 16.10.1.2
HotLog, 16.3
HOTLOG_SOURCE change sources and, 16.3
managing asynchronous, 16.10.1
synchronous, 16.3
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.2
database instance represented, 16.3.1
defined, 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.10.4
control columns, 16.10.2.2
defined, 16.1.3.1
dropping, 16.10.2.6
dropping with active subscribers, 16.10.2.6
effect of SQL DROP USER CASCADE statement on, 16.10.2.6
exporting, 16.10.3
granting subscribers access to, 16.10.2.4
importing, 16.10.3
importing for Change Data Capture, 16.10.3
managing, 16.10.2
purging all in a named change set, 16.10.2.5
purging all on staging database, 16.10.2.5
purging by name, 16.10.2.5
purging of unneeded data, 16.10.2.5
source tables referenced by, 16.10.2.1
tablespaces created in, 16.10.2.1
change-value selection, 16.1.1
columns
cardinality, 6.1.2
COMMIT_TIMESTAMP$
control column, 16.10.2.2
common joins, 18.3.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.3.1.1.4
partitioning methods, 5.3.1.1.4
performance considerations, 5.3.1.3.4, 5.3.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, 24.5.1.2
configuration
bandwidth, 4.1.1
CONNECT role, 16.6.1.1
constraints, 7.1, 10.4
foreign key, 7.3.2
parallel create table, 24.4.5.6
RELY, 7.3.3
states, 7.2
unique, 7.3.1
view, 7.3.6, 18.3.4.7
with partitioning, 7.3.5
with query rewrite, 18.5.1
control columns
used to indicate changed columns in a row, 16.10.2.3
controls columns
COMMIT_TIMESTAMP$, 16.10.2.2
CSCN$, 16.10.2.2
OPERATION$, 16.10.2.2
ROW_ID$, 16.10.2.2
RSID$, 16.10.2.2
SOURCE_COLMAP$, 16.10.2.2
interpreting, 16.10.2.3
SYS_NC_OID$, 16.10.2.2
TARGET_COLMAP$, 16.10.2.2
interpreting, 16.10.2.3
TIMESTAMP$, 16.10.2.2
USERNAME$, 16.10.2.2
XIDSEQ$, 16.10.2.2
XIDSLT$, 16.10.2.2
XIDUSN$, 16.10.2.2
cost-based rewrite, 18.1.1
CPU
utilization, 5.1.1, 24.1
CREATE DIMENSION statement, 10.2
CREATE INDEX statement, 24.8.9
partition attributes, 5.3.7.7
rules of parallelism, 24.4.5.5.1
CREATE MATERIALIZED VIEW statement, 8.3
enabling query rewrite, 18.2
CREATE SESSION privilege, 16.6.1.1
CREATE TABLE AS SELECT
rules of parallelism
index-organized tables, 24.1.3
CREATE TABLE AS SELECT statement, 24.6.4, 24.8.4
rules of parallelism
index-organized tables, 24.3.2.1
CREATE TABLE privilege, 16.6.1.1
CREATE TABLE statement
AS SELECT
decision support systems, 24.3.2.2
rules of parallelism, 24.4.5.6
space fragmentation, 24.3.2.6
temporary storage space, 24.3.2.5
parallelism, 24.3.2.2
index-organized tables, 24.1.3, 24.3.2.1
CREATE TABLESPACE privilege, 16.6.1.2
CSCN$
control column, 16.10.2.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, 24.3.3.10
partitioning, 5.3.1
purging, 15.2.3, 15.2.3
sufficiency check, 18.3.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.15
time series calculation, 21.16
with sparse data, 21.15.2
data dictionary
asynchronous change data capture and, 16.7.3
data extraction
with and without Change Data Capture, 16.1.2
data manipulation language
parallel DML, 24.3.3
transaction model for parallel DML, 24.3.3.4
data marts, 1.2.3
data segment compression, 3.2.3.1
bitmap indexes, 5.3.2.1
materialized views, 8.3.3
partitioning, 3.2.3.1, 5.3.2
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.3.1.3.1
physical design, 3.1
refresh tips, 15.3.9
refreshing table data, 24.3.3.2.1, 24.3.3.2.1
star queries, 19.3
database
scalability, 24.3.3.2
staging, 8.1
database initialization paramters
adjusting when Streams values change, 16.6.3.6
determining current setting of, 16.6.3.4
retaining settings when database is restarted, 16.6.3.5
database writer process (DBWn)
tuning, 24.8.8.7
DATE datatype
partition pruning, 5.3.6.4
partitioning, 5.3.6.4
date folding
with query rewrite, 18.3.4.9
DB_BLOCK_SIZE initialization parameter, 24.5.3.2
and parallel query, 24.5.3.2
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 24.5.3.3
DBA role, 16.6.1.1
DBA_DATA_FILES view, 24.6.7.7
DBA_EXTENTS view, 24.6.7.7
DBMS_ADVISOR package, 17.1
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.10.2.6
DBMS_CDC_PUBLISH.PURGE PL/SQL procedure, 16.10.2.5, 16.10.2.5
DBMS_CDC_PUBLISH.PURGE_CHANG_SET PL/SQL procedure, 16.10.2.5
DBMS_CDC_PUBLISH.PURGE_CHANGE_TABLE PL/SQL procedure, 16.10.2.5
DBMS_CDC_SUBSCRIBE package, 16.1.3.2
DBMS_CDC_SUBSCRIBE.PURGE_WINDOW PL/SQL procedure, 16.10.2.5
DBMS_JOB PL/SQL procedure, 16.10.2.5
DBMS_MVIEW package, 15.3.5, 15.3.5
EXPLAIN_MVIEW procedure, 8.7.1
EXPLAIN_REWRITE procedure, 18.4.2
REFRESH procedure, 15.3, 15.3.6
REFRESH_ALL_MVIEWS procedure, 15.3
REFRESH_DEPENDENT procedure, 15.3
DBMS_STATS package, 17.1, 18.1.1
decision support systems (DSS)
bitmap indexes, 6.1.1
disk striping, 24.7.1
parallel DML, 24.3.3.2
parallel SQL, 24.3.2.2, 24.3.3.2
performance, 24.3.3.2
scoring tables, 24.3.3.2.3
default partition, 5.3.1.1.3
degree of cardinality, 6.1.2
degree of parallelism, 24.2.1, 24.4.2, 24.4.5, 24.4.5.2.2
and adaptive multiuser, 24.4.7
between query operations, 24.2.4.3
parallel SQL, 24.4.3
DELETE statement
parallel DELETE statement, 24.4.5.2
DENSE_RANK function, 21.2.1
design
logical, 3.1
physical, 3.1
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
star joins, 19.3
star queries, 19.3
validating, 10.5
with query rewrite, 18.5.2
direct-path INSERT
restrictions, 24.3.3.9
direct-path INSERT statement
Change Data Capture restriction, 16.11.1
disk affinity
parallel DML, 24.7.2
partitions, 24.7
disk redundancy, 4.1.3
disk striping
affinity, 24.7
DISK_ASYNCH_IO initialization parameter, 24.5.3.4, 24.5.3.4
distributed transactions
parallel DDL restrictions, 24.1.3
parallel DML restrictions, 24.1.3, 24.3.3.12
DML access
subscribers, 16.10.2.4
DML_LOCKS initialization parameter, 24.5.2.3.4
downstream capture, 16.7.3
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.10.2.6
DSS database
partitioning indexes, 5.3.7.6

E

ENFORCED mode, 18.2.3
ENQUEUE_RESOURCES initialization parameter, 24.5.2.3.4
entity, 2.2
equipartitioning
examples, 5.3.7.1.1
local indexes, 5.3.7.1
errors
ORA-31424, 16.10.2.6
ORA-31496, 16.10.2.6
ETL. See extraction, transformation, and loading (ETL), 11.1
EXCHANGE PARTITION statement, 7.3.5
EXECUTE_CATALOG_ROLE privilege, 16.6.1.1
EXECUTE_TASK procedure, 17.2.17.1
execution plans
parallel operations, 24.6.4
star transformations, 19.4.2.2
EXPLAIN PLAN statement, 18.4.1, 24.6.3
partition pruning, 5.3.6.4
query parallelization, 24.8.7
star transformations, 19.4.2.2
EXPLAIN_MVIEW procedure, 17.3
exporting
a change table, 16.10.3
asynchronous change sets, 16.10.3
asynchronous change tables, 16.10.3
EXP utility, 12.3.1.3
expression matching
with query rewrite, 18.3.4.8
extents
parallel DDL, 24.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, 24.5.2.3.2
features, new, Preface
files
ultralarge, 3.2.2
FIRST_ROWS(n) hint, 24.8.13
FIRST_VALUE function, 21.3.7
FIRST/LAST functions, 21.6
FORCE clause, 8.3.7
foreign key
constraints, 7.3.2
joins
snowflake schemas, 19.3.1
fragmentation
parallel DDL, 24.3.2.6
FREELISTS parameter, 24.8.8.5
full partition-wise joins, 5.3.4.1
full table scans
parallel execution, 24.1.2
functions
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, 24.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.12, 21.12.1
windowing, 21.3

G

global
indexes, 24.8.8.3
global indexes
partitioning, 5.3.7.2
managing partitions, 5.3.7.2.2
summary of index types, 5.3.7.3
granules, 5.2
block range, 5.2.1
partition, 5.2.2
GROUP_ID function, 20.4.4
grouping
compatibility check, 18.3.3.3
conditions, 18.5.6
GROUPING function, 20.4
when to use, 20.4.2
GROUPING_ID function, 20.4.3
GROUPING_SETS expression, 20.5
groups, instance, 24.4.3.6
GT GlossaryTitle, Glossary
GV$FILESTAT view, 24.6.7

H

hash partitioning, 5.3.1.1.2
HASH_AREA_SIZE initialization parameter
and parallel execution, 24.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
FIRST_ROWS(n), 24.8.13
PARALLEL, 24.4.3.1
PARALLEL_INDEX, 24.4.3.1
query rewrite, 18.2, 18.2.3.1
histograms
creating with user-defined buckets, 21.14.1
HotLog change sets, 16.3
HOTLOG_SOURCE change sources, 16.2.2.1
change sets and, 16.3
hypothetical rank, 21.8

I

importing
a change table, 16.10.3, 16.10.3
asynchronous change sets, 16.10.3
asynchronous change tables, 16.10.3
data into a source table, 16.10.3
indexes
bitmap indexes, 6.1.4
bitmap join, 6.1.5
B-tree, 6.2
cardinality, 6.1.2
creating in parallel, 24.8.9
global, 24.8.8.3
global partitioned indexes, 5.3.7.2
managing partitions, 5.3.7.2.2
local, 24.8.8.3
local indexes, 5.3.7.1
nulls and, 6.1.3
parallel creation, 24.8.9, 24.8.9, 24.8.9
parallel DDL storage, 24.3.2.6
parallel local, 24.8.9
partitioned tables, 6.1.4
partitioning, 5.3.1.2
partitioning guidelines, 5.3.7.6
partitions, 5.3.7
index-organized tables
parallel CREATE, 24.1.3, 24.3.2.1
parallel queries, 24.3.1.1
initcdc.sql script, 16.11
initialization parameters
DB_BLOCK_SIZE, 24.5.3.2
DB_FILE_MULTIBLOCK_READ_COUNT, 24.5.3.3
DISK_ASYNCH_IO, 24.5.3.4
DML_LOCKS, 24.5.2.3.4
ENQUEUE_RESOURCES, 24.5.2.3.4
FAST_START_PARALLEL_ROLLBACK, 24.5.2.3.2
HASH_AREA_SIZE, 24.5.2.1.1
JOB_QUEUE_PROCESSES, 15.3.9
LARGE_POOL_SIZE, 24.5.1.5
LOG_BUFFER, 24.5.2.3.3
NLS_LANGUAGE, 5.3.6.1
NLS_SORT, 5.3.6.1
OPTIMIZER_MODE, 15.3.11, 18.2.1
PARALLEL_ADAPTIVE_MULTI_USER, 24.4.7
PARALLEL_EXECUTION_MESSAGE_SIZE, 24.5.2.1, 24.5.2.2
PARALLEL_MAX_SERVERS, 15.3.11, 24.2.2.1, 24.5.1.1.1
PARALLEL_MIN_PERCENT, 24.4.3.5, 24.5.1.1, 24.5.1.8
PARALLEL_MIN_SERVERS, 24.2.2, 24.2.2.1, 24.5.1.4
PGA_AGGREGATE_TARGET, 15.3.11
QUERY_REWRITE_ENABLED, 18.2, 18.2.1
QUERY_REWRITE_INTEGRITY, 18.2.1
SHARED_POOL_SIZE, 24.5.1.5, 24.5.1.5
STAR_TRANSFORMATION_ENABLED, 19.4.1
TAPE_ASYNCH_IO, 24.5.3.4
TIMED_STATISTICS, 24.6.7.6
TRANSACTIONS, 24.5.2.3.1
INSERT statement
functionality, 24.8.10.1
parallelizing INSERT ... SELECT, 24.4.5.3
instance groups for parallel operations, 24.4.3.6
instances
instance groups, 24.4.3.6
integrity constraints, 7.1
integrity rules
parallel DML restrictions, 24.3.3.10
invalidating
materialized views, 9.4
I/O
asynchronous, 24.5.3.4
parallel execution, 5.1.1, 24.1

J

Java
used by Change Data Capture, 16.11
JOB_QUEUE_PROCESSES initialization parameter, 15.3.9
join compatibility, 18.3.3.1
joins
full partition-wise, 5.3.4.1
partial partition-wise, 5.3.4.2
partition-wise, 5.3.4
star joins, 19.3
star queries, 19.3

K

key lookups, 14.4.1
keys, 8.1.6, 19.3

L

LAG/LEAD functions, 21.5
LARGE_POOL_SIZE initialization parameter, 24.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
linear regression functions, 21.9
list partitioning, 5.3.1.1.3
LOB datatypes
restrictions
parallel DDL, 24.1.3, 24.3.2.1
parallel DML, 24.3.3.9, 24.3.3.9
local indexes, 5.3.7.1, 5.3.7.3, 6.1.1, 6.1.4, 24.8.8.3
equipartitioning, 5.3.7.1
locks
parallel DML, 24.3.3.8
LOG_BUFFER initialization parameter
and parallel execution, 24.5.2.3.3
LOGGING clause, 24.8.8.8
logging mode
parallel DDL, 24.1.3, 24.3.2.1, 24.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, 24.7, 24.7.2
massively parallel systems, 5.1.1, 24.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.3.3.1.3
dropping, 8.4, 8.6
invalidating, 9.4
logs, 12.2.3.3
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, 18.2, 18.2.3.1
matching join graphs, 8.3.6
parameters, 18.2.1
privileges, 18.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, 18.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
tuning, 17.3
types of, 8.2
uses for, 8.1
with VPD, 9.5.1
MAXVALUE
partitioned tables and indexes, 5.3.6.2
measures, 8.1.6, 19.3
memory
configure at 2 levels, 24.5.2
MERGE statement, 15.2.1
Change Data Capture restriction, 16.11.1
MINIMUM EXTENT parameter, 24.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, 24.6.7
refresh, 15.3.12
mortgage calculation, 22.5
MOVE PARTITION statement
rules of parallelism, 24.4.5.5.2
multiple archiver processes, 24.8.8.6, 24.8.8.6
multiple hierarchies, 10.2.2
MV_CAPABILITIES_TABLE table, 8.7.1.2

N

National Language Support (NLS)
DATE datatype and partitions, 5.3.6.4
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.3.6.1
NLS_LANGUAGE parameter, 5.3.6.1
NLS_SORT parameter
no effect on partitioning keys, 5.3.6.1
NOAPPEND hint, 24.8.10.2
NOARCHIVELOG mode, 24.8.8.8
nodes
disk affinity in Real Application Clusters, 24.7
NOLOGGING clause, 24.8.4, 24.8.8.8, 24.8.9
with APPEND hint, 24.8.10.2
NOLOGGING mode
parallel DDL, 24.1.3, 24.3.2.1, 24.3.2.3
nonprefixed indexes, 5.3.7.1.2, 5.3.7.4
global partitioned indexes, 5.3.7.2.1
nonvolatile data, 1.1.3
NOPARALLEL attribute, 24.8.2
NOREWRITE hint, 18.2, 18.2.3.1
NTILE function, 21.2.5
nulls
indexes and, 6.1.3
partitioned tables and indexes, 5.3.6.3

O

object types
parallel query, 24.3.1.4
restrictions, 24.3.1.4
restrictions
parallel DDL, 24.1.3, 24.3.2.1
parallel DML, 24.3.3.9, 24.3.3.9
OLAP, 23.1
materialized views, 9.2
OLAP cubes
materialized views, 9.2.1
OLTP database
batch jobs, 24.3.3.2.5
parallel DML, 24.3.3.2
partitioning indexes, 5.3.7.6
ON COMMIT clause, 8.3.7
ON DEMAND clause, 8.3.7
OPERATION$
control column, 16.10.2.2
optimization
partition pruning
indexes, 5.3.7.5
partitioned indexes, 5.3.7.5
optimizations
parallel SQL, 24.2.4
query rewrite
enabling, 18.2
hints, 18.2, 18.2.3.1
matching join graphs, 8.3.6
query rewrites
privileges, 18.2.4
optimizer
with rewrite, 18.1
OPTIMIZER_MODE initialization parameter, 15.3.11, 18.2.1
ORA-31424 error, 16.10.2.6
ORA-31496 error, 16.10.2.6
Oracle Data Pump
using with Change Data Capture, 16.10.3
Oracle Real Application Clusters
disk affinity, 24.7
instance groups, 24.4.3.6
ORDER BY clause, 8.3.8
outer joins
with query rewrite, 18.5.3

P

packages
DBMS_ADVISOR, 17.1
paragraph tags
GT GlossaryTitle, Glossary
PARALLEL clause, 24.8.10.1, 24.8.10.3
parallelization rules, 24.4.5
PARALLEL CREATE INDEX statement, 24.5.2.3
PARALLEL CREATE TABLE AS SELECT statement
resources required, 24.5.2.3
parallel DDL, 24.3.2
extent allocation, 24.3.2.6
parallelization rules, 24.4.5
partitioned tables and indexes, 24.3.2.1
restrictions
LOBs, 24.1.3, 24.3.2.1
object types, 24.1.3, 24.3.1.4, 24.3.2.1
parallel delete, 24.4.5.2
parallel DELETE statement, 24.4.5.2
parallel DML, 24.3.3
applications, 24.3.3.2
bitmap indexes, 6.1.1
degree of parallelism, 24.4.5, 24.4.5.2.2
enabling PARALLEL DML, 24.3.3.3
lock and enqueue resources, 24.3.3.8
parallelization rules, 24.4.5
recovery, 24.3.3.6
restrictions, 24.3.3.9
object types, 24.3.1.4, 24.3.3.9, 24.3.3.9, 24.3.3.9, 24.3.3.9
remote transactions, 24.3.3.12
transaction model, 24.3.3.4
parallel execution
full table scans, 24.1.2
index creation, 24.8.9
interoperator parallelism, 24.2.4.3
intraoperator parallelism, 24.2.4.3
introduction, 5.1.1
I/O parameters, 24.5.3
plans, 24.6.4
query optimization, 24.8.12
resource parameters, 24.5.2
rewriting SQL, 24.8.3
solving problems, 24.8.2
tuning, 5.1, 24.1
PARALLEL hint, 24.4.3.1, 24.8.2, 24.8.10.1
parallelization rules, 24.4.5
UPDATE and DELETE, 24.4.5.2
parallel partition-wise joins
performance considerations, 5.3.4.4
parallel query, 24.3.1
bitmap indexes, 6.1.1
index-organized tables, 24.3.1.1
object types, 24.3.1.4
restrictions, 24.3.1.4
parallelization rules, 24.4.5
parallel SQL
allocating rows to parallel execution servers, 24.2.4.1
degree of parallelism, 24.4.3
instance groups, 24.4.3.6
number of parallel execution servers, 24.2.2
optimizer, 24.2.4
parallelization rules, 24.4.5
shared server, 24.2.2
parallel update, 24.4.5.2
parallel UPDATE statement, 24.4.5.2
PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 24.4.7
PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 24.5.2.1, 24.5.2.2
PARALLEL_INDEX hint, 24.4.3.1
PARALLEL_MAX_SERVERS initialization parameter, 15.3.11, 24.2.2.1, 24.5.1.1.1
and parallel execution, 24.5.1.1
PARALLEL_MIN_PERCENT initialization parameter, 24.4.3.5, 24.5.1.1, 24.5.1.8
PARALLEL_MIN_SERVERS initialization parameter, 24.2.2, 24.2.2.1, 24.5.1.4
PARALLEL_THREADS_PER_CPU initialization parameter, 24.4.9
parallelism, 5.1
degree, 24.2.1, 24.4.2
degree, overriding, 24.8.2
enabling for tables and queries, 24.4.6
interoperator, 24.2.4.3
intraoperator, 24.2.4.3
parameters
FREELISTS, 24.8.8.5
partition
default, 5.3.1.1.3
granules, 5.2.2
Partition Change Tracking (PCT), 9.1.1, 15.4.1, 18.3.5
with Pmarkers, 18.3.5.2
partitioned outer join, 21.15
partitioned tables
data warehouses, 5.3.1.3.1
materialized views, 15.4
partitioning, 12.2.3.2
composite, 5.3.1.1.4, 5.3.1.1.4
data, 5.3.1
data segment compression, 5.3.2
bitmap indexes, 5.3.2.1
hash, 5.3.1.1.2
indexes, 5.3.1.2
list, 5.3.1.1.3
materialized views, 9.1
prebuilt tables, 9.1.3
range, 5.3.1.1.1, 5.3.1.1.1
range-list, 5.3.1.3.6
partitions
affinity, 24.7
bitmap indexes, 6.1.4
DATE datatype, 5.3.6.4
equipartitioning
examples, 5.3.7.1.1
local indexes, 5.3.7.1
global indexes, 5.3.7.2
local indexes, 5.3.7.1
multicolumn keys, 5.3.6.5
nonprefixed indexes, 5.3.7.1.2, 5.3.7.4
parallel DDL, 24.3.2.1
partition bounds, 5.3.6
partition pruning
DATE datatype, 5.3.6.4
disk striping and, 24.7.1
indexes, 5.3.7.5
partitioning indexes, 5.3.7, 5.3.7.6
partitioning keys, 5.3.5, 5.3.5
physical attributes, 5.3.7.7
prefixed indexes, 5.3.7.1.1
pruning, 5.3.3
range partitioning
disk striping and, 24.7.1
restrictions
datatypes, 5.3.6.4
rules of parallelism, 24.4.5.5.2
partition-wise joins, 5.3.4
benefits of, 5.3.4.3
full, 5.3.4.1
partial, 5.3.4.2
PERCENT_RANK function, 21.2.4
performance
DSS database, 24.3.3.2
prefixed and nonprefixed indexes, 5.3.7.5
PGA_AGGREGATE_TARGET initialization parameter, 15.3.11
physical design, 3.1
structures, 3.2.1
pivoting, 14.4.3, 14.4.3
plans
star transformations, 19.4.2.2
PL/SQL procedures
DBMS_CDC_PUBLISH_DROP_CHANGE_TABLE, 16.10.2.6
DBMS_CDC_PUBLISH.PURGE, 16.10.2.5, 16.10.2.5
DBMS_CDC_PUBLISH.PURGE_CHANGE_SET, 16.10.2.5
DBMS_CDC_PUBLISH.PURGE_CHANGE_TABLE, 16.10.2.5
DBMS_CDC_SUBSCRIBE.PURGE_WINDOW, 16.10.2.5
DBMS_JOB, 16.10.2.5
Pmarkers
with PCT, 18.3.5.2
prebuilt materialized views, 8.3
predicates
partition pruning
indexes, 5.3.7.5
prefixed indexes, 5.3.7.1.1, 5.3.7.3
PRIMARY KEY constraints, 24.8.9
privileges
SQLAccess Advisor, 17.2.2
privileges required
to publish change data, 16.6.1.1
procedures
EXPLAIN_MVIEW, 17.3
TUNE_MVIEW, 17.3
process monitor process (PMON)
parallel DML process recovery, 24.3.3.6.2
processes
and memory contention in parallel processing, 24.5.1.1.1
pruning
partitions, 5.3.3, 24.7.1
using DATE columns, 5.3.3.1
pruning partitions
DATE datatype, 5.3.6.4
EXPLAIN PLAN, 5.3.6.4
indexes, 5.3.7.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.10.2.1
tasks, 16.1.3.1
publishing
asynchronous AutoLog mode
step-by-step example, 16.7.3
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.10.2.5
by name, 16.10.2.5
in a named changed set, 16.10.2.5
on the staging database, 16.10.2.5
publishers, 16.10.2.5
subscribers, 16.10.2.5
purging data, 15.2.3

Q

queries
ad hoc, 24.3.2.2
enabling parallelism for, 24.4.6
star queries, 19.3
query delta joins, 18.3.3.1.2
query optimization, 24.8.12
parallel execution, 24.8.12
query rewrite
advanced, 18.6
checks made by, 18.3.3
controlling, 18.2.2
correctness, 18.2.3
date folding, 18.3.4.9
enabling, 18.2, 18.2
hints, 18.2, 18.2.3.1
matching join graphs, 8.3.6
methods, 18.3
parameters, 18.2.1
privileges, 18.2.4
restrictions, 8.3.6.2
using equivalences, 18.6
using GROUP BY extensions, 18.3.4.3
using nested materialezed views, 18.3.4.2
using PCT, 18.3.5
VPD, 9.5.1.1
when it occurs, 18.1.2
with bind variables, 18.3.6
with DBMS_MVIEW package, 18.4.2
with expression matching, 18.3.4.8
with inline views, 18.3.4.5
with partially stale materialized views, 18.3.4.1
with selfjoins, 18.3.4.6
with set operator materialized views, 18.3.7
with view constraints, 18.3.4.7
QUERY_REWRITE_ENABLED initialization parameter, 18.2, 18.2.1
QUERY_REWRITE_INTEGRITY initialization parameter, 18.2.1

R

range partitioning, 5.3.1.1.1, 5.3.1.1.1
key comparison, 5.3.6.1, 5.3.6.5
partition bounds, 5.3.6
performance considerations, 5.3.1.3.1
range-list partitioning, 5.3.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, 24.4.5.5.1
REBUILD INDEX statement
rules of parallelism, 24.4.5.5.1
recovery
from asychronous change set capture errors, 16.10.1.4
parallel DML, 24.3.3.6
redo buffer allocation retries, 24.5.2.3.3
redo log files
archived
asynchronous Change Data Capture and, 16.9.1
determining which are no longer needed by Change Data Capture, 16.9.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, 24.6.1
RELY constraints, 7.3.3
remote transactions
parallel DML and DDL restrictio, 24.1.3
removing
Change Data Capture from source database, 16.11
replication
restrictions
parallel DML, 24.3.3.9
reporting functions, 21.4
RESOURCE role, 16.6.1.1
resources
consumption, parameters affecting, 24.5.2, 24.5.2.3
limiting for users, 24.5.1.3
limits, 24.5.1.1
parallel query usage, 24.5.2
restrictions
direct-path INSERT, 24.3.3.9
fast refresh, 8.3.7.1
nested materialized views, 8.2.3.4
parallel DDL, 24.1.3, 24.3.2.1
parallel DML, 24.3.3.9
remote transactions, 24.3.3.12
partitions
datatypes, 5.3.6.4
query rewrite, 8.3.6.2
result set, 19.4.2
REWRITE hint, 18.2, 18.2.3.1
rewrites
hints, 18.2.3.1
parameters, 18.2.1
privileges, 18.2.4
query optimizations
hints, 18.2, 18.2.3.1
matching join graphs, 8.3.6
rmcdc.sql script, 16.11
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.10.2.2
ROW_NUMBER function, 21.2.6
RSID$
control column, 16.10.2.2
rules
in MODEL clause, 22.2.5
in SQL modeling, 22.2.5
order of evaluation, 22.2.6

S

sar UNIX command, 24.6.10
scalability
batch jobs, 24.3.3.2.5
parallel DML, 24.3.3.2
scalable operations, 24.8.6
scans
full table
parallel query, 24.1.2
schema-level export operations, 16.10.3
schema-level import operations, 16.10.3
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.11
rmcdc.sql for Change Data Capture, 16.11
SELECT_CATALOG_ROLE privilege, 16.5, 16.6.1.1
sessions
enabling parallel DML, 24.3.3.3
set operators
materialized views, 9.2.4
shared server
parallel SQL execution, 24.2.2
SHARED_POOL_SIZE initialization parameter, 24.5.1.5
SHARED_POOL_SIZE parameter, 24.5.1.5
simultaneous equations, 22.5
single table aggregate requirements, 8.2.1.1
skewing parallel DML workload, 24.4.4
SMP architecture
disk affinity, 24.7.2
snowflake schemas, 19.3.1
complex queries, 19.3.1
SORT_AREA_SIZE initialization parameter
and parallel execution, 24.5.2.1.2
source database
defined, 16.1.3.1
source systems, 12.1
source tables
importing for Change Data Capture, 16.10.3
referenced by change tables, 16.10.2.1
SOURCE_COLMAP$
control column, 16.10.2.2
interpreting, 16.10.2.3
space management
MINIMUM EXTENT parameter, 24.3.2.6
parallel DDL, 24.3.2.4
sparse data
data densification, 21.15.2
SPLIT PARTITION clause
rules of parallelism, 24.4.5.5.2
SQL GRANT statement, 16.10.2.4
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.6
SQL REVOKE statement, 16.10.2.4
SQL statements
parallelizing, 24.1.3, 24.2.4
SQL Workload Journal, 17.2.10
SQL*Loader, 24.1.3
SQLAccess Advisor, 17.1, 17.1, 17.2.4
constants, 17.2.27
creating a task, 17.1.1
defining the workload, 17.1.1
EXECUTE_TASK procedure, 17.2.17.1
generating the recommendations, 17.1.1
implementing the recommendations, 17.1.1
maintaining workloads, 17.2.14
privileges, 17.2.2
quick tune, 17.2.25
recommendation process, 17.2.20
steps in using, 17.1.1
workload objects, 17.2.6
SQLAccess Advisor workloads
maintaining, 17.2.14
staging
areas, 1.2.2
databases, 8.1
files, 8.1
staging database
defined, 16.1.3.1
STALE_TOLERATED mode, 18.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.5.9
estimating, 24.6.4
operating system, 24.6.10
storage
fragmentation in parallel DDL, 24.3.2.6
index partitions, 5.3.7.7
STORAGE clause
parallel execution, 24.3.2.5
Streams apply parallelism value
determining, 16.6.3.6
Streams apply process
asynchronous Change Data Capture and, 16.6.3.6
Streams capture parallelism value
determining, 16.6.3.6
Streams capture process
asynchronous Change Data Capture and, 16.6.3.6
striping, 4.1.2
subpartition
mapping, 5.3.1.3.5
template, 5.3.1.3.5
subqueries
in DDL statements, 24.3.2.2
subscriber view
defined, 16.1.3.2
returning DML changes in order, 16.10.2.2, 16.10.2.2
subscribers
access to change tables, 16.10.2.4
ALL_PUBLISHED_COLUMNS view, 16.10.4
components associated with, 16.1.3.2
controlling access to tables, 16.10.2.4
defined, 16.1.3
DML access, 16.10.2.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.10.4
defined, 16.1.3.2
effect of SQL DROP USER CASCADE statement on, 16.10.2.6
summary management
components, 8.1.5
summary tables, 2.4.1
supplemental logging
asynchronous Change Data Capture, 16.9.2
asynchronous Change Data Capture and, 16.2.2
symmetric multiprocessors, 5.1.1, 24.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
defined, 16.3
disabling, 16.10.1.2
enabling, 16.10.1.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 performace impact, 16.6.2
SYS_NC_OID$
control column, 16.10.2.2
system monitor process (SMON)
parallel DML system recovery, 24.3.3.6.3

T

table differencing, 16.1.1
table partitioning
publisher and, 16.10.2.1
table queues, 24.6.7.9
tables
detail tables, 8.1.6
dimension tables (lookup tables), 8.1.6
dimensions
star queries, 19.3
enabling parallelism for, 24.4.6
external, 14.2.2
fact tables, 8.1.6
star queries, 19.3
historical, 24.3.3.2.4
lookup, 19.3
parallel creation, 24.3.2.2
parallel DDL storage, 24.3.2.6
refreshing in data warehouse, 24.3.3.2.1
STORAGE clause with parallel execution, 24.3.2.5
summary or rol, 24.3.2.2
tablespace
specifying default for Change Data Capture publisher, 16.6.1.2
tablespaces
change tables and, 16.10.2.1
transportable, 12.2.2.2, 13.2.3, 13.2.3.2
TAPE_ASYNCH_IO initialization parameter, 24.5.3.4, 24.5.3.4
TARGET_COLMAP$
control column, 16.10.2.2
interpreting, 16.10.2.3
templates
SQLAccess Advisor, 17.2.4
temporary segments
parallel DDL, 24.3.2.6
text match, 18.3.1
with query rewrite, 18.5.4
third normal form
queries, 19.2.1
schemas, 19.2
time series calculations, 21.16
TIMED_STATISTICS initialization parameter, 24.6.7.6
TIMESTAMP$
control column, 16.10.2.2
timestamps, 12.2.3.1
TO_DATE function
partitions, 5.3.6.4
transactions
distributed
parallel DDL restrictions, 24.1.3
parallel DML restrictions, 24.1.3, 24.3.3.12
TRANSACTIONS initialization parameter, 24.5.2.3.1
transformations, 14.1
scenarios, 14.4
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.11
restrictions, 24.3.3.11
parallel DML, 24.3.3.9
TRUSTED mode, 18.2.3
TUNE_MVIEW procedure, 17.3
two-phase commit, 24.5.2.3.1

U

ultralarge files, 3.2.2
unique
constraints, 7.3.1, 24.8.9
identifier, 2.2, 3.2
UNLIMITED TABLESPACE privilege, 16.6.1.2
update frequencies, 8.1.9
UPDATE statement
parallel UPDATE statement, 24.4.5.2
update windows, 8.1.9
user resources
limiting, 24.5.1.3
USERNAME$
control column, 16.10.2.2

V

V$FILESTAT view
and parallel query, 24.6.7.7
V$PARAMETER view, 24.6.7.8
V$PQ_SESSTAT view, 24.6.5, 24.6.7.6
V$PQ_SYSSTAT view, 24.6.5
V$PQ_TQSTAT view, 24.6.6, 24.6.7.9
V$PX_PROCESS view, 24.6.7.4, 24.6.7.5
V$PX_SESSION view, 24.6.7.2
V$PX_SESSTAT view, 24.6.7.3
V$SESSTAT view, 24.6.7.10, 24.6.10
V$SYSSTAT view, 24.5.2.3.3, 24.6.7.10, 24.8.8.7
validating dimensions, 10.5
VALUES LESS THAN clause, 5.3.6
MAXVALUE, 5.3.6.2
view constraints, 7.3.6, 18.3.4.7
views
DBA_DATA_FILES, 24.6.7.7
DBA_EXTENTS, 24.6.7.7
V$FILESTAT, 24.6.7.7
V$PARAMETER, 24.6.7.8
V$PQ_SESSTAT, 24.6.7.6
V$PQ_TQSTAT, 24.6.7.9
V$PX_PROCESS, 24.6.7.5
V$SESSTAT, 24.6.7.10, 24.6.10
V$SYSSTAT, 24.6.7.10
vmstat UNIX command, 24.6.10
VPD
and materialized views, 9.5.1
restrictions with materialized views, 9.5.1.2

W

WIDTH_BUCKET function, 21.12, 21.12.1
windowing functions, 21.3
workload objects, 17.2.6
workloads
deleting, 17.2.9
distribution, 24.6.6
skewing, 24.4.4

X

XIDSEQ$
control column, 16.10.2.2
XIDSLT$
control column, 16.10.2.2
XIDUSN$
control column, 16.10.2.2