Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

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-4
ALL_ARGUMENTS view, 2-6
ALL_ASSOCIATIONS view, 2-7
ALL_BASE_TABLE_MVIEWS view, 2-8
ALL_CATALOG view, 2-9
ALL_CLUSTER_HASH_EXPRESSIONS view, 2-9
ALL_CLUSTERS view, 2-10
ALL_COL_COMMENTS view, 2-11
ALL_COL_PRIVS view, 2-11
ALL_COL_PRIVS_MADE view, 2-12
ALL_COL_PRIVS_RECD view, 2-13
ALL_COLL_TYPES view, 2-13
ALL_CONS_COLUMNS view, 2-14
ALL_CONSTRAINTS view, 2-15
ALL_CONTEXT view, 2-16
ALL_DB_LINKS view, 2-17
ALL_DEF_AUDIT_OPTS view, 2-17
ALL_DEPENDENCIES view, 2-18
ALL_DIM_ATTRIBUTES view, 2-19
ALL_DIM_CHILD_OF view, 2-19
ALL_DIM_HIERARCHIES view, 2-20
ALL_DIM_JOIN_KEY view, 2-20
ALL_DIM_LEVEL_KEY view, 2-21
ALL_DIM_LEVELS view, 2-21
ALL_DIMENSIONS view, 2-22
ALL_DIRECTORIES view, 2-22
ALL_ERRORS view, 2-23
ALL_EXTERNAL_TABLES view, 2-23
ALL_HISTOGRAMS synonym for ALL_TAB_HISTOGRAMS view, 2-24
ALL_IND_COLUMNS view, 2-24
ALL_IND_EXPRESSIONS view, 2-25
ALL_IND_PARTITIONS view, 2-26
ALL_IND_SUBPARTITIONS view, 2-28
ALL_INDEXES view, 2-30
ALL_INDEXTYPE_COMMENTS view, 2-33
ALL_INDEXTYPE_OPERATORS view, 2-33
ALL_INDEXTYPES view, 2-34
ALL_INTERNAL_TRIGGERS view, 2-35
ALL_JOBS view, 2-35
ALL_JOIN_IND_COLUMNS view, 2-36
ALL_LIBRARIES view, 2-37
ALL_LOB_PARTITIONS view, 2-38
ALL_LOB_SUBPARTITIONS view, 2-39
ALL_LOBS view, 2-40
ALL_LOG_GROUP_COLUMNS view, 2-42
ALL_METHOD_PARAMS view, 2-43
ALL_METHOD_RESULTS view, 2-43
ALL_MVIEW_AGGREGATES view, 2-44
ALL_MVIEW_ANALYSIS view, 2-45
ALL_MVIEW_DETAIL_RELATIONS view, 2-47
ALL_MVIEW_JOINS view, 2-47
ALL_MVIEW_KEYS view, 2-48
ALL_MVIEW_REFRESH_TIMES view, 2-49
ALL_SNAPSHOT_REFRESH_TIMES synonym, 2-79
ALL_MVIEWS view, 2-50
ALL_NESTED_TABLES view, 2-53
ALL_OBJECT_TABLES view, 2-54
ALL_OBJECTS view, 2-56
ALL_OPANCILLARY view, 2-57
ALL_OPARGUMENTS view, 2-58
ALL_OPBINDINGS view, 2-58
ALL_OPERATOR_COMMENTS view, 2-59
ALL_OPERATORS view, 2-59
ALL_OUTLINE_HINTS view, 2-60
ALL_OUTLINES view, 2-60
ALL_PART_COL_STATISTICS view, 2-61
ALL_PART_HISTOGRAMS view, 2-62
ALL_PART_INDEXES view, 2-63
ALL_PART_KEY_COLUMNS view, 2-64
ALL_PART_LOBS view, 2-65
ALL_PART_TABLES view, 2-66
ALL_PARTIAL_DROP_TABS view, 2-68
ALL_POLICIES view, 2-68
ALL_PROCEDURES view, 2-69
ALL_PUBLISHED_COLUMNS view, 2-70
ALL_QUEUE_TABLES view, 2-71
ALL_QUEUES view, 2-72
ALL_REFRESH view, 2-73
ALL_REFRESH_CHILDREN view, 2-74
ALL_REFRESH_DEPENDENCIES view, 2-75
ALL_REFS view, 2-75
ALL_REGISTERED_MVIEWS view, 2-76
ALL_REGISTERED_SNAPSHOTS view, 2-77
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_SEQUENCES view, 2-78
ALL_SNAPSHOT_LOGS view, 2-78
ALL_SNAPSHOT_REFRESH_TIMES synonym for ALL_MVIEW_REFRESH_TIMES view, 2-79
ALL_SOURCE view, 2-79
ALL_SOURCE_TABLES view, 2-80
ALL_SQLJ_TYPE_ATTRS view, 2-80
ALL_SQLJ_TYPE_METHODS view, 2-81
ALL_SQLJ_TYPES view, 2-82
ALL_STORED_SETTINGS view, 2-82
ALL_SUBPART_COL_STATISTICS view, 2-83
ALL_SUBPART_HISTOGRAMS view, 2-84
ALL_SUBPART_KEY_COLUMNS view, 2-85
ALL_SUBSCRIBED_COLUMNS view, 2-85
ALL_SUBSCRIBED_TABLES view, 2-86
ALL_SUBSCRIPTIONS view, 2-86
ALL_SUMDELTA view, 2-87
ALL_SYNONYMS view, 2-88
ALL_TAB_COL_STATISTICS view, 2-88
ALL_TAB_COLUMNS view, 2-89
ALL_TAB_COMMENTS view, 2-91
ALL_TAB_HISTOGRAMS view, 2-91
ALL_HISTOGRAMS synonym, 2-24
ALL_TAB_MODIFICATIONS view, 2-92
ALL_TAB_PARTITIONS view, 2-93
ALL_TAB_PRIVS view, 2-95
ALL_TAB_PRIVS_MADE view, 2-95
ALL_TAB_PRIVS_RECD view, 2-96
ALL_TAB_SUBPARTITIONS view, 2-96
ALL_TABLES view, 2-98
ALL_TRIGGER_COLS view, 2-101
ALL_TRIGGERS view, 2-101
ALL_TYPE_ATTRS view, 2-102
ALL_TYPE_METHODS view, 2-103
ALL_TYPES view, 2-104
ALL_UNUSED_COL_TABS view, 2-105
ALL_UPDATABLE_COLUMNS view, 2-105
ALL_USERS view, 2-106
ALL_USTATS view, 2-106
ALL_VARRAYS view, 2-107
ALL_VIEWS view, 2-108
ALLOCATE EXTENT clause
of ALTER TABLE
instance number, 1-66
allocation
PCM locks, 1-59
ALTER DATABASE statement
ADD LOGFILE, 1-165
database name, 1-44
ENABLE THREAD, 1-165
THREAD, 1-165
ALTER SESSION statement
SET HASH_AREA_SIZE clause, 1-62
SET HASH_JOIN_ENABLED clause, 1-62
ALTER TABLE statement
allocating extents, 1-66
ANALYZE statement, 2-30, 2-89, 2-91, 2-98, 2-130, 2-160, 2-161, 2-213, 2-215
AQ_TM_PROCESSES initialization parameter, 1-15
ARCHIVE LOG START statement
automatic archiving, 1-74
ARCHIVE_LAG_TARGET initialization parameter, 1-16
archived redo logs
automatic versus manual, 1-82
destination file, 1-74
storage device, 1-74, 1-79
ARCHIVELOG mode, 1-74
archiving destination, 1-74, 1-79
automatic archiving, 1-82
AUDIT_ACTIONS table, 2-108
AUDIT_FILE_DEST initialization parameter, 1-17
AUDIT_TRAIL initialization parameter, 1-17
authenticating remote clients, 1-145
authenticating users, 1-123

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-20
blocks
PCM lock, 1-59
redo log, 1-85
size, 1-33, 1-36, 1-44, 4-2
BUFFER_POOL_KEEP initialization parameter, 1-21
BUFFER_POOL_RECYCLE initialization parameter, 1-22

C

cache
dictionary, 3-84, 3-104, 3-105, 3-106, 3-107, 3-108
statistics, 1-85
CAT synonym for USER_CATALOG view, 2-109
CATALOG view, 2-109
CATALOG.SQL script, 5-2
creating V$ views, 3-1
CATAUDIT.SQL script
audit trail records created by, 2-194
audit trails for connections and disconnections, 2-195
auditing characteristics described by, 2-204
CATBLOCK.SQL script, 5-3
CATCLUSTDB.SQL script, 5-3
CATEXP7.SQL script, 5-3
CATHS.SQL script, 5-3
CATIO.SQL script, 5-3
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 view, 2-109
CHANGE_SETS view, 2-110
CHANGE_SOURCES view, 2-110
CHANGE_TABLES view, 2-111
characters
numeric group separators, 1-107
checkpoints
checkpoint interval, 1-85
statistics, 1-85
CIRCUITS initialization parameter, 1-23
CLU synonym for USER_CLUSTERS view, 2-111
CLUSTER_DATABASE initialization parameter, 1-24
CLUSTER_DATABASE_INSTANCES initialization parameter, 1-24
CLUSTER_INTERCONNECTS initialization parameter, 1-25
CODE_PIECES view, 2-111
CODE_SIZE view, 2-112
COL view, 2-112
COLS synonym for USER_TAB_COLUMNS view, 2-112
COLUMN_PRIVILEGES view, 2-112
COMMIT_POINT_STRENGTH initialization parameter, 1-26
COMPATIBLE initialization parameter, 1-27
concurrency
ROW_LOCKING initialization parameter, 1-149
contention
block-level, 3-151
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-118
favoring IN-list iterators, 1-116
CPU_COUNT initialization parameter, 1-29
CREATE DATABASE statement
database name, 1-44
setting the log mode, 1-82
CREATE TABLE statement
FREELIST GROUPS clause, 1-66
CREATE_BITMAP_AREA_SIZE initialization parameter, 1-30
creating
a database
setting block size, 1-33, 1-36, 1-44
currency, 1-102
international currency symbol, 1-104
CURSOR_SHARING initialization parameter, 1-31
CURSOR_SPACE_FOR_TIME initialization parameter, 1-32
cursors
OPEN_CURSORS initialization parameter, 1-112
shared pool, 1-63, 1-155, 1-156

D

D0801050.SQL script, 5-7
D0801060.SQL script, 5-7
D0801070.SQL script, 5-7
data blocks
reading multiple, 1-40
size of, 1-33, 1-36, 1-44
data dictionary, 2-1
cache, 3-84, 3-104, 3-105, 3-106, 3-107, 3-108
datafiles, 1-59
DICTIONARY view, 2-182
scripts, 5-3
SQL scripts, 5-2
tables, 2-1
views, 1-59
overview, 2-1
user views, 2-1
database writer process (DBWR)
checkpoint, 1-85
DATABASE_PROPERTIES view, 2-112
databases
block size, 4-2
database limits, 4-1
default language, 1-105
name, 1-44, 1-45, 1-46
resource limits, 1-147
valid characters for database name, 1-44
datafiles
mapping blocks to PCM locks, 1-59
maximum number, 1-43
parameter, 1-43
unspecified for PCM locks, 1-59
dates
language used for, 1-103, 1-109, 1-110
setting SYSDATE, 1-58
TO_CHAR function, 1-103
TO_DATE function, 1-103
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-33
DB_RECYCLE_CACHE_SIZE initialization parameter, 1-45
DB_WRITER_PROCESSES initialization parameter, 1-46
DBA_2PC_NEIGHBORS view, 2-113
DBA_2PC_PENDING view, 2-113
DBA_ALL_TABLES view, 2-114
DBA_APPLICATION_ROLES view, 2-114
DBA_ASSOCIATIONS view, 2-114
DBA_AUDIT_EXISTS view, 2-114
DBA_AUDIT_OBJECT view, 2-115
DBA_AUDIT_SESSION view, 2-117
DBA_AUDIT_STATEMENT view, 2-117
DBA_AUDIT_TRAIL view, 2-119
DBA_BASE_TABLE_MVIEWS view, 2-121
DBA_BLOCKERS view, 2-121
DBA_CATALOG view, 2-121
DBA_CLU_COLUMNS view, 2-121
DBA_CLUSTER_HASH_EXPRESSIONS view, 2-122
DBA_CLUSTERS view, 2-122
DBA_COL_COMMENTS view, 2-122
DBA_COL_PRIVS view, 2-122
DBA_COLL_TYPES view, 2-122
DBA_CONS_COLUMNS view, 2-122
DBA_CONSTRAINTS view, 2-122
DBA_CONTEXT view, 2-123
DBA_DATA_FILES view, 1-59, 2-123, 2-172
DBA_DB_LINKS view, 2-123
DBA_DDL_LOCKS view, 2-123
DBA_DEPENDENCIES view, 2-124
DBA_DIM_ATTRIBUTES view, 2-124
DBA_DIM_CHILD_OF view, 2-124
DBA_DIM_HIERARCHIES view, 2-124
DBA_DIM_JOIN_KEY view, 2-125
DBA_DIM_LEVEL_KEY view, 2-125
DBA_DIM_LEVELS view, 2-125
DBA_DIMENSIONS view, 2-125
DBA_DIRECTORIES view, 2-125
DBA_DML_LOCKS view, 2-125
DBA_ERRORS view, 2-126
DBA_EXP_FILES view, 2-126
DBA_EXP_OBJECTS view, 2-127
DBA_EXP_VERSION view, 2-127
DBA_EXTENTS view, 2-127
DBA_EXTERNAL_TABLES view, 2-128
DBA_FREE_SPACE view, 2-128
DBA_FREE_SPACE_COALESCED view, 2-128
DBA_HISTOGRAMS synonym for DBA_TAB_HISTOGRAMS view, 2-129
DBA_IND_COLUMNS view, 2-129
DBA_IND_EXPRESSIONS view, 2-129
DBA_IND_PARTITIONS view, 2-129
DBA_IND_SUBPARTITIONS view, 2-130
DBA_INDEXES view, 2-130
collecting statistics for, 2-130
DBA_INDEXTYPE_COMMENTS view, 2-130
DBA_INDEXTYPE_OPERATORS view, 2-130
DBA_INDEXTYPES view, 2-130
DBA_INTERNAL_TRIGGERS view, 2-130
DBA_JOBS view, 2-131
DBA_JOBS_RUNNING view, 2-131
DBA_JOIN_IND_COLUMNS view, 2-131
DBA_KGLLOCK view, 2-131
DBA_LIBRARIES view, 2-132
DBA_LOB_PARTITIONS view, 2-132
DBA_LOB_SUBPARTITIONS view, 2-132
DBA_LOBS view, 2-132
DBA_LOCK_INTERNAL view, 2-132
DBA_LOCKS view, 2-133
DBA_LOG_GROUP_COLUMNS view, 2-133
DBA_METHOD_PARAMS view, 2-134
DBA_METHOD_RESULTS view, 2-134
DBA_MVIEW_AGGREGATES view, 2-134
DBA_MVIEW_ANALYSIS view, 2-134
DBA_MVIEW_DETAIL_RELATIONS view, 2-134
DBA_MVIEW_JOINS view, 2-135
DBA_MVIEW_KEYS view, 2-135
DBA_MVIEW_LOG_FILTER_COLS view, 2-135
DBA_SNAPSHOT_LOG_FILTER_COLS synonym, 2-156
DBA_MVIEW_REFRESH_TIMES view, 2-135
DBA_SNAPSHOT_REFRESH_TIMES synonym, 2-156
DBA_MVIEWS view, 2-135
DBA_NESTED_TABLES view, 2-136
DBA_OBJ_AUDIT_OPTS view, 2-136
DBA_OBJECT_SIZE view, 2-137
DBA_OBJECT_TABLES view, 2-137
DBA_OBJECTS view, 2-137
DBA_OPANCILLARY view, 2-137
DBA_OPARGUMENTS view, 2-138
DBA_OPBINDINGS view, 2-138
DBA_OPERATOR_COMMENTS view, 2-138
DBA_OPERATORS view, 2-138
DBA_OUTLINE_HINTS view, 2-139
DBA_OUTLINES view, 2-139
DBA_PART_COL_STATISTICS view, 2-139
DBA_PART_HISTOGRAMS view, 2-139
DBA_PART_INDEXES view, 2-139
DBA_PART_KEY_COLUMNS view, 2-140
DBA_PART_LOBS view, 2-140
DBA_PART_TABLES view, 2-140
DBA_PARTIAL_DROP_TABS view, 2-140
DBA_PENDING_TRANSACTIONS view, 2-140
DBA_POLICIES view, 2-140
DBA_PRIV_AUDIT_OPTS view, 2-141
DBA_PROCEDURES view, 2-141
DBA_PROFILES view, 2-141
DBA_PROXIES view, 2-141
DBA_PUBLISHED_COLUMNS view, 2-142
DBA_QUEUE_SCHEDULES view, 2-143
DBA_QUEUE_TABLES view, 2-144
DBA_QUEUES view, 2-145
DBA_RCHILD view, 2-145
DBA_REFRESH view, 2-145
DBA_REFRESH_CHILDREN view, 2-145
DBA_REFS view, 2-145
DBA_REGISTERED_MVIEW_GROUPS view, 2-146
DBA_REGISTERED_MVIEWS view, 2-146
DBA_REGISTERED_SNAPSHOT_GROUPS view, 2-146
DBA_REGISTERED_SNAPSHOTS view, 2-146
DBA_REPAIR_TABLE view, 2-147
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-148
DBA_RGROUP view, 2-150
DBA_ROLE_PRIVS view, 2-150
DBA_ROLES view, 2-151
DBA_ROLLBACK_SEGS view, 2-151
DBA_RSRC_CONSUMER_GROUP_PRIVS view, 2-151
DBA_RSRC_CONSUMER_GROUPS view, 2-152
DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 2-152
DBA_RSRC_PLAN_DIRECTIVES view, 2-153
DBA_RSRC_PLANS view, 2-154
DBA_SEGMENTS view, 2-155
DBA_SEQUENCES view, 2-156
DBA_SNAPSHOT_LOG_FILTER_COLS synonym for DBA_MVIEW_LOG_FILTER_COLS view, 2-156
DBA_SNAPSHOT_LOGS view, 2-156
DBA_SNAPSHOT_REFRESH_TIMES synonym for DBA_MVIEW_REFRESH_TIMES view, 2-156
DBA_SNAPSHOTS view, 2-156
DBA_SOURCE view, 2-157
DBA_SOURCE_TABLES view, 2-157
DBA_SQLJ_TYPE_ATTRS view, 2-157
DBA_SQLJ_TYPE_METHODS view, 2-157
DBA_SQLJ_TYPES view, 2-157
DBA_STMT_AUDIT_OPTS view, 2-157
DBA_SUBPART_COL_STATISTICS view, 2-158
DBA_SUBPART_HISTOGRAMS view, 2-158
DBA_SUBPART_KEY_COLUMNS view, 2-158
DBA_SUBSCRIBED_COLUMNS view, 2-158
DBA_SUBSCRIBED_TABLES view, 2-159
DBA_SUBSCRIPTIONS view, 2-159
DBA_SYNONYMS view, 2-159
DBA_SYS_PRIVS view, 2-159
DBA_TAB_COL_STATISTICS view, 2-160
DBA_TAB_COLUMNS view, 2-160
DBA_TAB_COMMENTS view, 2-160
DBA_TAB_HISTOGRAMS view, 2-160
DBA_HISTOGRAMS synonym, 2-129
DBA_TAB_MODIFICATIONS view, 2-160
DBA_TAB_PARTITIONS view, 2-160
DBA_TAB_PRIVS view, 2-161
DBA_TAB_SUBPARTITIONS view, 2-161
DBA_TABLES view, 2-161
DBA_TABLESPACES view, 2-161
DBA_TEMP_FILES view, 2-162
DBA_TRANSFORMATIONS view, 2-163
DBA_TRIGGER_COLS view, 2-164
DBA_TRIGGERS view, 2-164
DBA_TS_QUOTAS view, 2-164
DBA_TYPE_ATTRS view, 2-164
DBA_TYPE_METHODS view, 2-164
DBA_TYPES view, 2-165
DBA_UNDO_EXTENTS view, 2-165
DBA_UNUSED_COL_TABS view, 2-165
DBA_UPDATABLE_COLUMNS view, 2-165
DBA_USERS view, 2-166
DBA_USTATS view, 2-166
DBA_VARRAYS view, 2-167
DBA_VIEWS view, 2-167
DBA_WAITERS view, 2-167
DBLINK_ENCRYPT_LOGIN initialization parameter, 1-46
DBMS_ALERT_INFO view, 2-167
DBMS_LOCK_ALLOCATED view, 2-168
DBMSIOTC.SQL script, 5-3
DBMSOTRC.SQL script, 5-3
DBMSPOOL.SQL script, 5-4
DBWR_IO_SLAVES initialization parameter, 1-47
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-168
destination
archiving redo log files, 1-74
overriding default, 1-74
USER_DUMP_DEST, 1-174
DICT synonym for DICTIONARY, 2-168
DICT_COLUMNS view, 2-168
DICTIONARY view, 2-169
DICT synonym, 2-168
disk drives
archiving destination, 1-74
DISK_ASYNCH_IO initialization parameter, 1-47
dispatcher processes
maximum number, 1-91, 1-98
DISPATCHERS initialization parameter, 1-48
distinguished name, 1-140
distributed transactions
limiting number of, 1-52
DISTRIBUTED_TRANSACTIONS initialization parameter, 1-52
DML_LOCKS initialization parameter, 1-52
DRS_START initialization parameter, 1-53
dump files, 1-91
dynamic performance tables
CATALOG.SQL script, 3-1
public synonyms (V$), 3-2
views (V_$), 3-2

E

embedded parameter files, 1-64
ENQUEUE_RESOURCES initialization parameter, 1-54
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-52
distributed recovery, B-1
distributed TX, B-1
DML, B-1
ENQUEUE_RESOURCES initialization parameter, 1-53, 1-54
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-140
ERROR_SIZE view, 2-169
errors
archiving, 1-82
EVENT initialization parameter, 1-55
EXCEPTIONS view, 2-169
exclusive mode
specifying instance number, 1-66
extent
allocating to instance, 1-66

F

FAL_CLIENT initialization parameter, 1-55
FAL_SERVER initialization parameter, 1-56
FAST_START_IO_TARGET initialization parameter, 1-56
FAST_START_MTTR_TARGET initialization parameter, 1-57
FAST_START_PARALLEL_ROLLBACK initialization parameter, 1-58
FILE_LOCK view, 2-169
FILE_PING view, 2-170
filenames
case significance, 1-3
name and number, 1-59
FILEXT$ view, 2-172
FIXED_DATE initialization parameter, 1-58
free space list
locating space, 1-66
FREELIST GROUPS clause, 1-66

G

GC_FILES_TO_LOCKS initialization parameter, 1-59
global cache control parameters, 1-11
GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1-61
GLOBAL_NAME view, 2-172
GLOBAL_NAMES initialization parameter, 1-61
GV$ views
for parallel servers, 3-2

H

HASH_AREA_SIZE initialization parameter, 1-62
HASH_JOIN_ENABLED initialization parameter, 1-62
Heterogeneous Services
agents, 1-63
parameters, 1-12
HI_SHARED_MEMORY_ADDRESS initialization parameter, 1-63
hints
RULE, 1-118
HS_ALL_CAPS view, 2-172
HS_ALL_DD view, 2-173
HS_ALL_INITS view, 2-173
HS_AUTOREGISTER initialization parameter, 1-63
HS_BASE_CAPS view, 2-173
HS_BASE_DD view, 2-174
HS_CLASS_CAPS view, 2-174
HS_CLASS_DD view, 2-174
HS_CLASS_INIT view, 2-175
HS_EXTERNAL_OBJECT_PRIVILEGES view, 2-175
HS_EXTERNAL_OBJECTS view, 2-176
HS_EXTERNAL_USER_PRIVILEGES view, 2-176
HS_FDS_CLASS view, 2-176
HS_FDS_INST view, 2-177
HS_INST_CAPS view, 2-177
HS_INST_DD view, 2-177
HS_INST_INIT view, 2-178

I

IDEPTREE view, 2-178
IFILE initialization parameter, 1-4, 1-64
IND synonym for USER_INDEXES view, 2-179
INDEX_HISTOGRAM view, 2-179
INDEX_STATS view, 2-179
initialization parameter file, 1-2
common file, 1-64
embedded, 1-64
INITDW.ORA, 1-2
line continuation character (), 1-4
initialization parameters
ACTIVE_INSTANCE_COUNT, 1-15
altering, 1-6
AQ_TM_PROCESSES, 1-15
ARCHIVE_LAG_TARGET, 1-16
AUDIT_FILE_DEST, 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-20
BUFFER_POOL_KEEP, 1-21
BUFFER_POOL_RECYCLE, 1-22
case significance in filenames, 1-3
CIRCUITS, 1-23
CLUSTER_DATABASE, 1-24
CLUSTER_DATABASE_INSTANCES, 1-24
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-32
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-33
DB_RECYCLE_CACHE_SIZE, 1-45
DB_WRITER_PROCESSES, 1-46
DBLINK_ENCRYPT_LOGIN, 1-46
DBWR_IO_SLAVES, 1-47
derived, 1-10
DISK_ASYNCH_IO, 1-47
DISPATCHERS, 1-48
display current settings, 1-9
DISTRIBUTED_TRANSACTIONS, 1-52
DML_LOCKS, 1-52
DRS_START, 1-53
dynamic, 1-6
ENQUEUE_RESOURCES, 1-54
EVENT, 1-55
FAL_CLIENT, 1-55
FAL_SERVER, 1-56
FAST_START_IO_TARGET, 1-56
FAST_START_MTTR_TARGET, 1-57
FAST_START_PARALLEL_ROLLBACK, 1-58
files, 1-2
FIXED_DATE, 1-58
GC parameters, 1-11
GC_FILES_TO_LOCKS, 1-59
global cache, 1-11
global constant parameters, 1-11
GLOBAL_CONTEXT_POOL_SIZE, 1-61
GLOBAL_NAMES, 1-61
HASH_AREA_SIZE, 1-62
HASH_JOIN_ENABLED, 1-62
HI_SHARED_MEMORY_ADDRESS, 1-63
HS_AUTOREGISTER, 1-63
IFILE, 1-4, 1-64
INSTANCE_GROUPS, 1-65
INSTANCE_NAME, 1-65
INSTANCE_NUMBER, 1-66
JAVA_MAX_SESSIONSPACE_SIZE, 1-67
JAVA_POOL_SIZE, 1-67
JAVA_SOFT_SESSIONSPACE_LIMIT, 1-68
JOB_QUEUE_PROCESSES, 1-68
LARGE_POOL_SIZE, 1-69
LICENSE_MAX_SESSIONS, 1-70
LICENSE_MAX_USERS, 1-71
LICENSE_SESSIONS_WARNING, 1-71
LOCAL_LISTENER, 1-72
LOCK_NAME_SPACE, 1-73
LOCK_SGA, 1-73
LOG_ARCHIVE_DEST, 1-74
LOG_ARCHIVE_DEST_n, 1-75
LOG_ARCHIVE_DEST_STATE_n, 1-77
LOG_ARCHIVE_DUPLEX_DEST, 1-78
LOG_ARCHIVE_FORMAT, 1-79
LOG_ARCHIVE_MAX_PROCESSES, 1-80
LOG_ARCHIVE_MIN_SUCCEED_DEST, 1-81
LOG_ARCHIVE_START, 1-82
LOG_ARCHIVE_TRACE, 1-83
LOG_BUFFER, 1-84
LOG_CHECKPOINT_INTERVAL, 1-85
LOG_CHECKPOINT_TIMEOUT, 1-86
LOG_CHECKPOINTS_TO_ALERT, 1-87
LOG_FILE_NAME_CONVERT, 1-88
LOGMNR_MAX_PERSISTENT_SESSIONS, 1-89
MAX_COMMIT_PROPAGATION_DELAY, 1-90
MAX_DISPATCHERS, 1-91
MAX_DUMP_FILE_SIZE, 1-91
MAX_ENABLED_ROLES, 1-92
MAX_ROLLBACK_SEGMENTS, 1-92
MAX_SHARED_SERVERS, 1-93
MTS_CIRCUITS, 1-93
MTS_DISPATCHERS, 1-94
MTS_MAX_DISPATCHERS, 1-98
MTS_MAX_SERVERS, 1-99
MTS_SERVERS, 1-99
MTS_SESSIONS, 1-100
NLS_CALENDAR, 1-101
NLS_COMP, 1-102
NLS_CURRENCY, 1-102
NLS_DATE_FORMAT, 1-103
NLS_DATE_LANGUAGE, 1-103
NLS_DUAL_CURRENCY, 1-104
NLS_ISO_CURRENCY, 1-104
NLS_LANGUAGE, 1-105
NLS_LENGTH_SEMANTICS, 1-105
NLS_NCHAR_CONV_EXCP, 1-106
NLS_NUMERIC_CHARACTERS, 1-107
NLS_SORT, 1-107
NLS_TERRITORY, 1-108
NLS_TIMESTAMP_FORMAT, 1-109
NLS_TIMESTAMP_TZ_FORMAT, 1-110
O7_DICTIONARY_ACCESSIBILITY, 1-110
OBJECT_CACHE_MAX_SIZE_PERCENT, 1-111
OBJECT_CACHE_OPTIMAL_SIZE, 1-112
OPEN_CURSORS, 1-112
OPEN_LINKS, 1-113
operating system-dependent values, 1-11
OPTIMIZER_FEATURES_ENABLE, 1-115
OPTIMIZER_INDEX_CACHING, 1-116
OPTIMIZER_INDEX_COST_ADJ, 1-117
OPTIMIZER_MAX_PERMUTATIONS, 1-117
OPTIMIZER_MODE, 1-118
ORACLE_TRACE_COLLECTION_NAME, 1-119
ORACLE_TRACE_COLLECTION_PATH, 1-120
ORACLE_TRACE_COLLECTION_SIZE, 1-120
ORACLE_TRACE_ENABLE, 1-121
ORACLE_TRACE_FACILITY_NAME, 1-122
ORACLE_TRACE_FACILITY_PATH, 1-123
OS_AUTHENT_PREFIX, 1-123
OS_ROLES, 1-124
overview, 1-2
PARALLEL_ADAPTIVE_MULTI_USER, 1-125
PARALLEL_AUTOMATIC_TUNING, 1-126
PARALLEL_BROADCAST_ENABLED, 1-126
PARALLEL_EXECUTION_MESSAGE_SIZE, 1-127
PARALLEL_INSTANCE_GROUP, 1-128
PARALLEL_MAX_SERVERS, 1-128
PARALLEL_MIN_PERCENT, 1-129
PARALLEL_MIN_SERVERS, 1-130
PARALLEL_THREADS_PER_CPU, 1-131
PARTITION_VIEW_ENABLED, 1-131
performance tuning, 1-11
PGA_AGGREGATE_TARGET, 1-132
PLSQL_COMPILER_FLAGS, 1-133
PLSQL_NATIVE_C_COMPILER, 1-134
PLSQL_NATIVE_LIBRARY_DIR, 1-134
PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT, 1-135
PLSQL_NATIVE_LINKER, 1-135
PLSQL_NATIVE_MAKE_FILE_NAME, 1-136
PLSQL_NATIVE_MAKE_UTILITY, 1-136
PLSQL_V2_COMPATIBILITY, 1-137
PRE_PAGE_SGA, 1-137
PROCESSES, 1-138
QUERY_REWRITE_ENABLED, 1-139
QUERY_REWRITE_INTEGRITY, 1-140
RDBMS_SERVER_DN, 1-140
READ_ONLY_OPEN_DELAYED, 1-141
RECOVERY_PARALLELISM, 1-142
REMOTE_ARCHIVE_ENABLE, 1-142
REMOTE_DEPENDENCIES_MODE, 1-142
REMOTE_LISTENER, 1-143
REMOTE_LOGIN_PASSWORDFILE, 1-144
REMOTE_OS_AUTHENT, 1-145
REMOTE_OS_ROLES, 1-145
REPLICATION_DEPENDENCY_TRACKING, 1-146
RESOURCE_LIMIT, 1-147
RESOURCE_MANAGER_PLAN, 1-147
ROLLBACK_SEGMENTS, 1-148
ROW_LOCKING, 1-149
SERIAL_REUSE, 1-150
SERVICE_NAMES, 1-151
SESSION_CACHED_CURSORS, 1-152
SESSION_MAX_OPEN_FILES, 1-152
SESSIONS, 1-153
SGA_MAX_SIZE, 1-154
SHADOW_CORE_DUMP, 1-154
SHARED_MEMORY_ADDRESS, 1-155
SHARED_POOL_RESERVED_SIZE, 1-155, 3-118
SHARED_POOL_SIZE, 1-156
SHARED_SERVER_SESSIONS, 1-157
SHARED_SERVERS, 1-157
SORT_AREA_RETAINED_SIZE, 1-157
SORT_AREA_SIZE, 1-159
specifying in parameter files, 1-3
SPFILE, 1-160
SQL_TRACE, 1-161
SQL92_SECURITY, 1-161
STANDBY_ARCHIVE_DEST, 1-162
STANDBY_FILE_MANAGEMENT, 1-163
STANDBY_PRESERVES_NAMES, 1-163
STAR_TRANSFORMATION_ENABLED, 1-164
TAPE_ASYNCH_IO, 1-165
THREAD, 1-165
TIMED_OS_STATISTICS, 1-166
TIMED_STATISTICS, 1-167
TRACE_ENABLED, 1-168
TRACEFILE_IDENTIFIER, 1-169
TRANSACTION_AUDITING, 1-169
TRANSACTIONS, 1-170
TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1-171
UNDO_MANAGEMENT, 1-171
UNDO_RETENTION, 1-172
UNDO_SUPPRESS_ERRORS, 1-173
UNDO_TABLESPACE, 1-173
USE_INDIRECT_DATA_BUFFERS, 1-174
USER_DUMP_DEST, 1-174
UTL_FILE_DIR, 1-175
variable, 1-11
WORKAREA_SIZE_POLICY, 1-176
INITJVM.SQL script, 5-8
INIT.ORA file. See initialization parameter file
IN-list iterators
optimizer use of, 1-116
inserts
locating free space, 1-66
INST_ID column, 3-2
INSTANCE clause
of ALTER TABLE
allocating extents, 1-66
INSTANCE_GROUPS initialization parameter, 1-65
INSTANCE_NAME initialization parameter, 1-65
INSTANCE_NUMBER initialization parameter, 1-66
exclusive or parallel mode, 1-66
instances
checkpoint, 1-85
startup order, 1-66
I/O
reading multiple blocks, 1-40
redo log files, 1-84

J

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

L

language
database default language, 1-105
LARGE_POOL_SIZE initialization parameter, 1-69
LICENSE_MAX_SESSIONS initialization parameter, 1-70
LICENSE_MAX_USERS initialization parameter, 1-71
LICENSE_SESSIONS_WARNING initialization parameter, 1-71
licenses
maximum sessions, 1-70
maximum users, 1-71
warning for concurrent user sessions, 1-71
limits on the database, 4-1
linguistic sorts, 1-107
local currency, 1-102
LOCAL_LISTENER initialization parameter, 1-72
lock
conversion, 3-23
LOCK_NAME_SPACE initialization parameter, 1-73
LOCK_SGA initialization parameter, 1-73
locks
conversion, 3-17, 3-21, 3-24, 3-53, 3-87
names, A-11
on KGL objects, 2-131
table lock, 1-149
LOG_ARCHIVE_DEST initialization parameter, 1-74
LOG_ARCHIVE_DEST_n initialization parameter, 1-75
LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1-77
LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1-78
LOG_ARCHIVE_FORMAT initialization parameter, 1-79
LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1-80
LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1-81
LOG_ARCHIVE_START initialization parameter, 1-82
LOG_ARCHIVE_TRACE initialization parameter, 1-83
LOG_BUFFER initialization parameter, 1-84
LOG_CHECKPOINT_INTERVAL initialization parameter, 1-85
LOG_CHECKPOINT_TIMEOUT initialization parameter, 1-86
LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1-87
LOG_FILE_NAME_CONVERT initialization parameter, 1-88
LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 1-89
lowercase significance, 1-3

M

manual archiving, 1-82
MAX_COMMIT_PROPAGATION_DELAY initialization parameter, 1-90
MAX_DISPATCHERS initialization parameter, 1-91
MAX_DUMP_FILE_SIZE initialization parameter, 1-91
MAX_ENABLED_ROLES initialization parameter, 1-92
MAX_ROLLBACK_SEGMENTS initialization parameter, 1-92
MAX_SHARED_SERVERS initialization parameter, 1-93
memory
amount used for sorting, 1-157
virtual, 1-12
migration
scripts, 5-7
modes
archiving, 1-82
monitor
performance, 1-85
MTS_CIRCUITS initialization parameter, 1-93
MTS_DISPATCHERS initialization parameter, 1-94
MTS_MAX_DISPATCHERS initialization parameter, 1-98
MTS_MAX_SERVERS initialization parameter, 1-99
MTS_SERVERS initialization parameter, 1-99
MTS_SESSIONS initialization parameter, 1-100
multiple-process systems
number of processes, 1-138

N

nested files, 1-64
NLS_CALENDAR initialization parameter, 1-101
NLS_COMP initialization parameter, 1-102
NLS_CURRENCY initialization parameter, 1-102
defined by NLS_TERRITORY, 1-108
NLS_DATABASE_PARAMETERS view, 2-180
NLS_DATE_FORMAT initialization parameter, 1-103
defined by NLS_NUMERIC_CHARACTERS, 1-108
defined by NLS_TERRITORY, 1-108
NLS_DATE_LANGUAGE initialization parameter, 1-103
NLS_DUAL_CURRENCY initialization parameter, 1-104
NLS_INSTANCE_PARAMETERS view, 2-181
NLS_ISO_CURRENCY initialization parameter, 1-104
defined by NLS_TERRITORY, 1-108
NLS_LANGUAGE initialization parameter, 1-105
NLS_LENGTH_SEMANTICS initialization parameter, 1-105
NLS_NCHAR_CONV_EXCP initialization parameter, 1-106
NLS_NUMERIC_CHARACTERS initialization parameter, 1-107
NLS_SESSION_PARAMETERS view, 2-181
NLS_SORT initialization parameter, 1-107
NLS_TERRITORY initialization parameter, 1-108
NLS_TIMESTAMP_FORMAT initialization parameter, 1-109
NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1-110
NOARCHIVELOG mode
creating a database, 1-82
numeric group separators, 1-107

O

O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1-110
OBJ synonym for USER_OBJECTS view, 2-181
OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1-111
OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1-112
objects
data dictionary, 2-1
online redo log
archiving, 1-82
archiving mode, 1-74
block, 1-85
file size, 1-85
number of files, 1-82
setting checkpoint interval, 1-85
OPEN_CURSORS initialization parameter, 1-112
OPEN_LINKS initialization parameter, 1-113
operating system
authenticating remote clients, 1-145
authenticating users and passwords, 1-123
dependent parameters, 1-11
roles for remote clients, 1-145
optimization
trading cursor space for time, 1-32
OPTIMIZER_FEATURES_ENABLE initialization parameter, 1-115
OPTIMIZER_INDEX_CACHING initialization parameter, 1-116
OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1-117
OPTIMIZER_MAX_PERMUTATIONS initialization parameter, 1-117
OPTIMIZER_MODE initialization parameter, 1-118
ORACLE_TRACE_COLLECTION_NAME initialization parameter, 1-119
ORACLE_TRACE_COLLECTION_PATH initialization parameter, 1-120
ORACLE_TRACE_COLLECTION_SIZE initialization parameter, 1-120
ORACLE_TRACE_ENABLE initialization parameter, 1-121
ORACLE_TRACE_FACILITY_NAME initialization parameter, 1-122
ORACLE_TRACE_FACILITY_PATH initialization parameter, 1-123
Oracle9i Real Application Clusters
dynamic performance views, 3-2
initialization parameters
CIRCUITS, 1-23
CLUSTER_DATABASE, 1-24
CLUSTER_DATABASE_INSTANCES, 1-24
CLUSTER_INTERCONNECTS, 1-25
DISPATCHERS, 1-48
FAST_START_PARALLEL_ROLLBACK, 1-58
MTS_CIRCUITS, 1-93
MTS_DISPATCHERS, 1-94
PARALLEL_ADAPTIVE_MULTI_USER, 1-125
PARALLEL_AUTOMATIC_TUNING, 1-126
PARALLEL_BROADCAST_ENABLEd, 1-126
PARALLEL_EXECUTION_MESSAGE_SIZE, 1-127
PARALLEL_INSTANCE_GROUP, 1-128
PARALLEL_MAX_SERVERS, 1-128
PARALLEL_MIN_PERCENT, 1-129
PARALLEL_MIN_SERVERS, 1-130
PARALLEL_THREADS_PER_CPU, 1-131
ORPHAN_KEY_TABLE view. See DBA_ORPHAN_KEY_TABLE. DBA_ORPHAN_KEY_TABLE view, 2-138
OS_AUTHENT_PREFIX initialization parameter, 1-123
OS_ROLES initialization parameter, 1-124

P

parallel mode
instance number, 1-66
parallel query
maximum number of instances, 1-126, 1-127
maximum number of servers, 1-128
minimum number of queries, 1-130
PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1-125
PARALLEL_AUTOMATIC_TUNING initialization parameter, 1-126
PARALLEL_BROADCAST_ENABLED initialization parameter, 1-126
PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1-127
PARALLEL_INSTANCE_GROUP initialization parameter, 1-128
PARALLEL_MAX_SERVERS initialization parameter, 1-128
PARALLEL_MIN_PERCENT initialization parameter, 1-129
PARALLEL_MIN_SERVERS initialization parameter, 1-130
PARALLEL_THREADS_PER_CPU initialization parameter, 1-131
parameters
embedded parameter files, 1-4
PARSED_PIECES view, 2-181
PARSED_SIZE view, 2-181
PARTITION_VIEW_ENABLED initialization parameter, 1-131
partitions
raw, 1-74
passwords
authenticating, 1-123, 1-145
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1-144
PCM lock
mapping blocks to, 1-59
performance, 1-12
rule-based optimization, 1-118
shared pool, 1-63, 1-155, 1-156
PGA_AGGREGATE_TARGET initialization parameter, 1-132
pins
on KGL objects, 2-131
PLAN_TABLE execution plan table, 2-182
PLSQL_COMPILER_FLAGS initialization parameter, 1-133
PLSQL_NATIVE_C_COMPILER initialization parameter, 1-134
PLSQL_NATIVE_LIBRARY_DIR initialization parameter, 1-134
PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT initialization parameter, 1-135
PLSQL_NATIVE_LINKER initialization parameter, 1-135
PLSQL_NATIVE_MAKE_FILE_NAME initialization parameter, 1-136
PLSQL_NATIVE_MAKE_UTILITY initialization parameter, 1-136
PLSQL_V2_COMPATIBILITY initialization parameter, 1-137
PLUGGABLE_SET_CHECK view, 2-183
PRE_PAGE_SGA initialization parameter, 1-137
privileges
remote login, 1-144
RESTRICTED_SESSION privilege, 1-70, 1-71
table-level select privileges, 1-161, 1-162, 1-163, 1-164
procedures
shared pool, 1-63, 1-155, 1-156
processes
derived parameter values, 1-170
dispatcher process maximum number, 1-91, 1-98
maximum shared server processes, 1-93, 1-99
number of server processes, 1-67, 1-68, 1-99, 1-100, 1-139, 1-157
recovery, 1-140, 1-142
trace files, 1-174
user processes, 1-138
PROCESSES initialization parameter, 1-138
PRODUCT_COMPONENT_VERSION view, 2-184
profiles
resource limits, 1-147
PROXY_USERS view, 2-184
PSTUBTBL view, 2-185
PUBLIC clause
of ALTER DATABASE
thread of redo, 1-165
PUBLIC_DEPENDENCY view, 2-185
PUBLICSYN view, 2-185

Q

queries
dictionary views, 1-59
hints, 1-118
QUERY_REWRITE_ENABLED initialization parameter, 1-139
QUERY_REWRITE_INTEGRITY initialization parameter, 1-140
QUEUE_PRIVILEGES view, 2-186

R

raw partition
LOG_ARCHIVE_DEST initialization parameter, 1-74
RC_ views, 2-186
RDBMS_SERVER_DN initialization parameter, 1-140
READ_ONLY_OPEN_DELAYED initialization parameter, 1-141
recovery
number of required processes, 1-140, 1-142
RECOVERY_PARALLELISM initialization parameter, 1-142
redo logs
buffer size, 1-84
redo thread, 1-165
remote clients
authenticating, 1-145
remote logins, 1-144
REMOTE_ARCHIVE_ENABLE initialization parameter, 1-142
REMOTE_DEPENDENCIES_MODE initialization parameter, 1-142
REMOTE_LISTENER initialization parameter, 1-143
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1-144
REMOTE_OS_AUTHENT initialization parameter, 1-145
REMOTE_OS_ROLES initialization parameter, 1-145
REPAIR_TABLE view. See DBA_REPAIR_TABLE view.
REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1-146
resource limits for profiles, 1-147
RESOURCE_COST view, 2-186
RESOURCE_LIMIT initialization parameter, 1-147
RESOURCE_MANAGER_PLAN initialization parameter, 1-147
RESOURCE_MAP view, 2-187
RMJVM.SQL script, 5-8
ROLE_ROLE_PRIVS view, 2-187
ROLE_SYS_PRIVS view, 2-187
ROLE_TAB_PRIVS view, 2-187
roles, 1-124
remote clients, 1-145
rollback segments
maximum size, 1-92
ROLLBACK_SEGMENTS initialization parameter, 1-148
ROW_LOCKING initialization parameter, 1-149
rule-based optimization, 1-118

S

scripts
CATALOG.SQL, 5-2
CATBLOCK.SQL, 5-3
CATCLUSTDB.SQL, 5-3
CATEXP7.SQL, 5-3
CATHS.SQL, 5-3
CATIO.SQL, 5-3
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
D0801050.SQL, 5-7
D0801060.SQL, 5-7
D0801070.SQL, 5-7
data dictionary, 5-3
DBMSIOTC.SQL, 5-3
DBMSOTRC.SQL, 5-3
DBMSPOOL.SQL, 5-4
INITJVM.SQL, 5-8
Java, 5-8
migration, 5-7
RMJVM.SQL, 5-8
SQL scripts, 5-2
U0703040.SQL, 5-7
U0800060.SQL, 5-7
U0801050.SQL, 5-7
U0801060.SQL, 5-7
U0801070.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-188
SERIAL_REUSE initialization parameter, 1-150
server processes
number, 1-67, 1-68, 1-99, 1-100, 1-139, 1-157
SERVICE_NAMES initialization parameter, 1-151
SESSION_CACHED_CURSORS initialization parameter, 1-152
SESSION_CONTEXT view, 2-188
SESSION_MAX_OPEN_FILES initialization parameter, 1-152
SESSION_PRIVS view, 2-188
SESSION_ROLES view, 2-188
SESSIONS initialization parameter, 1-153
SGA_MAX_SIZE initialization parameter, 1-154
SHADOW_CORE_DUMP initialization parameter, 1-154
shared server
SESSIONS initialization parameter, 1-153
shared server dispatcher request statistics, 3-100
shared server processes
maximum number, 1-93, 1-99
SHARED_MEMORY_ADDRESS initialization parameter, 1-155
SHARED_POOL_RESERVED_SIZE initialization parameter, 1-155
V$SHARED_POOL_RESERVED, 3-118
SHARED_POOL_SIZE initialization parameter, 1-156
SHARED_SERVER_SESSIONS initialization parameter, 1-157
SHARED_SERVERS initialization parameter, 1-157
SHOW PARAMETERS statement, 1-9
SORT_AREA_RETAINED_SIZE initialization parameter, 1-157
SORT_AREA_SIZE initialization parameter, 1-159
sorting
maximum memory, 1-157
ORDER BY queries, 1-107
SOURCE_SIZE view, 2-189
SPFILE initialization parameter, 1-160
SQL scripts
creating the data dictionary, 5-2
optional, 5-3
required, 5-2
SQL_TRACE initialization parameter, 1-161
SQL92_SECURITY initialization parameter, 1-161
STANDBY_ARCHIVE_DEST initialization parameter, 1-162
STANDBY_FILE_MANAGEMENT initialization parameter, 1-163
STANDBY_PRESERVES_NAMES initialization parameter, 1-163
STAR_TRANSFORMATION_ENABLED initialization parameter, 1-164
starting up
database name, 1-44
instance number, 1-66
startup order, 1-66
STARTUP statement
database name, 1-44
statistics
background checkpoints completed, C-2
background checkpoints started, C-2
branch node splits, C-2
buffer is not pinned count, C-2
buffer is pinned count, C-2
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-3
calls to kcmgrs, C-3
change write time, C-3
cleanouts and rollbacks - consistent read gets, C-3
cleanouts only - consistent read gets, C-3
cluster key scan block gets, C-3
cluster key scans, C-3
cold recycle reads, C-3
commit cleanout failures
block lost, C-3
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-4
Commit SCN cached, C-4
consistent changes, C-4
consistent gets, C-4
CPU used by this session, C-4
CPU used when call started, C-5
CR blocks created, C-5
cross instance CR read, C-5
current blocks converted for CR, C-5
cursor authentication, C-5
data blocks consistent reads - undo records applied, C-5
db block changes, C-5
db block gets, C-5
DBWR buffers scanned, C-5
DBWR checkpoint buffers written, C-5
DBWR checkpoints, 1-85, C-5
DBWR cross instance writes, C-5
DBWR free buffers found, C-6
DBWR lru scans, C-6
DBWR make free requests, C-6
DBWR revisited being-written buffer, C-6
DBWR summed scan depth, C-6
DBWR transaction table writes, C-6
DBWR undo block writes, C-6
DDL statements parallelized, C-6
deferred (CURRENT) block cleanout applications, C-6
DFO trees parallelized, C-6
dirty buffers inspected, C-6
DML statements parallelized, C-6
enqueue conversions, C-7
enqueue deadlocks, C-7
enqueue releases, C-7
enqueue requests, C-7
enqueue timeouts, C-7
enqueue waits, C-7
exchange deadlocks, C-7
execute count, C-7
free buffer inspected, C-7
free buffer requested, C-7
global cache cr block log flush time, C-8
global cache cr block send time, C-8
global cache cr timeouts, C-8
global cache defers, C-8
global cache freelist waits, C-8
global cache get time, C-8
global cache gets, C-8
global cache prepare failures, C-8
global lock async converts, C-8
global lock async gets, C-8
global lock convert time, C-8
global lock get time, C-9
global lock release time, C-9
global lock releases, C-9
global lock sync converts, C-9
global lock sync gets, C-9
hot buffers moved to head of LRU, C-9
immediate (CR) block cleanout applications, C-9
immediate (CURRENT) block cleanout applications, C-9
index fast full scans (direct read), C-9
index fast full scans (full), C-9
index fast full scans (rowid ranges), C-9
instance recovery database freeze count, C-9
kcmccs called get current scn, C-9
kcmccs read scn without going to DLM, C-9
kcmggs waited for batching, C-9
leaf node splits, C-9
logons cumulative, C-9
logons current, C-9
messages received, C-10
messages sent, C-10
native hash arithmetic execute, C-10
native hash arithmetic fail, C-10
next scns gotten without going to DLM, C-10
no buffer to keep pinned count, C-10
no work - consistent read gets, C-10
opened cursors cumulative, C-10
opened cursors current, C-10
opens of replaced files, C-10
opens requiring cache replacement, C-10
operating system
OS All other sleep time, C-10
OS Chars read and written, C-10
OS Data page fault sleep time, C-10
OS Input blocks, C-11
OS Involuntary context switches, C-11
OS Kernel page fault sleep time, C-11
OS Major page faults, C-11
OS Messages received, C-11
OS Messages sent, C-11
OS Minor page faults, C-11
OS Other system trap CPU time, C-11
OS Output blocks, C-11
OS Process heap time, C-11
OS Signals received, C-11
OS Swaps, C-11
OS System call CPU time, C-11
OS System calls, C-11
OS Text page fault sleep time, C-11
OS User level CPU time, C-11
OS User lock wait sleep time, C-11
OS Voluntary context switches, C-11
OS Wait-cpu (latency) time, C-11
Process stack size, C-11
OS Input blocks, C-11
Parallel operations downgraded 1 to 25 pct, C-12
Parallel operations downgraded 25 to 50 pct, C-12
Parallel operations downgraded 50 to 75 pct, C-12
Parallel operations downgraded 75 to 99 pct, C-12
Parallel operations downgraded to serial, C-12
Parallel operations not downgraded, C-12
parse count (hard), C-12
parse count (total), C-12
parse time cpu, C-12
parse time elapsed, C-12
physical reads, C-12
physical reads direct, C-12
physical writes, C-13
physical writes direct, C-13
physical writes non checkpoint, C-13
pinned buffers inspected, C-13
prefetched blocks, C-13
prefetched blocks aged out before use, C-13
process last non-idle time, C-13
PX local messages recv'd, C-13
PX local messages sent, C-13
PX remote messages recv'd, C-13
PX remote messages sent, C-13
queries parallelized, C-13
recovery array read time, C-13
recovery array reads, C-13
recovery blocks read, C-13
recursive calls, C-14
recursive cpu usage, C-14
redo blocks written, C-14
redo buffer allocation retries, C-14
redo entries, C-14
redo log space requests, C-14
redo log space wait time, C-14
redo log switch interrupts, C-14
redo ordering marks, C-14
redo size, C-15
redo sync writes, C-15
redo synch time, C-15
redo wastage, C-15
redo write time, C-15
redo writer latching time, C-15
redo writes, C-15
remote instance undo block writes, C-15
remote instance undo header writes, C-15
rollback changes - undo records applied, C-15
rollbacks only - consistent read gets, C-15
rows fetched via callback, C-15
serializable aborts, C-15
session connect time, C-15
session cursor cache count, C-16
session cursor cache hits, C-16
session logical reads, C-16
session pga memory, C-16
session pga memory max, C-16
session stored procedure space, C-16
session uga memory, C-16
session uga memory max, C-16
sorts (disk), C-16
sorts (memory), C-16
sorts (rows), C-16
SQL*Net roundtrips to/from client, C-16
SQL*Net roundtrips to/from dblink, C-17
summed dirty queue length, C-17
switch current to new buffer, C-17
table fetch by rowid, C-17
table fetch continued row, C-17
table scan blocks gotten, C-17
table scan rows gotten, C-17
table scans (cache partitions), C-17
table scans (direct read), C-17
table scans (long tables), C-18
table scans (rowid ranges), C-18
table scans (short tables), C-18
timed, 1-167
total file opens, C-18
transaction lock background get time, C-18
transaction lock background gets, C-18
transaction lock foreground requests, C-18
transaction lock foreground wait time, C-18
transaction rollbacks, C-18
transaction tables consistent read rollbacks, C-18
transaction tables consistent reads - undo records applied, C-18
Unnecessary process cleanup for SCN batching, C-18
user calls, C-18
user commits, C-19
user rollbacks, C-19
write clones created in background, C-19
write clones created in foreground, C-19
STMT_AUDIT_OPTION_MAP table
auditing option type codes, 2-189
switch redo log file, 1-85
SYN synonym for USER_SYNONYMS view, 2-189
SYNONYMS view, 2-189
SYS_OBJECTS view, 2-190
SYSCATALOG view, 2-189
SYSFILES view, 2-189
SYSSEGOBJ view, 2-190
system global area, 1-12
buffer areas, 1-84
maximum concurrent transactions, 1-170
rollback segment size, 1-92
system performance, 1-12
SYSTEM_PRIVILEGE_MAP view, 2-190

T

TAB view, 2-190
TABLE_PRIVILEGE_MAP table
access privilege codes, 2-190
TABLE_PRIVILEGES view, 2-191
tables
data dictionary, 2-1
DML locks, 1-52
locating free space, 1-66
row locking, 1-149
TABQUOTAS view, 2-191
TABS synonym for USER_TABLES view, 2-191
tape archiving destination, 1-74
TAPE_ASYNCH_IO initialization parameter, 1-165
territory, 1-104, 1-108
THREAD initialization parameter, 1-165
TIMED_OS_STATISTICS initialization parameter, 1-166
TIMED_STATISTICS initialization parameter, 1-167
file read/write statistics, 3-57, 3-144
TO_CHAR function, 1-103
TO_DATE function, 1-103
trace files
destination, 1-174
maximum size, 1-91
TRACE_ENABLED initialization parameter, 1-168
TRACEFILE_IDENTIFIER initialization parameter, 1-169
TRANSACTION_AUDITING initialization parameter, 1-169
transactions
concurrent, 1-170
data locking, 1-52
TRANSACTIONS initialization parameter, 1-170
DML locks, 1-52
TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1-171
TRUSTED_SERVERS view, 2-192
TS_PITR_CHECK view, 2-192
TS_PITR_OBJECTS TO_BE_DROPPED view, 2-193

U

U0703040.SQL script, 5-7
U0800060.SQL script, 5-7
U0801050.SQL script, 5-7
U0801060.SQL script, 5-7
U0801070.SQL script, 5-7
UNDO_MANAGEMENT initialization parameter, 1-171
UNDO_RETENTION initialization parameter, 1-172
UNDO_SUPPRESS_ERRORS initialization parameter, 1-173
UNDO_TABLESPACE initialization parameter, 1-173
UNI_PLUGGABLE_SET_CHECK view, 2-193
updates
locating free space, 1-66
transaction processing option, 1-149
uppercase characters, 1-3
USE_INDIRECT_DATA_BUFFERS initialization parameter, 1-174
user processes
trace files, 1-174
USER_ALL_TABLES view, 2-194
USER_ARGUMENTS view, 2-194
USER_ASSOCIATIONS view, 2-194
USER_AUDIT_OBJECT view, 2-194
USER_AUDIT_SESSION view, 2-195
USER_AUDIT_STATEMENT view, 2-195
USER_AUDIT_TRAIL view, 2-195
USER_BASE_TABLE_MVIEWS view, 2-195
USER_CATALOG view, 2-195
CAT synonym, 2-109
USER_CLU_COLUMNS view, 2-195
USER_CLUSTER_HASH_EXPRESSIONS view, 2-196
USER_CLUSTERS view, 2-196
CLU synonym, 2-111
USER_COL_COMMENTS view, 2-196
USER_COL_PRIVS view, 2-196
USER_COL_PRIVS_MADE view, 2-196
USER_COL_PRIVS_RECD view, 2-196
USER_COLL_TYPES view, 2-197
USER_CONS_COLUMNS view, 2-197
USER_CONSTRAINTS view, 2-197
USER_DB_LINKS view, 2-197
USER_DEPENDENCIES view, 2-197
USER_DIM_ATTRIBUTES view, 2-197
USER_DIM_CHILD_OF view, 2-198
USER_DIM_HIERARCHIES view, 2-198
USER_DIM_JOIN_KEY view, 2-198
USER_DIM_LEVEL_KEY view, 2-198
USER_DIM_LEVELS view, 2-198
USER_DIMENSIONS view, 2-198
USER_DUMP_DEST initialization parameter, 1-174
USER_ERRORS view, 2-199
USER_EXTENTS view, 2-199
USER_EXTERNAL_TABLES view, 2-199
USER_FREE_SPACE view, 2-199
USER_HISTOGRAMS synonym for USER_TAB_HISTOGRAMS view, 2-199
USER_IND_COLUMNS view, 2-199
USER_IND_EXPRESSIONS view, 2-200
USER_IND_PARTITIONS view, 2-200
USER_IND_SUBPARTITIONS view, 2-200
USER_INDEXES view, 2-200
IND synonym, 2-179
USER_INDEXTYPE_COMMENTS view, 2-200
USER_INDEXTYPE_OPERATORS view, 2-200
USER_INDEXTYPES view, 2-201
USER_INTERNAL_TRIGGERS view, 2-201
USER_JOBS view, 2-201
USER_JOIN_IND_COLUMNS view, 2-201
USER_LIBRARIES view, 2-201
USER_LOB_PARTITIONS view, 2-201
USER_LOB_SUBPARTITIONS view, 2-202
USER_LOBS view, 2-202
USER_LOG_GROUP_COLUMNS view, 2-202
USER_LOG_GROUPS view, 2-202
USER_METHOD_PARAMS view, 2-202
USER_METHOD_RESULTS view, 2-202
USER_MVIEW_AGGREGATES view, 2-202
USER_MVIEW_ANALYSIS view, 2-203
USER_MVIEW_DETAIL_RELATIONS view, 2-203
USER_MVIEW_JOINS view, 2-203
USER_MVIEW_KEYS view, 2-203
USER_MVIEW_REFRESH_TIMES view, 2-204
USER_SNAPSHOT_REFRESH_TIMES synonym, 2-211
USER_MVIEWS view, 2-204
USER_NESTED_TABLES view, 2-204
USER_OBJ_AUDIT_OPTS view, 2-204
USER_OBJECT_SIZE view, 2-204
USER_OBJECT_TABLES view, 2-204
USER_OBJECTS view, 2-204
OBJ synonym, 2-181
USER_OPANCILLARY view, 2-205
USER_OPARGUMENTS view, 2-205
USER_OPBINDINGS view, 2-205
USER_OPERATOR_COMMENTS view, 2-205
USER_OPERATORS view, 2-205
USER_OUTLINE_HINTS view, 2-205
USER_OUTLINES view, 2-206
USER_PART_COL_STATISTICS view, 2-206
USER_PART_HISTOGRAMS view, 2-206
USER_PART_INDEXES view, 2-206
USER_PART_KEY_COLUMNS view, 2-206
USER_PART_LOBS view, 2-206
USER_PART_TABLES view, 2-207
USER_PARTIAL_DROP_TABS view, 2-207
USER_PASSWORD_LIMITS view, 2-207
USER_POLICIES view, 2-207
USER_PROCEDURES view, 2-207
USER_PROXIES view, 2-207
USER_PUBLISHED_COLUMNS view, 2-208
USER_QUEUE_SCHEDULES view, 2-208
USER_QUEUE_TABLES view, 2-208
USER_QUEUES view, 2-208
USER_REFRESH view, 2-209
USER_REFRESH_CHILDREN view, 2-209
USER_REFS view, 2-209
USER_REGISTERED_MVIEWS view, 2-209
USER_REGISTERED_SNAPSHOTS view, 2-209
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-209
USER_RESUMABLE view, 2-210
USER_ROLE_PRIVS view, 2-210
USER_RSRC_CONSUMER_GROUP_PRIVS view, 2-210
USER_RSRC_MANAGER_SYSTEM_PRIVS view, 2-210
USER_SEGMENTS view, 2-210
USER_SEQUENCES view, 2-211
SEQ synonym, 2-188
USER_SNAPSHOT_LOGS view, 2-211
USER_SNAPSHOT_REFRESH_TIMES synonym for USER_MVIEW_REFRESH_TIMES view, 2-211
USER_SNAPSHOTS view, 2-211
USER_SOURCE view, 2-211
USER_SOURCE_TABLES view, 2-211
USER_SQLJ_TYPE_ATTRS view, 2-211
USER_SQLJ_TYPE_METHODS view, 2-212
USER_SQLJ_TYPES view, 2-212
USER_STORED_SETTINGS view, 2-212
USER_SUBPART_COL_STATISTICS view, 2-212
USER_SUBPART_HISTOGRAMS view, 2-212
USER_SUBPART_KEY_COLUMNS view, 2-212
USER_SUBSCRIBED_COLUMNS view, 2-213
USER_SUBSCRIBED_TABLES view, 2-213
USER_SUBSCRIPTIONS view, 2-213
USER_SYNONYMS view, 2-213
SYN synonym, 2-189
USER_SYS_PRIVS view, 2-213
USER_TAB_COL_STATISTICS view, 2-213
USER_TAB_COLUMNS view, 2-213
COLS synonym, 2-112
USER_TAB_COMMENTS view, 2-214
USER_TAB_HISTOGRAMS view, 2-214
USER_HISTOGRAMS synonym, 2-199
USER_TAB_MODIFICATIONS view, 2-214
USER_TAB_PARTITIONS view, 2-214
USER_TAB_PRIVS view, 2-214
USER_TAB_PRIVS_MADE view, 2-215
USER_TAB_PRIVS_RECD view, 2-215
USER_TAB_SUBPARTITIONS view, 2-215
USER_TABLES view, 2-215
TABS synonym, 2-191
USER_TABLESPACES view, 2-215
USER_TRANSFORMATIONS view, 2-215
USER_TRIGGER_COLS view, 2-216
USER_TRIGGERS view, 2-216
USER_TS_QUOTAS view, 2-216
USER_TYPE_ATTRS view, 2-216
USER_TYPE_METHODS view, 2-216
USER_TYPES view, 2-216
USER_UNUSED_COL_TABS view, 2-216
USER_UPDATABLE_COLUMNS view, 2-217
USER_USERS view, 2-217
USER_USTATS view, 2-217
USER_VARRAYS view, 2-217
USER_VIEWS view, 2-217
USERLOCK.SQL script, 5-4
users
authenticating, 1-123
multiple, 1-52
UTL_FILE_DIR initialization parameter, 1-175
UTLBSTAT.SQL script, 5-4
UTLCHN1.SQL script, 5-4
UTLCONST.SQL script, 5-4
UTLDTREE.SQL script, 2-168, 5-4
utldtree.sql script, 2-178
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_PROCESSES view, 3-6
V$ARCHIVED_LOG view, 3-7
V$BACKUP view, 3-9
V$BACKUP_ASYNC_IO view, 3-9
V$BACKUP_CORRUPTION view, 3-10
V$BACKUP_DATAFILE view, 3-11
V$BACKUP_DEVICE view, 3-12
V$BACKUP_PIECE view, 3-12
V$BACKUP_REDOLOG view, 3-13
V$BACKUP_SET view, 3-14
V$BACKUP_SYNC_IO view, 3-15
V$BGPROCESS view, 3-16
V$BH view, 3-17
V$BSP view, 3-18
V$BUFFER_POOL view, 3-19
V$BUFFER_POOL_STATISTICS view, 3-20
V$CACHE view, 3-21
V$CACHE_LOCK view, 3-23
V$CACHE_TRANSFER view, 3-24
V$CIRCUIT view, 3-25
V$CLASS_CACHE_TRANSFER view, 3-26
V$CLASS_PING view, 3-27
V$COMPATIBILITY view, 3-28
V$COMPATSEG view, 3-28
V$CONTEXT view, 3-29
V$CONTROLFILE view, 3-29
V$CONTROLFILE_RECORD_SECTION view, 3-29
V$COPY_CORRUPTION view, 3-30
V$CR_BLOCK_SERVER view, 3-30
V$DATABASE view, 3-31
V$DATAFILE view, 3-33
V$DATAFILE_COPY view, 3-34
V$DATAFILE_HEADER view, 3-36
V$DB_CACHE_ADVICE view, 3-37
V$DB_OBJECT_CACHE view, 3-37
V$DB_PIPES view, 3-38
V$DBFILE view, 3-38
V$DBLINK view, 3-39
V$DELETED_OBJECT view, 3-39
V$DISPATCHER view, 3-40
V$DISPATCHER_RATE view, 3-41
V$DLM_ALL_LOCKS view, 3-45
V$DLM_CONVERT_LOCAL view, 3-46
V$GES_CONVERT_LOCAL synonym, 3-59
V$DLM_CONVERT_REMOTE view, 3-47
V$GES_CONVERT_REMOTE synonym, 3-60
V$DLM_LATCH view, 3-48
V$GES_LATCH synonym, 3-61
V$DLM_LOCKS view, 3-48
V$DLM_MISC view, 3-49
V$GES_STATISTICS synonym, 3-61
V$DLM_RESS view, 3-49
V$GES_RESOURCE synonym, 3-61
V$ENABLEDPRIVS view, 3-50
V$ENQUEUE_LOCK view, 3-50
V$ENQUEUE_STAT view, 3-51
V$EVENT_NAME view, 3-52
V$EXECUTION view, 3-52
V$FALSE_PING view, 3-52
V$FAST_START_SERVERS view, 3-53
V$FAST_START_TRANSACTIONS view, 3-54
V$FILE_CACHE_TRANSFER view, 3-54
V$FILE_PING view, 3-55
V$FILESTAT view, 3-57
V$FIXED_TABLE view, 3-57
V$FIXED_VIEW_DEFINITION view, 3-58
V$GC_ELEMENTS_WITH_COLLISIONS view, 3-58
V$GES_BLOCKING_ENQUEUE view, 3-58
V$GES_CONVERT_LOCAL synonym for V$DLM_CONVERT_LOCAL view, 3-59
V$GES_CONVERT_REMOTE synonym for V$DLM_CONVERT_REMOTE view, 3-60
V$GES_ENQUEUE view, 3-60
V$GES_LATCH synonym for V$DLM_LATCH view, 3-61
V$GES_RESOURCE synonym for V$DLM_RESS view, 3-61
V$GES_STATISTICS synonym for V$DLM_MISC view, 3-61
V$GLOBAL_BLOCKED_LOCKS view, 3-61
V$GLOBAL_TRANSACTION view, 3-62
V$HS_AGENT view, 3-62
V$HS_PARAMETER view, 3-63
V$HS_SESSION view, 3-63
V$INDEXED_FIXED_COLUMN view, 3-64
V$INSTANCE view, 3-64
V$INSTANCE_RECOVERY view, 3-65
V$LATCH view, 3-67
V$LATCH_CHILDREN view, 3-67
V$LATCH_MISSES view, 3-68
V$LATCH_PARENT view, 3-68
V$LATCHHOLDER view, 3-69
V$LATCHNAME view, 3-69
V$LIBRARYCACHE view, 3-69
V$LICENSE view, 3-70
V$LOADCSTAT view, 3-70
V$LOADTSTAT view, 3-71
V$LOCK view, 3-71
V$LOCK_ACTIVITY view, 3-73
V$LOCK_ELEMENT view, 3-74
V$LOCKED_OBJECT view, 3-75
V$LOCKS_WITH_COLLISIONS view, 3-75
V$LOG view, 3-75
V$LOG_HISTORY view, 3-76
V$LOGFILE view, 3-77
V$LOGHIST view, 3-77
V$LOGMNR_CONTENTS view, 3-77
V$LOGMNR_DICTIONARY view, 3-79
V$LOGMNR_LOGS view, 3-80
V$LOGMNR_PARAMETERS view, 3-80
V$MTS view, 3-81
V$MVREFRESH view, 3-2
V$MYSTAT view, 3-81
V$NLS_PARAMETERS view, 3-81
V$NLS_VALID_VALUES view, 3-82
V$OBJECT_DEPENDENCY view, 3-82
V$OBJECT_USAGE view, 3-83
V$OBSOLETE_PARAMETER view, 3-83
V$OFFLINE_RANGE view, 3-83
V$OPEN_CURSOR view, 3-84
V$OPTION view, 3-84
V$PARALLEL_DEGREE_LIMIT_MTH view, 3-84
V$PARAMETER view, 3-85
V$PARAMETER2 view, 3-85
V$PGASTAT view, 3-86
V$PING view, 3-87
V$PQ_SESSTAT view, 3-88
V$PQ_SLAVE view, 3-88
V$PQ_SYSSTAT view, 3-89
V$PQ_TQSTAT view, 3-90
V$PROCESS view, 3-91
V$PROXY_ARCHIVEDLOG view, 3-92
V$PROXY_DATAFILE view, 3-93
V$PWFILE_USERS view, 3-94
V$PX_PROCESS view, 3-95
V$PX_PROCESS_SYSSTAT view, 3-95
V$PX_SESSION view, 3-96
V$PX_SESSTAT view, 3-97
V$QUEUE view, 3-97
V$RECOVER_FILE view, 3-98
V$RECOVERY_FILE_STATUS view, 3-98
V$RECOVERY_LOG view, 3-98
V$RECOVERY_PROGRESS view, 3-99
V$RECOVERY_STATUS view, 3-99
V$REPLPROP view, 3-2
V$REPLQUEUE view, 3-2
V$REQDIST view, 3-100
V$RESERVED_WORDS view, 3-100
V$RESOURCE view, 3-101
V$RESOURCE_LIMIT view, 3-101
V$RMAN_CONFIGURATION view, 3-102
V$ROLLNAME view, 3-102
V$ROLLSTAT view, 3-103
V$ROWCACHE view, 3-103
V$ROWCACHE_PARENT view, 3-104
V$ROWCACHE_SUBORDINATE view, 3-105
V$RSRC_CONSUMER_GROUP view, 3-105
V$RSRC_CONSUMER_GROUP_CPU_MTH view, 3-106
V$RSRC_PLAN view, 3-107
V$RSRC_PLAN_CPU_MTH view, 3-107
V$SESS_IO view, 3-108
V$SESSION view, 3-108
V$SESSION_CONNECT_INFO view, 3-112
V$SESSION_CURSOR_CACHE view, 3-113
V$SESSION_EVENT view, 3-113, A-2
V$SESSION_LONGOPS view, 3-114
V$SESSION_OBJECT_CACHE view, 3-115
V$SESSION_WAIT view, 3-116, A-2
V$SESSTAT view, 3-117, C-1
V$SGA view, 3-118
V$SGASTAT view, 3-118
V$SHARED_POOL_RESERVED view, 3-118
V$SHARED_SERVER view, 3-119
V$SHARED_SERVER_MONITOR view, 3-120
V$SORT_SEGMENT view, 3-121
V$SORT_USAGE view, 3-121
V$SPPARAMETER view, 3-122
V$SQL view, 3-122
V$SQL_BIND_DATA view, 3-124
V$SQL_BIND_METADATA view, 3-125
V$SQL_CURSOR view, 3-126
V$SQL_PLAN view, 3-126
V$SQL_REDIRECTION view, 3-128
V$SQL_SHARED_CURSOR view, 3-128
V$SQL_SHARED_MEMORY view, 3-130
V$SQL_WORKAREA view, 3-130
V$SQL_WORKAREA_ACTIVE view, 3-131
V$SQLAREA view, 3-132
V$SQLTEXT view, 3-134
V$SQLTEXT_WITH_NEWLINES view, 3-134
V$STATNAME view, 3-135, C-1
V$SUBCACHE view, 3-136
V$SYSSTAT view, 3-136, C-1
V$SYSTEM_CURSOR_CACHE view, 3-137
V$SYSTEM_EVENT view, 3-137, A-2
V$SYSTEM_PARAMETER view, 3-138
V$SYSTEM_PARAMETER2 view, 3-139
V$TABLESPACE view, 3-140
V$TEMP_CACHE_TRANSFER view, 3-140
V$TEMP_EXTENT_MAP view, 3-141
V$TEMP_EXTENT_POOL view, 3-141
V$TEMP_PING view, 3-142
V$TEMP_SPACE_HEADER view, 3-143
V$TEMPFILE view, 3-144
V$TEMPORARY_LOBS view, 3-144
V$TEMPSTAT view, 3-144
V$THREAD view, 3-145
V$TIMER view, 3-146
V$TIMEZONE_NAMES view, 3-146
V$TRANSACTION view, 3-146
V$TRANSACTION_ENQUEUE view, 3-148
V$TYPE_SIZE view, 3-148
V$UNDOSTAT view, 3-149
V$VERSION view, 3-150
V$VPD_POLICY view, 3-150
V$WAITSTAT view, 3-151
views
data dictionary views, 2-1
data files, 1-59
virtual circuit status, A-47

W

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

Go to previous page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback