Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

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

Go to previous page
View PDF

Index

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


A

ACTIVE_INSTANCE_COUNT initialization parameter, 1-15
ALL_ALL_TABLES view, 2-6
ALL_APPLY view, 2-8
ALL_APPLY_CONFLICT_COLUMNS view, 2-9
ALL_APPLY_DML_HANDLERS view, 2-10
ALL_APPLY_ERROR view, 2-10
ALL_APPLY_KEY_COLUMNS view, 2-11
ALL_APPLY_PARAMETERS view, 2-12
ALL_APPLY_PROGRESS view, 2-12
ALL_ARGUMENTS view, 2-13
ALL_ASSOCIATIONS view, 2-14
ALL_AUDIT_POLICIES view, 2-15
ALL_BASE_TABLE_MVIEWS view, 2-16
ALL_CAPTURE view, 2-17
ALL_CAPTURE_PARAMETERS view, 2-18
ALL_CAPTURE_PREPARED_DATABASE view, 2-18
ALL_CAPTURE_PREPARED_SCHEMAS view, 2-19
ALL_CAPTURE_PREPARED_TABLES view, 2-19
ALL_CATALOG view, 2-20
ALL_CLUSTER_HASH_EXPRESSIONS view, 2-20
ALL_CLUSTERS view, 2-21
ALL_COL_COMMENTS view, 2-22
ALL_COL_PRIVS view, 2-22
ALL_COL_PRIVS_MADE view, 2-23
ALL_COL_PRIVS_RECD view, 2-24
ALL_COLL_TYPES view, 2-25
ALL_CONS_COLUMNS view, 2-25
ALL_CONS_OBJ_COLUMNS view, 2-26
ALL_CONSTRAINTS view, 2-27
ALL_CONTEXT view, 2-28
ALL_DB_LINKS view, 2-29
ALL_DEF_AUDIT_OPTS view, 2-29
ALL_DEPENDENCIES view, 2-30
ALL_DIM_ATTRIBUTES view, 2-31
ALL_DIM_CHILD_OF view, 2-32
ALL_DIM_HIERARCHIES view, 2-32
ALL_DIM_JOIN_KEY view, 2-33
ALL_DIM_LEVEL_KEY view, 2-33
ALL_DIM_LEVELS view, 2-34
ALL_DIMENSIONS view, 2-34
ALL_DIRECTORIES view, 2-35
ALL_ERRORS view, 2-35
ALL_EVALUATION_CONTEXT_TABLES view, 2-36
ALL_EVALUATION_CONTEXT_VARS view, 2-36
ALL_EVALUATION_CONTEXTS view, 2-37
ALL_EXTERNAL_LOCATIONS view, 2-38
ALL_EXTERNAL_TABLES view, 2-39
ALL_IND_COLUMNS view, 2-40
ALL_IND_EXPRESSIONS view, 2-41
ALL_IND_PARTITIONS view, 2-41
ALL_IND_SUBPARTITIONS view, 2-43
ALL_INDEXES view, 2-45
ALL_INDEXTYPE_COMMENTS view, 2-48
ALL_INDEXTYPE_OPERATORS view, 2-49
ALL_INDEXTYPES view, 2-50
ALL_INTERNAL_TRIGGERS view, 2-50
ALL_JAVA_ARGUMENTS view, 2-51
ALL_JAVA_CLASSES view, 2-52
ALL_JAVA_DERIVATIONS view, 2-53
ALL_JAVA_FIELDS view, 2-54
ALL_JAVA_IMPLEMENTS view, 2-55
ALL_JAVA_INNERS view, 2-56
ALL_JAVA_LAYOUTS view, 2-57
ALL_JAVA_METHODS view, 2-58
ALL_JAVA_NCOMPS view, 2-59
ALL_JAVA_RESOLVERS view, 2-60
ALL_JAVA_THROWS view, 2-61
ALL_JOBS view, 2-61
ALL_JOIN_IND_COLUMNS view, 2-63
ALL_LIBRARIES view, 2-63
ALL_LOB_PARTITIONS view, 2-64
ALL_LOB_SUBPARTITIONS view, 2-65
ALL_LOB_TEMPLATES view, 2-66
ALL_LOBS view, 2-67
ALL_LOG_GROUP_COLUMNS view, 2-68
ALL_LOG_GROUPS view, 2-69
ALL_METHOD_PARAMS view, 2-69
ALL_METHOD_RESULTS view, 2-70
ALL_MVIEW_AGGREGATES view, 2-71
ALL_MVIEW_ANALYSIS view, 2-72
ALL_MVIEW_DETAIL_RELATIONS view, 2-73
ALL_MVIEW_JOINS view, 2-74
ALL_MVIEW_KEYS view, 2-75
ALL_MVIEW_LOGS view, 2-76
ALL_MVIEW_REFRESH_TIMES view, 2-77
ALL_MVIEWS view, 2-77
ALL_NESTED_TABLES view, 2-82
ALL_OBJ_COLATTRS view, 2-82
ALL_OBJECT_TABLES view, 2-83
ALL_OBJECTS view, 2-85
ALL_OPANCILLARY view, 2-86
ALL_OPARGUMENTS view, 2-87
ALL_OPBINDINGS view, 2-87
ALL_OPERATOR_COMMENTS view, 2-88
ALL_OPERATORS view, 2-89
ALL_OUTLINE_HINTS view, 2-89
ALL_OUTLINES view, 2-90
ALL_PART_COL_STATISTICS view, 2-91
ALL_PART_HISTOGRAMS view, 2-92
ALL_PART_INDEXES view, 2-92
ALL_PART_KEY_COLUMNS view, 2-94
ALL_PART_LOBS view, 2-95
ALL_PART_TABLES view, 2-96
ALL_PARTIAL_DROP_TABS view, 2-98
ALL_PENDING_CONV_TABLES view, 2-98
ALL_POLICIES view, 2-99
ALL_POLICY_CONTEXTS view, 2-100
ALL_POLICY_GROUPS view, 2-101
ALL_PROCEDURES view, 2-101
ALL_PROPAGATION view, 2-102
ALL_PUBLISHED_COLUMNS view, 2-103
ALL_QUEUE_TABLES view, 2-103
ALL_QUEUES view, 2-105
ALL_REFRESH view, 2-105
ALL_REFRESH_CHILDREN view, 2-106
ALL_REFRESH_DEPENDENCIES view, 2-107
ALL_REFS view, 2-108
ALL_REGISTERED_MVIEWS view, 2-108
ALL_REGISTRY_BANNERS view, 2-109
ALL_REPAUDIT_ATTRIBUTE view, 2-2
ALL_REPAUDIT_COLUMN view, 2-2
ALL_REPCAT view, 2-2
ALL_REPCAT_REFRESH_TEMPLATES view, 2-2
ALL_REPCAT_TEMPLATE_OBJECTS view, 2-2
ALL_REPCAT_TEMPLATE_PARMS view, 2-2
ALL_REPCAT_TEMPLATE_SITES view, 2-2
ALL_REPCAT_USER_AUTHORIZATIONS view, 2-2
ALL_REPCAT_USER_PARM_VALUES view, 2-2
ALL_REPCATLOG view, 2-2
ALL_REPCOLUMN view, 2-2
ALL_REPCOLUMN_GROUP view, 2-2
ALL_REPCONFLICT view, 2-2
ALL_REPDDL view, 2-2
ALL_REPFLAVOR_COLUMNS view, 2-2
ALL_REPFLAVOR_OBJECTS view, 2-2
ALL_REPFLAVORS view, 2-2
ALL_REPGENERATED view, 2-2
ALL_REPGENOBJECTS view, 2-2
ALL_REPGROUP view, 2-2
ALL_REPGROUP_PRIVILEGES view, 2-2
ALL_REPGROUPED_COLUMN view, 2-2
ALL_REPKEY_COLUMNS view, 2-2
ALL_REPOBJECT view, 2-2
ALL_REPPARAMETER_COLUMN view, 2-2
ALL_REPPRIORITY view, 2-2
ALL_REPPRIORITY_GROUP view, 2-2
ALL_REPPROP view, 2-2
ALL_REPRESOL_STATS_CONTROL view, 2-2
ALL_REPRESOLUTION view, 2-2
ALL_REPRESOLUTION_METHOD view, 2-2
ALL_REPRESOLUTION_STATISTICS view, 2-2
ALL_REPSCHEMA view, 2-2
ALL_REPSITES view, 2-2
ALL_RULE_SET_RULES view, 2-110
ALL_RULE_SETS view, 2-110
ALL_RULES view, 2-111
ALL_SEQUENCES view, 2-112
ALL_SOURCE view, 2-112
ALL_SOURCE_TABLES view, 2-113
ALL_SQLJ_TYPE_ATTRS view, 2-113
ALL_SQLJ_TYPE_METHODS view, 2-114
ALL_SQLJ_TYPES view, 2-115
ALL_STORED_SETTINGS view, 2-116
ALL_STREAMS_GLOBAL_RULES view, 2-117
ALL_STREAMS_SCHEMA_RULES view, 2-118
ALL_STREAMS_TABLE_RULES view, 2-119
ALL_SUBPART_COL_STATISTICS view, 2-121
ALL_SUBPART_HISTOGRAMS view, 2-122
ALL_SUBPART_KEY_COLUMNS view, 2-123
ALL_SUBPARTITION_TEMPLATES view, 2-124
ALL_SUBSCRIBED_COLUMNS view, 2-124
ALL_SUBSCRIBED_TABLES view, 2-125
ALL_SUBSCRIPTIONS view, 2-125
ALL_SUMDELTA view, 2-126
ALL_SYNONYMS view, 2-126
ALL_TAB_COL_STATISTICS view, 2-127
ALL_TAB_COLUMNS view, 2-128
ALL_TAB_COMMENTS view, 2-130
ALL_TAB_HISTOGRAMS view, 2-130
ALL_TAB_MODIFICATIONS view, 2-131
ALL_TAB_PARTITIONS view, 2-132
ALL_TAB_PRIVS view, 2-133
ALL_TAB_PRIVS_MADE view, 2-134
ALL_TAB_PRIVS_RECD view, 2-135
ALL_TAB_SUBPARTITIONS view, 2-136
ALL_TABLES view, 2-137
ALL_TRIGGER_COLS view, 2-140
ALL_TRIGGERS view, 2-141
ALL_TYPE_ATTRS view, 2-142
ALL_TYPE_METHODS view, 2-143
ALL_TYPE_VERSIONS view, 2-144
ALL_TYPES view, 2-144
ALL_UNUSED_COL_TABS view, 2-145
ALL_UPDATABLE_COLUMNS view, 2-146
ALL_USERS view, 2-146
ALL_USTATS view, 2-147
ALL_VARRAYS view, 2-148
ALL_VERSION_HVIEW view, 2-3
ALL_VIEWS view, 2-148
ALL_WM_LOCKED_TABLES view, 2-3
ALL_WM_MODIFIED_TABLES view, 2-3
ALL_WM_RIC_INFO view, 2-3
ALL_WM_TAB_TRIGGERS view, 2-3
ALL_WM_VERSIONED_TABLES view, 2-3
ALL_WM_VT_ERRORS view, 2-3
ALL_WORKSPACE_PRIVS view, 2-3
ALL_WORKSPACE_SAVEPOINTS view, 2-3
ALL_WORKSPACES view, 2-3
ALL_XML_SCHEMAS view, 2-149
ALL_XML_TAB_COLS view, 2-150
ALL_XML_TABLES view, 2-151
ALL_XML_VIEW_COLS view, 2-151
ALL_XML_VIEWS view, 2-152
ALLOCATE EXTENT clause
of ALTER TABLE
instance number, 1-67
allocation
PCM locks, 1-60
ALTER DATABASE statement
ADD LOGFILE, 1-160
database name, 1-44
ENABLE THREAD, 1-160
THREAD, 1-160
ALTER SESSION statement
SET HASH_AREA_SIZE clause, 1-63
SET HASH_JOIN_ENABLED clause, 1-64
ALTER TABLE statement
allocating extents, 1-67
ANALYZE statement, 2-45, 2-128, 2-130, 2-137, 2-183, 2-226, 2-227, 2-289, 2-291
AQ_TM_PROCESSES initialization parameter, 1-15
ARCHIVE LOG START statement
automatic archiving, 1-75
ARCHIVE_LAG_TARGET initialization parameter, 1-16
archived redo logs
automatic versus manual, 1-83
destination file, 1-75
storage device, 1-75, 1-80
ARCHIVELOG mode, 1-75
archiving destination, 1-75, 1-80
automatic archiving, 1-83
AUDIT_ACTIONS table, 2-153
AUDIT_FILE_DEST initialization parameter, 1-17
AUDIT_SYS_OPERATIONS initialization parameter, 1-17
AUDIT_TRAIL initialization parameter, 1-17
authenticating remote clients, 1-140
authenticating users, 1-119

B

BACKGROUND_CORE_DUMP initialization parameter, 1-18
BACKGROUND_DUMP_DEST initialization parameter, 1-18
BACKUP_TAPE_IO_SLAVES initialization parameter, 1-19
BITMAP_MERGE_AREA_SIZE initialization parameter, 1-20
BLANK_TRIMMING initialization parameter, 1-21
blocks
PCM lock, 1-60
redo log, 1-86
size, 1-32, 1-36, 1-44, 4-2
BUFFER_POOL_KEEP initialization parameter, 1-21
BUFFER_POOL_RECYCLE initialization parameter, 1-22

C

cache
dictionary, 3-98, 3-123, 3-124, 3-126, 3-127
statistics, 1-86
CAT synonym for USER_CATALOG view, 2-153
CATALOG view, 2-153
CATALOG.SQL script, 5-2
creating V$ views, 3-1
CATAUDIT.SQL script
audit trail records created by, 2-264
audit trails for connections and disconnections, 2-264
auditing characteristics described by, 2-278
CATBLOCK.SQL script, 5-3
CATCLUST.SQL script, 5-2
CATEXP7.SQL script, 5-3
CATHS.SQL script, 5-3
CATIO.SQL script, 5-3
CATJAVA.SQL script, 5-8
CATNOADT.SQL script, 5-6
CATNOAUD.SQL script, 5-6
CATNOHS.SQL script, 5-6
CATNOPRT.SQL script, 5-6
CATNOQUE.SQL script, 5-6
CATNORMN.SQL script, 5-6
CATNOSVM.SQL script, 5-6
CATNSNMP.SQL script, 5-6
CATOCTK.SQL script, 5-3
CATPROC.SQL script, 5-2
CATQUEUE.SQL script, 5-3
CATREP.SQL script, 5-3
CATRMAN.SQL script, 5-3
CHAINED_ROWS table, 2-153
CHANGE_SETS view, 2-154
CHANGE_SOURCES view, 2-154
CHANGE_TABLES view, 2-155
characters
numeric group separators, 1-101
checkpoints
checkpoint interval, 1-86
statistics, 1-86
CIRCUITS initialization parameter, 1-24
CLU synonym for USER_CLUSTERS view, 2-155
CLUSTER_DATABASE initialization parameter, 1-24
CLUSTER_DATABASE_INSTANCES initialization parameter, 1-25
CLUSTER_INTERCONNECTS initialization parameter, 1-25
CMPDBMIG.SQL script, 5-7
CODE_PIECES view, 2-156
CODE_SIZE view, 2-156
COL view, 2-156
COLS synonym for USER_TAB_COLUMNS view, 2-156
COLUMN_PRIVILEGES view, 2-156
COMMIT_POINT_STRENGTH initialization parameter, 1-26
COMPATIBLE initialization parameter, 1-27
concurrency
ROW_LOCKING initialization parameter, 1-144
contention
block-level, 3-189
control files
names, 1-28
specifying, 1-28
CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 1-28
CONTROL_FILES initialization parameter, 1-28
CORE_DUMP_DEST initialization parameter, 1-29
cost-based optimization, 1-114
favoring IN-list iterators, 1-112
CPU_COUNT initialization parameter, 1-29
CREATE DATABASE statement
database name, 1-44
setting the log mode, 1-83
CREATE TABLE statement
FREELIST GROUPS clause, 1-67
CREATE_BITMAP_AREA_SIZE initialization parameter, 1-30
creating
a database
setting block size, 1-32, 1-36, 1-44
currency, 1-96
international currency symbol, 1-99
CURSOR_SHARING initialization parameter, 1-31
CURSOR_SPACE_FOR_TIME initialization parameter, 1-31
cursors
OPEN_CURSORS initialization parameter, 1-107
shared pool, 1-64, 1-149, 1-151

D

D0801070.SQL script, 5-7
D0900010.SQL script, 5-7
data blocks
reading multiple, 1-40
size of, 1-32, 1-36, 1-44
data dictionary, 2-1
cache, 3-98, 3-123, 3-124, 3-126, 3-127
datafiles, 1-60
scripts, 5-3
SQL scripts, 5-2
tables, 2-1
views, 1-60
overview, 2-1
user views, 2-1
database migration
scripts, 5-7
database writer process (DBWR)
checkpoint, 1-86
DATABASE_PROPERTIES view, 2-156
databases
block size, 4-2
database limits, 4-1
default language, 1-99
name, 1-44, 1-45
resource limits, 1-141, 1-142
valid characters for database name, 1-44
datafiles
mapping blocks to PCM locks, 1-60
maximum number, 1-43
parameter, 1-43
unspecified for PCM locks, 1-60
dates
language used for, 1-98, 1-103, 1-104
setting SYSDATE, 1-60
TO_CHAR function, 1-97
TO_DATE function, 1-97
DB_BLOCK_BUFFERS initialization parameter, 1-33
DB_BLOCK_CHECKING initialization parameter, 1-35
DB_BLOCK_CHECKSUM initialization parameter, 1-35
DB_BLOCK_SIZE initialization parameter, 1-36
DB_CACHE_ADVICE initialization parameter, 1-37
DB_CACHE_SIZE initialization parameter, 1-38
DB_CREATE_FILE_DEST initialization parameter, 1-38
DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 1-39
DB_DOMAIN initialization parameter, 1-39
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 1-40
DB_FILE_NAME_CONVERT initialization parameter, 1-41
DB_FILES initialization parameter, 1-43
DB_KEEP_CACHE_SIZE initialization parameter, 1-44
DB_NAME initialization parameter, 1-44
DB_nK_CACHE_SIZE initialization parameter, 1-32
DB_RECYCLE_CACHE_SIZE initialization parameter, 1-45
DB_WRITER_PROCESSES initialization parameter, 1-45
DBA_2PC_NEIGHBORS view, 2-157
DBA_2PC_PENDING view, 2-157
DBA_ALL_TABLES view, 2-158
DBA_APPLICATION_ROLES view, 2-158
DBA_APPLY view, 2-158
DBA_APPLY_CONFLICT_COLUMNS view, 2-159
DBA_APPLY_DML_HANDLERS view, 2-159
DBA_APPLY_ERROR view, 2-159
DBA_APPLY_INSTANTIATED_OBJECTS view, 2-159
DBA_APPLY_KEY_COLUMNS view, 2-160
DBA_APPLY_PARAMETERS view, 2-160
DBA_APPLY_PROGRESS view, 2-160
DBA_AQ_AGENT_PRIVS view, 2-160
DBA_AQ_AGENTS view, 2-161
DBA_ASSOCIATIONS view, 2-161
DBA_ATTRIBUTE_TRANSFORMATIONS view, 2-161
DBA_AUDIT_EXISTS view, 2-162
DBA_AUDIT_OBJECT view, 2-163
DBA_AUDIT_POLICIES view, 2-164
DBA_AUDIT_SESSION view, 2-164
DBA_AUDIT_STATEMENT view, 2-165
DBA_AUDIT_TRAIL view, 2-167
DBA_AW_PS view, 2-169
DBA_AWS view, 2-169
DBA_BASE_TABLE_MVIEWS view, 2-170
DBA_BLOCKERS view, 2-170
DBA_CAPTURE view, 2-170
DBA_CAPTURE_PARAMETERS view, 2-171
DBA_CAPTURE_PREPARED_DATABASE view, 2-171
DBA_CAPTURE_PREPARED_SCHEMAS view, 2-171
DBA_CAPTURE_PREPARED_TABLES view, 2-171
DBA_CATALOG view, 2-171
DBA_CLU_COLUMNS view, 2-172
DBA_CLUSTER_HASH_EXPRESSIONS view, 2-172
DBA_CLUSTERS view, 2-172
DBA_COL_COMMENTS view, 2-172
DBA_COL_PRIVS view, 2-172
DBA_COLL_TYPES view, 2-173
DBA_CONS_COLUMNS view, 2-173
DBA_CONS_OBJ_COLUMNS view, 2-173
DBA_CONSTRAINTS view, 2-174
DBA_CONTEXT view, 2-174
DBA_DATA_FILES view, 1-60, 2-174, 2-239
DBA_DB_LINKS view, 2-174
DBA_DDL_LOCKS view, 2-175
DBA_DEPENDENCIES view, 2-175
DBA_DIM_ATTRIBUTES view, 2-176
DBA_DIM_CHILD_OF view, 2-176
DBA_DIM_HIERARCHIES view, 2-176
DBA_DIM_JOIN_KEY view, 2-176
DBA_DIM_LEVEL_KEY view, 2-176
DBA_DIM_LEVELS view, 2-176
DBA_DIMENSIONS view, 2-177
DBA_DIRECTORIES view, 2-177
DBA_DML_LOCKS view, 2-177
DBA_DMT_FREE_SPACE view, 2-178
DBA_DMT_USED_EXTENTS view, 2-178
DBA_ERRORS view, 2-178
DBA_EVALUATION_CONTEXT_TABLES view, 2-178
DBA_EVALUATION_CONTEXT_VARS view, 2-179
DBA_EVALUATION_CONTEXTS view, 2-179
DBA_EXP_FILES view, 2-179
DBA_EXP_OBJECTS view, 2-179
DBA_EXP_VERSION view, 2-180
DBA_EXTENTS view, 2-180
DBA_EXTERNAL_LOCATIONS view, 2-181
DBA_EXTERNAL_TABLES view, 2-181
DBA_FGA_AUDIT_TRAIL view, 2-181
DBA_FREE_SPACE view, 2-182
DBA_FREE_SPACE_COALESCED view, 2-182
DBA_IND_COLUMNS view, 2-183
DBA_IND_EXPRESSIONS view, 2-183
DBA_IND_PARTITIONS view, 2-183
DBA_IND_SUBPARTITIONS view, 2-183
DBA_INDEXES view, 2-183
collecting statistics for, 2-183
DBA_INDEXTYPE_COMMENTS view, 2-183
DBA_INDEXTYPE_OPERATORS view, 2-184
DBA_INDEXTYPES view, 2-184
DBA_INTERNAL_TRIGGERS view, 2-184
DBA_JAVA_ARGUMENTS view, 2-184
DBA_JAVA_CLASSES view, 2-184
DBA_JAVA_DERIVATIONS view, 2-184
DBA_JAVA_FIELDS view, 2-185
DBA_JAVA_IMPLEMENTS view, 2-185
DBA_JAVA_INNERS view, 2-185
DBA_JAVA_LAYOUTS view, 2-185
DBA_JAVA_METHODS view, 2-185
DBA_JAVA_NCOMPS view, 2-185
DBA_JAVA_POLICY view, 2-186
DBA_JAVA_RESOLVERS view, 2-186
DBA_JAVA_THROWS view, 2-187
DBA_JOBS view, 2-187
DBA_JOBS_RUNNING view, 2-187
DBA_JOIN_IND_COLUMNS view, 2-187
DBA_KGLLOCK view, 2-188
DBA_LIBRARIES view, 2-188
DBA_LMT_FREE_SPACE view, 2-188
DBA_LMT_USED_EXTENTS view, 2-188
DBA_LOB_PARTITIONS view, 2-189
DBA_LOB_SUBPARTITIONS view, 2-189
DBA_LOB_TEMPLATES view, 2-189
DBA_LOBS view, 2-189
DBA_LOCK view, 2-189
DBA_LOCKS synonym, 2-190
DBA_LOCK_INTERNAL view, 2-190
DBA_LOCKS synonym for DBA_LOCK view, 2-190
DBA_LOG_GROUP_COLUMNS view, 2-191
DBA_LOG_GROUPS view, 2-191
DBA_LOGSTDBY_EVENTS view, 2-191
DBA_LOGSTDBY_LOG view, 2-191
DBA_LOGSTDBY_NOT_UNIQUE view, 2-192
DBA_LOGSTDBY_PARAMETERS view, 2-193
DBA_LOGSTDBY_PROGRESS view, 2-194
DBA_LOGSTDBY_SKIP view, 2-195
DBA_LOGSTDBY_SKIP_TRANSACTION view, 2-195
DBA_LOGSTDBY_UNSUPPORTED view, 2-196
DBA_METHOD_PARAMS view, 2-196
DBA_METHOD_RESULTS view, 2-196
DBA_MVIEW_AGGREGATES view, 2-196
DBA_MVIEW_ANALYSIS view, 2-197
DBA_MVIEW_DETAIL_RELATIONS view, 2-197
DBA_MVIEW_JOINS view, 2-197
DBA_MVIEW_KEYS view, 2-197
DBA_MVIEW_LOG_FILTER_COLS view, 2-197
DBA_MVIEW_LOGS view, 2-198
DBA_MVIEW_REFRESH_TIMES view, 2-198
DBA_MVIEWS view, 2-198
DBA_NESTED_TABLES view, 2-198
DBA_OBJ_AUDIT_OPTS view, 2-198
DBA_OBJ_COLATTRS view, 2-199
DBA_OBJECT_SIZE view, 2-200
DBA_OBJECT_TABLES view, 2-200
DBA_OBJECTS view, 2-200
DBA_OPANCILLARY view, 2-200
DBA_OPARGUMENTS view, 2-201
DBA_OPBINDINGS view, 2-201
DBA_OPERATOR_COMMENTS view, 2-201
DBA_OPERATORS view, 2-201
DBA_OUTLINE_HINTS view, 2-202
DBA_OUTLINES view, 2-202
DBA_PART_COL_STATISTICS view, 2-202
DBA_PART_HISTOGRAMS view, 2-202
DBA_PART_INDEXES view, 2-202
DBA_PART_KEY_COLUMNS view, 2-203
DBA_PART_LOBS view, 2-203
DBA_PART_TABLES view, 2-203
DBA_PARTIAL_DROP_TABS view, 2-203
DBA_PENDING_CONV_TABLES view, 2-203
DBA_PENDING_TRANSACTIONS view, 2-203
DBA_POLICIES view, 2-204
DBA_POLICY_CONTEXTS view, 2-204
DBA_POLICY_GROUPS view, 2-204
DBA_PRIV_AUDIT_OPTS view, 2-204
DBA_PROCEDURES view, 2-205
DBA_PROFILES view, 2-205
DBA_PROPAGATION view, 2-205
DBA_PROXIES view, 2-205
DBA_PUBLISHED_COLUMNS view, 2-206
DBA_QUEUE_SCHEDULES view, 2-207
DBA_QUEUE_TABLES view, 2-208
DBA_QUEUES view, 2-208
DBA_RCHILD view, 2-209
DBA_REFRESH view, 2-209
DBA_REFRESH_CHILDREN view, 2-209
DBA_REFS view, 2-209
DBA_REGISTERED_MVIEW_GROUPS view, 2-209
DBA_REGISTERED_MVIEWS view, 2-210
DBA_REGISTRY view, 2-210
DBA_REGISTRY_HIERARCHY view, 2-211
DBA_REPAIR_TABLE view, 2-212
DBA_REPAUDIT_ATTRIBUTE view, 2-2
DBA_REPAUDIT_COLUMN view, 2-2
DBA_REPCAT view, 2-2
DBA_REPCAT_EXCEPTIONS view, 2-2
DBA_REPCAT_REFRESH_TEMPLATES view, 2-2
DBA_REPCAT_TEMPLATE_OBJECTS view, 2-2
DBA_REPCAT_TEMPLATE_PARMS view, 2-2
DBA_REPCAT_TEMPLATE_SITES view, 2-2
DBA_REPCAT_USER_AUTHORIZATIONS view, 2-2
DBA_REPCAT_USER_PARM_VALUES view, 2-2
DBA_REPCATLOG view, 2-2
DBA_REPCOLUMN view, 2-2
DBA_REPCOLUMN_GROUP view, 2-2
DBA_REPCONFLICT view, 2-2
DBA_REPDDL view, 2-2
DBA_REPEXTENSIONS view, 2-2
DBA_REPFLAVOR_COLUMNS view, 2-2
DBA_REPFLAVOR_OBJECTS view, 2-2
DBA_REPFLAVORS view, 2-2
DBA_REPGENERATED view, 2-2
DBA_REPGENOBJECTS view, 2-2
DBA_REPGROUP view, 2-2
DBA_REPGROUP_PRIVILEGES view, 2-2
DBA_REPGROUPED_COLUMN view, 2-2
DBA_REPKEY_COLUMNS view, 2-2
DBA_REPOBJECT view, 2-2
DBA_REPPARAMETER_COLUMN view, 2-2
DBA_REPPRIORITY view, 2-2
DBA_REPPRIORITY_GROUP view, 2-2
DBA_REPPROP view, 2-2
DBA_REPRESOL_STATS_CONTROL view, 2-2
DBA_REPRESOLUTION view, 2-2
DBA_REPRESOLUTION_METHOD view, 2-2
DBA_REPRESOLUTION_STATISTICS view, 2-2
DBA_REPSCHEMA view, 2-2
DBA_REPSITES view, 2-2
DBA_REPSITES_NEW view, 2-2
DBA_RESUMABLE view, 2-213
DBA_RGROUP view, 2-214
DBA_ROLE_PRIVS view, 2-215
DBA_ROLES view, 2-215
DBA_ROLLBACK_SEGS view, 2-215
DBA_RSRC_CONSUMER_GROUP_PRIVS view, 2-216
DBA_RSRC_CONSUMER_GROUPS view, 2-217
DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 2-217
DBA_RSRC_PLAN_DIRECTIVES view, 2-218
DBA_RSRC_PLANS view, 2-219
DBA_RULE_SET_RULES view, 2-220
DBA_RULE_SETS view, 2-220
DBA_RULES view, 2-220
DBA_SEGMENTS view, 2-220
DBA_SEQUENCES view, 2-221
DBA_SOURCE view, 2-222
DBA_SOURCE_TABLES view, 2-222
DBA_SQLJ_TYPE_ATTRS view, 2-222
DBA_SQLJ_TYPE_METHODS view, 2-222
DBA_SQLJ_TYPES view, 2-222
DBA_STMT_AUDIT_OPTS view, 2-222
DBA_STORED_SETTINGS view, 2-223
DBA_STREAMS_GLOBAL_RULES view, 2-223
DBA_STREAMS_SCHEMA_RULES view, 2-223
DBA_STREAMS_TABLE_RULES view, 2-224
DBA_SUBPART_COL_STATISTICS view, 2-224
DBA_SUBPART_HISTOGRAMS view, 2-224
DBA_SUBPART_KEY_COLUMNS view, 2-224
DBA_SUBPARTITION_TEMPLATES view, 2-224
DBA_SUBSCRIBED_COLUMNS view, 2-224
DBA_SUBSCRIBED_TABLES view, 2-225
DBA_SUBSCRIPTIONS view, 2-225
DBA_SYNONYMS view, 2-225
DBA_SYS_PRIVS view, 2-225
DBA_TAB_COL_STATISTICS view, 2-226
DBA_TAB_COLUMNS view, 2-226
DBA_TAB_COMMENTS view, 2-226
DBA_TAB_HISTOGRAMS view, 2-226
DBA_TAB_MODIFICATIONS view, 2-226
DBA_TAB_PARTITIONS view, 2-226
DBA_TAB_PRIVS view, 2-227
DBA_TAB_SUBPARTITIONS view, 2-227
DBA_TABLES view, 2-227
DBA_TABLESPACES view, 2-228
DBA_TEMP_FILES view, 2-229
DBA_TRANSFORMATIONS view, 2-230
DBA_TRIGGER_COLS view, 2-230
DBA_TRIGGERS view, 2-230
DBA_TS_QUOTAS view, 2-230
DBA_TYPE_ATTRS view, 2-231
DBA_TYPE_METHODS view, 2-231
DBA_TYPE_VERSIONS view, 2-231
DBA_TYPES view, 2-231
DBA_UNDO_EXTENTS view, 2-232
DBA_UNUSED_COL_TABS view, 2-232
DBA_UPDATABLE_COLUMNS view, 2-232
DBA_USERS view, 2-233
DBA_USTATS view, 2-234
DBA_VARRAYS view, 2-234
DBA_VIEWS view, 2-234
DBA_WAITERS view, 2-234
DBA_WORKSPACE_SESSIONS view, 2-3
DBA_XML_SCHEMAS view, 2-234
DBA_XML_TAB_COLS view, 2-235
DBA_XML_TABLES view, 2-235
DBA_XML_VIEW_COLS view, 2-235
DBA_XML_VIEWS view, 2-235
DBLINK_ENCRYPT_LOGIN initialization parameter, 1-46
DBMS_ALERT_INFO view, 2-235
DBMS_LOCK_ALLOCATED view, 2-236
DBMSIOTC.SQL script, 5-3
DBMSOTRC.SQL script, 5-3
DBMSPOOL.SQL script, 5-4
DBWR_IO_SLAVES initialization parameter, 1-46
DEFCALL view, 2-2
DEFCALLDEST view, 2-2
DEFDEFAULTDEST view, 2-2
DEFERRCOUNT view, 2-2
DEFERROR view, 2-2
DEFLOB view, 2-2
DEFPROPAGATOR view, 2-2
DEFSCHEDULE view, 2-2
DEFTRAN view, 2-2
DEFTRANDEST view, 2-2
DEPTREE view, 2-236
destination
archiving redo log files, 1-75
overriding default, 1-75
USER_DUMP_DEST, 1-169
DG_BROKER_CONFIG_FILEn initialization parameter, 1-47
DG_BROKER_START initialization parameter, 1-48
DICT synonym for DICTIONARY, 2-236
DICT_COLUMNS view, 2-236
DICTIONARY view, 2-237
DICT synonym, 2-236
disk drives
archiving destination, 1-75
DISK_ASYNCH_IO initialization parameter, 1-48
dispatcher processes
maximum number, 1-92
DISPATCHERS initialization parameter, 1-49
distinguished name, 1-135
DISTRIBUTED_LOCK_TIMEOUT initialization parameter, 1-53
DML_LOCKS initialization parameter, 1-53
DRS_START initialization parameter, 1-54
dump files, 1-93
dynamic performance tables
CATALOG.SQL script, 3-1
public synonyms (V$), 3-2
views (V_$), 3-2

E

embedded parameter files, 1-65
ENQUEUE_RESOURCES initialization parameter, 1-55
enqueues
being written redo log, B-1
bind, B-1
buffer cache management, B-1
controlfile transaction, B-1
cross-instance call invocation, B-1
database mount, B-1
datafile, B-1
direct loader index creation, B-1
disabling, 1-53
distributed recovery, B-1
distributed TX, B-1
DML, B-1
ENQUEUE_RESOURCES initialization parameter, 1-55
file set, B-1
instance attribute lock, B-1
instance number, B-1
instance recovery, B-1
instance registration lock, B-1
instance state, B-1
job queue, B-1
library cache invalidation, B-1
library cache lock, B-1
library cache pin, B-1
media recovery, B-1
parallel slave synchronization, B-1
parallel slaves, B-1
password file, B-1
process startup, B-1
redo log "kick", B-1
redo thread, B-1
row cache, B-1
sequence number, B-1
SMON, B-1
sort segment, B-1
space management transaction, B-1
synchronized replication, B-1
system commit number, B-1
temporary segment, B-1
temporary table, B-1
transaction, B-1
transaction recovery, B-1
undo segment, serialization, B-1
user name, B-1
user-defined locks, B-1
enterprise roles, 1-135
ERROR_SIZE view, 2-237
errors
archiving, 1-83
EVENT initialization parameter, 1-56
EXCEPTIONS view, 2-237
exclusive mode
specifying instance number, 1-67
extent
allocating to instance, 1-67

F

FAL_CLIENT initialization parameter, 1-56
FAL_SERVER initialization parameter, 1-57
FAST_START_IO_TARGET initialization parameter, 1-57
FAST_START_MTTR_TARGET initialization parameter, 1-58
FAST_START_PARALLEL_ROLLBACK initialization parameter, 1-59
FILE_LOCK view, 2-237
FILE_MAPPING initialization parameter, 1-59
FILE_PING view, 2-238
filenames
case significance, 1-5
name and number, 1-60
FILESYSTEMIO_OPTIONS initialization parameter, 1-60
FILEXT$ view, 2-239
FIXED_DATE initialization parameter, 1-60
free space list
locating space, 1-67
FREELIST GROUPS clause, 1-67

G

GC_FILES_TO_LOCKS initialization parameter, 1-60
GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1-62
GLOBAL_NAME view, 2-240
GLOBAL_NAMES initialization parameter, 1-62
GV$ views
for parallel servers, 3-2

H

HASH_AREA_SIZE initialization parameter, 1-63
HASH_JOIN_ENABLED initialization parameter, 1-64
Heterogeneous Services
agents, 1-64
HI_SHARED_MEMORY_ADDRESS initialization parameter, 1-64
hints
RULE, 1-114
HS_ALL_CAPS view, 2-240
HS_ALL_DD view, 2-240
HS_ALL_INITS view, 2-241
HS_AUTOREGISTER initialization parameter, 1-64
HS_BASE_CAPS view, 2-241
HS_BASE_DD view, 2-241
HS_CLASS_CAPS view, 2-242
HS_CLASS_DD view, 2-242
HS_CLASS_INIT view, 2-243
HS_EXTERNAL_OBJECT_PRIVILEGES view, 2-243
HS_EXTERNAL_OBJECTS view, 2-243
HS_EXTERNAL_USER_PRIVILEGES view, 2-244
HS_FDS_CLASS view, 2-244
HS_FDS_INST view, 2-244
HS_INST_CAPS view, 2-245
HS_INST_DD view, 2-245
HS_INST_INIT view, 2-246

I

IDEPTREE view, 2-246
IFILE initialization parameter, 1-6, 1-65
IND synonym for USER_INDEXES view, 2-247
INDEX_HISTOGRAM view, 2-247
INDEX_STATS view, 2-247
initialization parameter file
common file, 1-65
embedded, 1-65
INITDW.ORA, 1-4
line continuation character (), 1-6
overview, 1-4
initialization parameters
ACTIVE_INSTANCE_COUNT, 1-15
altering, 1-7
AQ_TM_PROCESSES, 1-15
ARCHIVE_LAG_TARGET, 1-16
AUDIT_FILE_DEST, 1-17
AUDIT_SYS_OPERATIONS, 1-17
AUDIT_TRAIL, 1-17
BACKGROUND_CORE_DUMP, 1-18
BACKGROUND_DUMP_DEST, 1-18
BACKUP_TAPE_IO_SLAVES, 1-19
BITMAP_MERGE_AREA_SIZE, 1-20
BLANK_TRIMMING, 1-21
BUFFER_POOL_KEEP, 1-21
BUFFER_POOL_RECYCLE, 1-22
case significance in filenames, 1-5
CIRCUITS, 1-24
CLUSTER_DATABASE, 1-24
CLUSTER_DATABASE_INSTANCES, 1-25
CLUSTER_INTERCONNECTS, 1-25
COMMIT_POINT_STRENGTH, 1-26
COMPATIBLE, 1-27
CONTROL_FILE_RECORD_KEEP_TIME, 1-28
CONTROL_FILES, 1-28
CORE_DUMP_DEST, 1-29
CPU_COUNT, 1-29
CREATE_BITMAP_AREA_SIZE, 1-30
CURSOR_SHARING, 1-31
CURSOR_SPACE_FOR_TIME, 1-31
database creation, 1-44
DB_BLOCK_BUFFERS, 1-33
DB_BLOCK_CHECKING, 1-35
DB_BLOCK_CHECKSUM, 1-35
DB_BLOCK_SIZE, 1-36
DB_CACHE_ADVICE, 1-37
DB_CACHE_SIZE, 1-38
DB_CREATE_FILE_DEST, 1-38
DB_CREATE_ONLINE_LOG_DEST_n, 1-39
DB_DOMAIN, 1-39
DB_FILE_MULTIBLOCK_READ_COUNT, 1-40
DB_FILE_NAME_CONVERT, 1-41
DB_FILES, 1-43
DB_KEEP_CACHE_SIZE, 1-44
DB_NAME, 1-44
DB_nK_CACHE_SIZE, 1-32
DB_RECYCLE_CACHE_SIZE, 1-45
DB_WRITER_PROCESSES, 1-45
DBLINK_ENCRYPT_LOGIN, 1-46
DBWR_IO_SLAVES, 1-46
derived, 1-3
DG_BROKER_CONFIG_FILEn, 1-47
DG_BROKER_START, 1-48
DISK_ASYNCH_IO, 1-48
DISPATCHERS, 1-49
display current settings, 1-11
DISTRIBUTED_LOCK_TIMEOUT, 1-53
DML_LOCKS, 1-53
DRS_START, 1-54
dynamic, 1-8
embedded initialization parameter files, 1-6
ENQUEUE_RESOURCES, 1-55
EVENT, 1-56
FAL_CLIENT, 1-56
FAL_SERVER, 1-57
FAST_START_IO_TARGET, 1-57
FAST_START_MTTR_TARGET, 1-58
FAST_START_PARALLEL_ROLLBACK, 1-59
FILE_MAPPING, 1-59
FILESYSTEMIO_OPTIONS, 1-60
FIXED_DATE, 1-60
GC_FILES_TO_LOCKS, 1-60
GLOBAL_CONTEXT_POOL_SIZE, 1-62
GLOBAL_NAMES, 1-62
HASH_AREA_SIZE, 1-63
HASH_JOIN_ENABLED, 1-64
HI_SHARED_MEMORY_ADDRESS, 1-64
HS_AUTOREGISTER, 1-64
IFILE, 1-6, 1-65
INSTANCE_GROUPS, 1-66
INSTANCE_NAME, 1-67
INSTANCE_NUMBER, 1-67
JAVA_MAX_SESSIONSPACE_SIZE, 1-68
JAVA_POOL_SIZE, 1-68
JAVA_SOFT_SESSIONSPACE_LIMIT, 1-69
JOB_QUEUE_PROCESSES, 1-69
LARGE_POOL_SIZE, 1-70
LICENSE_MAX_SESSIONS, 1-71
LICENSE_MAX_USERS, 1-72
LICENSE_SESSIONS_WARNING, 1-72
LOCAL_LISTENER, 1-73
LOCK_NAME_SPACE, 1-74
LOCK_SGA, 1-74
LOG_ARCHIVE_DEST, 1-75
LOG_ARCHIVE_DEST_n, 1-76
LOG_ARCHIVE_DEST_STATE_n, 1-78
LOG_ARCHIVE_DUPLEX_DEST, 1-79
LOG_ARCHIVE_FORMAT, 1-80
LOG_ARCHIVE_MAX_PROCESSES, 1-81
LOG_ARCHIVE_MIN_SUCCEED_DEST, 1-82
LOG_ARCHIVE_START, 1-83
LOG_ARCHIVE_TRACE, 1-84
LOG_BUFFER, 1-85
LOG_CHECKPOINT_INTERVAL, 1-86
LOG_CHECKPOINT_TIMEOUT, 1-87
LOG_CHECKPOINTS_TO_ALERT, 1-88
LOG_FILE_NAME_CONVERT, 1-88
LOG_PARALLELISM, 1-90
LOGMNR_MAX_PERSISTENT_SESSIONS, 1-90
MAX_COMMIT_PROPAGATION_DELAY, 1-91
MAX_DISPATCHERS, 1-92
MAX_DUMP_FILE_SIZE, 1-93
MAX_ENABLED_ROLES, 1-94
MAX_ROLLBACK_SEGMENTS, 1-94
MAX_SHARED_SERVERS, 1-94
NLS_CALENDAR, 1-95
NLS_COMP, 1-96
NLS_CURRENCY, 1-96
NLS_DATE_FORMAT, 1-97
NLS_DATE_LANGUAGE, 1-98
NLS_DUAL_CURRENCY, 1-98
NLS_ISO_CURRENCY, 1-99
NLS_LANGUAGE, 1-99
NLS_LENGTH_SEMANTICS, 1-100
NLS_NCHAR_CONV_EXCP, 1-100
NLS_NUMERIC_CHARACTERS, 1-101
NLS_SORT, 1-101
NLS_TERRITORY, 1-102
NLS_TIMESTAMP_FORMAT, 1-103
NLS_TIMESTAMP_TZ_FORMAT, 1-104
O7_DICTIONARY_ACCESSIBILITY, 1-104
OBJECT_CACHE_MAX_SIZE_PERCENT, 1-105
OBJECT_CACHE_OPTIMAL_SIZE, 1-106
OLAP_PAGE_POOL_SIZE, 1-106
OPEN_CURSORS, 1-107
OPEN_LINKS, 1-107
operating system-dependent values, 1-3
OPTIMIZER_DYNAMIC_SAMPLING, 1-109
OPTIMIZER_FEATURES_ENABLE, 1-109
OPTIMIZER_INDEX_CACHING, 1-112
OPTIMIZER_INDEX_COST_ADJ, 1-113
OPTIMIZER_MAX_PERMUTATIONS, 1-113
OPTIMIZER_MODE, 1-114
ORACLE_TRACE_COLLECTION_NAME, 1-115
ORACLE_TRACE_COLLECTION_PATH, 1-116
ORACLE_TRACE_COLLECTION_SIZE, 1-116
ORACLE_TRACE_ENABLE, 1-117
ORACLE_TRACE_FACILITY_NAME, 1-117
ORACLE_TRACE_FACILITY_PATH, 1-118
OS_AUTHENT_PREFIX, 1-119
OS_ROLES, 1-120
PARALLEL_ADAPTIVE_MULTI_USER, 1-120
PARALLEL_AUTOMATIC_TUNING, 1-121
PARALLEL_EXECUTION_MESSAGE_SIZE, 1-122
PARALLEL_INSTANCE_GROUP, 1-122
PARALLEL_MAX_SERVERS, 1-123
PARALLEL_MIN_PERCENT, 1-124
PARALLEL_MIN_SERVERS, 1-125
PARALLEL_THREADS_PER_CPU, 1-126
parameter files, 1-4
PARTITION_VIEW_ENABLED, 1-126
performance tuning, 1-3
PGA_AGGREGATE_TARGET, 1-127
PLSQL_COMPILER_FLAGS, 1-128
PLSQL_NATIVE_C_COMPILER, 1-129
PLSQL_NATIVE_LIBRARY_DIR, 1-129
PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT, 1-129
PLSQL_NATIVE_LINKER, 1-130
PLSQL_NATIVE_MAKE_FILE_NAME, 1-130
PLSQL_NATIVE_MAKE_UTILITY, 1-131
PLSQL_V2_COMPATIBILITY, 1-131
PRE_PAGE_SGA, 1-132
PROCESSES, 1-133
QUERY_REWRITE_ENABLED, 1-133
QUERY_REWRITE_INTEGRITY, 1-134
RDBMS_SERVER_DN, 1-135
READ_ONLY_OPEN_DELAYED, 1-136
RECOVERY_PARALLELISM, 1-136
REMOTE_ARCHIVE_ENABLE, 1-137
REMOTE_DEPENDENCIES_MODE, 1-138
REMOTE_LISTENER, 1-138
REMOTE_LOGIN_PASSWORDFILE, 1-139
REMOTE_OS_AUTHENT, 1-140
REMOTE_OS_ROLES, 1-140
REPLICATION_DEPENDENCY_TRACKING, 1-141
RESOURCE_LIMIT, 1-141
RESOURCE_MANAGER_PLAN, 1-142
ROLLBACK_SEGMENTS, 1-143
ROW_LOCKING, 1-144
SERIAL_REUSE, 1-145
SERVICE_NAMES, 1-146
SESSION_CACHED_CURSORS, 1-146
SESSION_MAX_OPEN_FILES, 1-147
SESSIONS, 1-148
SGA_MAX_SIZE, 1-148
SHADOW_CORE_DUMP, 1-149
SHARED_MEMORY_ADDRESS, 1-149
SHARED_POOL_RESERVED_SIZE, 1-150, 3-142
SHARED_POOL_SIZE, 1-151
SHARED_SERVER_SESSIONS, 1-151
SHARED_SERVERS, 1-152
SORT_AREA_RETAINED_SIZE, 1-152
SORT_AREA_SIZE, 1-153
specifying in initialization parameter files, 1-5
SPFILE, 1-155
SQL_TRACE, 1-156
SQL92_SECURITY, 1-157
STANDBY_ARCHIVE_DEST, 1-157
STANDBY_FILE_MANAGEMENT, 1-158
STAR_TRANSFORMATION_ENABLED, 1-159
STATISTICS_LEVEL, 1-159
TAPE_ASYNCH_IO, 1-160
THREAD, 1-160
TIMED_OS_STATISTICS, 1-161
TIMED_STATISTICS, 1-162
TRACE_ENABLED, 1-163
TRACEFILE_IDENTIFIER, 1-163
TRANSACTION_AUDITING, 1-164
TRANSACTIONS, 1-165
TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1-165
UNDO_MANAGEMENT, 1-166
UNDO_RETENTION, 1-166
UNDO_SUPPRESS_ERRORS, 1-167
UNDO_TABLESPACE, 1-168
USE_INDIRECT_DATA_BUFFERS, 1-168
USER_DUMP_DEST, 1-169
UTL_FILE_DIR, 1-169
variable, 1-3
WORKAREA_SIZE_POLICY, 1-170
INITJVM.SQL script, 5-8
INIT.ORA file. See initialization parameter file
IN-list iterators
optimizer use of, 1-112
inserts
locating free space, 1-67
INST_ID column, 3-2
INSTANCE clause
of ALTER TABLE
allocating extents, 1-67
INSTANCE_GROUPS initialization parameter, 1-66
INSTANCE_NAME initialization parameter, 1-67
INSTANCE_NUMBER initialization parameter, 1-67
exclusive or parallel mode, 1-67
instances
checkpoint, 1-86
startup order, 1-67
I/O
reading multiple blocks, 1-40
redo log files, 1-85

J

Java initialization parameters
JAVA_MAX_SESSIONSPACE_SIZE, 1-68
JAVA_POOL_SIZE, 1-68
JAVA_SOFT_SESSIONSPACE_LIMIT, 1-69
Java scripts, 5-8
JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1-68
JAVA_POOL_SIZE initialization parameter, 1-68
JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1-69
JOB_QUEUE_PROCESSES initialization parameter, 1-69

L

language
database default language, 1-99
LARGE_POOL_SIZE initialization parameter, 1-70
LICENSE_MAX_SESSIONS initialization parameter, 1-71
LICENSE_MAX_USERS initialization parameter, 1-72
LICENSE_SESSIONS_WARNING initialization parameter, 1-72
licenses
maximum sessions, 1-71
maximum users, 1-72
warning for concurrent user sessions, 1-72
limits on the database, 4-1
linguistic sorts, 1-101
local currency, 1-96
LOCAL_LISTENER initialization parameter, 1-73
lock
conversion, 3-26
LOCK_NAME_SPACE initialization parameter, 1-74
LOCK_SGA initialization parameter, 1-74
locks
conversion, 3-22, 3-25, 3-29, 3-56
names, A-16
on KGL objects, 2-188
table lock, 1-144
LOG_ARCHIVE_DEST initialization parameter, 1-75
LOG_ARCHIVE_DEST_n initialization parameter, 1-76
LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1-78
LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1-79
LOG_ARCHIVE_FORMAT initialization parameter, 1-80
LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1-81
LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1-82
LOG_ARCHIVE_START initialization parameter, 1-83
LOG_ARCHIVE_TRACE initialization parameter, 1-84
LOG_BUFFER initialization parameter, 1-85
LOG_CHECKPOINT_INTERVAL initialization parameter, 1-86
LOG_CHECKPOINT_TIMEOUT initialization parameter, 1-87
LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1-88
LOG_FILE_NAME_CONVERT initialization parameter, 1-88
LOG_PARALLELISM initialization parameter, 1-90
LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 1-90
lowercase significance, 1-5

M

manual archiving, 1-83
MAP_OBJECT table, 2-248
MAX_COMMIT_PROPAGATION_DELAY initialization parameter, 1-91
MAX_DISPATCHERS initialization parameter, 1-92
MAX_DUMP_FILE_SIZE initialization parameter, 1-93
MAX_ENABLED_ROLES initialization parameter, 1-94
MAX_ROLLBACK_SEGMENTS initialization parameter, 1-94
MAX_SHARED_SERVERS initialization parameter, 1-94
memory
amount used for sorting, 1-152
virtual, 1-3
modes
archiving, 1-83
monitor
performance, 1-86
multiple-process systems
number of processes, 1-133

N

nested files, 1-65
NLS_CALENDAR initialization parameter, 1-95
NLS_COMP initialization parameter, 1-96
NLS_CURRENCY initialization parameter, 1-96
defined by NLS_TERRITORY, 1-102
NLS_DATABASE_PARAMETERS view, 2-249
NLS_DATE_FORMAT initialization parameter, 1-97
defined by NLS_NUMERIC_CHARACTERS, 1-102
defined by NLS_TERRITORY, 1-102
NLS_DATE_LANGUAGE initialization parameter, 1-98
NLS_DUAL_CURRENCY initialization parameter, 1-98
NLS_INSTANCE_PARAMETERS view, 2-249
NLS_ISO_CURRENCY initialization parameter, 1-99
defined by NLS_TERRITORY, 1-102
NLS_LANGUAGE initialization parameter, 1-99
NLS_LENGTH_SEMANTICS initialization parameter, 1-100
NLS_NCHAR_CONV_EXCP initialization parameter, 1-100
NLS_NUMERIC_CHARACTERS initialization parameter, 1-101
NLS_SESSION_PARAMETERS view, 2-249
NLS_SORT initialization parameter, 1-101
NLS_TERRITORY initialization parameter, 1-102
NLS_TIMESTAMP_FORMAT initialization parameter, 1-103
NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1-104
NOARCHIVELOG mode
creating a database, 1-83
numeric group separators, 1-101

O

O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1-104
OBJ synonym for USER_OBJECTS view, 2-250
OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1-105
OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1-106
objects
data dictionary, 2-1
OLAP_PAGE_POOL_SIZE initialization parameter, 1-106
online redo log
archiving, 1-83
archiving mode, 1-75
block, 1-86
file size, 1-86
number of files, 1-83
setting checkpoint interval, 1-86
OPEN_CURSORS initialization parameter, 1-107
OPEN_LINKS initialization parameter, 1-107
operating system
authenticating remote clients, 1-140
authenticating users and passwords, 1-119
dependent parameters, 1-3
roles for remote clients, 1-140
optimization
trading cursor space for time, 1-31
OPTIMIZER_DYNAMIC_SAMPLING initialization parameter, 1-109
OPTIMIZER_FEATURES_ENABLE initialization parameter, 1-109
OPTIMIZER_INDEX_CACHING initialization parameter, 1-112
OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1-113
OPTIMIZER_MAX_PERMUTATIONS initialization parameter, 1-113
OPTIMIZER_MODE initialization parameter, 1-114
ORACLE_TRACE_COLLECTION_NAME initialization parameter, 1-115
ORACLE_TRACE_COLLECTION_PATH initialization parameter, 1-116
ORACLE_TRACE_COLLECTION_SIZE initialization parameter, 1-116
ORACLE_TRACE_ENABLE initialization parameter, 1-117
ORACLE_TRACE_FACILITY_NAME initialization parameter, 1-117
ORACLE_TRACE_FACILITY_PATH initialization parameter, 1-118
Oracle9i Real Application Clusters
dynamic performance views, 3-2
initialization parameters
CIRCUITS, 1-24
CLUSTER_DATABASE, 1-24
CLUSTER_DATABASE_INSTANCES, 1-25
CLUSTER_INTERCONNECTS, 1-25
DISPATCHERS, 1-49
FAST_START_PARALLEL_ROLLBACK, 1-59
PARALLEL_ADAPTIVE_MULTI_USER, 1-120
PARALLEL_AUTOMATIC_TUNING, 1-121
PARALLEL_EXECUTION_MESSAGE_SIZE, 1-122
PARALLEL_INSTANCE_GROUP, 1-122
PARALLEL_MAX_SERVERS, 1-123
PARALLEL_MIN_PERCENT, 1-124
PARALLEL_MIN_SERVERS, 1-125
PARALLEL_THREADS_PER_CPU, 1-126
ORPHAN_KEY_TABLE view. See DBA_ORPHAN_KEY_TABLE. DBA_ORPHAN_KEY_TABLE view, 2-201
OS_AUTHENT_PREFIX initialization parameter, 1-119
OS_ROLES initialization parameter, 1-120

P

parallel mode
instance number, 1-67
parallel query
maximum number of instances, 1-122
maximum number of servers, 1-123
minimum number of queries, 1-125
PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1-120
PARALLEL_AUTOMATIC_TUNING initialization parameter, 1-121
PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1-122
PARALLEL_INSTANCE_GROUP initialization parameter, 1-122
PARALLEL_MAX_SERVERS initialization parameter, 1-123
PARALLEL_MIN_PERCENT initialization parameter, 1-124
PARALLEL_MIN_SERVERS initialization parameter, 1-125
PARALLEL_THREADS_PER_CPU initialization parameter, 1-126
PARSED_PIECES view, 2-250
PARSED_SIZE view, 2-250
PARTITION_VIEW_ENABLED initialization parameter, 1-126
partitions
raw, 1-75
passwords
authenticating, 1-119, 1-140
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1-139
PCM lock
mapping blocks to, 1-60
performance, 1-3
rule-based optimization, 1-114
shared pool, 1-64, 1-149, 1-151
PGA_AGGREGATE_TARGET initialization parameter, 1-127
pins
on KGL objects, 2-188
PLAN_TABLE execution plan table, 2-250
PLSQL_COMPILER_FLAGS initialization parameter, 1-128
PLSQL_NATIVE_C_COMPILER initialization parameter, 1-129
PLSQL_NATIVE_LIBRARY_DIR initialization parameter, 1-129
PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT initialization parameter, 1-129
PLSQL_NATIVE_LINKER initialization parameter, 1-130
PLSQL_NATIVE_MAKE_FILE_NAME initialization parameter, 1-130
PLSQL_NATIVE_MAKE_UTILITY initialization parameter, 1-131
PLSQL_V2_COMPATIBILITY initialization parameter, 1-131
PLUGGABLE_SET_CHECK view, 2-252
PRE_PAGE_SGA initialization parameter, 1-132
privileges
remote login, 1-139
RESTRICTED_SESSION privilege, 1-71, 1-72
table-level select privileges, 1-157, 1-159
procedures
shared pool, 1-64, 1-149, 1-151
processes
derived parameter values, 1-165
dispatcher process maximum number, 1-92
maximum shared server processes, 1-94
number of server processes, 1-68, 1-69, 1-133, 1-151, 1-152
recovery, 1-134, 1-136
trace files, 1-169
user processes, 1-133
PROCESSES initialization parameter, 1-133
PRODUCT_COMPONENT_VERSION view, 2-253
profiles
resource limits, 1-141, 1-142
PROXY_USERS view, 2-253
PSTUBTBL view, 2-254
PUBLIC clause
of ALTER DATABASE
thread of redo, 1-160
PUBLIC_DEPENDENCY view, 2-254
PUBLICSYN view, 2-254

Q

queries
dictionary views, 1-60
hints, 1-114
QUERY_REWRITE_ENABLED initialization parameter, 1-133
QUERY_REWRITE_INTEGRITY initialization parameter, 1-134
QUEUE_PRIVILEGES view, 2-255

R

raw partition
LOG_ARCHIVE_DEST initialization parameter, 1-75
RC_ARCHIVED_LOG view, 2-4
RC_BACKUP_CONTROLFILE view, 2-4
RC_BACKUP_CORRUPTION view, 2-4
RC_BACKUP_DATAFILE view, 2-4
RC_BACKUP_PIECE view, 2-4
RC_BACKUP_REDOLOG view, 2-4
RC_BACKUP_SET view, 2-4
RC_BACKUP_SPFILE view, 2-4
RC_CHECKPOINT view, 2-4
RC_CONTROLFILE_COPY view, 2-4
RC_COPY_CORRUPTION view, 2-4
RC_DATABASE view, 2-4
RC_DATABASE_BLOCK_CORRUPTION view, 2-4
RC_DATABASE_INCARNATION view, 2-4
RC_DATAFILE view, 2-4
RC_DATAFILE_COPY view, 2-4
RC_LOG_HISTORY view, 2-4
RC_OFFLINE_RANGE view, 2-4
RC_PROXY_CONTROLFILE view, 2-4
RC_PROXY_DATAFILE view, 2-4
RC_REDO_LOG view, 2-4
RC_REDO_THREAD view, 2-4
RC_RESYNC view, 2-4
RC_RMAN_CONFIGURATION view, 2-4
RC_STORED_SCRIPT view, 2-4
RC_STORED_SCRIPT_LINE view, 2-4
RC_TABLESPACE view, 2-4
RDBMS_SERVER_DN initialization parameter, 1-135
READ_ONLY_OPEN_DELAYED initialization parameter, 1-136
recovery
number of required processes, 1-134, 1-136
RECOVERY_PARALLELISM initialization parameter, 1-136
redo logs
buffer size, 1-85
redo thread, 1-160
remote clients
authenticating, 1-140
remote logins, 1-139
REMOTE_ARCHIVE_ENABLE initialization parameter, 1-137
REMOTE_DEPENDENCIES_MODE initialization parameter, 1-138
REMOTE_LISTENER initialization parameter, 1-138
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1-139
REMOTE_OS_AUTHENT initialization parameter, 1-140
REMOTE_OS_ROLES initialization parameter, 1-140
REPAIR_TABLE view. See DBA_REPAIR_TABLE view.
REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1-141
resource limits for profiles, 1-141, 1-142
RESOURCE_COST view, 2-255
RESOURCE_LIMIT initialization parameter, 1-141
RESOURCE_MANAGER_PLAN initialization parameter, 1-142
RESOURCE_MAP table, 2-255
RMJVM.SQL script, 5-8
ROLE_ROLE_PRIVS view, 2-256
ROLE_SYS_PRIVS view, 2-256
ROLE_TAB_PRIVS view, 2-256
ROLE_WM_PRIVS view, 2-3
roles, 1-120
remote clients, 1-140
rollback segments
maximum size, 1-94
ROLLBACK_SEGMENTS initialization parameter, 1-143
ROW_LOCKING initialization parameter, 1-144
rule-based optimization, 1-114

S

scripts
CATALOG.SQL, 5-2
CATBLOCK.SQL, 5-3
CATCLUST.SQL, 5-2
CATEXP7.SQL, 5-3
CATHS.SQL, 5-3
CATIO.SQL, 5-3
CATJAVA.SQL, 5-8
CATNOADT.SQL, 5-6
CATNOAUD.SQL, 5-6
CATNOHS.SQL, 5-6
CATNOPRT.SQL, 5-6
CATNOQUE.SQL, 5-6
CATNORMN.SQL, 5-6
CATNOSVM.SQL, 5-6
CATNSNMP.SQL, 5-6
CATOCTK.SQL, 5-3
CATPROC.SQL, 5-2
CATQUEUE.SQL, 5-3
CATREP.SQL, 5-3
CATRMAN.SQL, 5-3
CMPDBMIG.SQL, 5-7
D0801070.SQL, 5-7
D0900010.SQL, 5-7
data dictionary, 5-3
database migration, 5-7
DBMSIOTC.SQL, 5-3
DBMSOTRC.SQL, 5-3
DBMSPOOL.SQL, 5-4
INITJVM.SQL, 5-8
Java, 5-8
RMJVM.SQL, 5-8
SQL scripts, 5-2
U0703040.SQL, 5-7
U0800060.SQL, 5-7
U0801070.SQL, 5-7
U0900010.SQL, 5-7
USERLOCK.SQL, 5-4
UTLBSTAT.SQL, 5-4
UTLCHN1.SQL, 5-4
UTLCONST.SQL, 5-4
UTLDTREE.SQL, 5-4
UTLESTAT.SQL, 5-4
UTLEXPT1.SQL, 5-4
UTLINCMP.SQL, 5-7
UTLIP.SQL, 5-4
UTLIRP.SQL, 5-5
UTLLOCKT.SQL, 5-5
UTLPWDMG.SQL, 5-5
UTLRP.SQL, 5-5
UTLSAMPL.SQL, 5-5
UTLSCLN.SQL, 5-5
UTLTKPRF.SQL, 5-5
UTLVALID.SQL, 5-5
UTLXPLAN.SQL, 5-5
SEQ synonym for USER_SEQUENCES view, 2-256
SERIAL_REUSE initialization parameter, 1-145
server parameter file
overview, 1-4
server processes
number, 1-68, 1-69, 1-133, 1-151, 1-152
SERVICE_NAMES initialization parameter, 1-146
SESSION_CACHED_CURSORS initialization parameter, 1-146
SESSION_CONTEXT view, 2-257
SESSION_MAX_OPEN_FILES initialization parameter, 1-147
SESSION_PRIVS view, 2-257
SESSION_ROLES view, 2-257
SESSIONS initialization parameter, 1-148
SGA_MAX_SIZE initialization parameter, 1-148
SHADOW_CORE_DUMP initialization parameter, 1-149
shared server
SESSIONS initialization parameter, 1-148
shared server dispatcher request statistics, 3-119
shared server processes
maximum number, 1-94
SHARED_MEMORY_ADDRESS initialization parameter, 1-149
SHARED_POOL_RESERVED_SIZE initialization parameter, 1-150
V$SHARED_POOL_RESERVED, 3-142
SHARED_POOL_SIZE initialization parameter, 1-151
SHARED_SERVER_SESSIONS initialization parameter, 1-151
SHARED_SERVERS initialization parameter, 1-152
SHOW PARAMETERS command, 1-11
SORT_AREA_RETAINED_SIZE initialization parameter, 1-152
SORT_AREA_SIZE initialization parameter, 1-153
sorting
maximum memory, 1-152
ORDER BY queries, 1-101
SOURCE_SIZE view, 2-257
SPFILE initialization parameter, 1-155
SQL scripts
creating the data dictionary, 5-2
optional, 5-3
required, 5-2
SQL_TRACE initialization parameter, 1-156
SQL92_SECURITY initialization parameter, 1-157
STANDBY_ARCHIVE_DEST initialization parameter, 1-157
STANDBY_FILE_MANAGEMENT initialization parameter, 1-158
STAR_TRANSFORMATION_ENABLED initialization parameter, 1-159
starting up
database name, 1-44
instance number, 1-67
startup order, 1-67
STARTUP statement
database name, 1-44
statistics
background checkpoints completed, C-3
background checkpoints started, C-3
branch node splits, C-3
buffer is not pinned count, C-3
buffer is pinned count, C-3
bytes received via SQL*Net from client, C-3
bytes received via SQL*Net from dblink, C-3
bytes sent via SQL*Net to client, C-3
bytes sent via SQL*Net to dblink, C-3
Cached Commit SCN referenced, C-3
calls to get snapshot scn
kcmgss, C-3
calls to kcmgas, C-3
calls to kcmgcs, C-4
calls to kcmgrs, C-4
change write time, C-4
cleanouts and rollbacks - consistent read gets, C-4
cleanouts only - consistent read gets, C-4
cluster key scan block gets, C-4
cluster key scans, C-4
cold recycle reads, C-4
commit cleanout failures
block lost, C-4
buffer being written, C-4
callback failure, C-4
cannot pin, C-4
hot backup in progress, C-4
write disabled, C-4
commit cleanouts, C-4
commit cleanouts successfully completed, C-5
Commit SCN cached, C-5
consistent changes, C-5
consistent gets, C-5
CPU used by this session, C-5
CPU used when call started, C-5
CR blocks created, C-5
cross instance CR read, C-6
current blocks converted for CR, C-5
cursor authentication, C-5
data blocks consistent reads - undo records applied, C-5
db block changes, C-6
db block gets, C-6
DBWR buffers scanned, C-6
DBWR checkpoint buffers written, C-6
DBWR checkpoints, 1-86, C-6
DBWR cross instance writes, C-6
DBWR free buffers found, C-6
DBWR lru scans, C-6
DBWR make free requests, C-6
DBWR revisited being-written buffer, C-7
DBWR summed scan depth, C-7
DBWR transaction table writes, C-7
DBWR undo block writes, C-7
DDL statements parallelized, C-7
deferred (CURRENT) block cleanout applications, C-7
DFO trees parallelized, C-7
dirty buffers inspected, C-7
DML statements parallelized, C-7
enqueue conversions, C-7
enqueue deadlocks, C-7
enqueue releases, C-7
enqueue requests, C-7
enqueue timeouts, C-8
enqueue waits, C-8
exchange deadlocks, C-8
execute count, C-8
free buffer inspected, C-8
free buffer requested, C-8
global cache blocks corrupt, C-8
global cache cr block log flush time, C-9
global cache cr block send time, C-9
global cache cr timeouts, C-9
global cache defers, C-9
global cache freelist waits, C-9
global cache get time, C-9
global cache gets, C-9
global cache prepare failures, C-9
global lock async converts, C-9
global lock async gets, C-9
global lock convert time, C-9
global lock get time, C-9
global lock release time, C-10
global lock releases, C-10
global lock sync converts, C-10
global lock sync gets, C-10
hot buffers moved to head of LRU, C-10
immediate (CR) block cleanout applications, C-10
immediate (CURRENT) block cleanout applications, C-10
index fast full scans (direct read), C-10
index fast full scans (full), C-10
index fast full scans (rowid ranges), C-10
instance recovery database freeze count, C-10
kcmccs called get current scn, C-10
kcmccs read scn without going to DLM, C-10
kcmggs waited for batching, C-10
leaf node splits, C-10
logons cumulative, C-10
logons current, C-10
messages received, C-10
messages sent, C-10
native hash arithmetic execute, C-11
native hash arithmetic fail, C-11
next scns gotten without going to DLM, C-11
no buffer to keep pinned count, C-11
no work - consistent read gets, C-11
opened cursors cumulative, C-11
opened cursors current, C-11
opens of replaced files, C-11
opens requiring cache replacement, C-11
operating system
OS All other sleep time, C-11
OS Chars read and written, C-11
OS Data page fault sleep time, C-11
OS Input blocks, C-11
OS Involuntary context switches, C-12
OS Kernel page fault sleep time, C-12
OS Major page faults, C-12
OS Messages received, C-12
OS Messages sent, C-12
OS Minor page faults, C-12
OS Other system trap CPU time, C-12
OS Output blocks, C-12
OS Process heap time, C-12
OS Signals received, C-12
OS Swaps, C-12
OS System call CPU time, C-12
OS System calls, C-12
OS Text page fault sleep time, C-12
OS User level CPU time, C-12
OS User lock wait sleep time, C-12
OS Voluntary context switches, C-12
OS Wait-cpu (latency) time, C-12
Process stack size, C-12
OS Input blocks, C-12
Parallel operations downgraded 1 to 25 pct, C-13
Parallel operations downgraded 25 to 50 pct, C-13
Parallel operations downgraded 50 to 75 pct, C-13
Parallel operations downgraded 75 to 99 pct, C-13
Parallel operations downgraded to serial, C-13
Parallel operations not downgraded, C-13
parse count (hard), C-13
parse count (total), C-13
parse time cpu, C-13
parse time elapsed, C-13
physical reads, C-13
physical reads direct, C-13
physical writes, C-14
physical writes direct, C-14
physical writes non checkpoint, C-14
pinned buffers inspected, C-14
prefetched blocks, C-14
prefetched blocks aged out before use, C-14
process last non-idle time, C-14
PX local messages recv'd, C-14
PX local messages sent, C-14
PX remote messages recv'd, C-14
PX remote messages sent, C-14
queries parallelized, C-14
recovery array read time, C-14
recovery array reads, C-14
recovery blocks read, C-15
recursive calls, C-15
recursive cpu usage, C-15
redo blocks written, C-15
redo buffer allocation retries, C-15
redo entries, C-15
redo log space requests, C-15
redo log space wait time, C-15
redo log switch interrupts, C-15
redo ordering marks, C-16
redo size, C-16
redo sync writes, C-16
redo synch time, C-16
redo wastage, C-16
redo write time, C-16
redo writer latching time, C-16
redo writes, C-16
remote instance undo block writes, C-16
remote instance undo header writes, C-16
rollback changes - undo records applied, C-16
rollbacks only - consistent read gets, C-16
rows fetched via callback, C-16
serializable aborts, C-17
session connect time, C-17
session cursor cache count, C-17
session cursor cache hits, C-17
session logical reads, C-17
session pga memory, C-17
session pga memory max, C-17
session stored procedure space, C-17
session uga memory, C-17
session uga memory max, C-17
sorts (disk), C-17
sorts (memory), C-18
sorts (rows), C-18
SQL*Net roundtrips to/from client, C-18
SQL*Net roundtrips to/from dblink, C-18
summed dirty queue length, C-18
switch current to new buffer, C-18
table fetch by rowid, C-18
table fetch continued row, C-18
table scan blocks gotten, C-19
table scan rows gotten, C-19
table scans (cache partitions), C-19
table scans (direct read), C-19
table scans (long tables), C-19
table scans (rowid ranges), C-19
table scans (short tables), C-19
timed, 1-162
total file opens, C-19
transaction lock background get time, C-19
transaction lock background gets, C-19
transaction lock foreground requests, C-19
transaction lock foreground wait time, C-19
transaction rollbacks, C-19
transaction tables consistent read rollbacks, C-20
transaction tables consistent reads - undo records applied, C-20
Unnecessary process cleanup for SCN batching, C-20
user calls, C-20
user commits, C-20
user rollbacks, C-20
write clones created in background, C-20
write clones created in foreground, C-20
STATISTICS_LEVEL initialization parameter, 1-159
STMT_AUDIT_OPTION_MAP table, 2-258
switch redo log file, 1-86
SYN synonym for USER_SYNONYMS view, 2-258
SYNONYMS view, 2-258
SYS_OBJECTS view, 2-259
SYSCATALOG view, 2-258
SYSFILES view, 2-258
SYSSEGOBJ view, 2-258
system global area, 1-3
buffer areas, 1-85
maximum concurrent transactions, 1-165
rollback segment size, 1-94
system performance, 1-3
SYSTEM_PRIVILEGE_MAP table, 2-258

T

TAB view, 2-259
TABLE_PRIVILEGE_MAP table, 2-259
TABLE_PRIVILEGES view, 2-259
tables
data dictionary, 2-1
DML locks, 1-53
locating free space, 1-67
row locking, 1-144
TABQUOTAS view, 2-260
TABS synonym for USER_TABLES view, 2-260
tape archiving destination, 1-75
TAPE_ASYNCH_IO initialization parameter, 1-160
territory, 1-98, 1-102
THREAD initialization parameter, 1-160
TIMED_OS_STATISTICS initialization parameter, 1-161
TIMED_STATISTICS initialization parameter, 1-162
file read/write statistics, 3-58, 3-182
TO_CHAR function, 1-97
TO_DATE function, 1-97
trace files
destination, 1-169
maximum size, 1-93
TRACE_ENABLED initialization parameter, 1-163
TRACEFILE_IDENTIFIER initialization parameter, 1-163
TRANSACTION_AUDITING initialization parameter, 1-164
transactions
concurrent, 1-165
data locking, 1-53
TRANSACTIONS initialization parameter, 1-165
DML locks, 1-53
TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1-165
TRUSTED_SERVERS view, 2-260
TS_PITR_CHECK view, 2-261
TS_PITR_OBJECTS TO_BE_DROPPED view, 2-262

U

U0703040.SQL script, 5-7
U0800060.SQL script, 5-7
U0801070.SQL script, 5-7
U0900010.SQL script, 5-7
UNDO_MANAGEMENT initialization parameter, 1-166
UNDO_RETENTION initialization parameter, 1-166
UNDO_SUPPRESS_ERRORS initialization parameter, 1-167
UNDO_TABLESPACE initialization parameter, 1-168
UNI_PLUGGABLE_SET_CHECK view, 2-262
updates
locating free space, 1-67
transaction processing option, 1-144
uppercase characters, 1-5
USE_INDIRECT_DATA_BUFFERS initialization parameter, 1-168
user processes
trace files, 1-169
USER_ALL_TABLES view, 2-263
USER_AQ_AGENT_PRIVS view, 2-263
USER_ARGUMENTS view, 2-263
USER_ASSOCIATIONS view, 2-264
USER_ATTRIBUTE_TRANSFORMATIONS view, 2-264
USER_AUDIT_OBJECT view, 2-264
USER_AUDIT_POLICIES view, 2-264
USER_AUDIT_SESSION view, 2-264
USER_AUDIT_STATEMENT view, 2-264
USER_AUDIT_TRAIL view, 2-265
USER_AW_PS view, 2-265
USER_AWS view, 2-265
USER_BASE_TABLE_MVIEWS view, 2-265
USER_CATALOG view, 2-266
CAT synonym, 2-153
USER_CLU_COLUMNS view, 2-266
USER_CLUSTER_HASH_EXPRESSIONS view, 2-266
USER_CLUSTERS view, 2-266
CLU synonym, 2-155
USER_COL_COMMENTS view, 2-266
USER_COL_PRIVS view, 2-266
USER_COL_PRIVS_MADE view, 2-267
USER_COL_PRIVS_RECD view, 2-267
USER_COLL_TYPES view, 2-267
USER_CONS_COLUMNS view, 2-267
USER_CONS_OBJ_COLUMNS view, 2-267
USER_CONSTRAINTS view, 2-268
USER_DB_LINKS view, 2-268
USER_DEPENDENCIES view, 2-268
USER_DIM_ATTRIBUTES view, 2-268
USER_DIM_CHILD_OF view, 2-268
USER_DIM_HIERARCHIES view, 2-268
USER_DIM_JOIN_KEY view, 2-269
USER_DIM_LEVEL_KEY view, 2-269
USER_DIM_LEVELS view, 2-269
USER_DIMENSIONS view, 2-269
USER_DUMP_DEST initialization parameter, 1-169
USER_ERRORS view, 2-269
USER_EVALUATION_CONTEXT_TABLES view, 2-269
USER_EVALUATION_CONTEXT_VARS view, 2-270
USER_EVALUATION_CONTEXTS view, 2-270
USER_EXTENTS view, 2-270
USER_EXTERNAL_LOCATIONS view, 2-270
USER_EXTERNAL_TABLES view, 2-270
USER_FREE_SPACE view, 2-271
USER_IND_COLUMNS view, 2-271
USER_IND_EXPRESSIONS view, 2-271
USER_IND_PARTITIONS view, 2-271
USER_IND_SUBPARTITIONS view, 2-271
USER_INDEXES view, 2-271
IND synonym, 2-247
USER_INDEXTYPE_COMMENTS view, 2-272
USER_INDEXTYPE_OPERATORS view, 2-272
USER_INDEXTYPES view, 2-272
USER_INTERNAL_TRIGGERS view, 2-272
USER_JAVA_ARGUMENTS view, 2-272
USER_JAVA_CLASSES view, 2-273
USER_JAVA_DERIVATIONS view, 2-273
USER_JAVA_FIELDS view, 2-273
USER_JAVA_IMPLEMENTS view, 2-273
USER_JAVA_INNERS view, 2-273
USER_JAVA_LAYOUTS view, 2-274
USER_JAVA_METHODS view, 2-274
USER_JAVA_NCOMPS view, 2-274
USER_JAVA_POLICY view, 2-274
USER_JAVA_RESOLVERS view, 2-274
USER_JAVA_THROWS view, 2-275
USER_JOBS view, 2-275
USER_JOIN_IND_COLUMNS view, 2-275
USER_LIBRARIES view, 2-275
USER_LOB_PARTITIONS view, 2-275
USER_LOB_SUBPARTITIONS view, 2-275
USER_LOB_TEMPLATES view, 2-276
USER_LOBS view, 2-276
USER_LOG_GROUP_COLUMNS view, 2-276
USER_LOG_GROUPS view, 2-276
USER_METHOD_PARAMS view, 2-276
USER_METHOD_RESULTS view, 2-276
USER_MVIEW_AGGREGATES view, 2-277
USER_MVIEW_ANALYSIS view, 2-277
USER_MVIEW_DETAIL_RELATIONS view, 2-277
USER_MVIEW_JOINS view, 2-277
USER_MVIEW_KEYS view, 2-277
USER_MVIEW_LOGS view, 2-278
USER_MVIEW_REFRESH_TIMES view, 2-278
USER_MVIEWS view, 2-278
USER_NESTED_TABLES view, 2-278
USER_OBJ_AUDIT_OPTS view, 2-278
USER_OBJ_COLATTRS view, 2-278
USER_OBJECT_SIZE view, 2-279
USER_OBJECT_TABLES view, 2-279
USER_OBJECTS view, 2-279
OBJ synonym, 2-250
USER_OPANCILLARY view, 2-279
USER_OPARGUMENTS view, 2-279
USER_OPBINDINGS view, 2-279
USER_OPERATOR_COMMENTS view, 2-279
USER_OPERATORS view, 2-280
USER_OUTLINE_HINTS view, 2-280
USER_OUTLINES view, 2-280
USER_PART_COL_STATISTICS view, 2-280
USER_PART_HISTOGRAMS view, 2-280
USER_PART_INDEXES view, 2-280
USER_PART_KEY_COLUMNS view, 2-281
USER_PART_LOBS view, 2-281
USER_PART_TABLES view, 2-281
USER_PARTIAL_DROP_TABS view, 2-281
USER_PASSWORD_LIMITS view, 2-281
USER_PENDING_CONV_TABLES view, 2-282
USER_POLICIES view, 2-282
USER_POLICY_CONTEXTS view, 2-282
USER_POLICY_GROUPS view, 2-282
USER_PROCEDURES view, 2-282
USER_PROXIES view, 2-283
USER_PUBLISHED_COLUMNS view, 2-283
USER_QUEUE_SCHEDULES view, 2-283
USER_QUEUE_TABLES view, 2-283
USER_QUEUES view, 2-284
USER_REFRESH view, 2-284
USER_REFRESH_CHILDREN view, 2-284
USER_REFS view, 2-284
USER_REGISTERED_MVIEWS view, 2-284
USER_REGISTRY view, 2-284
USER_REPAUDIT_ATTRIBUTE view, 2-2
USER_REPAUDIT_COLUMN view, 2-2
USER_REPCAT view, 2-2
USER_REPCAT_REFRESH_TEMPLATES view, 2-2
USER_REPCAT_TEMPLATE_OBJECTS view, 2-2
USER_REPCAT_TEMPLATE_PARMS view, 2-2
USER_REPCAT_TEMPLATE_SITES view, 2-2
USER_REPCAT_USER_AUTHORIZATION view, 2-2
USER_REPCAT_USER_PARM_VALUES view, 2-2
USER_REPCATLOG view, 2-2
USER_REPCOLUMN view, 2-2
USER_REPCOLUMN_GROUP view, 2-2
USER_REPCONFLICT view, 2-2
USER_REPDDL view, 2-2
USER_REPFLAVOR_COLUMNS view, 2-2
USER_REPFLAVOR_OBJECTS view, 2-2
USER_REPFLAVORS view, 2-2
USER_REPGENERATED view, 2-2
USER_REPGENOBJECTS view, 2-2
USER_REPGROUP view, 2-2
USER_REPGROUP_PRIVILEGES view, 2-2
USER_REPGROUPED_COLUMN view, 2-2
USER_REPKEY_COLUMNS view, 2-2
USER_REPOBJECT view, 2-2
USER_REPPARAMETER_COLUMN view, 2-2
USER_REPPRIORITY view, 2-2
USER_REPPRIORITY_GROUP view, 2-2
USER_REPPROP view, 2-2
USER_REPRESOL_STATS_CONTROL view, 2-2
USER_REPRESOLUTION view, 2-2
USER_REPRESOLUTION_METHOD view, 2-2
USER_REPRESOLUTION_STATISTICS view, 2-2
USER_REPSCHEMA view, 2-2
USER_REPSITES view, 2-2
USER_RESOURCE_LIMITS view, 2-285
USER_RESUMABLE view, 2-285
USER_ROLE_PRIVS view, 2-285
USER_RSRC_CONSUMER_GROUP_PRIVS view, 2-285
USER_RSRC_MANAGER_SYSTEM_PRIVS view, 2-286
USER_RULE_SET_RULES view, 2-286
USER_RULE_SETS view, 2-286
USER_RULES view, 2-286
USER_SEGMENTS view, 2-286
USER_SEQUENCES view, 2-286
SEQ synonym, 2-256
USER_SOURCE view, 2-287
USER_SOURCE_TABLES view, 2-287
USER_SQLJ_TYPE_ATTRS view, 2-287
USER_SQLJ_TYPE_METHODS view, 2-287
USER_SQLJ_TYPES view, 2-287
USER_STORED_SETTINGS view, 2-287
USER_SUBPART_COL_STATISTICS view, 2-288
USER_SUBPART_HISTOGRAMS view, 2-288
USER_SUBPART_KEY_COLUMNS view, 2-288
USER_SUBPARTITION_TEMPLATES view, 2-288
USER_SUBSCRIBED_COLUMNS view, 2-288
USER_SUBSCRIBED_TABLES view, 2-289
USER_SUBSCRIPTIONS view, 2-289
USER_SYNONYMS view, 2-289
SYN synonym, 2-258
USER_SYS_PRIVS view, 2-289
USER_TAB_COL_STATISTICS view, 2-289
USER_TAB_COLUMNS view, 2-289
COLS synonym, 2-156
USER_TAB_COMMENTS view, 2-289
USER_TAB_HISTOGRAMS view, 2-290
USER_TAB_MODIFICATIONS view, 2-290
USER_TAB_PARTITIONS view, 2-290
USER_TAB_PRIVS view, 2-290
USER_TAB_PRIVS_MADE view, 2-290
USER_TAB_PRIVS_RECD view, 2-291
USER_TAB_SUBPARTITIONS view, 2-291
USER_TABLES view, 2-291
TABS synonym, 2-260
USER_TABLESPACES view, 2-291
USER_TRANSFORMATIONS view, 2-291
USER_TRIGGER_COLS view, 2-292
USER_TRIGGERS view, 2-292
USER_TS_QUOTAS view, 2-292
USER_TYPE_ATTRS view, 2-292
USER_TYPE_METHODS view, 2-292
USER_TYPE_VERSIONS view, 2-292
USER_TYPES view, 2-293
USER_UNUSED_COL_TABS view, 2-293
USER_UPDATABLE_COLUMNS view, 2-293
USER_USERS view, 2-293
USER_USTATS view, 2-293
USER_VARRAYS view, 2-293
USER_VIEWS view, 2-294
USER_WM_LOCKED_TABLES view, 2-3
USER_WM_MODIFIED_TABLES view, 2-3
USER_WM_PRIVS view, 2-3
USER_WM_RIC_INFO view, 2-3
USER_WM_TAB_TRIGGERS view, 2-3
USER_WM_VERSIONED_TABLES view, 2-3
USER_WM_VT_ERRORS view, 2-3
USER_WORKSPACE_PRIVS view, 2-3
USER_WORKSPACE_SAVEPOINTS view, 2-3
USER_WORKSPACES view, 2-3
USER_XML_SCHEMAS view, 2-294
USER_XML_TAB_COLS view, 2-294
USER_XML_TABLES view, 2-294
USER_XML_VIEW_COLS view, 2-294
USER_XML_VIEWS view, 2-294
USERLOCK.SQL script, 5-4
users
authenticating, 1-119
multiple, 1-53
UTL_FILE_DIR initialization parameter, 1-169
UTLBSTAT.SQL script, 5-4
UTLCHN1.SQL script, 5-4
UTLCONST.SQL script, 5-4
UTLDTREE.SQL script, 2-236, 5-4
utldtree.sql script, 2-246
UTLESTAT.SQL script, 5-4
UTLEXPT1.SQL script, 5-4
UTLINCMP.SQL script, 5-7
UTLIP.SQL script, 5-4
UTLIRP.SQL script, 5-5
UTLLOCKT.SQL script, 5-5
UTLPWDMG.SQL script, 5-5
UTLRP.SQL script, 5-5
UTLSAMPL.SQL script, 5-5
UTLSCLN.SQL script, 5-5
UTLTKPRF.SQL script, 5-5
UTLVALID.SQL script, 5-5
UTLXPLAN.SQL script, 5-5

V

V$ACCESS view, 3-4
V$ACTIVE_INSTANCES view, 3-4
V$ACTIVE_SESS_POOL_MTH view, 3-4
V$AQ view, 3-4
V$ARCHIVE view, 3-5
V$ARCHIVE_DEST view, 3-5
V$ARCHIVE_DEST_STATUS view, 3-8
V$ARCHIVE_GAP view, 3-10
V$ARCHIVE_PROCESSES view, 3-10
V$ARCHIVED_LOG view, 3-10
V$BACKUP view, 3-12
V$BACKUP_ASYNC_IO view, 3-13
V$BACKUP_CORRUPTION view, 3-14
V$BACKUP_DATAFILE view, 3-15
V$BACKUP_DEVICE view, 3-16
V$BACKUP_PIECE view, 3-17
V$BACKUP_REDOLOG view, 3-18
V$BACKUP_SET view, 3-18
V$BACKUP_SPFILE view, 3-20
V$BACKUP_SYNC_IO view, 3-20
V$BGPROCESS view, 3-21
V$BH view, 3-21
V$BUFFER_POOL view, 3-23
V$BUFFER_POOL_STATISTICS view, 3-24
V$CACHE view, 3-25
V$CACHE_LOCK view, 3-26
V$CACHE_TRANSFER view, 3-29
V$CIRCUIT view, 3-30
V$CLASS_CACHE_TRANSFER view, 3-31
V$COMPATIBILITY view, 3-31
V$COMPATSEG view, 3-32
V$CONTEXT view, 3-32
V$CONTROLFILE view, 3-32
V$CONTROLFILE_RECORD_SECTION view, 3-32
V$COPY_CORRUPTION view, 3-33
V$CR_BLOCK_SERVER view, 3-34
V$DATABASE view, 3-35
V$DATABASE_BLOCK_CORRUPTION view, 3-38
V$DATABASE_INCARNATION view, 3-39
V$DATAFILE view, 3-39
V$DATAFILE_COPY view, 3-41
V$DATAFILE_HEADER view, 3-42
V$DATAGUARD_STATUS view, 3-43
V$DB_CACHE_ADVICE view, 3-44
V$DB_OBJECT_CACHE view, 3-45
V$DB_PIPES view, 3-46
V$DBFILE view, 3-46
V$DBLINK view, 3-46
V$DELETED_OBJECT view, 3-47
V$DISPATCHER view, 3-47
V$DISPATCHER_RATE view, 3-48
V$ENABLEDPRIVS view, 3-53
V$ENQUEUE_LOCK view, 3-53
V$ENQUEUE_STAT view, 3-54
V$EVENT_NAME view, 3-55
V$EXECUTION view, 3-55
V$FALSE_PING view, 3-55
V$FAST_START_SERVERS view, 3-56
V$FAST_START_TRANSACTIONS view, 3-57
V$FILE_CACHE_TRANSFER view, 3-57
V$FILESTAT view, 3-58
V$FIXED_TABLE view, 3-59
V$FIXED_VIEW_DEFINITION view, 3-59
V$GC_ELEMENT view, 3-60
V$GC_ELEMENTS_WITH_COLLISIONS view, 3-60
V$GCSHVMASTER_INFO view, 3-61
V$GCSPFMASTER_INFO view, 3-61
V$GES_BLOCKING_ENQUEUE view, 3-61
V$GES_CONVERT_LOCAL view, 3-63
V$GES_CONVERT_REMOTE view, 3-63
V$GES_ENQUEUE view, 3-64
V$GES_LATCH view, 3-65
V$GES_RESOURCE view, 3-65
V$GES_STATISTICS view, 3-66
V$GLOBAL_BLOCKED_LOCKS view, 3-66
V$GLOBAL_TRANSACTION view, 3-66
V$HS_AGENT view, 3-67
V$HS_PARAMETER view, 3-67
V$HS_SESSION view, 3-68
V$HVMASTER_INFO view, 3-68
V$INDEXED_FIXED_COLUMN view, 3-68
V$INSTANCE view, 3-69
V$INSTANCE_RECOVERY view, 3-70
V$LATCH view, 3-71
V$LATCH_CHILDREN view, 3-72
V$LATCH_MISSES view, 3-73
V$LATCH_PARENT view, 3-74
V$LATCHHOLDER view, 3-74
V$LATCHNAME view, 3-74
V$LIBRARY_CACHE_MEMORY view, 3-75
V$LIBRARYCACHE view, 3-75
V$LICENSE view, 3-76
V$LOADISTAT view, 3-76
V$LOADPSTAT view, 3-76
V$LOCK view, 3-77
V$LOCK_ACTIVITY view, 3-79
V$LOCKED_OBJECT view, 3-79
V$LOG view, 3-80
V$LOG_HISTORY view, 3-81
V$LOGFILE view, 3-81
V$LOGHIST view, 3-82
V$LOGMNR_CONTENTS view, 3-82
V$LOGMNR_DICTIONARY view, 3-84
V$LOGMNR_LOGS view, 3-85
V$LOGMNR_PARAMETERS view, 3-86
V$LOGSTDBY view, 3-86
V$LOGSTDBY_STATS view, 3-87
V$MANAGED_STANDBY view, 3-87
V$MAP_COMP_LIST view, 3-89
V$MAP_ELEMENT view, 3-89
V$MAP_EXT_ELEMENT view, 3-90
V$MAP_FILE view, 3-91
V$MAP_FILE_EXTENT view, 3-91
V$MAP_FILE_IO_STACK view, 3-92
V$MAP_LIBRARY view, 3-92
V$MAP_SUBELEMENT view, 3-93
V$MTTR_TARGET_ADVICE view, 3-93
V$MVREFRESH view, 3-2
V$MYSTAT view, 3-94
V$NLS_PARAMETERS view, 3-95
V$NLS_VALID_VALUES view, 3-95
V$OBJECT_DEPENDENCY view, 3-95
V$OBJECT_USAGE view, 3-96
V$OBSOLETE_PARAMETER view, 3-96
V$OFFLINE_RANGE view, 3-96
V$OPEN_CURSOR view, 3-97
V$OPTION view, 3-97
V$PARALLEL_DEGREE_LIMIT_MTH view, 3-98
V$PARAMETER view, 3-98
V$PARAMETER2 view, 3-99
V$PGA_TARGET_ADVICE view, 3-100
V$PGA_TARGET_ADVICE_HISTOGRAM view, 3-101
V$PGASTAT view, 3-103
V$PQ_SESSTAT view, 3-106
V$PQ_SLAVE view, 3-106
V$PQ_SYSSTAT view, 3-107
V$PQ_TQSTAT view, 3-108
V$PROCESS view, 3-109
V$PROXY_ARCHIVEDLOG view, 3-110
V$PROXY_DATAFILE view, 3-111
V$PWFILE_USERS view, 3-113
V$PX_PROCESS view, 3-113
V$PX_PROCESS_SYSSTAT view, 3-113
V$PX_SESSION view, 3-115
V$PX_SESSTAT view, 3-115
V$QUEUE view, 3-116
V$QUEUEING_MTH view, 3-116
V$RECOVER_FILE view, 3-116
V$RECOVERY_FILE_STATUS view, 3-117
V$RECOVERY_LOG view, 3-117
V$RECOVERY_PROGRESS view, 3-118
V$RECOVERY_STATUS view, 3-118
V$REPLPROP view, 3-2
V$REPLQUEUE view, 3-2
V$REQDIST view, 3-119
V$RESERVED_WORDS view, 3-119
V$RESOURCE view, 3-120
V$RESOURCE_LIMIT view, 3-120
V$RMAN_CONFIGURATION view, 3-121
V$ROLLNAME view, 3-121
V$ROLLSTAT view, 3-122
V$ROWCACHE view, 3-122
V$ROWCACHE_PARENT view, 3-123
V$ROWCACHE_SUBORDINATE view, 3-124
V$RSRC_CONSUMER_GROUP view, 3-124
V$RSRC_CONSUMER_GROUP_CPU_MTH view, 3-125
V$RSRC_PLAN view, 3-126
V$RSRC_PLAN_CPU_MTH view, 3-126
V$SEGMENT_STATISTICS view, 3-127
V$SEGSTAT view, 3-127
V$SEGSTAT_NAME view, 3-127
V$SESS_IO view, 3-128
V$SESSION view, 3-128
V$SESSION_CONNECT_INFO view, 3-133
V$SESSION_CURSOR_CACHE view, 3-134
V$SESSION_EVENT view, 3-134, A-2
V$SESSION_LONGOPS view, 3-135
V$SESSION_OBJECT_CACHE view, 3-136
V$SESSION_WAIT view, 3-137, A-2
V$SESSTAT view, 3-138, C-1
V$SGA view, 3-139
V$SGA_CURRENT_RESIZE_OPS view, 3-139
V$SGA_DYNAMIC_COMPONENTS view, 3-140
V$SGA_DYNAMIC_FREE_MEMORY view, 3-141
V$SGA_RESIZE_OPS view, 3-140
V$SGASTAT view, 3-141
V$SHARED_POOL_ADVICE view, 3-142
V$SHARED_POOL_RESERVED view, 3-142
V$SHARED_SERVER view, 3-143
V$SHARED_SERVER_MONITOR view, 3-144
V$SORT_SEGMENT view, 3-145
V$SPPARAMETER view, 3-146
V$SQL view, 3-146
V$SQL_BIND_DATA view, 3-148
V$SQL_BIND_METADATA view, 3-149
V$SQL_CURSOR view, 3-149
V$SQL_PLAN view, 3-150
V$SQL_PLAN_STATISTICS view, 3-152
V$SQL_PLAN_STATISTICS_ALL view, 3-153
V$SQL_REDIRECTION view, 3-156
V$SQL_SHARED_CURSOR view, 3-157
V$SQL_SHARED_MEMORY view, 3-158
V$SQL_WORKAREA view, 3-159
V$SQL_WORKAREA_ACTIVE view, 3-160
V$SQL_WORKAREA_HISTOGRAM view, 3-162
V$SQLAREA view, 3-163
V$SQLTEXT view, 3-164
V$SQLTEXT_WITH_NEWLINES view, 3-165
V$STANDBY_LOG view, 3-165
V$STATISTICS_LEVEL view, 3-166
V$STATNAME view, 3-167, C-1
V$STREAMS_APPLY_COORDINATOR view, 3-168
V$STREAMS_APPLY_READER view, 3-169
V$STREAMS_APPLY_SERVER view, 3-170
V$STREAMS_CAPTURE view, 3-172
V$SUBCACHE view, 3-174
V$SYSSTAT view, 3-174, C-1
V$SYSTEM_CURSOR_CACHE view, 3-175
V$SYSTEM_EVENT view, 3-175, A-2
V$SYSTEM_PARAMETER view, 3-176
V$SYSTEM_PARAMETER2 view, 3-177
V$TABLESPACE view, 3-178
V$TEMP_CACHE_TRANSFER view, 3-178
V$TEMP_EXTENT_MAP view, 3-179
V$TEMP_EXTENT_POOL view, 3-180
V$TEMP_SPACE_HEADER view, 3-180
V$TEMPFILE view, 3-181
V$TEMPORARY_LOBS view, 3-181
V$TEMPSEG_USAGE view, 3-181
V$TEMPSTAT view, 3-182
V$THREAD view, 3-183
V$TIMER view, 3-184
V$TIMEZONE_NAMES view, 3-184
V$TRANSACTION view, 3-184
V$TRANSACTION_ENQUEUE view, 3-185
V$TYPE_SIZE view, 3-186
V$UNDOSTAT view, 3-187
V$VERSION view, 3-188
V$VPD_POLICY view, 3-188
V$WAITSTAT view, 3-189
views
data dictionary views, 2-1
data files, 1-60
virtual circuit status, A-51

W

wait events
alter system set dispatchers, A-17
batched allocate scn lock request, A-17
BFILE check if exists, A-17
BFILE check if open, A-17
BFILE closure, A-18
BFILE get length, A-18
BFILE get name object, A-18
BFILE get path object, A-18
BFILE internal seek, A-19
BFILE open, A-19
BFILE read, A-19
buffer busy waits, A-20
buffer deadlock, A-20
buffer for checkpoint, A-20
buffer latch, A-21
buffer read retry, A-21
checkpoint completed, A-22
checkpoint range buffer not saved, A-22
controlfile parallel write, A-22
controlfile sequential read, A-23
controlfile single write, A-23
conversion file read, A-24
db file parallel read, A-24
db file parallel write, A-24
db file scattered read, A-25
db file sequential read, A-25
db file single write, A-25
DFS db file lock, A-26
DFS lock handle, A-26
direct path read, A-26
direct path write, A-27
dispatcher shutdown, A-27
dispatcher timer, A-28
duplicate cluster key, A-28
enqueue, A-28
file identify, A-29
file open, A-29
free buffer waits, A-29
free global transaction table entry, A-29
free process state object, A-30
global cache busy, A-30
global cache freelist wait, A-31
global cache lock cleanup, A-30
global cache null to s, A-31
global cache null to x, A-31
global cache open s, A-31
global cache open x, A-32
global cache s to x, A-32
inactive session, A-32
inactive transaction branch, A-33
index block split, A-33
instance recovery, A-33
instance state change, A-34
io done, A-34
kcl bg acks, A-34
latch activity, A-35
latch free, A-35
library cache load lock, A-36
library cache lock, A-36
library cache pin, A-37
lock manager wait for remote message, A-37
log file parallel write, A-38
log file sequential read, A-38
log file single write, A-38
log file switch (archiving needed), A-39
log file switch (checkpoint incomplete), A-39
log file switch (clearing log file), A-39
log file switch completion, A-39
log file sync, A-39
log switch/archive, A-40
on-going SCN fetch to complete, A-40
parallel query create server, A-40
parallel query dequeue wait, A-40
parallel query qref latch, A-41
parallel query server shutdown, A-41
parallel query signal server, A-41
pending global transaction(s), A-42
pipe get, A-42
pipe put, A-42
PL/SQL lock timer, A-17, A-43
pmon rdomain attach, A-43
pmon timer, A-43
process startup, A-43
queue messages, A-44
rdbms ipc message, A-44
rdbms ipc message block, A-44
rdbms ipc reply, A-44
redo, A-45
row cache lock, A-45
scginq AST call, A-45
single-task message, A-45
smon timer, A-46
SQL*Net break/reset to client, A-46
SQL*Net break/reset to dblink, A-46
SQL*Net message from client, A-47
SQL*Net message from dblink, A-47
SQL*Net message to client, A-47
SQL*Net message to dblink, A-47
SQL*Net more data from client, A-48
SQL*Net more data from dblink, A-48
SQL*Net more data to client, A-48
SQL*Net more data to dblink, A-49
switch logfile command, A-49
timer in sksawat, A-49
transaction, A-49
unbound tx, A-50
undo segment extension, A-50
undo segment recovery, A-50
undo segment tx slot, A-50
wait events
log buffer space, A-37
WMON goes to sleep, A-17, A-51
write complete, A-51
writes stopped by instance recovery or database suspension, A-51
WM_INSTALLATION view, 2-3
WM_REPLICATION_INFO view, 2-3
WORKAREA_SIZE_POLICY initialization parameter, 1-170