Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

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

Go to previous page
Previous
View PDF

Index

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

A

ACTIVE_INSTANCE_COUNT initialization parameter, 1.7
ALL_ALL_TABLES view, 2.3
ALL_APPLY view, 2.4
ALL_APPLY_CONFLICT_COLUMNS view, 2.5
ALL_APPLY_DML_HANDLERS view, 2.6
ALL_APPLY_ENQUEUE view, 2.7
ALL_APPLY_ERROR view, 2.8
ALL_APPLY_EXECUTE view, 2.9
ALL_APPLY_KEY_COLUMNS view, 2.10
ALL_APPLY_PARAMETERS view, 2.11
ALL_APPLY_PROGRESS view, 2.12
ALL_APPLY_TABLE_COLUMNS view, 2.13
ALL_ARGUMENTS view, 2.14
ALL_ASSOCIATIONS view, 2.15
ALL_AUDIT_POLICIES view, 2.16
ALL_AUDIT_POLICY_COLUMNS view, 2.17
ALL_AW_PS view, 2.18
ALL_AWS view, 2.19
ALL_BASE_TABLE_MVIEWS view, 2.20
ALL_CAPTURE view, 2.21
ALL_CAPTURE_EXTRA_ATTRIBUTES view, 2.22
ALL_CAPTURE_PARAMETERS view, 2.23
ALL_CAPTURE_PREPARED_DATABASE view, 2.24
ALL_CAPTURE_PREPARED_SCHEMAS view, 2.25
ALL_CAPTURE_PREPARED_TABLES view, 2.26
ALL_CATALOG view, 2.27
ALL_CLUSTER_HASH_EXPRESSIONS view, 2.28
ALL_CLUSTERS view, 2.29
ALL_COL_COMMENTS view, 2.30
ALL_COL_PRIVS view, 2.31
ALL_COL_PRIVS_MADE view, 2.32
ALL_COL_PRIVS_RECD view, 2.33
ALL_COLL_TYPES view, 2.34
ALL_CONS_COLUMNS view, 2.35
ALL_CONS_OBJ_COLUMNS view, 2.36
ALL_CONSTRAINTS view, 2.37
ALL_CONTEXT view, 2.38
ALL_DB_LINKS view, 2.39
ALL_DEF_AUDIT_OPTS view, 2.40
ALL_DEPENDENCIES view, 2.41
ALL_DIM_ATTRIBUTES view, 2.42
ALL_DIM_CHILD_OF view, 2.43
ALL_DIM_HIERARCHIES view, 2.44
ALL_DIM_JOIN_KEY view, 2.45
ALL_DIM_LEVEL_KEY view, 2.46
ALL_DIM_LEVELS view, 2.47
ALL_DIMENSIONS view, 2.48
ALL_DIRECTORIES view, 2.49
ALL_ERRORS view, 2.50
ALL_EVALUATION_CONTEXT_TABLES view, 2.51
ALL_EVALUATION_CONTEXT_VARS view, 2.52
ALL_EVALUATION_CONTEXTS view, 2.53
ALL_EXTERNAL_LOCATIONS view, 2.54
ALL_EXTERNAL_TABLES view, 2.55
ALL_IND_COLUMNS view, 2.56
ALL_IND_EXPRESSIONS view, 2.57
ALL_IND_PARTITIONS view, 2.58
ALL_IND_STATISTICS view, 2.59
ALL_IND_SUBPARTITIONS view, 2.60
ALL_INDEXES view, 2.61
ALL_INDEXTYPE_ARRAYTYPES view, 2.62
ALL_INDEXTYPE_COMMENTS view, 2.63
ALL_INDEXTYPE_OPERATORS view, 2.64
ALL_INDEXTYPES view, 2.65
ALL_INTERNAL_TRIGGERS view, 2.66
ALL_JAVA_ARGUMENTS view, 2.67
ALL_JAVA_CLASSES view, 2.68
ALL_JAVA_DERIVATIONS view, 2.69
ALL_JAVA_FIELDS view, 2.70
ALL_JAVA_IMPLEMENTS view, 2.71
ALL_JAVA_INNERS view, 2.72
ALL_JAVA_LAYOUTS view, 2.73
ALL_JAVA_METHODS view, 2.74
ALL_JAVA_NCOMPS view, 2.75
ALL_JAVA_RESOLVERS view, 2.76
ALL_JAVA_THROWS view, 2.77
ALL_JOBS view, 2.78
ALL_JOIN_IND_COLUMNS view, 2.79
ALL_LIBRARIES view, 2.80
ALL_LOB_PARTITIONS view, 2.81
ALL_LOB_SUBPARTITIONS view, 2.82
ALL_LOB_TEMPLATES view, 2.83
ALL_LOBS view, 2.84
ALL_LOG_GROUP_COLUMNS view, 2.85
ALL_LOG_GROUPS view, 2.86
ALL_METHOD_PARAMS view, 2.87
ALL_METHOD_RESULTS view, 2.88
ALL_MVIEW_AGGREGATES view, 2.89
ALL_MVIEW_ANALYSIS view, 2.90
ALL_MVIEW_COMMENTS view, 2.91
ALL_MVIEW_DETAIL_RELATIONS view, 2.92
ALL_MVIEW_JOINS view, 2.93
ALL_MVIEW_KEYS view, 2.94
ALL_MVIEW_LOGS view, 2.95
ALL_MVIEW_REFRESH_TIMES view, 2.96
ALL_MVIEWS view, 2.97
ALL_NESTED_TABLE_COLS view, 2.98
ALL_NESTED_TABLES view, 2.99
ALL_OBJ_COLATTRS view, 2.100
ALL_OBJECT_TABLES view, 2.101
ALL_OBJECTS view, 2.102
ALL_OPANCILLARY view, 2.103
ALL_OPARGUMENTS view, 2.104
ALL_OPBINDINGS view, 2.105
ALL_OPERATOR_COMMENTS view, 2.106
ALL_OPERATORS view, 2.107
ALL_OUTLINE_HINTS view, 2.108
ALL_OUTLINES view, 2.109
ALL_PART_COL_STATISTICS view, 2.110
ALL_PART_HISTOGRAMS view, 2.111
ALL_PART_INDEXES view, 2.112
ALL_PART_KEY_COLUMNS view, 2.113
ALL_PART_LOBS view, 2.114
ALL_PART_TABLES view, 2.115
ALL_PARTIAL_DROP_TABS view, 2.116
ALL_PENDING_CONV_TABLES view, 2.117
ALL_PLSQL_OBJECT_SETTINGS view, 2.118
ALL_POLICIES view, 2.119
ALL_POLICY_CONTEXTS view, 2.120
ALL_POLICY_GROUPS view, 2.121
ALL_PROCEDURES view, 2.122
ALL_PROPAGATION view, 2.123
ALL_PUBLISHED_COLUMNS view, 2.124
ALL_QUEUE_TABLES view, 2.125
ALL_QUEUES view, 2.126
ALL_REFRESH view, 2.127
ALL_REFRESH_CHILDREN view, 2.128
ALL_REFRESH_DEPENDENCIES view, 2.129
ALL_REFS view, 2.130
ALL_REGISTERED_MVIEWS view, 2.131
ALL_REGISTRY_BANNERS view, 2.132
ALL_REPCAT view, 2.1.1
ALL_REPCAT_REFRESH_TEMPLATES view, 2.1.1
ALL_REPCAT_TEMPLATE_OBJECTS view, 2.1.1
ALL_REPCAT_TEMPLATE_PARMS view, 2.1.1
ALL_REPCAT_TEMPLATE_SITES view, 2.1.1
ALL_REPCAT_USER_AUTHORIZATIONS view, 2.1.1
ALL_REPCAT_USER_PARM_VALUES view, 2.1.1
ALL_REPCATLOG view, 2.1.1
ALL_REPCOLUMN view, 2.1.1
ALL_REPCOLUMN_GROUP view, 2.1.1
ALL_REPCONFLICT view, 2.1.1
ALL_REPDDL view, 2.1.1
ALL_REPFLAVOR_COLUMNS view, 2.1.1
ALL_REPFLAVOR_OBJECTS view, 2.1.1
ALL_REPFLAVORS view, 2.1.1
ALL_REPGENERATED view, 2.1.1
ALL_REPGENOBJECTS view, 2.1.1
ALL_REPGROUP view, 2.1.1
ALL_REPGROUP_PRIVILEGES view, 2.1.1
ALL_REPGROUPED_COLUMN view, 2.1.1
ALL_REPKEY_COLUMNS view, 2.1.1
ALL_REPOBJECT view, 2.1.1
ALL_REPPARAMETER_COLUMN view, 2.1.1
ALL_REPPRIORITY view, 2.1.1
ALL_REPPRIORITY_GROUP view, 2.1.1
ALL_REPPROP view, 2.1.1
ALL_REPRESOL_STATS_CONTROL view, 2.1.1
ALL_REPRESOLUTION view, 2.1.1
ALL_REPRESOLUTION_METHOD view, 2.1.1
ALL_REPRESOLUTION_STATISTICS view, 2.1.1
ALL_REPSCHEMA view, 2.1.1
ALL_REPSITES view, 2.1.1
ALL_REWRITE_EQUIVALENCES view, 2.133
ALL_RULE_SET_RULES view, 2.134
ALL_RULE_SETS view, 2.135
ALL_RULES view, 2.136
ALL_SCHEDULER_JOB_ARGS view, 2.137
ALL_SCHEDULER_JOB_CLASSES view, 2.138
ALL_SCHEDULER_JOB_LOG view, 2.139
ALL_SCHEDULER_JOB_RUN_DETAILS view, 2.140
ALL_SCHEDULER_JOBS view, 2.141
ALL_SCHEDULER_PROGRAM_ARGS view, 2.142
ALL_SCHEDULER_PROGRAMS view, 2.143
ALL_SCHEDULER_RUNNING_JOBS view, 2.144
ALL_SCHEDULER_SCHEDULES view, 2.145
ALL_SCHEDULER_WINDOW_DETAILS view, 2.146
ALL_SCHEDULER_WINDOW_GROUPS view, 2.147
ALL_SCHEDULER_WINDOW_LOG view, 2.148
ALL_SCHEDULER_WINDOWS view, 2.149
ALL_SCHEDULER_WINGROUP_MEMBERS view, 2.150
ALL_SEC_RELEVANT_COLS view, 2.151
ALL_SEQUENCES view, 2.152
ALL_SERVICES view, 2.153
ALL_SOURCE view, 2.154
ALL_SOURCE_TABLES view, 2.155
ALL_SQLJ_TYPE_ATTRS view, 2.156
ALL_SQLJ_TYPE_METHODS view, 2.157
ALL_SQLJ_TYPES view, 2.158
ALL_STORED_SETTINGS view, 2.159
ALL_STREAMS_GLOBAL_RULES view, 2.160
ALL_STREAMS_MESSAGE_CONSUMERS view, 2.161
ALL_STREAMS_MESSAGE_RULES view, 2.162
ALL_STREAMS_NEWLY_SUPPORTED view, 2.163
ALL_STREAMS_RULES view, 2.164
ALL_STREAMS_SCHEMA_RULES view, 2.165
ALL_STREAMS_TABLE_RULES view, 2.166
ALL_STREAMS_TRANSFORM_FUNCTION view, 2.167
ALL_STREAMS_UNSUPPORTED view, 2.168
ALL_SUBPART_COL_STATISTICS view, 2.169
ALL_SUBPART_HISTOGRAMS view, 2.170
ALL_SUBPART_KEY_COLUMNS view, 2.171
ALL_SUBPARTITION_TEMPLATES view, 2.172
ALL_SUBSCRIBED_COLUMNS view, 2.173
ALL_SUBSCRIBED_TABLES view, 2.174
ALL_SUBSCRIPTIONS view, 2.175
ALL_SUMDELTA view, 2.176
ALL_SYNONYMS view, 2.177
ALL_TAB_COL_STATISTICS view, 2.178
ALL_TAB_COLS view, 2.179
ALL_TAB_COLUMNS view, 2.180
ALL_TAB_COMMENTS view, 2.181
ALL_TAB_HISTOGRAMS view, 2.182
ALL_TAB_MODIFICATIONS view, 2.183
ALL_TAB_PARTITIONS view, 2.184
ALL_TAB_PRIVS view, 2.185
ALL_TAB_PRIVS_MADE view, 2.186
ALL_TAB_PRIVS_RECD view, 2.187
ALL_TAB_STATISTICS view, 2.188
ALL_TAB_SUBPARTITIONS view, 2.189
ALL_TABLES view, 2.190
ALL_TRIGGER_COLS view, 2.191
ALL_TRIGGERS view, 2.192
ALL_TYPE_ATTRS view, 2.193
ALL_TYPE_METHODS view, 2.194
ALL_TYPE_VERSIONS view, 2.195
ALL_TYPES view, 2.196
ALL_UNUSED_COL_TABS view, 2.197
ALL_UPDATABLE_COLUMNS view, 2.198
ALL_USERS view, 2.199
ALL_USTATS view, 2.200
ALL_VARRAYS view, 2.201
ALL_VERSION_HVIEW view, 2.1.2
ALL_VIEWS view, 2.202
ALL_WARNING_SETTINGS view, 2.203
ALL_WM_LOCKED_TABLES view, 2.1.2
ALL_WM_MODIFIED_TABLES view, 2.1.2
ALL_WM_RIC_INFO view, 2.1.2
ALL_WM_TAB_TRIGGERS view, 2.1.2
ALL_WM_VERSIONED_TABLES view, 2.1.2
ALL_WM_VT_ERRORS view, 2.1.2
ALL_WORKSPACE_PRIVS view, 2.1.2
ALL_WORKSPACE_SAVEPOINTS view, 2.1.2
ALL_WORKSPACES view, 2.1.2
ALL_XML_SCHEMAS view, 2.204
ALL_XML_TAB_COLS view, 2.205
ALL_XML_TABLES view, 2.206
ALL_XML_VIEW_COLS view, 2.207
ALL_XML_VIEWS view, 2.208
ALLOCATE EXTENT clause
of ALTER TABLE
instance number, 1.85
allocation
PCM locks, 1.75
ALTER DATABASE statement
ADD LOGFILE, 1.211
ENABLE THREAD, 1.211
THREAD, 1.211
ALTER TABLE statement
allocating extents, 1.85
ANALYZE statement, 2.61, 2.98, 2.179, 2.180, 2.190, 3.179, 3.237, 3.359, 3.360, 3.368, 3.572, 3.655, 3.656, 3.666
AQ_TM_PROCESSES initialization parameter, 1.8
ARCHIVE LOG START statement
automatic archiving, 1.100
ARCHIVE_LAG_TARGET initialization parameter, 1.9
archived redo logs
destination file, 1.100
storage device, 1.100, 1.104
ARCHIVELOG mode, 1.100
archiving destination, 1.100, 1.104
ASM_DISKGROUPS initialization parameter, 1.10
ASM_DISKSTRING initialization parameter, 1.11
ASM_POWER_LIMIT initialization parameter, 1.12
AUDIT_ACTIONS table, 2.209
AUDIT_FILE_DEST initialization parameter, 1.13
AUDIT_SYS_OPERATIONS initialization parameter, 1.14
AUDIT_TRAIL initialization parameter, 1.15
authenticating remote clients, 1.177
authenticating users, 1.147

B

BACKGROUND_CORE_DUMP initialization parameter, 1.16
BACKGROUND_DUMP_DEST initialization parameter, 1.17
BACKUP_TAPE_IO_SLAVES initialization parameter, 1.18
BITMAP_MERGE_AREA_SIZE initialization parameter, 1.19
BLANK_TRIMMING initialization parameter, 1.20
blocks
PCM lock, 1.75
redo log, 1.110
size, 1.35, 1.39, 1.49, A.2

C

cache
dictionary, 5.50, 5.51, 5.52, 5.53, 5.54, 5.55, 5.56
statistics, 1.110
CAT synonym for USER_CATALOG view, 2.211
CATALOG view, 2.210
CATALOG.SQL script, B.1
creating V$ views, 4.1
CATAUDIT.SQL script
audit trail records created by, 3.490
audit trails for connections and disconnections, 3.493
auditing characteristics described by, 3.574
CATBLOCK.SQL script, B.2
CATCLUST.SQL script, B.1
CATEXP7.SQL script, B.2
CATHS.SQL script, B.2
CATIO.SQL script, B.2
CATJAVA.SQL script, B.5
CATNOADT.SQL script, B.3
CATNOAUD.SQL script, B.3
CATNOHS.SQL script, B.3
CATNOPRT.SQL script, B.3
CATNOQUE.SQL script, B.3
CATNORMN.SQL script, B.3
CATNOSVM.SQL script, B.3
CATNSNMP.SQL script, B.3
CATOCTK.SQL script, B.2
CATPROC.SQL script, B.1
CATQUEUE.SQL script, B.2
CATREP.SQL script, B.2
CATRMAN.SQL script, B.2
CHAINED_ROWS table, 2.212
CHANGE_SETS view, 2.213
CHANGE_SOURCES view, 2.214
CHANGE_TABLES view, 2.215
characters
numeric group separators, 1.130
checkpoints
checkpoint interval, 1.110
statistics, 1.110
CIRCUITS initialization parameter, 1.21
CLU synonym for USER_CLUSTERS view, 2.216
CLUSTER_DATABASE initialization parameter, 1.22
CLUSTER_DATABASE_INSTANCES initialization parameter, 1.23
CLUSTER_INTERCONNECTS initialization parameter, 1.24
COL view, 2.217
COLS synonym for USER_TAB_COLUMNS view, 2.218
COMMIT_POINT_STRENGTH initialization parameter, 1.25
COMPATIBLE initialization parameter, 1.26
contention
block-level, 5.158
control files
names, 1.28
specifying, 1.28
CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 1.27
CONTROL_FILES initialization parameter, 1.28
CORE_DUMP_DEST initialization parameter, 1.29
cost-based optimization, 1.146
favoring IN-list iterators, 1.144
CPU_COUNT initialization parameter, 1.30
CREATE TABLE statement
FREELIST GROUPS clause, 1.85
CREATE_BITMAP_AREA_SIZE initialization parameter, 1.31
CREATE_STORED_OUTLINES initialization parameter, 1.32
creating
a database
setting block size, 1.35, 1.39, 1.49
currency, 1.122
international currency symbol, 1.126
CURSOR_SHARING initialization parameter, 1.33
CURSOR_SPACE_FOR_TIME initialization parameter, 1.34
cursors
OPEN_CURSORS initialization parameter, 1.139
shared pool, 1.194

D

D0902000.SQL script, B.4
data blocks
reading multiple, 1.45
size of, 1.35, 1.39, 1.49
data dictionary, 2
cache, 5.50, 5.51, 5.52, 5.53, 5.54, 5.55, 5.56
datafiles, 1.75
scripts, B.2
SQL scripts, B.1
tables, 2.1
views, 1.75
overview, 2.1
user views, 2
database writer process (DBWR)
checkpoint, 1.110
DATABASE_PROPERTIES view, 2.219
databases
block size, A.2
database limits, A
default language, 1.127
resource limits, 1.180, 1.181
datafiles
mapping blocks to PCM locks, 1.75
maximum number, 1.47
parameter, 1.47
unspecified for PCM locks, 1.75
dates
language used for, 1.124, 1.133, 1.134
setting SYSDATE, 1.74
TO_CHAR function, 1.123
TO_DATE function, 1.123
DB_BLOCK_BUFFERS initialization parameter, 1.36
DB_BLOCK_CHECKING initialization parameter, 1.37
DB_BLOCK_CHECKSUM initialization parameter, 1.38
DB_BLOCK_SIZE initialization parameter, 1.39
DB_CACHE_ADVICE initialization parameter, 1.40
DB_CACHE_SIZE initialization parameter, 1.41
DB_CREATE_FILE_DEST initialization parameter, 1.42
DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 1.43
DB_DOMAIN initialization parameter, 1.44
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 1.45
DB_FILE_NAME_CONVERT initialization parameter, 1.46
DB_FILES initialization parameter, 1.47
DB_FLASHBACK_RETENTION_TARGET initialization parameter, 1.48
DB_KEEP_CACHE_SIZE initialization parameter, 1.49
DB_NAME initialization parameter, 1.50
DB_nK_CACHE_SIZE initialization parameter, 1.35
DB_RECOVERY_FILE_DEST initialization parameter, 1.51
DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 1.52
DB_RECYCLE_CACHE_SIZE initialization parameter, 1.53
DB_UNIQUE_NAME initialization parameter, 1.54
DB_WRITER_PROCESSES initialization parameter, 1.55
DBA_2PC_NEIGHBORS view, 3.1
DBA_2PC_PENDING view, 3.2
DBA_ADVISOR_ACTIONS view, 3.3
DBA_ADVISOR_COMMANDS view, 3.4
DBA_ADVISOR_DEFINITIONS view, 3.5
DBA_ADVISOR_FINDINGS view, 3.6
DBA_ADVISOR_JOURNAL view, 3.7
DBA_ADVISOR_LOG view, 3.8
DBA_ADVISOR_OBJECT_TYPES view, 3.9
DBA_ADVISOR_OBJECTS view, 3.10
DBA_ADVISOR_PARAMETERS view, 3.11
DBA_ADVISOR_RATIONALE view, 3.12
DBA_ADVISOR_RECOMMENDATIONS view, 3.13
DBA_ADVISOR_SQLA_REC_SUM view, 3.14
DBA_ADVISOR_SQLA_WK_MAP view, 3.15
DBA_ADVISOR_SQLA_WK_STMTS view, 3.16
DBA_ADVISOR_SQLW_JOURNAL view, 3.17
DBA_ADVISOR_SQLW_PARAMETERS view, 3.18
DBA_ADVISOR_SQLW_STMTS view, 3.19
DBA_ADVISOR_SQLW_SUM view, 3.20
DBA_ADVISOR_SQLW_TABLES view, 3.21
DBA_ADVISOR_SQLW_TEMPLATES view, 3.22
DBA_ADVISOR_TASKS view, 3.23
DBA_ADVISOR_TEMPLATES view, 3.24
DBA_ADVISOR_USAGE view, 3.25
DBA_ALERT_HISTORY view, 3.26
DBA_ALL_TABLES view, 3.27
DBA_APPLICATION_ROLES view, 3.28
DBA_APPLY view, 3.29
DBA_APPLY_CONFLICT_COLUMNS view, 3.30
DBA_APPLY_DML_HANDLERS view, 3.31
DBA_APPLY_ENQUEUE view, 3.32
DBA_APPLY_ERROR view, 3.33
DBA_APPLY_EXECUTE view, 3.34
DBA_APPLY_INSTANTIATED_GLOBAL view, 3.35
DBA_APPLY_INSTANTIATED_OBJECTS view, 3.36
DBA_APPLY_INSTANTIATED_SCHEMAS view, 3.37
DBA_APPLY_KEY_COLUMNS view, 3.38
DBA_APPLY_PARAMETERS view, 3.39
DBA_APPLY_PROGRESS view, 3.40
DBA_APPLY_TABLE_COLUMNS view, 3.41
DBA_AQ_AGENT_PRIVS view, 3.42
DBA_AQ_AGENTS view, 3.43
DBA_ASSOCIATIONS view, 3.44
DBA_ATTRIBUTE_TRANSFORMATIONS view, 3.45
DBA_AUDIT_EXISTS view, 3.46
DBA_AUDIT_OBJECT view, 3.47
DBA_AUDIT_POLICIES view, 3.48
DBA_AUDIT_POLICY_COLUMNS view, 3.49
DBA_AUDIT_SESSION view, 3.50
DBA_AUDIT_STATEMENT view, 3.51
DBA_AUDIT_TRAIL view, 3.52
DBA_AW_PS view, 3.53
DBA_AWS view, 3.54
DBA_BASE_TABLE_MVIEWS view, 3.55
DBA_BLOCKERS view, 3.56
DBA_CAPTURE view, 3.57
DBA_CAPTURE_EXTRA_ATTRIBUTES view, 3.58
DBA_CAPTURE_PARAMETERS view, 3.59
DBA_CAPTURE_PREPARED_DATABASE view, 3.60
DBA_CAPTURE_PREPARED_SCHEMAS view, 3.61
DBA_CAPTURE_PREPARED_TABLES view, 3.62
DBA_CATALOG view, 3.63
DBA_CLU_COLUMNS view, 3.64
DBA_CLUSTER_HASH_EXPRESSIONS view, 3.65
DBA_CLUSTERS view, 3.66
DBA_COL_COMMENTS view, 3.67
DBA_COL_PRIVS view, 3.68
DBA_COLL_TYPES view, 3.69
DBA_COMMON_AUDIT_TRAIL view, 3.70
DBA_CONS_OBJ_COLUMNS view, 3.71
DBA_CONSTRAINTS view, 3.72
DBA_CONTEXT view, 3.73
DBA_DATA_FILES view, 3.74
DBA_DATAPUMP_JOBS view, 3.75
DBA_DATAPUMP_SESSIONS view, 3.76
DBA_DB_LINKS view, 3.77
DBA_DDL_LOCKS view, 3.78
DBA_DEPENDENCIES view, 3.79
DBA_DIM_ATTRIBUTES view, 3.80
DBA_DIM_CHILD_OF view, 3.81
DBA_DIM_HIERARCHIES view, 3.82
DBA_DIM_JOIN_KEY view, 3.83
DBA_DIM_LEVEL_KEY view, 3.84
DBA_DIM_LEVELS view, 3.85
DBA_DIMENSIONS view, 3.86
DBA_DIRECTORIES view, 3.87
DBA_DML_LOCKS view, 3.88
DBA_DMT_FREE_SPACE view, 3.89
DBA_DMT_USED_EXTENTS view, 3.90
DBA_ENABLED_AGGREGATIONS view, 3.91
DBA_ENABLED_TRACES view, 3.92
DBA_ERRORS view, 3.93
DBA_EVALUATION_CONTEXT_TABLES view, 3.94
DBA_EVALUATION_CONTEXT_VARS view, 3.95
DBA_EVALUATION_CONTEXTS view, 3.96
DBA_EXP_FILES view, 3.97
DBA_EXP_OBJECTS view, 3.98
DBA_EXP_VERSION view, 3.99
DBA_EXTENTS view, 3.100
DBA_EXTERNAL_LOCATIONS view, 3.101
DBA_EXTERNAL_TABLES view, 3.102
DBA_FEATURE_USAGE_STATISTICS view, 3.103
DBA_FGA_AUDIT_TRAIL view, 3.104
DBA_FREE_SPACE view, 3.105
DBA_FREE_SPACE_COALESCED view, 3.106
DBA_HIGH_WATER_MARK_STATISTICS view, 3.107
DBA_HIST_ACTIVE_SESS_HISTORY view, 3.108
DBA_HIST_BASELINE view, 3.109
DBA_HIST_BG_EVENT_SUMMARY view, 3.110
DBA_HIST_BUFFER_POOL_STAT view, 3.111
DBA_HIST_CR_BLOCK_SERVER view, 3.112
DBA_HIST_CURRENT_BLOCK_SERVER view, 3.113
DBA_HIST_DATABASE_INSTANCE view, 3.114
DBA_HIST_DATAFILE view, 3.115
DBA_HIST_DB_CACHE_ADVICE view, 3.116
DBA_HIST_DLM_MISC view, 3.117
DBA_HIST_ENQUEUE_STAT view, 3.118
DBA_HIST_EVENT_NAME view, 3.119
DBA_HIST_FILEMETRIC_HISTORY view, 3.120
DBA_HIST_FILESTATXS view, 3.121
DBA_HIST_INSTANCE_RECOVERY view, 3.122
DBA_HIST_JAVA_POOL_ADVICE view, 3.123
DBA_HIST_LATCH view, 3.124
DBA_HIST_LATCH_CHILDREN view, 3.125
DBA_HIST_LATCH_MISSES_SUMMARY view, 3.126
DBA_HIST_LATCH_NAME view, 3.127
DBA_HIST_LATCH_PARENT view, 3.128
DBA_HIST_LIBRARYCACHE view, 3.129
DBA_HIST_LOG view, 3.130
DBA_HIST_METRIC_NAME view, 3.131
DBA_HIST_MTTR_TARGET_ADVICE view, 3.132
DBA_HIST_OPTIMIZER_ENV view, 3.133
DBA_HIST_OSSTAT view, 3.134
DBA_HIST_OSSTAT_NAME view, 3.135
DBA_HIST_PARAMETER view, 3.136
DBA_HIST_PARAMETER_NAME view, 3.137
DBA_HIST_PGA_TARGET_ADVICE view, 3.138
DBA_HIST_PGASTAT view, 3.139
DBA_HIST_RESOURCE_LIMIT view, 3.140
DBA_HIST_ROLLSTAT view, 3.141
DBA_HIST_ROWCACHE_SUMMARY view, 3.142
DBA_HIST_SEG_STAT view, 3.143
DBA_HIST_SEG_STAT_OBJ view, 3.144
DBA_HIST_SERVICE_NAME view, 3.145
DBA_HIST_SERVICE_STAT view, 3.146
DBA_HIST_SERVICE_WAIT_CLASS view, 3.147
DBA_HIST_SESSMETRIC_HISTORY view, 3.148
DBA_HIST_SGA view, 3.149
DBA_HIST_SGASTAT view, 3.150
DBA_HIST_SHARED_POOL_ADVICE view, 3.151
DBA_HIST_SNAP_ERROR view, 3.152
DBA_HIST_SNAPSHOT view, 3.153
DBA_HIST_SQL_PLAN view, 3.154
DBA_HIST_SQL_SUMMARY view, 3.155
DBA_HIST_SQL_WORKAREA_HSTGRM view, 3.156
DBA_HIST_SQLBIND view, 3.157
DBA_HIST_SQLSTAT view, 3.158
DBA_HIST_SQLTEXT view, 3.159
DBA_HIST_STAT_NAME view, 3.160
DBA_HIST_SYS_TIME_MODEL view, 3.161
DBA_HIST_SYSMETRIC_HISTORY view, 3.162
DBA_HIST_SYSMETRIC_SUMMARY view, 3.163
DBA_HIST_SYSSTAT view, 3.164
DBA_HIST_SYSTEM_EVENT view, 3.165
DBA_HIST_TABLESPACE_STAT view, 3.166
DBA_HIST_TBSPC_SPACE_USAGE view, 3.167
DBA_HIST_TEMPFILE view, 3.168
DBA_HIST_TEMPSTATXS view, 3.169
DBA_HIST_THREAD view, 3.170
DBA_HIST_UNDOSTAT view, 3.171
DBA_HIST_WAITCLASSMET_HISTORY view, 3.172
DBA_HIST_WAITSTAT view, 3.173
DBA_HIST_WR_CONTROL view, 3.174
DBA_IND_COLUMNS view, 3.175
DBA_IND_EXPRESSIONS view, 3.176
DBA_IND_PARTITIONS view, 3.177
DBA_IND_STATISTICS view, 3.178
DBA_IND_SUBPARTITIONS view, 3.179
DBA_INDEXES view, 3.180
collecting statistics for, 3.179
DBA_INDEXTYPE_ARRAYTYPES view, 3.181
DBA_INDEXTYPE_COMMENTS view, 3.182
DBA_INDEXTYPE_OPERATORS view, 3.183
DBA_INDEXTYPES view, 3.184
DBA_INTERNAL_TRIGGERS view, 3.185
DBA_JAVA_ARGUMENTS view, 3.186
DBA_JAVA_CLASSES view, 3.187
DBA_JAVA_DERIVATIONS view, 3.188
DBA_JAVA_FIELDS view, 3.189
DBA_JAVA_IMPLEMENTS view, 3.190
DBA_JAVA_INNERS view, 3.191
DBA_JAVA_LAYOUTS view, 3.192
DBA_JAVA_METHODS view, 3.193
DBA_JAVA_NCOMPS view, 3.194
DBA_JAVA_POLICY view, 3.195
DBA_JAVA_RESOLVERS view, 3.196
DBA_JAVA_THROWS view, 3.197
DBA_JOBS view, 3.198
DBA_JOBS_RUNNING view, 3.199
DBA_JOIN_IND_COLUMNS view, 3.200
DBA_KGLLOCK view, 3.201
DBA_LIBRARIES view, 3.202
DBA_LMT_FREE_SPACE view, 3.203
DBA_LMT_USED_EXTENTS view, 3.204
DBA_LOB_PARTITIONS view, 3.205
DBA_LOB_SUBPARTITIONS view, 3.206
DBA_LOB_TEMPLATES view, 3.207
DBA_LOBS view, 3.208
DBA_LOCK view, 3.209
DBA_LOCKS synonym, 3.211
DBA_LOCK_INTERNAL view, 3.210
DBA_LOCKS synonym for DBA_LOCK view, 3.211
DBA_LOG_GROUP_COLUMNS view, 3.212
DBA_LOG_GROUPS view, 3.213
DBA_LOGMNR_LOG view, 3.214
DBA_LOGMNR_PURGED_LOG view, 3.215
DBA_LOGMNR_SESSION view, 3.216
DBA_LOGSTDBY_EVENTS view, 3.217
DBA_LOGSTDBY_LOG view, 3.218
DBA_LOGSTDBY_NOT_UNIQUE view, 3.219
DBA_LOGSTDBY_PARAMETERS view, 3.220
DBA_LOGSTDBY_PROGRESS view, 3.221
DBA_LOGSTDBY_SKIP view, 3.222
DBA_LOGSTDBY_SKIP_TRANSACTION view, 3.223
DBA_LOGSTDBY_UNSUPPORTED view, 3.224
DBA_METHOD_PARAMS view, 3.225
DBA_METHOD_RESULTS view, 3.226
DBA_MVIEW_AGGREGATES view, 3.227
DBA_MVIEW_ANALYSIS view, 3.228
DBA_MVIEW_COMMENTS view, 3.229
DBA_MVIEW_DETAIL_RELATIONS view, 3.230
DBA_MVIEW_JOINS view, 3.231
DBA_MVIEW_KEYS view, 3.232
DBA_MVIEW_LOG_FILTER_COLS view, 3.233
DBA_MVIEW_LOGS view, 3.234
DBA_MVIEW_REFRESH_TIMES view, 3.235
DBA_MVIEWS view, 3.236
DBA_NESTED_TABLE_COLS view, 3.237
DBA_NESTED_TABLES view, 3.238
DBA_OBJ_AUDIT_OPTS view, 3.239
DBA_OBJ_COLATTRS view, 3.240
DBA_OBJECT_SIZE view, 3.241
DBA_OBJECT_TABLES view, 3.242
DBA_OBJECTS view, 3.243
DBA_OPANCILLARY view, 3.244
DBA_OPARGUMENTS view, 3.245
DBA_OPBINDINGS view, 3.246
DBA_OPERATOR_COMMENTS view, 3.247
DBA_OPERATORS view, 3.248
DBA_ORPHAN_KEY_TABLE view, 3.249
DBA_OUTLINE_HINTS view, 3.250
DBA_OUTLINES view, 3.251
DBA_OUTSTANDING_ALERTS view, 3.252
DBA_PART_COL_STATISTICS view, 3.253
DBA_PART_HISTOGRAMS view, 3.254
DBA_PART_INDEXES view, 3.255
DBA_PART_KEY_COLUMNS view, 3.256
DBA_PART_LOBS view, 3.257
DBA_PART_TABLES view, 3.258
DBA_PARTIAL_DROP_TABS view, 3.259
DBA_PENDING_CONV_TABLES view, 3.260
DBA_PENDING_TRANSACTIONS view, 3.261
DBA_PLSQL_OBJECT_SETTINGS view, 3.262
DBA_POLICIES view, 3.263
DBA_POLICY_CONTEXTS view, 3.264
DBA_POLICY_GROUPS view, 3.265
DBA_PRIV_AUDIT_OPTS view, 3.266
DBA_PROCEDURES view, 3.267
DBA_PROFILES view, 3.268
DBA_PROPAGATION view, 3.269
DBA_PROXIES view, 3.270
DBA_PUBLISHED_COLUMNS view, 3.271
DBA_QUEUE_SCHEDULES view, 3.272
DBA_QUEUE_TABLES view, 3.273
DBA_QUEUES view, 3.274
DBA_RCHILD view, 3.275
DBA_RECYCLEBIN view, 3.276
DBA_REDEFINITION_ERRORS view, 3.277
DBA_REDEFINITION_OBJECTS view, 3.278
DBA_REFRESH view, 3.279
DBA_REFRESH_CHILDREN view, 3.280
DBA_REFS view, 3.281
DBA_REGISTERED_ARCHIVED_LOG view, 3.282
DBA_REGISTERED_MVIEW_GROUPS view, 3.283
DBA_REGISTERED_MVIEWS view, 3.284
DBA_REGISTRY view, 3.285
DBA_REGISTRY_HIERARCHY view, 3.286
DBA_REPAIR_TABLE view, 3.287
DBA_REPCAT view, 2.1.1
DBA_REPCAT_EXCEPTIONS view, 2.1.1
DBA_REPCAT_REFRESH_TEMPLATES view, 2.1.1
DBA_REPCAT_TEMPLATE_OBJECTS view, 2.1.1
DBA_REPCAT_TEMPLATE_PARMS view, 2.1.1
DBA_REPCAT_TEMPLATE_SITES view, 2.1.1
DBA_REPCAT_USER_AUTHORIZATIONS view, 2.1.1
DBA_REPCAT_USER_PARM_VALUES view, 2.1.1
DBA_REPCATLOG view, 2.1.1
DBA_REPCOLUMN view, 2.1.1
DBA_REPCOLUMN_GROUP view, 2.1.1
DBA_REPCONFLICT view, 2.1.1
DBA_REPDDL view, 2.1.1
DBA_REPEXTENSIONS view, 2.1.1
DBA_REPFLAVOR_COLUMNS view, 2.1.1
DBA_REPFLAVOR_OBJECTS view, 2.1.1
DBA_REPFLAVORS view, 2.1.1
DBA_REPGENERATED view, 2.1.1
DBA_REPGENOBJECTS view, 2.1.1
DBA_REPGROUP view, 2.1.1
DBA_REPGROUP_PRIVILEGES view, 2.1.1
DBA_REPGROUPED_COLUMN view, 2.1.1
DBA_REPKEY_COLUMNS view, 2.1.1
DBA_REPOBJECT view, 2.1.1
DBA_REPPARAMETER_COLUMN view, 2.1.1
DBA_REPPRIORITY view, 2.1.1
DBA_REPPRIORITY_GROUP view, 2.1.1
DBA_REPPROP view, 2.1.1
DBA_REPRESOL_STATS_CONTROL view, 2.1.1
DBA_REPRESOLUTION view, 2.1.1
DBA_REPRESOLUTION_METHOD view, 2.1.1
DBA_REPRESOLUTION_STATISTICS view, 2.1.1
DBA_REPSCHEMA view, 2.1.1
DBA_REPSITES view, 2.1.1
DBA_REPSITES_NEW view, 2.1.1
DBA_RESUMABLE view, 3.288
DBA_REWRITE_EQUIVALENCES view, 3.289
DBA_RGROUP view, 3.290
DBA_ROLE_PRIVS view, 3.291
DBA_ROLES view, 3.292
DBA_ROLLBACK_SEGS view, 3.293
DBA_RSRC_CONSUMER_GROUP_PRIVS view, 3.294
DBA_RSRC_CONSUMER_GROUPS view, 3.295
DBA_RSRC_GROUP_MAPPINGS view, 3.296
DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 3.297
DBA_RSRC_MAPPING_PRIORITY view, 3.298
DBA_RSRC_PLAN_DIRECTIVES view, 3.299
DBA_RSRC_PLANS view, 3.300
DBA_RULE_SET_RULES view, 3.301
DBA_RULE_SETS view, 3.302
DBA_RULES view, 3.303
DBA_SCHEDULER_JOB_ARGS view, 3.304
DBA_SCHEDULER_JOB_CLASSES view, 3.305
DBA_SCHEDULER_JOB_LOG view, 3.306
DBA_SCHEDULER_JOB_RUN_DETAILS view, 3.307
DBA_SCHEDULER_JOBS view, 3.308
DBA_SCHEDULER_PROGRAM_ARGS view, 3.309
DBA_SCHEDULER_PROGRAMS view, 3.310
DBA_SCHEDULER_RUNNING_JOBS view, 3.311
DBA_SCHEDULER_SCHEDULES view, 3.312
DBA_SCHEDULER_WINDOW_DETAILS view, 3.313
DBA_SCHEDULER_WINDOW_GROUPS view, 3.314
DBA_SCHEDULER_WINDOW_LOG view, 3.315
DBA_SCHEDULER_WINDOWS view, 3.316
DBA_SCHEDULER_WINGROUP_MEMBERS view, 3.317
DBA_SEC_RELEVANT_COLS view, 3.318
DBA_SEGMENTS view, 3.319
DBA_SEQUENCES view, 3.320
DBA_SERVER_REGISTRY view, 3.321
DBA_SERVICES view, 3.322
DBA_SOURCE view, 3.323
DBA_SOURCE_TABLES view, 3.324
DBA_SQL_PROFILES view, 3.325
DBA_SQLJ_TYPE_ATTRS view, 3.326
DBA_SQLJ_TYPE_METHODS view, 3.327
DBA_SQLJ_TYPES view, 3.328
DBA_SQLSET view, 3.329
DBA_SQLSET_BINDS view, 3.330
DBA_SQLSET_REFERENCES view, 3.331
DBA_SQLSET_STATEMENTS view, 3.332
DBA_SQLTUNE_BINDS view, 3.333
DBA_SQLTUNE_PLANS view, 3.334
DBA_SQLTUNE_RATIONALE_PLAN view, 3.335
DBA_SQLTUNE_STATISTICS view, 3.336
DBA_STMT_AUDIT_OPTS view, 3.337
DBA_STORED_SETTINGS view, 3.338
DBA_STREAMS_ADMINISTRATOR view, 3.339
DBA_STREAMS_GLOBAL_RULES view, 3.340
DBA_STREAMS_MESSAGE_CONSUMERS view, 3.341
DBA_STREAMS_MESSAGE_RULES view, 3.342
DBA_STREAMS_NEWLY_SUPPORTED view, 3.343
DBA_STREAMS_RULES view, 3.344
DBA_STREAMS_SCHEMA_RULES view, 3.345
DBA_STREAMS_TABLE_RULES view, 3.346
DBA_STREAMS_TRANSFORM_FUNCTION view, 3.347
DBA_STREAMS_UNSUPPORTED view, 3.348
DBA_SUBPART_COL_STATISTICS view, 3.349
DBA_SUBPART_HISTOGRAMS view, 3.350
DBA_SUBPART_KEY_COLUMNS view, 3.351
DBA_SUBPARTITION_TEMPLATES view, 3.352
DBA_SUBSCRIBED_COLUMNS view, 3.353
DBA_SUBSCRIBED_TABLES view, 3.354
DBA_SUBSCRIPTIONS view, 3.355
DBA_SYNONYMS view, 3.356
DBA_SYS_PRIVS view, 3.357
DBA_TAB_COL_STATISTICS view, 3.358
DBA_TAB_COLS view, 3.359
DBA_TAB_COLUMNS view, 3.360
DBA_TAB_COMMENTS view, 3.361
DBA_TAB_HISTOGRAMS view, 3.362
DBA_TAB_MODIFICATIONS view, 3.363
DBA_TAB_PARTITIONS view, 3.364
DBA_TAB_PRIVS view, 3.365
DBA_TAB_STATISTICS view, 3.366
DBA_TAB_SUBPARTITIONS view, 3.367
DBA_TABLES view, 3.368
DBA_TABLESPACE_GROUPS view, 3.369
DBA_TABLESPACES view, 3.370
DBA_TEMP_FILES view, 3.371
DBA_THRESHOLDS view, 3.372
DBA_TRANSFORMATIONS view, 3.373
DBA_TRIGGER_COLS view, 3.374
DBA_TRIGGERS view, 3.375
DBA_TS_QUOTAS view, 3.376
DBA_TUNE_MVIEW view, 3.377
DBA_TYPE_ATTRS view, 3.378
DBA_TYPE_METHODS view, 3.379
DBA_TYPE_VERSIONS view, 3.380
DBA_TYPES view, 3.381
DBA_UNDO_EXTENTS view, 3.382
DBA_UNUSED_COL_TABS view, 3.383
DBA_UPDATABLE_COLUMNS view, 3.384
DBA_USERS view, 3.385
DBA_USTATS view, 3.386
DBA_VARRAYS view, 3.387
DBA_VIEWS view, 3.388
DBA_WAITERS view, 3.389
DBA_WARNING_SETTINGS view, 3.390
DBA_WORKSPACE_SESSIONS view, 2.1.2
DBA_XML_SCHEMAS view, 3.391
DBA_XML_TAB_COLS view, 3.392
DBA_XML_TABLES view, 3.393
DBA_XML_VIEW_COLS view, 3.394
DBA_XML_VIEWS view, 3.399
DBMS_ALERT_INFO view, 3.400
DBMS_LOCK_ALLOCATED view, 3.401
DBMSIOTC.SQL script, B.2
DBMSOTRC.SQL script, B.2
DBMSPOOL.SQL script, B.2
DBWR_IO_SLAVES initialization parameter, 1.56
DDL_WAIT_FOR_LOCKS initialization parameter, 1.57
DEFCALL view, 2.1.1
DEFCALLDEST view, 2.1.1
DEFDEFAULTDEST view, 2.1.1
DEFERRCOUNT view, 2.1.1
DEFERROR view, 2.1.1
DEFLOB view, 2.1.1
DEFPROPAGATOR view, 2.1.1
DEFSCHEDULE view, 2.1.1
DEFTRAN view, 2.1.1
DEFTRANDEST view, 2.1.1
DEPTREE view, 3.402
destination
archiving redo log files, 1.100
overriding default, 1.100
USER_DUMP_DEST, 1.222
DG_BROKER_CONFIG_FILEn initialization parameter, 1.58
DG_BROKER_START initialization parameter, 1.59
DICT synonym for DICTIONARY, 3.403
DICT_COLUMNS view, 3.404
DICTIONARY view, 3.405
DICT synonym, 3.403
disk drives
archiving destination, 1.100
DISK_ASYNCH_IO initialization parameter, 1.60
dispatcher processes
maximum number, 1.116
DISPATCHERS initialization parameter, 1.61
distinguished name, 1.170
DISTRIBUTED_LOCK_TIMEOUT initialization parameter, 1.62
DML_LOCKS initialization parameter, 1.63
downgrading
scripts, B.4
dump files, 1.117
dynamic performance tables
CATALOG.SQL script, 4.1
public synonyms (V$), 4.1.1
views (V_$), 4.1.1

E

embedded initialization parameter files, 1.82
ENQUEUE_RESOURCES initialization parameter, 1.64
enqueues
AJV snapshot refresh, D
ALTER SYSTEM SET PARAMETER = VALUE, D
backup/restore, D
being written redo log, D
bind, D
buffer cache management, D
controlfile transaction, D
cross-instance call invocation, D
database mount, D
datafile, D
direct loader index creation, D
disabling, 1.63
distributed recovery process, D
distributed transaction, D
DML, D
ENQUEUE_RESOURCES initialization parameter, 1.64
extend table, D
file set, D
high-water lock, D
instance attribute lock, D
instance number, D
instance recovery, D
instance registration lock, D
instance state, D
job queue, D
library cache invalidation, D
library cache lock, D
library cache pin, D
log start or switch, D
media recovery, D
mount definition, D
object reuse, D
parallel slave synchronization, D
parallel slaves, D
password file, D
process startup, D
redo log "kick", D
redo thread, D
row cache, D
row wait, D
sequence number, D, D
sequence number value, D
SMON, D
sort segment, D
space management transaction, D
synchronized replication, D
system commit number, D
temporary segment, D
temporary table, D
temporary table object, D
thread checkpoint, D
transaction, D
transaction recovery, D
undo segment, serialization, D
user name, D
user-defined locks, D
enterprise roles, 1.170
ERROR_SIZE view, 3.406
EVENT initialization parameter, 1.65
EXCEPTIONS view, 3.407
extent
allocating to instance, 1.85

F

FAL_CLIENT initialization parameter, 1.66
FAL_SERVER initialization parameter, 1.67
FAST_START_IO_TARGET initialization parameter, 1.68
FAST_START_MTTR_TARGET initialization parameter, 1.69
FAST_START_PARALLEL_ROLLBACK initialization parameter, 1.70
FILE_MAPPING initialization parameter, 1.71
FILEIO_NETWORK_ADAPTERS initialization parameter, 1.72
filenames
case significance, 1.3.2.1.1
name and number, 1.75
FILESYSTEMIO_OPTIONS initialization parameter, 1.73
FIXED_DATE initialization parameter, 1.74
FLASHBACK_TRANSACTION_QUERY view, 3.395
free space list
locating space, 1.85
FREELIST GROUPS clause, 1.85

G

GC_FILES_TO_LOCKS initialization parameter, 1.75
GCS_SERVER_PROCESSES initialization parameter, 1.76
GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1.77
GLOBAL_NAME view, 3.396
GLOBAL_NAMES initialization parameter, 1.78
GV$ views
for Real Application Clusters, 4.1.2

H

HASH_AREA_SIZE initialization parameter, 1.79
Heterogeneous Services
agents, 1.81
HI_SHARED_MEMORY_ADDRESS initialization parameter, 1.80
HS_ALL_CAPS view, 3.397
HS_ALL_DD view, 3.398
HS_ALL_INITS view, 3.408
HS_AUTOREGISTER initialization parameter, 1.81
HS_BASE_CAPS view, 3.409
HS_BASE_DD view, 3.410
HS_CLASS_CAPS view, 3.411
HS_CLASS_DD view, 3.412
HS_CLASS_INIT view, 3.413
HS_EXTERNAL_OBJECT_PRIVILEGES view, 3.414
HS_EXTERNAL_OBJECTS view, 3.415
HS_EXTERNAL_USER_PRIVILEGES view, 3.416
HS_FDS_CLASS view, 3.417
HS_FDS_INST view, 3.418
HS_INST_CAPS view, 3.419
HS_INST_DD view, 3.420
HS_INST_INIT view, 3.421

I

IDEPTREE view, 3.422
IFILE initialization parameter, 1.3.2.1.1, 1.82
IND synonym for USER_INDEXES view, 3.423
INDEX_HISTOGRAM view, 3.424
INDEX_STATS view, 3.425
initialization parameter file
common file, 1.82
embedded, 1.82
INITDW.ORA
line continuation character, 1.3.2.1.1
overview, 1.3
initialization parameters
ACTIVE_INSTANCE_COUNT, 1.7
altering, 1.4
AQ_TM_PROCESSES, 1.8
ARCHIVE_LAG_TARGET, 1.9
ASM_DISKGROUPS, 1.10
ASM_DISKSTRING, 1.11
ASM_POWER_LIMIT, 1.12
AUDIT_FILE_DEST, 1.13
AUDIT_SYS_OPERATIONS, 1.14
AUDIT_TRAIL, 1.15
BACKGROUND_CORE_DUMP, 1.16
BACKGROUND_DUMP_DEST, 1.17
BACKUP_TAPE_IO_SLAVES, 1.18
basic, 1.2
BITMAP_MERGE_AREA_SIZE, 1.19
BLANK_TRIMMING, 1.20
case significance in filenames, 1.3.2.1.1
CIRCUITS, 1.21
CLUSTER_DATABASE, 1.22
CLUSTER_DATABASE_INSTANCES, 1.23
CLUSTER_INTERCONNECTS, 1.24
COMMIT_POINT_STRENGTH, 1.25
COMPATIBLE, 1.26
CONTROL_FILE_RECORD_KEEP_TIME, 1.27
CONTROL_FILES, 1.28
CORE_DUMP_DEST, 1.29
CPU_COUNT, 1.30
CREATE_BITMAP_AREA_SIZE, 1.31
CREATE_STORED_OUTLINES, 1.32
CURSOR_SHARING, 1.33
CURSOR_SPACE_FOR_TIME, 1.34
DB_BLOCK_BUFFERS, 1.36
DB_BLOCK_CHECKING, 1.37
DB_BLOCK_CHECKSUM, 1.38
DB_BLOCK_SIZE, 1.39
DB_CACHE_ADVICE, 1.40
DB_CACHE_SIZE, 1.41
DB_CREATE_FILE_DEST, 1.42
DB_CREATE_ONLINE_LOG_DEST_n, 1.43
DB_DOMAIN, 1.44
DB_FILE_MULTIBLOCK_READ_COUNT, 1.45
DB_FILE_NAME_CONVERT, 1.46
DB_FILES, 1.47
DB_FLASHBACK_RETENTION_TARGET, 1.48
DB_KEEP_CACHE_SIZE, 1.49
DB_NAME, 1.50
DB_nK_CACHE_SIZE, 1.35
DB_RECOVERY_FILE_DEST, 1.51
DB_RECOVERY_FILE_DEST_SIZE, 1.52
DB_RECYCLE_CACHE_SIZE, 1.53
DB_UNIQUE_NAME, 1.54
DB_WRITER_PROCESSES, 1.55
DBWR_IO_SLAVES, 1.56
DDL_WAIT_FOR_LOCKS, 1.57
derived, 1.1.1.1
DG_BROKER_CONFIG_FILEn, 1.58
DG_BROKER_START, 1.59
DISK_ASYNCH_IO, 1.60
DISPATCHERS, 1.61
display current settings, 1.4.3
DISTRIBUTED_LOCK_TIMEOUT, 1.62
DML_LOCKS, 1.63
embedded initialization parameter files, 1.3.2.1.1
ENQUEUE_RESOURCES, 1.64
EVENT, 1.65
FAL_CLIENT, 1.66
FAL_SERVER, 1.67
FAST_START_IO_TARGET, 1.68
FAST_START_MTTR_TARGET, 1.69
FAST_START_PARALLEL_ROLLBACK, 1.70
FILE_MAPPING, 1.71
FILEIO_NETWORK_ADAPTERS, 1.72
FILESYSTEMIO_OPTIONS, 1.73
FIXED_DATE, 1.74
functional category, 1.4.1
GC_FILES_TO_LOCKS, 1.75
GCS_SERVER_PROCESSES, 1.76
GLOBAL_CONTEXT_POOL_SIZE, 1.77
GLOBAL_NAMES, 1.78
HASH_AREA_SIZE, 1.79
HI_SHARED_MEMORY_ADDRESS, 1.80
HS_AUTOREGISTER, 1.81
IFILE, 1.3.2.1.1, 1.82
INSTANCE_GROUPS, 1.83
INSTANCE_NAME, 1.84
INSTANCE_NUMBER, 1.85
INSTANCE_TYPE, 1.86
JAVA_MAX_SESSIONSPACE_SIZE, 1.87
JAVA_POOL_SIZE, 1.88
JAVA_SOFT_SESSIONSPACE_LIMIT, 1.89
JOB_QUEUE_PROCESSES, 1.90
LARGE_POOL_SIZE, 1.91
LDAP_DIRECTORY_ACCESS, 1.92
LICENSE_MAX_SESSIONS, 1.93
LICENSE_MAX_USERS, 1.94
LICENSE_SESSIONS_WARNING, 1.95
LOCAL_LISTENER, 1.96
LOCK_NAME_SPACE, 1.97
LOCK_SGA, 1.98
LOG_ARCHIVE_CONFIG, 1.99
LOG_ARCHIVE_DEST, 1.100
LOG_ARCHIVE_DEST_n, 1.101
LOG_ARCHIVE_DEST_STATE_n, 1.102
LOG_ARCHIVE_DUPLEX_DEST, 1.103
LOG_ARCHIVE_FORMAT, 1.104
LOG_ARCHIVE_LOCAL_FIRST, 1.105
LOG_ARCHIVE_MAX_PROCESSES, 1.106
LOG_ARCHIVE_MIN_SUCCEED_DEST, 1.107
LOG_ARCHIVE_TRACE, 1.108
LOG_BUFFER, 1.109
LOG_CHECKPOINT_INTERVAL, 1.110
LOG_CHECKPOINT_TIMEOUT, 1.111
LOG_CHECKPOINTS_TO_ALERT, 1.112
LOG_FILE_NAME_CONVERT, 1.113
LOGMNR_MAX_PERSISTENT_SESSIONS, 1.114
MAX_COMMIT_PROPAGATION_DELAY, 1.115
MAX_DISPATCHERS, 1.116
MAX_DUMP_FILE_SIZE, 1.117
MAX_ENABLED_ROLES, 1.118
MAX_SHARED_SERVERS, 1.119
modifiable, 1.4.2
NLS_CALENDAR, 1.120
NLS_COMP, 1.121
NLS_CURRENCY, 1.122
NLS_DATE_FORMAT, 1.123
NLS_DATE_LANGUAGE, 1.124
NLS_DUAL_CURRENCY, 1.125
NLS_ISO_CURRENCY, 1.126
NLS_LANGUAGE, 1.127
NLS_LENGTH_SEMANTICS, 1.128
NLS_NCHAR_CONV_EXCP, 1.129
NLS_NUMERIC_CHARACTERS, 1.130
NLS_SORT, 1.131
NLS_TERRITORY, 1.132
NLS_TIMESTAMP_FORMAT, 1.133
NLS_TIMESTAMP_TZ_FORMAT, 1.134
O7_DICTIONARY_ACCESSIBILITY, 1.135
OBJECT_CACHE_MAX_SIZE_PERCENT, 1.136
OBJECT_CACHE_OPTIMAL_SIZE, 1.137
OLAP_PAGE_POOL_SIZE, 1.138
OPEN_CURSORS, 1.139
OPEN_LINKS, 1.140
OPEN_LINKS_PER_INSTANCE, 1.141
operating system-dependent values, 1.1.1.2
OPTIMIZER_DYNAMIC_SAMPLING, 1.142
OPTIMIZER_FEATURES_ENABLE, 1.143
OPTIMIZER_INDEX_CACHING, 1.144
OPTIMIZER_INDEX_COST_ADJ, 1.145
OPTIMIZER_MODE, 1.146
OS_AUTHENT_PREFIX, 1.147
OS_ROLES, 1.148
PARALLEL_ADAPTIVE_MULTI_USER, 1.149
PARALLEL_AUTOMATIC_TUNING, 1.150
PARALLEL_EXECUTION_MESSAGE_SIZE, 1.151
PARALLEL_INSTANCE_GROUP, 1.152
PARALLEL_MAX_SERVERS, 1.153
PARALLEL_MIN_PERCENT, 1.154
PARALLEL_MIN_SERVERS, 1.155
PARALLEL_THREADS_PER_CPU, 1.156
parameter files, 1.3
performance tuning, 1.1.1.3
PGA_AGGREGATE_TARGET, 1.157
PLSQL_CODE_TYPE, 1.158
PLSQL_COMPILER_FLAGS, 1.159
PLSQL_DEBUG, 1.160
PLSQL_NATIVE_LIBRARY_DIR, 1.161
PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT, 1.162
PLSQL_OPTIMIZE_LEVEL, 1.163
PLSQL_V2_COMPATIBILITY, 1.164
PLSQL_WARNINGS, 1.165
PRE_PAGE_SGA, 1.166
PROCESSES, 1.167
QUERY_REWRITE_ENABLED, 1.168
QUERY_REWRITE_INTEGRITY, 1.169
RDBMS_SERVER_DN, 1.170
READ_ONLY_OPEN_DELAYED, 1.171
RECOVERY_PARALLELISM, 1.172
REMOTE_ARCHIVE_ENABLE, 1.173
REMOTE_DEPENDENCIES_MODE, 1.174
REMOTE_LISTENER, 1.175
REMOTE_LOGIN_PASSWORDFILE, 1.176
REMOTE_OS_AUTHENT, 1.177
REMOTE_OS_ROLES, 1.178
REPLICATION_DEPENDENCY_TRACKING, 1.179
RESOURCE_LIMIT, 1.180
RESOURCE_MANAGER_PLAN, 1.181
RESUMABLE_TIMEOUT, 1.182
ROLLBACK_SEGMENTS, 1.183
SERIAL_REUSE, 1.184
SERVICE_NAMES, 1.185
SESSION_CACHED_CURSORS, 1.186
SESSION_MAX_OPEN_FILES, 1.187
SESSIONS, 1.188
SGA_MAX_SIZE, 1.189
SGA_TARGET, 1.190
SHADOW_CORE_DUMP, 1.191
SHARED_MEMORY_ADDRESS, 1.192
SHARED_POOL_RESERVED_SIZE, 1.193
SHARED_POOL_SIZE, 1.194
SHARED_SERVER_SESSIONS, 1.195
SHARED_SERVERS, 1.196
SKIP_UNUSABLE_INDEXES, 1.197
SMTP_OUT_SERVER, 1.198
SORT_AREA_RETAINED_SIZE, 1.199
SORT_AREA_SIZE, 1.200
specifying in initialization parameter files, 1.3.2.1
SPFILE, 1.201
SQL_TRACE, 1.202
SQL92_SECURITY, 1.203
SQLTUNE_CATEGORY, 1.204
STANDBY_ARCHIVE_DEST, 1.205
STANDBY_FILE_MANAGEMENT, 1.206
STAR_TRANSFORMATION_ENABLED, 1.207
STATISTICS_LEVEL, 1.208
STREAMS_POOL_SIZE, 1.209
TAPE_ASYNCH_IO, 1.210
THREAD, 1.211
TIMED_OS_STATISTICS, 1.212
TIMED_STATISTICS, 1.213
TRACE_ENABLED, 1.214
TRACEFILE_IDENTIFIER, 1.215
TRANSACTIONS, 1.216
TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1.217
UNDO_MANAGEMENT, 1.218
UNDO_RETENTION, 1.219
UNDO_TABLESPACE, 1.220
USE_INDIRECT_DATA_BUFFERS, 1.221
USER_DUMP_DEST, 1.222
UTL_FILE_DIR, 1.223
variable, 1.1.1.3
WORKAREA_SIZE_POLICY, 1.224
INITJVM.SQL script, B.5
INIT.ORA file. See initialization parameter file
IN-list iterators
optimizer use of, 1.144
inserts
locating free space, 1.85
INST_ID column, 4.1.2
INSTANCE clause
of ALTER TABLE
allocating extents, 1.85
INSTANCE_GROUPS initialization parameter, 1.83
INSTANCE_NAME initialization parameter, 1.84
INSTANCE_NUMBER initialization parameter, 1.85
INSTANCE_TYPE initialization parameter, 1.86
instances
checkpoint, 1.110
startup order, 1.85
I/O
reading multiple blocks, 1.45
redo log files, 1.109

J

Java initialization parameters
JAVA_MAX_SESSIONSPACE_SIZE, 1.87
JAVA_POOL_SIZE, 1.88
JAVA_SOFT_SESSIONSPACE_LIMIT, 1.89
Java scripts, B.5
JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1.87
JAVA_POOL_SIZE initialization parameter, 1.88
JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1.89
JOB_QUEUE_PROCESSES initialization parameter, 1.90

L

language
database default language, 1.127
LARGE_POOL_SIZE initialization parameter, 1.91
LDAP_DIRECTORY_ACCESS initialization parameter, 1.92
LICENSE_MAX_SESSIONS initialization parameter, 1.93
LICENSE_MAX_USERS initialization parameter, 1.94
LICENSE_SESSIONS_WARNING initialization parameter, 1.95
licenses
maximum sessions, 1.93
maximum users, 1.94
warning for concurrent user sessions, 1.95
limits on the database, A
linguistic sorts, 1.131
local currency, 1.122
LOCAL_LISTENER initialization parameter, 1.96
LOCK_NAME_SPACE initialization parameter, 1.97
LOCK_SGA initialization parameter, 1.98
locks
names, C.3
LOG_ARCHIVE_CONFIG initialization parameter, 1.99
LOG_ARCHIVE_DEST initialization parameter, 1.100
LOG_ARCHIVE_DEST_n initialization parameter, 1.101
LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1.102
LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1.103
LOG_ARCHIVE_FORMAT initialization parameter, 1.104
LOG_ARCHIVE_LOCAL_FIRST initialization parameter, 1.105
LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1.106
LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1.107
LOG_ARCHIVE_TRACE initialization parameter, 1.108
LOG_BUFFER initialization parameter, 1.109
LOG_CHECKPOINT_INTERVAL initialization parameter, 1.110
LOG_CHECKPOINT_TIMEOUT initialization parameter, 1.111
LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1.112
LOG_FILE_NAME_CONVERT initialization parameter, 1.113
LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 1.114
lowercase significance, 1.3.2.1.1

M

MAP_OBJECT table, 3.426
MAX_COMMIT_PROPAGATION_DELAY initialization parameter, 1.115
MAX_DISPATCHERS initialization parameter, 1.116
MAX_DUMP_FILE_SIZE initialization parameter, 1.117
MAX_ENABLED_ROLES initialization parameter, 1.118
MAX_SHARED_SERVERS initialization parameter, 1.119
memory
amount used for sorting, 1.199
virtual, 1.1.1.3
monitor
performance, 1.110
multiple-process systems
number of processes, 1.167

N

NLS_CALENDAR initialization parameter, 1.120
NLS_COMP initialization parameter, 1.121
NLS_CURRENCY initialization parameter, 1.122
defined by NLS_TERRITORY, 1.132
NLS_DATABASE_PARAMETERS view, 3.427
NLS_DATE_FORMAT initialization parameter, 1.123
defined by NLS_NUMERIC_CHARACTERS, 1.130
defined by NLS_TERRITORY, 1.132
NLS_DATE_LANGUAGE initialization parameter, 1.124
NLS_DUAL_CURRENCY initialization parameter, 1.125
NLS_INSTANCE_PARAMETERS view, 3.428
NLS_ISO_CURRENCY initialization parameter, 1.126
defined by NLS_TERRITORY, 1.132
NLS_LANGUAGE initialization parameter, 1.127
NLS_LENGTH_SEMANTICS initialization parameter, 1.128
NLS_NCHAR_CONV_EXCP initialization parameter, 1.129
NLS_NUMERIC_CHARACTERS initialization parameter, 1.130
NLS_SESSION_PARAMETERS view, 3.429
NLS_SORT initialization parameter, 1.131
NLS_TERRITORY initialization parameter, 1.132
NLS_TIMESTAMP_FORMAT initialization parameter, 1.133
NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1.134
numeric group separators, 1.130

O

O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1.135
OBJ synonym for USER_OBJECTS view, 3.430
OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1.136
OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1.137
objects
data dictionary, 2.1
OLAP_PAGE_POOL_SIZE initialization parameter, 1.138
online redo log
archiving mode, 1.100
block, 1.110
file size, 1.110
setting checkpoint interval, 1.110
OPEN_CURSORS initialization parameter, 1.139
OPEN_LINKS initialization parameter, 1.140
OPEN_LINKS_PER_INSTANCE initialization parameter, 1.141
operating system
authenticating remote clients, 1.177
authenticating users and passwords, 1.147
dependent parameters, 1.1.1.2
roles for remote clients, 1.178
optimization
trading cursor space for time, 1.34
OPTIMIZER_DYNAMIC_SAMPLING initialization parameter, 1.142
OPTIMIZER_FEATURES_ENABLE initialization parameter, 1.143
OPTIMIZER_INDEX_CACHING initialization parameter, 1.144
OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1.145
OPTIMIZER_MODE initialization parameter, 1.146
ORPHAN_KEY_TABLE view. See DBA_ORPHAN_KEY_TABLE view.
OS_AUTHENT_PREFIX initialization parameter, 1.147
OS_ROLES initialization parameter, 1.148

P

parallel query
maximum number of instances, 1.151
maximum number of servers, 1.153
minimum number of queries, 1.155
PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1.149
PARALLEL_AUTOMATIC_TUNING initialization parameter, 1.150
PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1.151
PARALLEL_INSTANCE_GROUP initialization parameter, 1.152
PARALLEL_MAX_SERVERS initialization parameter, 1.153
PARALLEL_MIN_PERCENT initialization parameter, 1.154
PARALLEL_MIN_SERVERS initialization parameter, 1.155
PARALLEL_THREADS_PER_CPU initialization parameter, 1.156
passwords
authenticating, 1.147, 1.177
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.176
PCM lock
mapping blocks to, 1.75
performance, 1.1.1.3
shared pool, 1.194
PGA_AGGREGATE_TARGET initialization parameter, 1.157
PLAN_TABLE table, 3.431
PLSQL_CODE_TYPE initialization parameter, 1.158
PLSQL_COMPILER_FLAGS initialization parameter, 1.159
PLSQL_DEBUG initialization parameter, 1.160
PLSQL_NATIVE_LIBRARY_DIR initialization parameter, 1.161
PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT initialization parameter, 1.162
PLSQL_OPTIMIZE_LEVEL initialization parameter, 1.163
PLSQL_V2_COMPATIBILITY initialization parameter, 1.164
PLSQL_WARNINGS initialization parameter, 1.165
PLUGGABLE_SET_CHECK view, 3.432
PRE_PAGE_SGA initialization parameter, 1.166
privileges
remote login, 1.176
RESTRICTED_SESSION privilege, 1.93, 1.95
table-level select privileges, 1.203
procedures
shared pool, 1.194
processes
derived parameter values, 1.216
dispatcher process maximum number, 1.116
maximum shared server processes, 1.119
number of server processes, 1.87, 1.89, 1.195, 1.196
recovery, 1.172
trace files, 1.222
user processes, 1.167
PROCESSES initialization parameter, 1.167
PRODUCT_COMPONENT_VERSION view, 3.433
profiles
resource limits, 1.180, 1.181
PROXY_USERS view, 3.434
PSTUBTBL view, 3.435
PUBLIC clause
of ALTER DATABASE
thread of redo, 1.211
PUBLIC_DEPENDENCY view, 3.436
PUBLICSYN view, 3.437

Q

queries
dictionary views, 1.75
hints, 1.146
QUERY_REWRITE_ENABLED initialization parameter, 1.168
QUERY_REWRITE_INTEGRITY initialization parameter, 1.169
QUEUE_PRIVILEGES view, 3.438

R

RC_ARCHIVED_LOG view, 2.1.3
RC_BACKUP_CONTROLFILE view, 2.1.3
RC_BACKUP_CORRUPTION view, 2.1.3
RC_BACKUP_DATAFILE view, 2.1.3
RC_BACKUP_PIECE view, 2.1.3
RC_BACKUP_REDOLOG view, 2.1.3
RC_BACKUP_SET view, 2.1.3
RC_BACKUP_SPFILE view, 2.1.3
RC_CHECKPOINT view, 2.1.3
RC_CONTROLFILE_COPY view, 2.1.3
RC_COPY_CORRUPTION view, 2.1.3
RC_DATABASE view, 2.1.3
RC_DATABASE_BLOCK_CORRUPTION view, 2.1.3
RC_DATABASE_INCARNATION view, 2.1.3
RC_DATAFILE view, 2.1.3
RC_DATAFILE_COPY view, 2.1.3
RC_LOG_HISTORY view, 2.1.3
RC_OFFLINE_RANGE view, 2.1.3
RC_PROXY_CONTROLFILE view, 2.1.3
RC_PROXY_DATAFILE view, 2.1.3
RC_REDO_LOG view, 2.1.3
RC_REDO_THREAD view, 2.1.3
RC_RESYNC view, 2.1.3
RC_RMAN_CONFIGURATION view, 2.1.3
RC_STORED_SCRIPT view, 2.1.3
RC_STORED_SCRIPT_LINE view, 2.1.3
RC_TABLESPACE view, 2.1.3
RDBMS_SERVER_DN initialization parameter, 1.170
READ_ONLY_OPEN_DELAYED initialization parameter, 1.171
Real Application Clusters
dynamic performance views, 4.1.2
initialization parameters
CIRCUITS, 1.21
CLUSTER_DATABASE, 1.22
CLUSTER_DATABASE_INSTANCES, 1.23
CLUSTER_INTERCONNECTS, 1.24
DISPATCHERS, 1.61
FAST_START_PARALLEL_ROLLBACK, 1.70
PARALLEL_ADAPTIVE_MULTI_USER, 1.149
PARALLEL_AUTOMATIC_TUNING, 1.150
PARALLEL_EXECUTION_MESSAGE_SIZE, 1.151
PARALLEL_INSTANCE_GROUP, 1.152
PARALLEL_MAX_SERVERS, 1.153
PARALLEL_MIN_PERCENT, 1.154
PARALLEL_MIN_SERVERS, 1.155
PARALLEL_THREADS_PER_CPU, 1.156
recovery
number of required processes, 1.172
RECOVERY_PARALLELISM initialization parameter, 1.172
RECYCLEBIN synonym for USER_RECYCLEBIN view, 3.439
redo logs
buffer size, 1.109
redo thread, 1.211
remote clients
authenticating, 1.177
remote logins, 1.176
REMOTE_ARCHIVE_ENABLE initialization parameter, 1.173
REMOTE_DEPENDENCIES_MODE initialization parameter, 1.174
REMOTE_LISTENER initialization parameter, 1.175
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.176
REMOTE_OS_AUTHENT initialization parameter, 1.177
REMOTE_OS_ROLES initialization parameter, 1.178
REPAIR_TABLE view. See DBA_REPAIR_TABLE view.
REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1.179
resource limits for profiles, 1.180, 1.181
RESOURCE_COST view, 3.440
RESOURCE_LIMIT initialization parameter, 1.180
RESOURCE_MANAGER_PLAN initialization parameter, 1.181
RESOURCE_MAP table, 3.441
RESUMABLE_TIMEOUT initialization parameter, 1.182
RMJVM.SQL script, B.5
ROLE_ROLE_PRIVS view, 3.442
ROLE_SYS_PRIVS view, 3.443
ROLE_TAB_PRIVS view, 3.444
ROLE_WM_PRIVS view, 2.1.2
roles, 1.148
remote clients, 1.178
ROLLBACK_SEGMENTS initialization parameter, 1.183

S

scripts
CATALOG.SQL, B.1
CATBLOCK.SQL, B.2
CATCLUST.SQL, B.1
CATEXP7.SQL, B.2
CATHS.SQL, B.2
CATIO.SQL, B.2
CATJAVA.SQL, B.5
CATNOADT.SQL, B.3
CATNOAUD.SQL, B.3
CATNOHS.SQL, B.3
CATNOPRT.SQL, B.3
CATNOQUE.SQL, B.3
CATNORMN.SQL, B.3
CATNOSVM.SQL, B.3
CATNSNMP.SQL, B.3
CATOCTK.SQL, B.2
CATPROC.SQL, B.1
CATQUEUE.SQL, B.2
CATREP.SQL, B.2
CATRMAN.SQL, B.2
D0902000.SQL, B.4
data dictionary, B.2
DBMSIOTC.SQL, B.2
DBMSOTRC.SQL, B.2
DBMSPOOL.SQL, B.2
downgrading, B.4
INITJVM.SQL, B.5
Java, B.5
RMJVM.SQL, B.5
SQL scripts, B.1
U0800060.SQL, B.4
U0801070.SQL, B.4
U0900010.SQL, B.4
U0902000.SQL, B.4
upgrading, B.4
USERLOCK.SQL, B.2
UTLBSTAT.SQL, B.2
UTLCHN1.SQL, B.2
UTLCONST.SQL, B.2
UTLDTREE.SQL, B.2
UTLESTAT.SQL, B.2
UTLEXPT1.SQL, B.2
UTLIP.SQL, B.2
UTLIRP.SQL, B.2
UTLLOCKT.SQL, B.2
UTLPWDMG.SQL, B.2
UTLRP.SQL, B.2
UTLSAMPL.SQL, B.2
UTLSCLN.SQL, B.2
UTLTKPRF.SQL, B.2
UTLU101I.SQL, B.4
UTLU101S.SQL, B.4
UTLVALID.SQL, B.2
UTLXPLAN.SQL, B.2
SEQ synonym for USER_SEQUENCES view, 3.445
SERIAL_REUSE initialization parameter, 1.184
server parameter file
overview, 1.3
server processes
number, 1.87, 1.89, 1.195, 1.196
SERVICE_NAMES initialization parameter, 1.185
SESSION_CACHED_CURSORS initialization parameter, 1.186
SESSION_CONTEXT view, 3.446
SESSION_MAX_OPEN_FILES initialization parameter, 1.187
SESSION_PRIVS view, 3.447
SESSION_ROLES view, 3.448
SESSIONS initialization parameter, 1.188
SGA_MAX_SIZE initialization parameter, 1.189
SGA_TARGET initialization parameter, 1.190
SHADOW_CORE_DUMP initialization parameter, 1.191
shared server
SESSIONS initialization parameter, 1.188
shared server processes
maximum number, 1.119
SHARED_MEMORY_ADDRESS initialization parameter, 1.192
SHARED_POOL_RESERVED_SIZE initialization parameter, 1.193
SHARED_POOL_SIZE initialization parameter, 1.194
SHARED_SERVER_SESSIONS initialization parameter, 1.195
SHARED_SERVERS initialization parameter, 1.196
SHOW PARAMETERS command, 1.4.3
SKIP_UNUSABLE_INDEXES initialization parameter, 1.197
SMTP_OUT_SERVER initialization parameter, 1.198
SORT_AREA_RETAINED_SIZE initialization parameter, 1.199
SORT_AREA_SIZE initialization parameter, 1.200
sorting
maximum memory, 1.199
ORDER BY queries, 1.131
SOURCE_SIZE view, 3.449
SPFILE initialization parameter, 1.201
SQL scripts
creating the data dictionary, B.1
optional, B.2
required, B.1
SQL_TRACE initialization parameter, 1.202
SQL92_SECURITY initialization parameter, 1.203
SQLTUNE_CATEGORY initialization parameter, 1.204
STANDBY_ARCHIVE_DEST initialization parameter, 1.205
STANDBY_FILE_MANAGEMENT initialization parameter, 1.206
STAR_TRANSFORMATION_ENABLED initialization parameter, 1.207
starting up
instance number, 1.85
startup order, 1.85
statistics
background checkpoints completed, E.2
background checkpoints started, E.2
background timeouts, E.2
branch node splits, E.2
buffer is not pinned count, E.2
buffer is pinned count, E.2
bytes received via SQL*Net from client, E.2
bytes received via SQL*Net from dblink, E.2
bytes sent via SQL*Net to client, E.2
bytes sent via SQL*Net to dblink, E.2
Cached Commit SCN referenced, E.2
calls to get snapshot scn
kcmgss, E.2
calls to kcmgas, E.2
calls to kcmgcs, E.2
calls to kcmgrs, E.2
change write time, E.2
cleanouts and rollbacks - consistent read gets, E.2
cleanouts only - consistent read gets, E.2
cluster key scan block gets, E.2
cluster key scans, E.2
cold recycle reads, E.2
commit cleanout failures
block lost, E.2
buffer being written, E.2
callback failure, E.2
cannot pin, E.2
hot backup in progress, E.2
write disabled, E.2
commit cleanouts, E.2
commit cleanouts successfully completed, E.2
Commit SCN cached, E.2
consistent changes, E.2
consistent gets, E.2
CPU used by this session, E.2
CPU used when call started, E.2
CR blocks created, E.2
current blocks converted for CR, E.2
cursor authentication, E.2
data blocks consistent reads - undo records applied, E.2
db block changes, E.2
db block gets, E.2
DBWR buffers scanned, E.2
DBWR checkpoint buffers written, E.2
DBWR checkpoints, 1.110, E.2
DBWR cross instance writes, E.2
DBWR free buffers found, E.2
DBWR lru scans, E.2
DBWR make free requests, E.2
DBWR revisited being-written buffer, E.2
DBWR summed scan depth, E.2
DBWR transaction table writes, E.2
DBWR undo block writes, E.2
DDL statements parallelized, E.2
deferred (CURRENT) block cleanout applications, E.2
DFO trees parallelized, E.2
dirty buffers inspected, E.2
DML statements parallelized, E.2
enqueue conversions, E.2
enqueue deadlocks, E.2
enqueue releases, E.2
enqueue requests, E.2
enqueue timeouts, E.2
enqueue waits, E.2
exchange deadlocks, E.2
execute count, E.2
free buffer inspected, E.2
free buffer requested, E.2
global cache blocks corrupt, E.2
global cache cr block log flush time, E.2, E.2
global cache cr block send time, E.2
global cache cr timeouts, E.2
global cache defers, E.2
global cache freelist waits, E.2
global cache get time, E.2
global cache gets, E.2
global cache prepare failures, E.2
global lock async converts, E.2
global lock async gets, E.2
global lock convert time, E.2
global lock get time, E.2
global lock release time, E.2
global lock releases, E.2
global lock sync converts, E.2
global lock sync gets, E.2
hot buffers moved to head of LRU, E.2
immediate (CR) block cleanout applications, E.2
immediate (CURRENT) block cleanout applications, E.2
index fast full scans (direct read), E.2
index fast full scans (full), E.2
index fast full scans (rowid ranges), E.2
instance recovery database freeze count, E.2
kcmccs called get current scn, E.2
kcmccs read scn without going to DLM, E.2
kcmggs waited for batching, E.2
leaf node splits, E.2
logons cumulative, E.2
logons current, E.2
messages received, E.2
messages sent, E.2
native hash arithmetic execute, E.2
native hash arithmetic fail, E.2
next scns gotten without going to DLM, E.2
no buffer to keep pinned count, E.2
no work - consistent read gets, E.2
opened cursors cumulative, E.2
opened cursors current, E.2
opens of replaced files, E.2
opens requiring cache replacement, E.2
operating system
OS All other sleep time, E.2
OS Chars read and written, E.2
OS Data page fault sleep time, E.2
OS Input blocks, E.2
OS Involuntary context switches, E.2
OS Kernel page fault sleep time, E.2
OS Major page faults, E.2
OS Messages received, E.2
OS Messages sent, E.2
OS Minor page faults, E.2
OS Other system trap CPU time, E.2
OS Output blocks, E.2
OS Process heap time, E.2
OS Signals received, E.2
OS Swaps, E.2
OS System call CPU time, E.2
OS System calls, E.2
OS Text page fault sleep time, E.2
OS User level CPU time, E.2
OS User lock wait sleep time, E.2
OS Voluntary context switches, E.2
OS Wait-cpu (latency) time, E.2
Process stack size, E.2
Parallel operations downgraded 1 to 25 pct, E.2
Parallel operations downgraded 25 to 50 pct, E.2
Parallel operations downgraded 50 to 75 pct, E.2
Parallel operations downgraded 75 to 99 pct, E.2
Parallel operations downgraded to serial, E.2
Parallel operations not downgraded, E.2
parse count (hard), E.2
parse count (total), E.2
parse time cpu, E.2
parse time elapsed, E.2
physical reads, E.2
physical reads direct, E.2
physical writes, E.2
physical writes direct, E.2
physical writes non checkpoint, E.2
pinned buffers inspected, E.2
prefetched blocks, E.2
prefetched blocks aged out before use, E.2
process last non-idle time, E.2
PX local messages recv'd, E.2
PX local messages sent, E.2
PX remote messages recv'd, E.2
PX remote messages sent, E.2
queries parallelized, E.2
recovery array read time, E.2
recovery array reads, E.2
recovery blocks read, E.2
recursive calls, E.2
recursive cpu usage, E.2
redo blocks written, E.2
redo buffer allocation retries, E.2
redo entries, E.2
redo log space requests, E.2
redo log space wait time, E.2
redo log switch interrupts, E.2
redo ordering marks, E.2
redo size, E.2
redo sync writes, E.2
redo synch time, E.2
redo wastage, E.2
redo write time, E.2
redo writer latching time, E.2
redo writes, E.2
remote instance undo block writes, E.2
remote instance undo header writes, E.2
rollback changes - undo records applied, E.2
rollbacks only - consistent read gets, E.2
rows fetched via callback, E.2
serializable aborts, E.2
session connect time, E.2
session cursor cache count, E.2
session cursor cache hits, E.2
session logical reads, E.2
session pga memory, E.2
session pga memory max, E.2
session stored procedure space, E.2
session uga memory, E.2
session uga memory max, E.2
sorts (disk), E.2
sorts (memory), E.2
sorts (rows), E.2
SQL*Net roundtrips to/from client, E.2
SQL*Net roundtrips to/from dblink, E.2
summed dirty queue length, E.2
switch current to new buffer, E.2
table fetch by rowid, E.2
table fetch continued row, E.2
table scan blocks gotten, E.2
table scan rows gotten, E.2
table scans (cache partitions), E.2
table scans (direct read), E.2
table scans (long tables), E.2
table scans (rowid ranges), E.2
table scans (short tables), E.2
timed, 1.213
total file opens, E.2
transaction lock background get time, E.2
transaction lock background gets, E.2
transaction lock foreground requests, E.2
transaction lock foreground wait time, E.2
transaction rollbacks, E.2
transaction tables consistent read rollbacks, E.2
transaction tables consistent reads - undo records applied, E.2
Unnecessary process cleanup for SCN batching, E.2
user calls, E.2
user commits, E.2
user rollbacks, E.2
write clones created in background, E.2
write clones created in foreground, E.2
STATISTICS_LEVEL initialization parameter, 1.208
STMT_AUDIT_OPTION_MAP table, 3.450
STREAMS_POOL_SIZE initialization parameter, 1.209
switch redo log file, 1.110
SYN synonym for USER_SYNONYMS view, 3.451
SYNONYMS view, 3.452
SYS_OBJECTS view, 3.457
SYSCATALOG view, 3.453
SYSFILES view, 3.454
SYSSEGOBJ view, 3.455
system global area, 1.1.1.3
buffer areas, 1.109
maximum concurrent transactions, 1.216
system performance, 1.1.1.3
SYSTEM_PRIVILEGE_MAP table, 3.456

T

TAB view, 3.458
TABLE_PRIVILEGE_MAP table, 3.459
tables
data dictionary, 2.1
DML locks, 1.63
locating free space, 1.85
TABQUOTAS view, 3.461
TABS synonym for USER_TABLES view, 3.460
tape archiving destination, 1.100
TAPE_ASYNCH_IO initialization parameter, 1.210
territory, 1.125, 1.132
THREAD initialization parameter, 1.211
TIMED_OS_STATISTICS initialization parameter, 1.212
TIMED_STATISTICS initialization parameter, 1.213
file read/write statistics, 4.85, 5.144
TO_CHAR function, 1.123
TO_DATE function, 1.123
trace files
destination, 1.222
maximum size, 1.117
TRACE_ENABLED initialization parameter, 1.214
TRACEFILE_IDENTIFIER initialization parameter, 1.215
transactions
concurrent, 1.216
data locking, 1.63
TRANSACTIONS initialization parameter, 1.216
DML locks, 1.63
TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1.217
TRUSTED_SERVERS view, 3.462
TS_PITR_CHECK view, 3.463
TS_PITR_OBJECTS TO_BE_DROPPED view, 3.464

U

U0800060.SQL script, B.4
U0801070.SQL script, B.4
U0900010.SQL script, B.4
U0902000.SQL script, B.4
UNDO_MANAGEMENT initialization parameter, 1.218
UNDO_RETENTION initialization parameter, 1.219
UNDO_TABLESPACE initialization parameter, 1.220
UNI_PLUGGABLE_SET_CHECK view, 3.465
updates
locating free space, 1.85
upgrading
scripts, B.4
uppercase characters, 1.3.2.1.1
USE_INDIRECT_DATA_BUFFERS initialization parameter, 1.221
user processes
trace files, 1.222
USER_ADVISOR_ACTIONS view, 3.466
USER_ADVISOR_FINDINGS view, 3.467
USER_ADVISOR_JOURNAL view, 3.468
USER_ADVISOR_LOG view, 3.469
USER_ADVISOR_OBJECTS view, 3.470
USER_ADVISOR_PARAMETERS view, 3.471
USER_ADVISOR_RATIONALE view, 3.472
USER_ADVISOR_RECOMMENDATIONS view, 3.473
USER_ADVISOR_SQLA_REC_SUM view, 3.474
USER_ADVISOR_SQLA_WK_MAP view, 3.475
USER_ADVISOR_SQLA_WK_STMTS view, 3.476
USER_ADVISOR_SQLW_JOURNAL view, 3.477
USER_ADVISOR_SQLW_PARAMETERS view, 3.478
USER_ADVISOR_SQLW_STMTS view, 3.479
USER_ADVISOR_SQLW_SUM view, 3.480
USER_ADVISOR_SQLW_TABLES view, 3.481
USER_ADVISOR_SQLW_TEMPLATES view, 3.482
USER_ADVISOR_TASKS view, 3.483
USER_ADVISOR_TEMPLATES view, 3.484
USER_ALL_TABLES view, 3.485
USER_AQ_AGENT_PRIVS view, 3.486
USER_ARGUMENTS view, 3.487
USER_ASSOCIATIONS view, 3.488
USER_ATTRIBUTE_TRANSFORMATIONS view, 3.489
USER_AUDIT_OBJECT view, 3.490
USER_AUDIT_POLICIES view, 3.491
USER_AUDIT_POLICY_COLUMNS view, 3.492
USER_AUDIT_SESSION view, 3.493
USER_AUDIT_STATEMENT view, 3.494
USER_AUDIT_TRAIL view, 3.495
USER_AW_PS view, 3.496
USER_AWS view, 3.497
USER_BASE_TABLE_MVIEWS view, 3.498
USER_CATALOG view, 3.499
CAT synonym, 2.211
USER_CLU_COLUMNS view, 3.500
USER_CLUSTER_HASH_EXPRESSIONS view, 3.501
USER_CLUSTERS view, 3.502
CLU synonym, 2.216
USER_COL_COMMENTS view, 3.503
USER_COL_PRIVS view, 3.504
USER_COL_PRIVS_MADE view, 3.505
USER_COL_PRIVS_RECD view, 3.506
USER_COLL_TYPES view, 3.507
USER_CONS_COLUMNS view, 3.508
USER_CONS_OBJ_COLUMNS view, 3.509
USER_CONSTRAINTS view, 3.510
USER_DATAPUMP_JOBS view, 3.511
USER_DB_LINKS view, 3.512
USER_DEPENDENCIES view, 3.513
USER_DIM_ATTRIBUTES view, 3.514
USER_DIM_CHILD_OF view, 3.515
USER_DIM_HIERARCHIES view, 3.516
USER_DIM_JOIN_KEY view, 3.517
USER_DIM_LEVEL_KEY view, 3.518
USER_DIM_LEVELS view, 3.519
USER_DIMENSIONS view, 3.520
USER_DUMP_DEST initialization parameter, 1.222
USER_ERRORS view, 3.521
USER_EVALUATION_CONTEXT_TABLES view, 3.522
USER_EVALUATION_CONTEXT_VARS view, 3.523
USER_EVALUATION_CONTEXTS view, 3.524
USER_EXTENTS view, 3.525
USER_EXTERNAL_LOCATIONS view, 3.526
USER_EXTERNAL_TABLES view, 3.527
USER_FREE_SPACE view, 3.528
USER_IND_COLUMNS view, 3.529
USER_IND_EXPRESSIONS view, 3.530
USER_IND_PARTITIONS view, 3.531
USER_IND_STATISTICS view, 3.532
USER_IND_SUBPARTITIONS view, 3.533
USER_INDEXES view, 3.534
IND synonym, 3.423
USER_INDEXTYPE_ARRAYTYPES view, 3.535
USER_INDEXTYPE_COMMENTS view, 3.536
USER_INDEXTYPE_OPERATORS view, 3.537
USER_INDEXTYPES view, 3.538
USER_INTERNAL_TRIGGERS view, 3.539
USER_JAVA_ARGUMENTS view, 3.540
USER_JAVA_CLASSES view, 3.541
USER_JAVA_DERIVATIONS view, 3.542
USER_JAVA_FIELDS view, 3.543
USER_JAVA_IMPLEMENTS view, 3.544
USER_JAVA_INNERS view, 3.545
USER_JAVA_LAYOUTS view, 3.546
USER_JAVA_METHODS view, 3.547
USER_JAVA_NCOMPS view, 3.548
USER_JAVA_POLICY view, 3.549
USER_JAVA_RESOLVERS view, 3.550
USER_JAVA_THROWS view, 3.551
USER_JOBS view, 3.552
USER_JOIN_IND_COLUMNS view, 3.553, 3.553
USER_LIBRARIES view, 3.554
USER_LOB_PARTITIONS view, 3.555
USER_LOB_SUBPARTITIONS view, 3.556
USER_LOB_TEMPLATES view, 3.557
USER_LOBS view, 3.558
USER_LOG_GROUP_COLUMNS view, 3.559
USER_LOG_GROUPS view, 3.560
USER_METHOD_PARAMS view, 3.561
USER_METHOD_RESULTS view, 3.562
USER_MVIEW_AGGREGATES view, 3.563
USER_MVIEW_ANALYSIS view, 3.564
USER_MVIEW_COMMENTS view, 3.565
USER_MVIEW_DETAIL_RELATIONS view, 3.566
USER_MVIEW_JOINS view, 3.567
USER_MVIEW_KEYS view, 3.568
USER_MVIEW_LOGS view, 3.569
USER_MVIEW_REFRESH_TIMES view, 3.570
USER_MVIEWS view, 3.571
USER_NESTED_TABLE_COLS view, 3.572
USER_NESTED_TABLES view, 3.573
USER_OBJ_AUDIT_OPTS view, 3.574
USER_OBJ_COLATTRS view, 3.575
USER_OBJECT_SIZE view, 3.576
USER_OBJECT_TABLES view, 3.577
USER_OBJECTS view, 3.578
OBJ synonym, 3.430
USER_OPANCILLARY view, 3.579
USER_OPARGUMENTS view, 3.580
USER_OPBINDINGS view, 3.581
USER_OPERATOR_COMMENTS view, 3.582
USER_OPERATORS view, 3.583
USER_OUTLINE_HINTS view, 3.584
USER_OUTLINES view, 3.585
USER_PART_COL_STATISTICS view, 3.586
USER_PART_HISTOGRAMS view, 3.587
USER_PART_INDEXES view, 3.588
USER_PART_KEY_COLUMNS view, 3.589
USER_PART_LOBS view, 3.590
USER_PART_TABLES view, 3.591
USER_PARTIAL_DROP_TABS view, 3.592
USER_PASSWORD_LIMITS view, 3.593
USER_PENDING_CONV_TABLES view, 3.594
USER_PLSQL_OBJECT_SETTINGS view, 3.595
USER_POLICIES view, 3.596
USER_POLICY_CONTEXTS view, 3.597
USER_POLICY_GROUPS view, 3.598
USER_PROCEDURES view, 3.599
USER_PROXIES view, 3.600
USER_PUBLISHED_COLUMNS view, 3.601
USER_QUEUE_SCHEDULES view, 3.602
USER_QUEUE_TABLES view, 3.603
USER_QUEUES view, 3.604
USER_RECYCLEBIN view, 3.605
RECYCLEBIN synonym, 3.439
USER_REFRESH view, 3.606
USER_REFRESH_CHILDREN view, 3.607
USER_REFS view, 3.608
USER_REGISTERED_MVIEWS view, 3.609
USER_REGISTRY view, 3.610
USER_REPCAT view, 2.1.1
USER_REPCAT_REFRESH_TEMPLATES view, 2.1.1
USER_REPCAT_TEMPLATE_OBJECTS view, 2.1.1
USER_REPCAT_TEMPLATE_PARMS view, 2.1.1
USER_REPCAT_TEMPLATE_SITES view, 2.1.1
USER_REPCAT_USER_AUTHORIZATION view, 2.1.1
USER_REPCAT_USER_PARM_VALUES view, 2.1.1
USER_REPCATLOG view, 2.1.1
USER_REPCOLUMN view, 2.1.1
USER_REPCOLUMN_GROUP view, 2.1.1
USER_REPCONFLICT view, 2.1.1
USER_REPDDL view, 2.1.1
USER_REPFLAVOR_COLUMNS view, 2.1.1
USER_REPFLAVOR_OBJECTS view, 2.1.1
USER_REPFLAVORS view, 2.1.1
USER_REPGENERATED view, 2.1.1
USER_REPGENOBJECTS view, 2.1.1
USER_REPGROUP view, 2.1.1
USER_REPGROUP_PRIVILEGES view, 2.1.1
USER_REPGROUPED_COLUMN view, 2.1.1
USER_REPKEY_COLUMNS view, 2.1.1
USER_REPOBJECT view, 2.1.1
USER_REPPARAMETER_COLUMN view, 2.1.1
USER_REPPRIORITY view, 2.1.1
USER_REPPRIORITY_GROUP view, 2.1.1
USER_REPPROP view, 2.1.1
USER_REPRESOL_STATS_CONTROL view, 2.1.1
USER_REPRESOLUTION view, 2.1.1
USER_REPRESOLUTION_METHOD view, 2.1.1
USER_REPRESOLUTION_STATISTICS view, 2.1.1
USER_REPSCHEMA view, 2.1.1
USER_REPSITES view, 2.1.1
USER_RESOURCE_LIMITS view, 3.611
USER_RESUMABLE view, 3.612
USER_REWRITE_EQUIVALENCES view, 3.613
USER_ROLE_PRIVS view, 3.614
USER_RSRC_CONSUMER_GROUP_PRIVS view, 3.615
USER_RSRC_MANAGER_SYSTEM_PRIVS view, 3.616
USER_RULE_SET_RULES view, 3.617
USER_RULE_SETS view, 3.618
USER_RULES view, 3.619
USER_SCHEDULER_JOB_ARGS view, 3.620
USER_SCHEDULER_JOB_LOG view, 3.621
USER_SCHEDULER_JOB_RUN_DETAILS view, 3.622
USER_SCHEDULER_JOBS view, 3.623
USER_SCHEDULER_PROGRAM_ARGS view, 3.624
USER_SCHEDULER_PROGRAMS view, 3.625
USER_SCHEDULER_RUNNING_JOBS view, 3.626
USER_SCHEDULER_SCHEDULES view, 3.627
USER_SEC_RELEVANT_COLS view, 3.628
USER_SEGMENTS view, 3.629
USER_SEQUENCES view, 3.630
SEQ synonym, 3.445
USER_SOURCE view, 3.631
USER_SOURCE_TABLES view, 3.632
USER_SQLJ_TYPE_ATTRS view, 3.633
USER_SQLJ_TYPE_METHODS view, 3.634
USER_SQLJ_TYPES view, 3.635
USER_SQLSET view, 3.636
USER_SQLSET_BINDS view, 3.637
USER_SQLSET_REFERENCES view, 3.638
USER_SQLSET_STATEMENTS view, 3.639
USER_SQLTUNE_BINDS view, 3.640
USER_SQLTUNE_PLANS view, 3.641
USER_SQLTUNE_RATIONALE_PLAN view, 3.642
USER_SQLTUNE_STATISTICS view, 3.643
USER_STORED_SETTINGS view, 3.644
USER_SUBPART_COL_STATISTICS view, 3.645
USER_SUBPART_HISTOGRAMS view, 3.646
USER_SUBPART_KEY_COLUMNS view, 3.647
USER_SUBPARTITION_TEMPLATES view, 3.648
USER_SUBSCRIBED_COLUMNS view, 3.649
USER_SUBSCRIBED_TABLES view, 3.650
USER_SUBSCRIPTIONS view, 3.651
USER_SYNONYMS view, 3.652
SYN synonym, 3.451
USER_SYS_PRIVS view, 3.653
USER_TAB_COL_STATISTICS view, 3.654
USER_TAB_COLS view, 3.655
USER_TAB_COLUMNS view, 3.656
COLS synonym, 2.218
USER_TAB_COMMENTS view, 3.657
USER_TAB_HISTOGRAMS view, 3.658
USER_TAB_MODIFICATIONS view, 3.659
USER_TAB_PARTITIONS view, 3.660
USER_TAB_PRIVS view, 3.661
USER_TAB_PRIVS_MADE view, 3.662
USER_TAB_PRIVS_RECD view, 3.663
USER_TAB_STATISTICS view, 3.664
USER_TAB_SUBPARTITIONS view, 3.665
USER_TABLES view, 3.666
TABS synonym, 3.460
USER_TABLESPACES view, 3.667
USER_TRANSFORMATIONS view, 3.668
USER_TRIGGER_COLS view, 3.669
USER_TRIGGERS view, 3.670
USER_TS_QUOTAS view, 3.671
USER_TUNE_MVIEW view, 3.672
USER_TYPE_ATTRS view, 3.673
USER_TYPE_METHODS view, 3.674
USER_TYPE_VERSIONS view, 3.675
USER_TYPES view, 3.676
USER_UNUSED_COL_TABS view, 3.677
USER_UPDATABLE_COLUMNS view, 3.678
USER_USERS view, 3.679
USER_USTATS view, 3.680
USER_VARRAYS view, 3.681
USER_VIEWS view, 3.682
USER_WARNING_SETTINGS view, 3.683
USER_WM_LOCKED_TABLES view, 2.1.2
USER_WM_MODIFIED_TABLES view, 2.1.2
USER_WM_PRIVS view, 2.1.2
USER_WM_RIC_INFO view, 2.1.2
USER_WM_TAB_TRIGGERS view, 2.1.2
USER_WM_VERSIONED_TABLES view, 2.1.2
USER_WM_VT_ERRORS view, 2.1.2
USER_WORKSPACE_PRIVS view, 2.1.2
USER_WORKSPACE_SAVEPOINTS view, 2.1.2
USER_WORKSPACES view, 2.1.2
USER_XML_SCHEMAS view, 3.684
USER_XML_TAB_COLS view, 3.685
USER_XML_TABLES view, 3.686
USER_XML_VIEW_COLS view, 3.687
USER_XML_VIEWS view, 3.688
USERLOCK.SQL script, B.2
users
authenticating, 1.147
multiple, 1.63
UTL_FILE_DIR initialization parameter, 1.223
UTLBSTAT.SQL script, B.2
UTLCHN1.SQL script, B.2
UTLCONST.SQL script, B.2
UTLDTREE.SQL script, 3.402, 3.422, B.2
UTLESTAT.SQL script, B.2
UTLEXPT1.SQL script, B.2
UTLIP.SQL script, B.2
UTLIRP.SQL script, B.2
UTLLOCKT.SQL script, B.2
UTLPWDMG.SQL script, B.2
UTLRP.SQL script, B.2
UTLSAMPL.SQL script, B.2
UTLSCLN.SQL script, B.2
UTLTKPRF.SQL script, B.2
UTLU101I.SQL script, B.4
UTLU101S.SQL script, B.4
UTLVALID.SQL script, B.2
UTLXPLAN.SQL script, B.2

V

V$ACCESS view, 4.3
V$ACTIVE_INSTANCES view, 4.4
V$ACTIVE_SERVICES view, 4.5
V$ACTIVE_SESS_POOL_MTH view, 4.6
V$ACTIVE_SESSION_HISTORY view, 4.7
V$ALERT_TYPES view, 4.8
V$AQ view, 4.9
V$ARCHIVE view, 4.10
V$ARCHIVE_DEST view, 4.11
V$ARCHIVE_DEST_STATUS view, 4.12
V$ARCHIVE_GAP view, 4.13
V$ARCHIVE_PROCESSES view, 4.14
V$ARCHIVED_LOG view, 4.15
V$ASM_ALIAS view, 4.16
V$ASM_CLIENT view, 4.17
V$ASM_DISK view, 4.18
V$ASM_DISKGROUP view, 4.19
V$ASM_FILE view, 4.20
V$ASM_OPERATION view, 4.21
V$ASM_TEMPLATE view, 4.22
V$BACKUP view, 4.23
V$BACKUP_ASYNC_IO view, 4.24
V$BACKUP_CORRUPTION view, 4.25
V$BACKUP_DATAFILE view, 4.26
V$BACKUP_DEVICE view, 4.27
V$BACKUP_FILES view, 4.28
V$BACKUP_PIECE view, 4.29
V$BACKUP_REDOLOG view, 4.30
V$BACKUP_SET view, 4.31
V$BACKUP_SPFILE view, 4.32
V$BACKUP_SYNC_IO view, 4.33
V$BGPROCESS view, 4.34
V$BH view, 4.35
V$BLOCK_CHANGE_TRACKING view, 4.36
V$BUFFER_POOL view, 4.37
V$BUFFER_POOL_STATISTICS view, 4.38
V$BUFFERED_PUBLISHERS view, 4.39
V$BUFFERED_QUEUES view, 4.40
V$BUFFERED_SUBSCRIBERS view, 4.41
V$CACHE view, 4.42
V$CACHE_LOCK view, 4.43
V$CACHE_TRANSFER view, 4.44
V$CIRCUIT view, 4.45
V$CLASS_CACHE_TRANSFER view, 4.46
V$CLIENT_STATS view, 4.47
V$CONTEXT view, 4.48
V$CONTROLFILE view, 4.49
V$CONTROLFILE_RECORD_SECTION view, 4.50
V$COPY_CORRUPTION view, 4.51
V$CR_BLOCK_SERVER view, 4.52
V$CURRENT_BLOCK_SERVER view, 4.53
V$DATABASE view, 4.54
V$DATABASE_BLOCK_CORRUPTION view, 4.55
V$DATABASE_INCARNATION view, 4.56
V$DATAFILE view, 4.57
V$DATAFILE_COPY view, 4.58
V$DATAFILE_HEADER view, 4.59
V$DATAGUARD_CONFIG view, 4.60
V$DATAGUARD_STATUS view, 4.61
V$DB_CACHE_ADVICE view, 4.62
V$DB_OBJECT_CACHE view, 4.63
V$DB_PIPES view, 4.64
V$DBFILE view, 4.65
V$DBLINK view, 4.66
V$DELETED_OBJECT view, 4.67
V$DISPATCHER view, 4.68
V$DISPATCHER_CONFIG view, 4.69
V$DISPATCHER_RATE view, 4.70
V$ENABLEDPRIVS view, 4.71
V$ENQUEUE_LOCK view, 4.72
V$ENQUEUE_STAT view, 4.73
V$EVENT_HISTOGRAM view, 4.74
V$EVENT_NAME view, 4.75
V$EVENTMETRIC view, 4.76
V$EXECUTION view, 4.77
V$FALSE_PING view, 4.78
V$FAST_START_SERVERS view, 4.79
V$FAST_START_TRANSACTIONS view, 4.80
V$FILE_CACHE_TRANSFER view, 4.81
V$FILE_HISTOGRAM view, 4.82
V$FILEMETRIC view, 4.83
V$FILEMETRIC_HISTORY view, 4.84
V$FILESTAT view, 4.85
V$FIXED_TABLE view, 4.86
V$FIXED_VIEW_DEFINITION view, 4.87
V$FLASHBACK_DATABASE_LOG view, 4.88
V$FLASHBACK_DATABASE_STAT view, 4.89
V$GC_ELEMENT view, 4.90
V$GC_ELEMENTS_WITH_COLLISIONS view, 4.91
V$GCSHVMASTER_INFO view, 4.92
V$GCSPFMASTER_INFO view, 4.93
V$GES_BLOCKING_ENQUEUE view, 4.94
V$GES_CONVERT_LOCAL view, 4.95
V$GES_CONVERT_REMOTE view, 4.96
V$GES_ENQUEUE view, 4.97
V$GES_LATCH view, 4.98
V$GES_RESOURCE view, 4.99
V$GES_STATISTICS view, 4.100
V$GLOBAL_BLOCKED_LOCKS view, 4.101
V$GLOBAL_TRANSACTION view, 4.102
V$HS_AGENT view, 4.103
V$HS_PARAMETER view, 4.104
V$HS_SESSION view, 4.105
V$HVMASTER_INFO view, 4.106
V$INDEXED_FIXED_COLUMN view, 4.107
V$INSTANCE view, 4.108
V$INSTANCE_RECOVERY view, 4.109
V$JAVA_LIBRARY_CACHE_MEMORY view, 4.110
V$JAVA_POOL_ADVICE view, 4.111
V$LATCH view, 4.112
V$LATCH_CHILDREN view, 4.113
V$LATCH_MISSES view, 4.114
V$LATCH_PARENT view, 4.115
V$LATCHHOLDER view, 4.116
V$LATCHNAME view, 4.117
V$LIBRARY_CACHE_MEMORY view, 4.118
V$LIBRARYCACHE view, 4.119
V$LICENSE view, 4.120
V$LOADISTAT view, 4.121
V$LOADPSTAT view, 4.122
V$LOCK view, 4.123
V$LOCK_ACTIVITY view, 4.124
V$LOCKED_OBJECT view, 4.125
V$LOG view, 4.126
V$LOG_HISTORY view, 4.127
V$LOGFILE view, 4.128
V$LOGHIST view, 4.129
V$LOGMNR_CONTENTS view, 4.130
V$LOGMNR_DICTIONARY view, 4.131
V$LOGMNR_LOGS view, 4.132
V$LOGMNR_PARAMETERS view, 4.133
V$LOGSTDBY view, 4.134
V$LOGSTDBY_STATS view, 4.135
V$MANAGED_STANDBY view, 4.136
V$MAP_COMP_LIST view, 4.137
V$MAP_ELEMENT view, 4.138
V$MAP_EXT_ELEMENT view, 4.139
V$MAP_FILE view, 4.140
V$MAP_FILE_EXTENT view, 4.141
V$MAP_FILE_IO_STACK view, 4.142
V$MAP_LIBRARY view, 4.143
V$MAP_SUBELEMENT view, 4.144
V$METRICNAME view, 4.145
V$MTTR_TARGET_ADVICE view, 4.146
V$MVREFRESH view, 4.147
V$MYSTAT view, 4.148
V$NLS_PARAMETERS view, 5.1
V$NLS_VALID_VALUES view, 5.2
V$OBJECT_DEPENDENCY view, 5.3
V$OBJECT_USAGE view, 5.4
V$OBSOLETE_BACKUP_FILES view, 5.5
V$OBSOLETE_PARAMETER view, 5.6
V$OFFLINE_RANGE view, 5.7
V$OPEN_CURSOR view, 5.8
V$OPTION view, 5.9
V$OSSTAT view, 5.10
V$PARALLEL_DEGREE_LIMIT_MTH view, 5.11
V$PARAMETER view, 5.12
V$PARAMETER2 view, 5.13
V$PGA_TARGET_ADVICE view, 5.14
V$PGA_TARGET_ADVICE_HISTOGRAM view, 5.15
V$PGASTAT view, 5.16
V$PQ_SESSTAT view, 5.17
V$PQ_SLAVE view, 5.18
V$PQ_SYSSTAT view, 5.19
V$PQ_TQSTAT view, 5.20
V$PROCESS view, 5.21
V$PROPAGATION_RECEIVER view, 5.22
V$PROPAGATION_SENDER view, 5.23
V$PROXY_ARCHIVEDLOG view, 5.24
V$PROXY_DATAFILE view, 5.25
V$PWFILE_USERS view, 5.26
V$PX_PROCESS view, 5.27
V$PX_PROCESS_SYSSTAT view, 5.28
V$PX_SESSION view, 5.29
V$PX_SESSTAT view, 5.30
V$QUEUE view, 5.31
V$QUEUEING_MTH view, 5.32
V$RECOVER_FILE view, 5.33
V$RECOVERY_FILE_DEST view, 5.34
V$RECOVERY_FILE_STATUS view, 5.35
V$RECOVERY_LOG view, 5.36
V$RECOVERY_PROGRESS view, 5.37
V$RECOVERY_STATUS view, 5.38
V$REPLPROP view, 5.39
V$REPLQUEUE view, 5.40
V$REQDIST view, 5.41
V$RESERVED_WORDS view, 5.42
V$RESOURCE view, 5.43
V$RESOURCE_LIMIT view, 5.44
V$RMAN_CONFIGURATION view, 5.45
V$RMAN_OUTPUT view, 5.46
V$RMAN_STATUS view, 5.47
V$ROLLNAME view, 5.48
V$ROLLSTAT view, 5.49
V$ROWCACHE view, 5.50
V$ROWCACHE_PARENT view, 5.51
V$ROWCACHE_SUBORDINATE view, 5.52
V$RSRC_CONSUMER_GROUP view, 5.53
V$RSRC_CONSUMER_GROUP_CPU_MTH view, 5.54
V$RSRC_PLAN view, 5.55
V$RSRC_PLAN_CPU_MTH view, 5.56
V$RULE view, 5.57
V$RULE_SET view, 5.58
V$RULE_SET_AGGREGATE_STATS view, 5.59
V$SEGMENT_STATISTICS view, 5.60
V$SEGSTAT view, 5.61
V$SEGSTAT_NAME view, 5.62
V$SERV_MOD_ACT_STATS view, 5.63
V$SERVICE_EVENT view, 5.64
V$SERVICE_STATS view, 5.65
V$SERVICE_WAIT_CLASS view, 5.66
V$SERVICEMETRIC view, 5.67
V$SERVICEMETRIC_HISTORY view, 5.68
V$SERVICES view, 5.69
V$SES_OPTIMIZER_ENV view, 5.70
V$SESS_IO view, 5.71
V$SESS_TIME_MODEL view, 5.72
V$SESSION view, 5.73
V$SESSION_CONNECT_INFO view, 5.74
V$SESSION_CURSOR_CACHE view, 5.75
V$SESSION_EVENT view, 5.76, C.1
V$SESSION_LONGOPS view, 5.77
V$SESSION_OBJECT_CACHE view, 5.78
V$SESSION_WAIT view, 5.79, C.1
V$SESSION_WAIT_CLASS view, 5.80
V$SESSION_WAIT_HISTORY view, 5.81
V$SESSMETRIC view, 5.82
V$SESSTAT view, 5.83, E, E.1
V$SGA view, 5.84
V$SGA_CURRENT_RESIZE_OPS view, 5.85
V$SGA_DYNAMIC_COMPONENTS view, 5.86
V$SGA_DYNAMIC_FREE_MEMORY view, 5.87
V$SGA_RESIZE_OPS view, 5.88
V$SGAINFO view, 5.89
V$SGASTAT view, 5.90
V$SHARED_POOL_ADVICE view, 5.91
V$SHARED_POOL_RESERVED view, 5.92
V$SHARED_SERVER view, 5.93
V$SHARED_SERVER_MONITOR view, 5.94
V$SORT_SEGMENT view, 5.95
V$SPPARAMETER view, 5.96
V$SQL view, 5.97
V$SQL_BIND_CAPTURE view, 5.98
V$SQL_BIND_DATA view, 5.99
V$SQL_BIND_METADATA view, 5.100
V$SQL_CURSOR view, 5.101
V$SQL_OPTIMIZER_ENV view, 5.102
V$SQL_PLAN view, 5.103
V$SQL_PLAN_STATISTICS view, 5.104
V$SQL_PLAN_STATISTICS_ALL view, 5.105
V$SQL_REDIRECTION view, 5.106
V$SQL_SHARED_CURSOR view, 5.107
V$SQL_SHARED_MEMORY view, 5.108
V$SQL_WORKAREA view, 5.109
V$SQL_WORKAREA_ACTIVE view, 5.110
V$SQL_WORKAREA_HISTOGRAM view, 5.111
V$SQLAREA view, 5.112
V$SQLTEXT view, 5.113
V$SQLTEXT_WITH_NEWLINES view, 5.114
V$STANDBY_LOG view, 5.115
V$STATISTICS_LEVEL view, 5.116
V$STATNAME view, 5.117, E.1
V$STREAMS_APPLY_COORDINATOR view, 5.118
V$STREAMS_APPLY_READER view, 5.119
V$STREAMS_APPLY_SERVER view, 5.120
V$STREAMS_CAPTURE view, 5.121
V$SUBCACHE view, 5.122
V$SYS_OPTIMIZER_ENV view, 5.123
V$SYS_TIME_MODEL view, 5.124
V$SYSAUX_OCCUPANTS view, 5.125
V$SYSMETRIC view, 5.126
V$SYSMETRIC_HISTORY view, 5.127
V$SYSMETRIC_SUMMARY view, 5.128
V$SYSSTAT view, 5.129, E
V$SYSTEM_CURSOR_CACHE view, 5.130
V$SYSTEM_EVENT view, 5.131, C.1
V$SYSTEM_PARAMETER view, 5.132
V$SYSTEM_PARAMETER2 view, 5.133
V$SYSTEM_WAIT_CLASS view, 5.134
V$TABLESPACE view, 5.135
V$TEMP_CACHE_TRANSFER view, 5.136
V$TEMP_EXTENT_MAP view, 5.137
V$TEMP_EXTENT_POOL view, 5.138
V$TEMP_HISTOGRAM view, 5.139
V$TEMP_SPACE_HEADER view, 5.140
V$TEMPFILE view, 5.141
V$TEMPORARY_LOBS view, 5.142
V$TEMPSEG_USAGE view, 5.143
V$TEMPSTAT view, 5.144
V$THREAD view, 5.145
V$THRESHOLD_TYPES view, 5.146
V$TIMER view, 5.147
V$TIMEZONE_NAMES view, 5.148
V$TRANSACTION view, 5.149
V$TRANSACTION_ENQUEUE view, 5.150
V$TRANSPORTABLE_PLATFORM view, 5.151
V$TYPE_SIZE view, 5.152
V$UNDOSTAT view, 5.153
V$VERSION view, 5.154
V$VPD_POLICY view, 5.155
V$WAITCLASSMETRIC view, 5.156
V$WAITCLASSMETRIC_HISTORY view, 5.157
V$WAITSTAT view, 5.158
views
data dictionary views, 2
data files, 1.75

W

wait events
alter system set dispatchers, C.4.1
batched allocate scn lock request, C.4.2
BFILE check if exists, C.4.3
BFILE check if open, C.4.4
BFILE closure, C.4.5
BFILE get length, C.4.6
BFILE get name object, C.4.7
BFILE get path object, C.4.8
BFILE internal seek, C.4.9
BFILE open, C.4.10
BFILE read, C.4.11
buffer busy waits, C.4.12
buffer deadlock, C.4.13
buffer for checkpoint, C.4.14
buffer latch, C.4.15
buffer read retry, C.4.16
checkpoint completed, C.4.17
checkpoint range buffer not saved, C.4.18
controlfile parallel write, C.4.19
controlfile sequential read, C.4.20
controlfile single write, C.4.21
conversion file read, C.4.22
db file parallel read, C.4.23
db file parallel write, C.4.24
db file scattered read, C.4.25
db file sequential read, C.4.26
db file single write, C.4.27
DFS db file lock, C.4.28
DFS lock handle, C.4.29
direct path read, C.4.30
direct path write, C.4.31
dispatcher shutdown, C.4.32
dispatcher timer, C.4.33
duplicate cluster key, C.4.34
enqueue, C.4.35
file identify, C.4.36
file open, C.4.37
free buffer waits, C.4.38
free global transaction table entry, C.4.39
free process state object, C.4.40
global cache busy, C.4.41
global cache freelist wait, C.4.43
global cache lock cleanup, C.4.42
global cache null to s, C.4.44
global cache null to x, C.4.45
global cache open s, C.4.46
global cache open x, C.4.47
global cache s to x, C.4.48
inactive session, C.4.49
inactive transaction branch, C.4.50
index block split, C.4.51
instance recovery, C.4.52
instance state change, C.4.53
io done, C.4.54
kcl bg acks, C.4.55
latch activity, C.4.56
latch free, C.4.57
library cache load lock, C.4.58
library cache lock, C.4.59
library cache pin, C.4.60
lock manager wait for remote message, C.4.61
log buffer space, C.4.62
log file parallel write, C.4.63
log file sequential read, C.4.64
log file single write, C.4.65
log file switch (archiving needed), C.4.66
log file switch (checkpoint incomplete), C.4.67
log file switch (clearing log file), C.4.68
log file switch completion, C.4.69
log file sync, C.4.70
log switch/archive, C.4.71
on-going SCN fetch to complete, C.4.72
pending global transaction(s), C.4.73
pipe get, C.4.74
pipe put, C.4.75
PL/SQL lock timer, C.4.76
pmon timer, C.4.77
process startup, C.4.78
PX dequeue wait, C.4.79
PX qref latch, C.4.80
PX server shutdown, C.4.81
PX signal server, C.4.82
queue messages, C.4.83
rdbms ipc message, C.4.84
rdbms ipc message block, C.4.85
rdbms ipc reply, C.4.86
redo wait, C.4.87
row cache lock, C.4.88
scginq AST call, C.4.89
single-task message, C.4.90
smon timer, C.4.91
SQL*Net break/reset to client, C.4.92
SQL*Net break/reset to dblink, C.4.93
SQL*Net message from client, C.4.94
SQL*Net message from dblink, C.4.95
SQL*Net message to client, C.4.96
SQL*Net message to dblink, C.4.97
SQL*Net more data from client, C.4.98
SQL*Net more data from dblink, C.4.99
SQL*Net more data to client, C.4.100
SQL*Net more data to dblink, C.4.101
switch logfile command, C.4.102
timer in sksawat, C.4.103
transaction, C.4.104
unbound tx, C.4.105
undo segment extension, C.4.106
undo segment recovery, C.4.107
undo segment tx slot, C.4.108
virtual circuit status, C.4.109
WMON goes to sleep, C.4.110
write complete waits, C.4.111
writes stopped by instance recovery or database suspension, C.4.112
WM_INSTALLATION view, 2.1.2
WM_REPLICATION_INFO view, 2.1.2
WORKAREA_SIZE_POLICY initialization parameter, 1.224