Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E17110-04
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
Contact Us

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  X 

A

ACTIVE_INSTANCE_COUNT initialization parameter, 1.7
ALL_ALL_TABLES view, 2.3
ALL_APPLY view, 2.4
ALL_APPLY_CHANGE_HANDLERS view, 2.5
ALL_APPLY_CONFLICT_COLUMNS view, 2.6
ALL_APPLY_DML_HANDLERS view, 2.7
ALL_APPLY_ENQUEUE view, 2.8
ALL_APPLY_ERROR view, 2.9
ALL_APPLY_ERROR_MESSAGES view, 2.10
ALL_APPLY_EXECUTE view, 2.11
ALL_APPLY_KEY_COLUMNS view, 2.12
ALL_APPLY_PARAMETERS view, 2.13
ALL_APPLY_PROGRESS view, 2.14
ALL_APPLY_TABLE_COLUMNS view, 2.15
ALL_ARGUMENTS view, 2.16
ALL_ASSEMBLIES view, 2.17
ALL_ASSOCIATIONS view, 2.18
ALL_AUDIT_POLICIES view, 2.19
ALL_AUDIT_POLICY_COLUMNS view, 2.20
ALL_AW_PS view, 2.21
ALL_AWS view, 2.22
ALL_BASE_TABLE_MVIEWS view, 2.23
ALL_CAPTURE view, 2.24
ALL_CAPTURE_EXTRA_ATTRIBUTES view, 2.25
ALL_CAPTURE_PARAMETERS view, 2.26
ALL_CAPTURE_PREPARED_DATABASE view, 2.27
ALL_CAPTURE_PREPARED_SCHEMAS view, 2.28
ALL_CAPTURE_PREPARED_TABLES view, 2.29
ALL_CATALOG view, 2.30
ALL_CHANGE_PROPAGATION_SETS view, 2.31
CHANGE_PROPAGATION_SETS synonym, 3.150
ALL_CHANGE_PROPAGATIONS view, 2.32
CHANGE_PROPAGATIONS synonym, 3.151
ALL_CHANGE_SETS view, 2.33
CHANGE_SETS synonym, 3.152
ALL_CHANGE_SOURCES view, 2.34
CHANGE_SOURCES synonym, 3.153
ALL_CHANGE_TABLES view, 2.35
CHANGE_TABLES synonym, 3.154
ALL_CLUSTER_HASH_EXPRESSIONS view, 2.36
ALL_CLUSTERS view, 2.37
ALL_COL_COMMENTS view, 2.38
ALL_COL_PENDING_STATS view, 2.39
ALL_COL_PRIVS view, 2.40
ALL_COL_PRIVS_MADE view, 2.41
ALL_COL_PRIVS_RECD view, 2.42
ALL_COLL_TYPES view, 2.43
ALL_CONS_COLUMNS view, 2.44
ALL_CONS_OBJ_COLUMNS view, 2.45
ALL_CONSTRAINTS view, 2.46
ALL_CONTEXT view, 2.47
ALL_CUBE_ATTR_VISIBILITY view, 2.48
ALL_CUBE_ATTRIBUTES view, 2.49
ALL_CUBE_BUILD_PROCESSES view, 2.50
ALL_CUBE_CALCULATED_MEMBERS view, 2.51
ALL_CUBE_DIM_LEVELS view, 2.52
ALL_CUBE_DIM_MODELS view, 2.53
ALL_CUBE_DIM_VIEW_COLUMNS view, 2.54
ALL_CUBE_DIM_VIEWS view, 2.55
ALL_CUBE_DIMENSIONALITY view, 2.56
ALL_CUBE_DIMENSIONS view, 2.57
ALL_CUBE_HIER_LEVELS view, 2.58
ALL_CUBE_HIER_VIEW_COLUMNS view, 2.59
ALL_CUBE_HIER_VIEWS view, 2.60
ALL_CUBE_HIERARCHIES view, 2.61
ALL_CUBE_MEASURES view, 2.62
ALL_CUBE_VIEW_COLUMNS view, 2.63
ALL_CUBE_VIEWS view, 2.64
ALL_CUBES view, 2.65
ALL_DB_LINKS view, 2.66
ALL_DEF_AUDIT_OPTS view, 2.67
ALL_DEPENDENCIES view, 2.68
ALL_DEQUEUE_QUEUES view, 2.69
ALL_DIM_ATTRIBUTES view, 2.70
ALL_DIM_CHILD_OF view, 2.71
ALL_DIM_HIERARCHIES view, 2.72
ALL_DIM_JOIN_KEY view, 2.73
ALL_DIM_LEVEL_KEY view, 2.74
ALL_DIM_LEVELS view, 2.75
ALL_DIMENSIONS view, 2.76
ALL_DIRECTORIES view, 2.77
ALL_EDITION_COMMENTS view, 2.78
ALL_EDITIONING_VIEW_COLS view, 2.79
ALL_EDITIONING_VIEW_COLS_AE view, 2.80
ALL_EDITIONING_VIEWS view, 2.81
ALL_EDITIONING_VIEWS_AE view, 2.82
ALL_EDITIONS view, 2.83
ALL_ENCRYPTED_COLUMNS view, 2.84
ALL_ERRORS view, 2.85
ALL_ERRORS_AE view, 2.86
ALL_EVALUATION_CONTEXT_TABLES view, 2.87
ALL_EVALUATION_CONTEXT_VARS view, 2.88
ALL_EVALUATION_CONTEXTS view, 2.89
ALL_EXTERNAL_LOCATIONS view, 2.90
ALL_EXTERNAL_TABLES view, 2.91
ALL_FILE_GROUP_EXPORT_INFO view, 2.92
ALL_FILE_GROUP_FILES view, 2.93
ALL_FILE_GROUP_TABLES view, 2.94
ALL_FILE_GROUP_TABLESPACES view, 2.95
ALL_FILE_GROUP_VERSIONS view, 2.96
ALL_FILE_GROUPS view, 2.97
ALL_HISTOGRAMS synonym for ALL_TAB_HISTOGRAMS, 2.98
ALL_IDENTIFIERS view, 2.99
ALL_IND_COLUMNS view, 2.100
ALL_IND_EXPRESSIONS view, 2.101
ALL_IND_PARTITIONS view, 2.102
ALL_IND_PENDING_STATS view, 2.103
ALL_IND_STATISTICS view, 2.104
ALL_IND_SUBPARTITIONS view, 2.105
ALL_INDEXES view, 2.106
ALL_INDEXTYPE_ARRAYTYPES view, 2.107
ALL_INDEXTYPE_COMMENTS view, 2.108
ALL_INDEXTYPE_OPERATORS view, 2.109
ALL_INDEXTYPES view, 2.110
ALL_INTERNAL_TRIGGERS view, 2.111
ALL_JAVA_ARGUMENTS view, 2.112
ALL_JAVA_CLASSES view, 2.113
ALL_JAVA_COMPILER_OPTIONS view, 2.114
ALL_JAVA_DERIVATIONS view, 2.115
ALL_JAVA_FIELDS view, 2.116
ALL_JAVA_IMPLEMENTS view, 2.117
ALL_JAVA_INNERS view, 2.118
ALL_JAVA_LAYOUTS view, 2.119
ALL_JAVA_METHODS view, 2.120
ALL_JAVA_NCOMPS view, 2.121
ALL_JAVA_RESOLVERS view, 2.122
ALL_JAVA_THROWS view, 2.123
ALL_JOBS synonym for USER_JOBS view, 2.124
ALL_JOIN_IND_COLUMNS view, 2.125
ALL_LIBRARIES view, 2.126
ALL_LOB_PARTITIONS view, 2.127
ALL_LOB_SUBPARTITIONS view, 2.128
ALL_LOB_TEMPLATES view, 2.129
ALL_LOBS view, 2.130
ALL_LOG_GROUP_COLUMNS view, 2.131
ALL_LOG_GROUPS view, 2.132
ALL_MEASURE_FOLDER_CONTENTS view, 2.133
ALL_MEASURE_FOLDERS view, 2.134
ALL_METHOD_PARAMS view, 2.135
ALL_METHOD_RESULTS view, 2.136
ALL_MINING_MODEL_ATTRIBUTES view, 2.137
ALL_MINING_MODEL_SETTINGS view, 2.138
ALL_MINING_MODELS view, 2.139
ALL_MP_GRAPH_WORKSPACES view, 2.1.2
ALL_MP_PARENT_WORKSPACES view, 2.1.2
ALL_MVIEW_AGGREGATES view, 2.140
ALL_MVIEW_ANALYSIS view, 2.141
ALL_MVIEW_COMMENTS view, 2.142
ALL_MVIEW_DETAIL_PARTITION view, 2.143
ALL_MVIEW_DETAIL_RELATIONS view, 2.144
ALL_MVIEW_DETAIL_SUBPARTITION view, 2.145
ALL_MVIEW_JOINS view, 2.146
ALL_MVIEW_KEYS view, 2.147
ALL_MVIEW_LOGS view, 2.148
ALL_MVIEW_REFRESH_TIMES view, 2.149
ALL_MVIEWS view, 2.150
ALL_NESTED_TABLE_COLS view, 2.151
ALL_NESTED_TABLES view, 2.152
ALL_OBJ_COLATTRS view, 2.153
ALL_OBJECT_TABLES view, 2.154
ALL_OBJECTS view, 2.155
ALL_OBJECTS_AE view, 2.156
ALL_OPANCILLARY view, 2.157
ALL_OPARGUMENTS view, 2.158
ALL_OPBINDINGS view, 2.159
ALL_OPERATOR_COMMENTS view, 2.160
ALL_OPERATORS view, 2.161
ALL_OUTLINE_HINTS synonym for USER_OUTLINE_HINTS view, 2.162
ALL_OUTLINES synonym for USER_OUTLINES view, 2.163
ALL_PART_COL_STATISTICS view, 3.1
ALL_PART_HISTOGRAMS view, 3.2
ALL_PART_INDEXES view, 3.3
ALL_PART_KEY_COLUMNS view, 3.4
ALL_PART_LOBS view, 3.5
ALL_PART_TABLES view, 3.6
ALL_PARTIAL_DROP_TABS view, 3.7
ALL_PENDING_CONV_TABLES view, 3.8
ALL_PLSQL_OBJECT_SETTINGS view, 3.9
ALL_POLICIES view, 3.10
ALL_POLICY_CONTEXTS view, 3.11
ALL_POLICY_GROUPS view, 3.12
ALL_PROCEDURES view, 3.13
ALL_PROPAGATION view, 3.14
ALL_PUBLISHED_COLUMNS synonym for USER_PUBLISHED_COLUMNS view, 3.15
ALL_QUEUE_SCHEDULES view, 3.16
ALL_QUEUE_SUBSCRIBERS view, 3.17
ALL_QUEUE_TABLES view, 3.18
ALL_QUEUES view, 3.19
ALL_REFRESH view, 3.20
ALL_REFRESH_CHILDREN view, 3.21
ALL_REFRESH_DEPENDENCIES view, 3.22
ALL_REFS view, 3.23
ALL_REGISTERED_MVIEWS view, 3.24
ALL_REGISTRY_BANNERS view, 3.25
ALL_REMOVED_WORKSPACES view, 2.1.2
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, 3.26
ALL_RULE_SET_RULES view, 3.27
ALL_RULE_SETS view, 3.28
ALL_RULES view, 3.29
ALL_SCHEDULER_CHAIN_RULES view, 3.30
ALL_SCHEDULER_CHAIN_STEPS view, 3.31
ALL_SCHEDULER_CHAINS view, 3.32
ALL_SCHEDULER_CREDENTIALS view, 3.33
ALL_SCHEDULER_DB_DESTS view, 3.34
ALL_SCHEDULER_DESTS view, 3.35
ALL_SCHEDULER_EXTERNAL_DESTS view, 3.36
ALL_SCHEDULER_FILE_WATCHERS view, 3.37
ALL_SCHEDULER_GLOBAL_ATTRIBUTE view, 3.38
ALL_SCHEDULER_GROUP_MEMBERS view, 3.39
ALL_SCHEDULER_GROUPS view, 3.40
ALL_SCHEDULER_JOB_ARGS view, 3.41
ALL_SCHEDULER_JOB_CLASSES view, 3.42
ALL_SCHEDULER_JOB_DESTS view, 3.43
ALL_SCHEDULER_JOB_LOG view, 3.44
ALL_SCHEDULER_JOB_RUN_DETAILS view, 3.45
ALL_SCHEDULER_JOBS view, 3.46
ALL_SCHEDULER_NOTIFICATIONS view, 3.47
ALL_SCHEDULER_PROGRAM_ARGS view, 3.48
ALL_SCHEDULER_PROGRAMS view, 3.49
ALL_SCHEDULER_REMOTE_DATABASES view, 3.50
ALL_SCHEDULER_REMOTE_JOBSTATE view, 3.51
ALL_SCHEDULER_RUNNING_CHAINS view, 3.52
ALL_SCHEDULER_RUNNING_JOBS view, 3.53
ALL_SCHEDULER_SCHEDULES view, 3.54
ALL_SCHEDULER_WINDOW_DETAILS view, 3.55
ALL_SCHEDULER_WINDOW_GROUPS view, 3.56
ALL_SCHEDULER_WINDOW_LOG view, 3.57
ALL_SCHEDULER_WINDOWS view, 3.58
ALL_SCHEDULER_WINGROUP_MEMBERS view, 3.59
ALL_SEC_RELEVANT_COLS view, 3.60
ALL_SECONDARY_OBJECTS view, 3.61
ALL_SEQUENCES view, 3.62
ALL_SERVICES view, 3.63
ALL_SOURCE view, 3.64
ALL_SOURCE_AE view, 3.65
ALL_SOURCE_TABLES synonym for USER_SOURCE_TABLES view, 3.66
ALL_SQLJ_TYPE_ATTRS view, 3.67
ALL_SQLJ_TYPE_METHODS view, 3.68
ALL_SQLJ_TYPES view, 3.69
ALL_SQLSET view, 3.70
ALL_SQLSET_BINDS view, 3.71
ALL_SQLSET_PLANS view, 3.72
ALL_SQLSET_REFERENCES view, 3.73
ALL_SQLSET_STATEMENTS view, 3.74
ALL_STAT_EXTENSIONS view, 3.75
ALL_STORED_SETTINGS view, 3.76
ALL_STREAMS_COLUMNS view, 3.77
ALL_STREAMS_GLOBAL_RULES view, 3.78
ALL_STREAMS_MESSAGE_CONSUMERS view, 3.79
ALL_STREAMS_MESSAGE_RULES view, 3.80
ALL_STREAMS_NEWLY_SUPPORTED view, 3.81
ALL_STREAMS_RULES view, 3.82
ALL_STREAMS_SCHEMA_RULES view, 3.83
ALL_STREAMS_STMT_HANDLERS view, 3.84
ALL_STREAMS_STMTS view, 3.85
ALL_STREAMS_TABLE_RULES view, 3.86
ALL_STREAMS_TRANSFORM_FUNCTION view, 3.87
ALL_STREAMS_UNSUPPORTED view, 3.88
ALL_SUBPART_COL_STATISTICS view, 3.89
ALL_SUBPART_HISTOGRAMS view, 3.90
ALL_SUBPART_KEY_COLUMNS view, 3.91
ALL_SUBPARTITION_TEMPLATES view, 3.92
ALL_SUBSCRIBED_COLUMNS synonym for USER_SUBSCRIBED_COLUMNS view, 3.93
ALL_SUBSCRIBED_TABLES synonym for USER_SUBSCRIBED_TABLES view, 3.94
ALL_SUBSCRIPTIONS synonym for USER_SUBSCRIPTIONS view, 3.95
ALL_SUMDELTA view, 3.96
ALL_SYNC_CAPTURE view, 3.97
ALL_SYNC_CAPTURE_PREPARED_TABS view, 3.98
ALL_SYNC_CAPTURE_TABLES view, 3.99
ALL_SYNONYMS view, 3.100
ALL_TAB_COL_STATISTICS view, 3.101
ALL_TAB_COLS view, 3.102
ALL_TAB_COLUMNS view, 3.103
ALL_TAB_COMMENTS view, 3.104
ALL_TAB_HISTGRM_PENDING_STATS view, 3.105
ALL_TAB_HISTOGRAMS view, 3.106
ALL_HISTOGRAMS synonym, 2.98
ALL_TAB_MODIFICATIONS view, 3.107
ALL_TAB_PARTITIONS view, 3.108
ALL_TAB_PENDING_STATS view, 3.109
ALL_TAB_PRIVS view, 3.110
ALL_TAB_PRIVS_MADE view, 3.111
ALL_TAB_PRIVS_RECD view, 3.112
ALL_TAB_STAT_PREFS view, 3.113
ALL_TAB_STATISTICS view, 3.114
ALL_TAB_STATS_HISTORY view, 3.115
ALL_TAB_SUBPARTITIONS view, 3.116
ALL_TABLES view, 3.117
ALL_TRIGGER_COLS view, 3.118
ALL_TRIGGER_ORDERING view, 3.119
ALL_TRIGGERS view, 3.120
ALL_TSTZ_TAB_COLS view, 3.121
ALL_TSTZ_TABLES view, 3.122
ALL_TYPE_ATTRS view, 3.123
ALL_TYPE_METHODS view, 3.124
ALL_TYPE_VERSIONS view, 3.125
ALL_TYPES view, 3.126
ALL_UNUSED_COL_TABS view, 3.127
ALL_UPDATABLE_COLUMNS view, 3.128
ALL_USERS view, 3.129
ALL_USTATS view, 3.130
ALL_VARRAYS view, 3.131
ALL_VERSION_HVIEW view, 2.1.2
ALL_VIEWS view, 3.132
ALL_VIEWS_AE view, 3.133
ALL_WARNING_SETTINGS view, 3.134
ALL_WM_CONS_COLUMNS view, 2.1.2
ALL_WM_CONSTRAINTS view, 2.1.2
ALL_WM_IND_COLUMNS view, 2.1.2
ALL_WM_IND_EXPRESSIONS view, 2.1.2
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_INDEXES view, 3.135
ALL_XML_SCHEMAS view, 3.136
ALL_XML_TAB_COLS view, 3.137
ALL_XML_TABLES view, 3.138
ALL_XML_VIEW_COLS view, 3.139
ALL_XML_VIEWS view, 3.140
ALL_XSTREAM_INBOUND view, 3.141
ALL_XSTREAM_INBOUND_PROGRESS view, 3.142
ALL_XSTREAM_OUTBOUND view, 3.143
ALL_XSTREAM_OUTBOUND_PROGRESS view, 3.144
ALL_XSTREAM_RULES view, 3.145
ALLOCATE EXTENT clause
of ALTER TABLE
instance number, 1.102
ALTER DATABASE statement
ADD LOGFILE, 1.252
ENABLE THREAD, 1.252
THREAD, 1.252
ALTER TABLE statement
allocating extents, 1.102
ANALYZE statement, 2.106, 2.151, 3.102, 3.103, 3.117, 5.79, 5.147, 6.43, 6.44, 6.56, 6.359, 6.465, 6.466, 6.480
AQ_TM_PROCESSES initialization parameter, 1.8
ARCHIVE LOG START statement
automatic archiving, 1.120
ARCHIVE_LAG_TARGET initialization parameter, 1.9
archived redo logs
destination file, 1.120
storage device, 1.120, 1.124
ARCHIVELOG mode, 1.120
archiving destination, 1.120, 1.124
ASM_DISKGROUPS initialization parameter, 1.10
ASM_DISKSTRING initialization parameter, 1.11
ASM_POWER_LIMIT initialization parameter, 1.12
ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter, 1.13
AUDIT_ACTIONS table, 3.146
AUDIT_FILE_DEST initialization parameter, 1.14
AUDIT_SYS_OPERATIONS initialization parameter, 1.15
AUDIT_SYSLOG_LEVEL initialization parameter, 1.16
AUDIT_TRAIL initialization parameter, 1.17
authenticating remote clients, 1.208
authenticating users, 1.172

B

BACKGROUND_CORE_DUMP initialization parameter, 1.18
BACKGROUND_DUMP_DEST initialization parameter, 1.19
BACKUP_TAPE_IO_SLAVES initialization parameter, 1.20
BITMAP_MERGE_AREA_SIZE initialization parameter, 1.21
BLANK_TRIMMING initialization parameter, 1.22
blocks
redo log, 1.130
size, 1.44, 1.48, 1.60

C

cache
dictionary, 8.152, 8.153, 8.154
statistics, 1.130
CAT synonym for USER_CATALOG view, 3.147
CATALOG view, 3.148
CATALOG.SQL script, B.1
creating V$ views, 7.1
CATBLOCK.SQL script, B.2
CATCLUST.SQL script, B.1
CATDWGRD.SQL script, B.4
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
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
CATUPGRD.SQL script, B.4
CHAINED_ROWS table, 3.149
CHANGE_PROPAGATION_SETS synonym for ALL_CHANGE_PROPAGATION_SETS view, 3.150
CHANGE_PROPAGATIONS synonym for ALL_CHANGE_PROPAGATIONS view, 3.151
CHANGE_SETS synonym for ALL_CHANGE_SETS view, 3.152
CHANGE_SOURCES synonym for ALL_CHANGE_SOURCES view, 3.153
CHANGE_TABLES synonym for ALL_CHANGE_TABLES view, 3.154
characters
numeric group separators, 1.150
checkpoints
checkpoint interval, 1.130
statistics, 1.130
CIRCUITS initialization parameter, 1.23
CLIENT_RESULT_CACHE_LAG initialization parameter, 1.24
CLIENT_RESULT_CACHE_SIZE initialization parameter, 1.25
CLIENT_RESULT_CACHE_STATS$ view, 3.155
CLU synonym for USER_CLUSTERS view, 3.156
CLUSTER_DATABASE initialization parameter, 1.26
CLUSTER_DATABASE_INSTANCES initialization parameter, 1.27
CLUSTER_INTERCONNECTS initialization parameter, 1.28
COL view, 3.157
COLS synonym for USER_TAB_COLUMNS view, 3.158
COMMIT_LOGGING initialization parameter, 1.29
COMMIT_POINT_STRENGTH initialization parameter, 1.30
COMMIT_WAIT initialization parameter, 1.31
COMMIT_WRITE initialization parameter, 1.32
COMPATIBLE initialization parameter, 1.33
contention
block-level, 9.125
control files
names, 1.35
specifying, 1.35
CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 1.34
CONTROL_FILES initialization parameter, 1.35
CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter, 1.36
CORE_DUMP_DEST initialization parameter, 1.37
cost-based optimization, 1.167
favoring IN-list iterators, 1.165
CPU_COUNT initialization parameter, 1.38
CREATE TABLE statement
FREELIST GROUPS clause, 1.102
CREATE_BITMAP_AREA_SIZE initialization parameter, 1.39
CREATE_STORED_OUTLINES initialization parameter, 1.40
creating
a database
setting block size, 1.44, 1.48, 1.60
currency, 1.141, 1.142
international currency symbol, 1.146
CURSOR_BIND_CAPTURE_DESTINATION initialization parameter, 1.41
CURSOR_SHARING initialization parameter, 1.42
CURSOR_SPACE_FOR_TIME initialization parameter, 1.43
cursors
OPEN_CURSORS initialization parameter, 1.159
shared pool, 1.235

D

data blocks
reading multiple, 1.54
size of, 1.44, 1.48, 1.60
data dictionary, 2
cache, 8.152, 8.153, 8.154
scripts, B.2
SQL scripts, B.1
tables, 2.1
views
overview, 2.1
user views, 2
database writer process (DBWR)
checkpoint, 1.130
DATABASE_PROPERTIES view, 3.159
databases
database limits, A
default language, 1.147
resource limits, 1.211, 1.213
datafiles
maximum number, 1.56
parameter, 1.56
dates
language used for, 1.144, 1.153, 1.154
setting SYSDATE, 1.91
TO_CHAR function, 1.143
TO_DATE function, 1.143
DB_BLOCK_BUFFERS initialization parameter, 1.45
DB_BLOCK_CHECKING initialization parameter, 1.46
DB_BLOCK_CHECKSUM initialization parameter, 1.47
DB_BLOCK_SIZE initialization parameter, 1.48
DB_CACHE_ADVICE initialization parameter, 1.49
DB_CACHE_SIZE initialization parameter, 1.50
DB_CREATE_FILE_DEST initialization parameter, 1.51
DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 1.52
DB_DOMAIN initialization parameter, 1.53
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 1.54
DB_FILE_NAME_CONVERT initialization parameter, 1.55
DB_FILES initialization parameter, 1.56
DB_FLASH_CACHE_FILE initialization parameter, 1.57
DB_FLASH_CACHE_SIZE initialization parameter, 1.58
DB_FLASHBACK_RETENTION_TARGET initialization parameter, 1.59
DB_KEEP_CACHE_SIZE initialization parameter, 1.60
DB_LOST_WRITE_PROTECT initialization parameter, 1.61
DB_NAME initialization parameter, 1.62
DB_nK_CACHE_SIZE initialization parameter, 1.44
DB_RECOVERY_FILE_DEST initialization parameter, 1.63
DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 1.64
DB_RECYCLE_CACHE_SIZE initialization parameter, 1.65
DB_SECUREFILE initialization parameter, 1.66
DB_ULTRA_SAFE initialization parameter, 1.67
DB_UNIQUE_NAME initialization parameter, 1.68
DB_UNRECOVERABLE_SCN_TRACKING initialization parameter, 1.69
DB_WRITER_PROCESSES initialization parameter, 1.70
DBA_2PC_NEIGHBORS view, 4.1
DBA_2PC_PENDING view, 4.2
DBA_ADDM_FDG_BREAKDOWN view, 4.3
DBA_ADDM_FINDINGS view, 4.4
DBA_ADDM_INSTANCES view, 4.5
DBA_ADDM_SYSTEM_DIRECTIVES view, 4.6
DBA_ADDM_TASK_DIRECTIVES view, 4.7
DBA_ADDM_TASKS view, 4.8
DBA_ADVISOR_ACTIONS view, 4.9
DBA_ADVISOR_COMMANDS view, 4.10
DBA_ADVISOR_DEF_PARAMETERS view, 4.11
DBA_ADVISOR_DEFINITIONS view, 4.12
DBA_ADVISOR_DIR_DEFINITIONS view, 4.13
DBA_ADVISOR_DIR_INSTANCES view, 4.14
DBA_ADVISOR_DIR_TASK_INST view, 4.15
DBA_ADVISOR_EXEC_PARAMETERS view, 4.16
DBA_ADVISOR_EXECUTION_TYPES view, 4.17
DBA_ADVISOR_EXECUTIONS view, 4.18
DBA_ADVISOR_FDG_BREAKDOWN view, 4.19
DBA_ADVISOR_FINDING_NAMES view, 4.20
DBA_ADVISOR_FINDINGS view, 4.21
DBA_ADVISOR_JOURNAL view, 4.22
DBA_ADVISOR_LOG view, 4.23
DBA_ADVISOR_OBJECT_TYPES view, 4.24
DBA_ADVISOR_OBJECTS view, 4.25
DBA_ADVISOR_PARAMETERS view, 4.26
DBA_ADVISOR_RATIONALE view, 4.27
DBA_ADVISOR_RECOMMENDATIONS view, 4.28
DBA_ADVISOR_SQLA_REC_SUM view, 4.29
DBA_ADVISOR_SQLA_TABLES view, 4.30
DBA_ADVISOR_SQLA_WK_MAP view, 4.31
DBA_ADVISOR_SQLA_WK_STMTS view, 4.32
DBA_ADVISOR_SQLPLANS view, 4.33
DBA_ADVISOR_SQLSTATS view, 4.34
DBA_ADVISOR_SQLW_JOURNAL view, 4.35
DBA_ADVISOR_SQLW_PARAMETERS view, 4.36
DBA_ADVISOR_SQLW_STMTS view, 4.37
DBA_ADVISOR_SQLW_SUM view, 4.38
DBA_ADVISOR_SQLW_TABLES view, 4.39
DBA_ADVISOR_SQLW_TEMPLATES view, 4.40
DBA_ADVISOR_TASKS view, 4.41
DBA_ADVISOR_TEMPLATES view, 4.42
DBA_ADVISOR_USAGE view, 4.43
DBA_ALERT_HISTORY view, 4.44
DBA_ALL_TABLES view, 4.45
DBA_APPLICATION_ROLES view, 4.46
DBA_APPLY view, 4.47
DBA_APPLY_CHANGE_HANDLERS view, 4.48
DBA_APPLY_CONFLICT_COLUMNS view, 4.49
DBA_APPLY_DML_HANDLERS view, 4.50
DBA_APPLY_ENQUEUE view, 4.51
DBA_APPLY_ERROR view, 4.52
DBA_APPLY_ERROR_MESSAGES view, 4.53
DBA_APPLY_EXECUTE view, 4.54
DBA_APPLY_INSTANTIATED_GLOBAL view, 4.55
DBA_APPLY_INSTANTIATED_OBJECTS view, 4.56
DBA_APPLY_INSTANTIATED_SCHEMAS view, 4.57
DBA_APPLY_KEY_COLUMNS view, 4.58
DBA_APPLY_OBJECT_DEPENDENCIES view, 4.59
DBA_APPLY_PARAMETERS view, 4.60
DBA_APPLY_PROGRESS view, 4.61
DBA_APPLY_SPILL_TXN view, 4.62
DBA_APPLY_TABLE_COLUMNS view, 4.63
DBA_APPLY_VALUE_DEPENDENCIES view, 4.64
DBA_AQ_AGENT_PRIVS view, 4.65
DBA_AQ_AGENTS view, 4.66
DBA_ARGUMENTS view, 4.67
DBA_ASSEMBLIES view, 4.68
DBA_ASSOCIATIONS view, 4.69
DBA_ATTRIBUTE_TRANSFORMATIONS view, 4.70
DBA_AUDIT_EXISTS view, 4.71
DBA_AUDIT_MGMT_CLEAN_EVENTS view, 4.72
DBA_AUDIT_MGMT_CLEANUP_JOBS view, 4.73
DBA_AUDIT_MGMT_CONFIG_PARAMS view, 4.74
DBA_AUDIT_MGMT_LAST_ARCH_TS view, 4.75
DBA_AUDIT_OBJECT view, 4.76
DBA_AUDIT_POLICIES view, 4.77
DBA_AUDIT_POLICY_COLUMNS view, 4.78
DBA_AUDIT_SESSION view, 4.79
DBA_AUDIT_STATEMENT view, 4.80
DBA_AUDIT_TRAIL view, 4.81
DBA_AUTO_SEGADV_CTL view, 4.82
DBA_AUTO_SEGADV_SUMMARY view, 4.83
DBA_AUTOTASK_CLIENT view, 4.84
DBA_AUTOTASK_CLIENT_HISTORY view, 4.85
DBA_AUTOTASK_CLIENT_JOB view, 4.86
DBA_AUTOTASK_JOB_HISTORY view, 4.87
DBA_AUTOTASK_OPERATION view, 4.88
DBA_AUTOTASK_SCHEDULE view, 4.89
DBA_AUTOTASK_TASK view, 4.90
DBA_AUTOTASK_WINDOW_CLIENTS view, 4.91
DBA_AUTOTASK_WINDOW_HISTORY view, 4.92
DBA_AW_PS view, 4.93
DBA_AWS view, 4.94
DBA_BASE_TABLE_MVIEWS view, 4.95
DBA_BLOCKERS view, 4.96
DBA_CAPTURE view, 4.97
DBA_CAPTURE_EXTRA_ATTRIBUTES view, 4.98
DBA_CAPTURE_PARAMETERS view, 4.99
DBA_CAPTURE_PREPARED_DATABASE view, 4.100
DBA_CAPTURE_PREPARED_SCHEMAS view, 4.101
DBA_CAPTURE_PREPARED_TABLES view, 4.102
DBA_CATALOG view, 4.103
DBA_CHANGE_NOTIFICATION_REGS view, 4.104
DBA_CLU_COLUMNS view, 4.105
DBA_CLUSTER_HASH_EXPRESSIONS view, 4.106
DBA_CLUSTERS view, 4.107
DBA_COL_COMMENTS view, 4.108
DBA_COL_PENDING_STATS view, 4.109
DBA_COL_PRIVS view, 4.110
DBA_COLL_TYPES view, 4.111
DBA_COMMON_AUDIT_TRAIL view, 4.112
DBA_COMPARISON view, 4.113
DBA_COMPARISON_COLUMNS view, 4.114
DBA_COMPARISON_ROW_DIF view, 4.115
DBA_COMPARISON_SCAN view, 4.116
DBA_COMPARISON_SCAN_VALUES view, 4.117
DBA_CONNECT_ROLE_GRANTEES view, 4.118
DBA_CONS_OBJ_COLUMNS view, 4.119
DBA_CONSTRAINTS view, 4.120
DBA_CONTEXT view, 4.121
DBA_CPOOL_INFO view, 4.122
DBA_CPU_USAGE_STATISTICS view, 4.123
DBA_CQ_NOTIFICATION_QUERIES view, 4.124
DBA_CUBE_ATTR_VISIBILITY view, 4.125
DBA_CUBE_ATTRIBUTES view, 4.126
DBA_CUBE_BUILD_PROCESSES view, 4.127
DBA_CUBE_CALCULATED_MEMBERS view, 4.128
DBA_CUBE_DIM_LEVELS view, 4.129
DBA_CUBE_DIM_MODELS view, 4.130
DBA_CUBE_DIM_VIEW_COLUMNS view, 4.131
DBA_CUBE_DIM_VIEWS view, 4.132
DBA_CUBE_DIMENSIONALITY view, 4.133
DBA_CUBE_DIMENSIONS view, 4.134
DBA_CUBE_HIER_LEVELS view, 4.135
DBA_CUBE_HIER_VIEW_COLUMNS view, 4.136
DBA_CUBE_HIER_VIEWS view, 4.137
DBA_CUBE_HIERARCHIES view, 4.138
DBA_CUBE_MEASURES view, 4.139
DBA_CUBE_VIEW_COLUMNS view, 4.140
DBA_CUBE_VIEWS view, 4.141
DBA_CUBES view, 4.142
DBA_DATA_FILES view, 4.143
DBA_DATAPUMP_JOBS view, 4.144
DBA_DATAPUMP_SESSIONS view, 4.145
DBA_DB_LINKS view, 4.146
DBA_DDL_LOCKS view, 4.147
DBA_DEPENDENCIES view, 4.148
DBA_DIM_ATTRIBUTES view, 4.149
DBA_DIM_CHILD_OF view, 4.150
DBA_DIM_HIERARCHIES view, 4.151
DBA_DIM_JOIN_KEY view, 4.152
DBA_DIM_LEVEL_KEY view, 4.153
DBA_DIM_LEVELS view, 4.154
DBA_DIMENSIONS view, 4.155
DBA_DIRECTORIES view, 4.156
DBA_DML_LOCKS view, 4.157
DBA_DMT_FREE_SPACE view, 4.158
DBA_DMT_USED_EXTENTS view, 4.159
DBA_EDITION_COMMENTS view, 4.160
DBA_EDITIONING_VIEW_COLS view, 4.161
DBA_EDITIONING_VIEW_COLS_AE view, 4.162
DBA_EDITIONING_VIEWS view, 4.163
DBA_EDITIONING_VIEWS_AE view, 4.164
DBA_EDITIONS view, 4.165
DBA_ENABLED_AGGREGATIONS view, 4.166
DBA_ENABLED_TRACES view, 4.167
DBA_ENCRYPTED_COLUMNS view, 4.168
DBA_EPG_DAD_AUTHORIZATION view, 4.169
DBA_ERRORS view, 4.170
DBA_ERRORS_AE view, 4.171
DBA_EVALUATION_CONTEXT_TABLES view, 4.172
DBA_EVALUATION_CONTEXT_VARS view, 4.173
DBA_EVALUATION_CONTEXTS view, 4.174
DBA_EXP_FILES view, 4.175
DBA_EXP_OBJECTS view, 4.176
DBA_EXP_VERSION view, 4.177
DBA_EXTENTS view, 4.178
DBA_EXTERNAL_LOCATIONS view, 4.179
DBA_EXTERNAL_TABLES view, 4.180
DBA_FEATURE_USAGE_STATISTICS view, 4.181
DBA_FGA_AUDIT_TRAIL view, 4.182
DBA_FILE_GROUP_EXPORT_INFO view, 4.183
DBA_FILE_GROUP_FILES view, 4.184
DBA_FILE_GROUP_TABLES view, 4.185
DBA_FILE_GROUP_TABLESPACES view, 4.186
DBA_FILE_GROUP_VERSIONS view, 4.187
DBA_FILE_GROUPS view, 4.188
DBA_FLASHBACK_ARCHIVE view, 4.189
DBA_FLASHBACK_ARCHIVE_TABLES view, 4.190
DBA_FLASHBACK_ARCHIVE_TS view, 4.191
DBA_FLASHBACK_TXN_REPORT view, 4.192
DBA_FLASHBACK_TXN_STATE view, 4.193
DBA_FREE_SPACE view, 4.194
DBA_FREE_SPACE_COALESCED view, 4.195
DBA_HIGH_WATER_MARK_STATISTICS view, 4.196
DBA_HIST_ACTIVE_SESS_HISTORY view, 4.197
DBA_HIST_BASELINE view, 4.198
DBA_HIST_BASELINE_DETAILS view, 4.199
DBA_HIST_BASELINE_METADATA view, 4.200
DBA_HIST_BASELINE_TEMPLATE view, 4.201
DBA_HIST_BG_EVENT_SUMMARY view, 4.202
DBA_HIST_BUFFER_POOL_STAT view, 4.203
DBA_HIST_BUFFERED_QUEUES view, 4.204
DBA_HIST_BUFFERED_SUBSCRIBERS view, 4.205
DBA_HIST_CLUSTER_INTERCON view, 4.206
DBA_HIST_COLORED_SQL view, 4.207
DBA_HIST_COMP_IOSTAT view, 4.208
DBA_HIST_CR_BLOCK_SERVER view, 4.209
DBA_HIST_CURRENT_BLOCK_SERVER view, 4.210
DBA_HIST_DATABASE_INSTANCE view, 4.211
DBA_HIST_DATAFILE view, 4.212
DBA_HIST_DB_CACHE_ADVICE view, 4.213
DBA_HIST_DISPATCHER view, 4.214
DBA_HIST_DLM_MISC view, 4.215
DBA_HIST_DYN_REMASTER_STATS view, 4.216
DBA_HIST_ENQUEUE_STAT view, 4.217
DBA_HIST_EVENT_HISTOGRAM view, 4.218
DBA_HIST_EVENT_NAME view, 4.219
DBA_HIST_FILEMETRIC_HISTORY view, 4.220
DBA_HIST_FILESTATXS view, 4.221
DBA_HIST_IC_CLIENT_STATS view, 4.222
DBA_HIST_IC_DEVICE_STATS view, 4.223
DBA_HIST_INST_CACHE_TRANSFER view, 4.224
DBA_HIST_INSTANCE_RECOVERY view, 4.225
DBA_HIST_INTERCONNECT_PINGS view, 4.226
DBA_HIST_IOSTAT_DETAIL view, 4.227
DBA_HIST_IOSTAT_FILETYPE view, 4.228
DBA_HIST_IOSTAT_FILETYPE_NAME view, 4.229
DBA_HIST_IOSTAT_FUNCTION view, 4.230
DBA_HIST_IOSTAT_FUNCTION_NAME view, 4.231
DBA_HIST_JAVA_POOL_ADVICE view, 4.232
DBA_HIST_LATCH view, 5.1
DBA_HIST_LATCH_CHILDREN view, 5.2
DBA_HIST_LATCH_MISSES_SUMMARY view, 5.3
DBA_HIST_LATCH_NAME view, 5.4
DBA_HIST_LATCH_PARENT view, 5.5
DBA_HIST_LIBRARYCACHE view, 5.6
DBA_HIST_LOG view, 5.7
DBA_HIST_MEM_DYNAMIC_COMP view, 5.8
DBA_HIST_MEMORY_RESIZE_OPS view, 5.9
DBA_HIST_MEMORY_TARGET_ADVICE view, 5.10
DBA_HIST_METRIC_NAME view, 5.11
DBA_HIST_MTTR_TARGET_ADVICE view, 5.12
DBA_HIST_MUTEX_SLEEP view, 5.13
DBA_HIST_OPTIMIZER_ENV view, 5.14
DBA_HIST_OSSTAT view, 5.15
DBA_HIST_OSSTAT_NAME view, 5.16
DBA_HIST_PARAMETER view, 5.17
DBA_HIST_PARAMETER_NAME view, 5.18
DBA_HIST_PERSISTENT_QUEUES view, 5.19
DBA_HIST_PERSISTENT_SUBS view, 5.20
DBA_HIST_PGA_TARGET_ADVICE view, 5.21
DBA_HIST_PGASTAT view, 5.22
DBA_HIST_PLAN_OPERATION_NAME view, 5.23
DBA_HIST_PLAN_OPTION_NAME view, 5.24
DBA_HIST_PROCESS_MEM_SUMMARY view, 5.25
DBA_HIST_RESOURCE_LIMIT view, 5.26
DBA_HIST_ROWCACHE_SUMMARY view, 5.27
DBA_HIST_RSRC_CONSUMER_GROUP view, 5.28
DBA_HIST_RSRC_PLAN view, 5.29
DBA_HIST_RULE_SET view, 5.30
DBA_HIST_SEG_STAT view, 5.31
DBA_HIST_SEG_STAT_OBJ view, 5.32
DBA_HIST_SERVICE_NAME view, 5.33
DBA_HIST_SERVICE_STAT view, 5.34
DBA_HIST_SERVICE_WAIT_CLASS view, 5.35
DBA_HIST_SESS_TIME_STATS view, 5.36
DBA_HIST_SESSMETRIC_HISTORY view, 5.37
DBA_HIST_SGA view, 5.38
DBA_HIST_SGA_TARGET_ADVICE view, 5.39
DBA_HIST_SGASTAT view, 5.40
DBA_HIST_SHARED_POOL_ADVICE view, 5.41
DBA_HIST_SHARED_SERVER_SUMMARY view, 5.42
DBA_HIST_SNAP_ERROR view, 5.43
DBA_HIST_SNAPSHOT view, 5.44
DBA_HIST_SQL_BIND_METADATA view, 5.45
DBA_HIST_SQL_PLAN view, 5.46
DBA_HIST_SQL_SUMMARY view, 5.47
DBA_HIST_SQL_WORKAREA_HSTGRM view, 5.48
DBA_HIST_SQLBIND view, 5.49
DBA_HIST_SQLCOMMAND_NAME view, 5.50
DBA_HIST_SQLSTAT view, 5.51
DBA_HIST_SQLTEXT view, 5.52
DBA_HIST_STAT_NAME view, 5.53
DBA_HIST_STREAMS_APPLY_SUM view, 5.54
DBA_HIST_STREAMS_CAPTURE view, 5.55
DBA_HIST_STREAMS_POOL_ADVICE view, 5.56
DBA_HIST_SYS_TIME_MODEL view, 5.57
DBA_HIST_SYSMETRIC_HISTORY view, 5.58
DBA_HIST_SYSMETRIC_SUMMARY view, 5.59
DBA_HIST_SYSSTAT view, 5.60
DBA_HIST_SYSTEM_EVENT view, 5.61
DBA_HIST_TABLESPACE_STAT view, 5.62
DBA_HIST_TBSPC_SPACE_USAGE view, 5.63
DBA_HIST_TEMPFILE view, 5.64
DBA_HIST_TEMPSTATXS view, 5.65
DBA_HIST_THREAD view, 5.66
DBA_HIST_TOPLEVELCALL_NAME view, 5.67
DBA_HIST_UNDOSTAT view, 5.68
DBA_HIST_WAITCLASSMET_HISTORY view, 5.69
DBA_HIST_WAITSTAT view, 5.70
DBA_HIST_WR_CONTROL view, 5.71
DBA_HISTOGRAMS synonym for DBA_TAB_HISTOGRAMS, 5.72
DBA_IDENTIFIERS view, 5.73
DBA_IND_COLUMNS view, 5.74
DBA_IND_EXPRESSIONS view, 5.75
DBA_IND_PARTITIONS view, 5.76
DBA_IND_PENDING_STATS view, 5.77
DBA_IND_STATISTICS view, 5.78
DBA_IND_SUBPARTITIONS view, 5.79
DBA_INDEXES view, 5.80
collecting statistics for, 5.79
DBA_INDEXTYPE_ARRAYTYPES view, 5.81
DBA_INDEXTYPE_COMMENTS view, 5.82
DBA_INDEXTYPE_OPERATORS view, 5.83
DBA_INDEXTYPES view, 5.84
DBA_INTERNAL_TRIGGERS view, 5.85
DBA_JAVA_ARGUMENTS view, 5.86
DBA_JAVA_CLASSES view, 5.87
DBA_JAVA_COMPILER_OPTIONS view, 5.88
DBA_JAVA_DERIVATIONS view, 5.89
DBA_JAVA_FIELDS view, 5.90
DBA_JAVA_IMPLEMENTS view, 5.91
DBA_JAVA_INNERS view, 5.92
DBA_JAVA_LAYOUTS view, 5.93
DBA_JAVA_METHODS view, 5.94
DBA_JAVA_NCOMPS view, 5.95
DBA_JAVA_POLICY view, 5.96
DBA_JAVA_RESOLVERS view, 5.97
DBA_JAVA_THROWS view, 5.98
DBA_JOBS view, 5.99
DBA_JOBS_RUNNING view, 5.100
DBA_JOIN_IND_COLUMNS view, 5.101
DBA_KGLLOCK view, 5.102
DBA_LIBRARIES view, 5.103
DBA_LMT_FREE_SPACE view, 5.104
DBA_LMT_USED_EXTENTS view, 5.105
DBA_LOB_PARTITIONS view, 5.106
DBA_LOB_SUBPARTITIONS view, 5.107
DBA_LOB_TEMPLATES view, 5.108
DBA_LOBS view, 5.109
DBA_LOCK view, 5.110
DBA_LOCKS synonym, 5.112
DBA_LOCK_INTERNAL view, 5.111
DBA_LOCKS synonym for DBA_LOCK view, 5.112
DBA_LOG_GROUP_COLUMNS view, 5.113
DBA_LOG_GROUPS view, 5.114
DBA_LOGMNR_LOG view, 5.115
DBA_LOGMNR_PURGED_LOG view, 5.116
DBA_LOGMNR_SESSION view, 5.117
DBA_LOGSTDBY_EVENTS view, 5.118
DBA_LOGSTDBY_HISTORY view, 5.119
DBA_LOGSTDBY_LOG view, 5.120
DBA_LOGSTDBY_NOT_UNIQUE view, 5.121
DBA_LOGSTDBY_PARAMETERS view, 5.122
DBA_LOGSTDBY_PROGRESS view, 5.123
DBA_LOGSTDBY_SKIP view, 5.124
DBA_LOGSTDBY_SKIP_TRANSACTION view, 5.125
DBA_LOGSTDBY_UNSUPPORTED view, 5.126
DBA_LOGSTDBY_UNSUPPORTED_TABLE view, 5.127
LOGSTDBY_UNSUPPORTED_TABLES synonym, 6.139
DBA_MEASURE_FOLDER_CONTENTS view, 5.128
DBA_MEASURE_FOLDERS view, 5.129
DBA_METHOD_PARAMS view, 5.130
DBA_METHOD_RESULTS view, 5.131
DBA_MINING_MODEL_ATTRIBUTES view, 5.132
DBA_MINING_MODEL_SETTINGS view, 5.133
DBA_MINING_MODELS view, 5.134
DBA_MVIEW_AGGREGATES view, 5.135
DBA_MVIEW_ANALYSIS view, 5.136
DBA_MVIEW_COMMENTS view, 5.137
DBA_MVIEW_DETAIL_PARTITION view, 5.138
DBA_MVIEW_DETAIL_RELATIONS view, 5.139
DBA_MVIEW_DETAIL_SUBPARTITION view, 5.140
DBA_MVIEW_JOINS view, 5.141
DBA_MVIEW_KEYS view, 5.142
DBA_MVIEW_LOG_FILTER_COLS view, 5.143
DBA_MVIEW_LOGS view, 5.144
DBA_MVIEW_REFRESH_TIMES view, 5.145
DBA_MVIEWS view, 5.146
DBA_NESTED_TABLE_COLS view, 5.147
DBA_NESTED_TABLES view, 5.148
DBA_NETWORK_ACL_PRIVILEGES view, 5.149
DBA_NETWORK_ACLS view, 5.150
DBA_OBJ_AUDIT_OPTS view, 5.151
DBA_OBJ_COLATTRS view, 5.152
DBA_OBJECT_SIZE view, 5.153
DBA_OBJECT_TABLES view, 5.154
DBA_OBJECTS view, 5.155
DBA_OBJECTS_AE view, 5.156
DBA_OPANCILLARY view, 5.157
DBA_OPARGUMENTS view, 5.158
DBA_OPBINDINGS view, 5.159
DBA_OPERATOR_COMMENTS view, 5.160
DBA_OPERATORS view, 5.161
DBA_OPTSTAT_OPERATIONS view, 5.162
DBA_ORPHAN_KEY_TABLE view, 5.163
DBA_OUTLINE_HINTS view, 5.164
DBA_OUTLINES view, 5.165
DBA_OUTSTANDING_ALERTS view, 5.166
DBA_PARALLEL_EXECUTE_CHUNKS view, 5.167
DBA_PARALLEL_EXECUTE_TASKS view, 5.168
DBA_PART_COL_STATISTICS view, 5.169
DBA_PART_HISTOGRAMS view, 5.170
DBA_PART_INDEXES view, 5.171
DBA_PART_KEY_COLUMNS view, 5.172
DBA_PART_LOBS view, 5.173
DBA_PART_TABLES view, 5.174
DBA_PARTIAL_DROP_TABS view, 5.175
DBA_PENDING_CONV_TABLES view, 5.176
DBA_PENDING_TRANSACTIONS view, 5.177
DBA_PLSQL_OBJECT_SETTINGS view, 5.178
DBA_POLICIES view, 5.179
DBA_POLICY_CONTEXTS view, 5.180
DBA_POLICY_GROUPS view, 5.181
DBA_PRIV_AUDIT_OPTS view, 5.182
DBA_PROCEDURES view, 5.183
DBA_PROFILES view, 5.184
DBA_PROPAGATION view, 5.185
DBA_PROXIES view, 5.186
DBA_PUBLISHED_COLUMNS view, 5.187
DBA_QUEUE_SCHEDULES view, 5.188
DBA_QUEUE_SUBSCRIBERS view, 5.189
DBA_QUEUE_TABLES view, 5.190
DBA_QUEUES view, 5.191
DBA_RCHILD view, 5.192
DBA_RECOVERABLE_SCRIPT view, 5.193
DBA_RECOVERABLE_SCRIPT_BLOCKS view, 5.194
DBA_RECOVERABLE_SCRIPT_ERRORS view, 5.195
DBA_RECOVERABLE_SCRIPT_HIST view, 5.196
DBA_RECOVERABLE_SCRIPT_PARAMS view, 5.197
DBA_RECYCLEBIN view, 5.198
DBA_REDEFINITION_ERRORS view, 5.199
DBA_REDEFINITION_OBJECTS view, 5.200
DBA_REFRESH view, 5.201
DBA_REFRESH_CHILDREN view, 5.202
DBA_REFS view, 5.203
DBA_REGISTERED_ARCHIVED_LOG view, 5.204
DBA_REGISTERED_MVIEW_GROUPS view, 5.205
DBA_REGISTERED_MVIEWS view, 5.206
DBA_REGISTRY view, 5.207
DBA_REGISTRY_HIERARCHY view, 5.208
DBA_REGISTRY_HISTORY view, 5.209
DBA_REGISTRY_LOG view, 5.210
DBA_REPAIR_TABLE view, 5.211
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_RESOURCE_INCARNATIONS view, 5.212
DBA_RESUMABLE view, 5.213
DBA_REWRITE_EQUIVALENCES view, 5.214
DBA_RGROUP view, 5.215
DBA_ROLE_PRIVS view, 5.216
DBA_ROLES view, 5.217
DBA_ROLLBACK_SEGS view, 5.218
DBA_RSRC_CATEGORIES view, 5.219
DBA_RSRC_CONSUMER_GROUP_PRIVS view, 5.220
DBA_RSRC_CONSUMER_GROUPS view, 5.221
DBA_RSRC_GROUP_MAPPINGS view, 5.222
DBA_RSRC_IO_CALIBRATE view, 5.223
DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 5.224
DBA_RSRC_MAPPING_PRIORITY view, 5.225
DBA_RSRC_PLAN_DIRECTIVES view, 5.226
DBA_RSRC_PLANS view, 5.227
DBA_RULE_SET_RULES view, 5.228
DBA_RULE_SETS view, 5.229
DBA_RULES view, 5.230
DBA_SCHEDULER_CHAIN_RULES view, 5.231
DBA_SCHEDULER_CHAIN_STEPS view, 5.232
DBA_SCHEDULER_CHAINS view, 5.233
DBA_SCHEDULER_CREDENTIALS view, 5.234
DBA_SCHEDULER_DB_DESTS view, 5.235
DBA_SCHEDULER_DESTS view, 5.236
DBA_SCHEDULER_EXTERNAL_DESTS view, 5.237
DBA_SCHEDULER_FILE_WATCHERS view, 5.238
DBA_SCHEDULER_GLOBAL_ATTRIBUTE view, 5.239
DBA_SCHEDULER_GROUP_MEMBERS view, 5.240
DBA_SCHEDULER_GROUPS view, 5.241
DBA_SCHEDULER_JOB_ARGS view, 5.242
DBA_SCHEDULER_JOB_CLASSES view, 5.243
DBA_SCHEDULER_JOB_DESTS view, 5.244
DBA_SCHEDULER_JOB_LOG view, 5.245
DBA_SCHEDULER_JOB_ROLES view, 5.246
DBA_SCHEDULER_JOB_RUN_DETAILS view, 5.247
DBA_SCHEDULER_JOBS view, 5.248
DBA_SCHEDULER_NOTIFICATIONS view, 5.249
DBA_SCHEDULER_PROGRAM_ARGS view, 5.250
DBA_SCHEDULER_PROGRAMS view, 5.251
DBA_SCHEDULER_REMOTE_DATABASES view, 5.252
DBA_SCHEDULER_REMOTE_JOBSTATE view, 5.253
DBA_SCHEDULER_RUNNING_CHAINS view, 5.254
DBA_SCHEDULER_RUNNING_JOBS view, 5.255
DBA_SCHEDULER_SCHEDULES view, 5.256
DBA_SCHEDULER_WINDOW_DETAILS view, 5.257
DBA_SCHEDULER_WINDOW_GROUPS view, 5.258
DBA_SCHEDULER_WINDOW_LOG view, 5.259
DBA_SCHEDULER_WINDOWS view, 5.260
DBA_SCHEDULER_WINGROUP_MEMBERS view, 5.261
DBA_SEC_RELEVANT_COLS view, 5.262
DBA_SECONDARY_OBJECTS view, 5.263
DBA_SEGMENTS view, 5.264
DBA_SEGMENTS_OLD view, 5.265
DBA_SEQUENCES view, 5.266
DBA_SERVER_REGISTRY view, 5.267
DBA_SERVICES view, 5.268
DBA_SOURCE view, 5.269
DBA_SOURCE_AE view, 5.270
DBA_SOURCE_TABLES view, 5.271
DBA_SQL_MANAGEMENT_CONFIG view, 5.272
DBA_SQL_PATCHES view, 5.273
DBA_SQL_PLAN_BASELINES view, 5.274
DBA_SQL_PROFILES view, 5.275
DBA_SQLJ_TYPE_ATTRS view, 5.276
DBA_SQLJ_TYPE_METHODS view, 5.277
DBA_SQLJ_TYPES view, 5.278
DBA_SQLSET view, 5.279
DBA_SQLSET_BINDS view, 5.280
DBA_SQLSET_PLANS view, 5.281
DBA_SQLSET_REFERENCES view, 5.282
DBA_SQLSET_STATEMENTS view, 5.283
DBA_SQLTUNE_BINDS view, 5.284
DBA_SQLTUNE_PLANS view, 5.285
DBA_SQLTUNE_RATIONALE_PLAN view, 5.286
DBA_SQLTUNE_STATISTICS view, 5.287
DBA_SSCR_CAPTURE view, 5.288
DBA_SSCR_RESTORE view, 5.289
DBA_STAT_EXTENSIONS view, 5.290
DBA_STMT_AUDIT_OPTS view, 5.291
DBA_STORED_SETTINGS view, 5.292
DBA_STREAMS_ADD_COLUMN view, 6.1
DBA_STREAMS_ADMINISTRATOR view, 6.2
DBA_STREAMS_COLUMNS view, 6.3
DBA_STREAMS_DELETE_COLUMN view, 6.4
DBA_STREAMS_GLOBAL_RULES view, 6.5
DBA_STREAMS_KEEP_COLUMNS view, 6.6
DBA_STREAMS_MESSAGE_CONSUMERS view, 6.7
DBA_STREAMS_MESSAGE_RULES view, 6.8
DBA_STREAMS_NEWLY_SUPPORTED view, 6.9
DBA_STREAMS_RENAME_COLUMN view, 6.10
DBA_STREAMS_RENAME_SCHEMA view, 6.11
DBA_STREAMS_RENAME_TABLE view, 6.12
DBA_STREAMS_RULES view, 6.13
DBA_STREAMS_SCHEMA_RULES view, 6.14
DBA_STREAMS_SPLIT_MERGE view, 6.15
DBA_STREAMS_SPLIT_MERGE_HIST view, 6.16
DBA_STREAMS_STMT_HANDLERS view, 6.17
DBA_STREAMS_STMTS view, 6.18
DBA_STREAMS_TABLE_RULES view, 6.19
DBA_STREAMS_TP_COMPONENT view, 6.20
DBA_STREAMS_TP_COMPONENT_LINK view, 6.21
DBA_STREAMS_TP_COMPONENT_STAT view, 6.22
DBA_STREAMS_TP_DATABASE view, 6.23
DBA_STREAMS_TP_PATH_BOTTLENECK view, 6.24
DBA_STREAMS_TP_PATH_STAT view, 6.25
DBA_STREAMS_TRANSFORM_FUNCTION view, 6.26
DBA_STREAMS_TRANSFORMATIONS view, 6.27
DBA_STREAMS_UNSUPPORTED view, 6.28
DBA_SUBPART_COL_STATISTICS view, 6.29
DBA_SUBPART_HISTOGRAMS view, 6.30
DBA_SUBPART_KEY_COLUMNS view, 6.31
DBA_SUBPARTITION_TEMPLATES view, 6.32
DBA_SUBSCR_REGISTRATIONS view, 6.33
DBA_SUBSCRIBED_COLUMNS view, 6.34
DBA_SUBSCRIBED_TABLES view, 6.35
DBA_SUBSCRIPTIONS view, 6.36
DBA_SYNC_CAPTURE view, 6.37
DBA_SYNC_CAPTURE_PREPARED_TABS view, 6.38
DBA_SYNC_CAPTURE_TABLES view, 6.39
DBA_SYNONYMS view, 6.40
DBA_SYS_PRIVS view, 6.41
DBA_TAB_COL_STATISTICS view, 6.42
DBA_TAB_COLS view, 6.43
DBA_TAB_COLUMNS view, 6.44
DBA_TAB_COMMENTS view, 6.45
DBA_TAB_HISTGRM_PENDING_STATS view, 6.46
DBA_TAB_HISTOGRAMS view, 6.47
DBA_HISTOGRAMS synonym, 5.72
DBA_TAB_MODIFICATIONS view, 6.48
DBA_TAB_PARTITIONS view, 6.49
DBA_TAB_PENDING_STATS view, 6.50
DBA_TAB_PRIVS view, 6.51
DBA_TAB_STAT_PREFS view, 6.53
DBA_TAB_STATISTICS view, 6.52
DBA_TAB_STATS_HISTORY view, 6.54
DBA_TAB_SUBPARTITIONS view, 6.55
DBA_TABLES view, 6.56
DBA_TABLESPACE_GROUPS view, 6.57
DBA_TABLESPACE_THRESHOLDS view, 6.58
DBA_TABLESPACE_USAGE_METRICS view, 6.59
DBA_TABLESPACES view, 6.60
DBA_TEMP_FILES view, 6.61
DBA_TEMP_FREE_SPACE view, 6.62
DBA_THRESHOLDS view, 6.63
DBA_TRANSFORMATIONS view, 6.64
DBA_TRIGGER_COLS view, 6.65
DBA_TRIGGER_ORDERING view, 6.66
DBA_TRIGGERS view, 6.67
DBA_TS_QUOTAS view, 6.68
DBA_TSM_DESTINATION view, 6.69
DBA_TSM_SOURCE view, 6.70
DBA_TSTZ_TAB_COLS view, 6.71
DBA_TSTZ_TABLES view, 6.72
DBA_TUNE_MVIEW view, 6.73
DBA_TYPE_ATTRS view, 6.74
DBA_TYPE_METHODS view, 6.75
DBA_TYPE_VERSIONS view, 6.76
DBA_TYPES view, 6.77
DBA_UNDO_EXTENTS view, 6.78
DBA_UNUSED_COL_TABS view, 6.79
DBA_UPDATABLE_COLUMNS view, 6.80
DBA_USERS view, 6.81
DBA_USERS_WITH_DEFPWD view, 6.82
DBA_USTATS view, 6.83
DBA_VARRAYS view, 6.84
DBA_VIEWS view, 6.85
DBA_VIEWS_AE view, 6.86
DBA_WAITERS view, 6.87
DBA_WALLET_ACLS view, 6.88
DBA_WARNING_SETTINGS view, 6.89
DBA_WM_SYS_PRIVS view, 2.1.2
DBA_WM_VT_ERRORS view, 2.1.2
DBA_WORKLOAD_CAPTURES view, 6.90
DBA_WORKLOAD_CONNECTION_MAP view, 6.91
DBA_WORKLOAD_FILTERS view, 6.92
DBA_WORKLOAD_REPLAY_DIVERGENCE view, 6.93
DBA_WORKLOAD_REPLAYS view, 6.94
DBA_WORKSPACE_SESSIONS view, 2.1.2
DBA_WORKSPACES view, 2.1.2
DBA_XML_INDEXES view, 6.95
DBA_XML_SCHEMAS view, 6.96
DBA_XML_TAB_COLS view, 6.97
DBA_XML_TABLES view, 6.98
DBA_XML_VIEW_COLS view, 6.99
DBA_XML_VIEWS view, 6.100
DBA_XSTREAM_ADMINISTRATOR view, 6.101
DBA_XSTREAM_INBOUND view, 6.102
DBA_XSTREAM_INBOUND_PROGRESS view, 6.103
DBA_XSTREAM_OUT_SUPPORT_MODE view, 6.104
DBA_XSTREAM_OUTBOUND view, 6.105
DBA_XSTREAM_OUTBOUND_PROGRESS view, 6.106
DBA_XSTREAM_RULES view, 6.107
DBFS_CONTENT view, 6.108
DBFS_CONTENT_PROPERTIES view, 6.109
DBMS_ALERT_INFO view, 6.110
DBMS_LOCK_ALLOCATED view, 6.111
DBMSIOTC.SQL script, B.2
DBMSPOOL.SQL script, B.2
DBWR_IO_SLAVES initialization parameter, 1.71
DDL_LOCK_TIMEOUT initialization parameter, 1.72
DEFCALL view, 2.1.1
DEFCALLDEST view, 2.1.1
DEFDEFAULTDEST view, 2.1.1
DEFERRCOUNT view, 2.1.1
DEFERRED_SEGMENT_CREATION initialization parameter, 1.73
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, 6.112
destination
archiving redo log files, 1.120
overriding default, 1.120
USER_DUMP_DEST, 1.263
DG_BROKER_CONFIG_FILEn initialization parameter, 1.74
DG_BROKER_START initialization parameter, 1.75
DIAGNOSTIC_DEST initialization parameter, 1.76
DICT synonym for DICTIONARY, 6.113
DICT_COLUMNS view, 6.114
DICTIONARY view, 6.115
DICT synonym, 6.113
disk drives
archiving destination, 1.120
DISK_ASYNCH_IO initialization parameter, 1.77
dispatcher processes
maximum number, 1.134
DISPATCHERS initialization parameter, 1.78
distinguished name, 1.200
DISTRIBUTED_LOCK_TIMEOUT initialization parameter, 1.79
DM_USER_MODELS view, 6.116
DML_LOCKS initialization parameter, 1.80
DOCUMENT_LINKS view, 6.117
downgrading
scripts, B.4
DST_UPGRADE_INSERT_CONV initialization parameter, 1.81
dump files, 1.135
dynamic performance tables
CATALOG.SQL script, 7.1
public synonyms (V$), 7.1.1
views (V_$), 7.1.1

E

embedded initialization parameter files, 1.99
ENABLE_DDL_LOGGING initialization parameter, 1.82
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.80
distributed recovery process, D
distributed transaction, D
DML, D
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.200
ERROR_SIZE view, 6.118
EVENT initialization parameter, 1.83
EXCEPTIONS table, 6.119
extent
allocating to instance, 1.102

F

FAL_CLIENT initialization parameter, 1.84
FAL_SERVER initialization parameter, 1.85
FAST_START_MTTR_TARGET initialization parameter, 1.86
FAST_START_PARALLEL_ROLLBACK initialization parameter, 1.87
FILE_MAPPING initialization parameter, 1.88
FILEIO_NETWORK_ADAPTERS initialization parameter, 1.89
filenames
case significance, 1.3.2.1.1
FILESYSTEMIO_OPTIONS initialization parameter, 1.90
FIXED_DATE initialization parameter, 1.91
FLASHBACK_TRANSACTION_QUERY view, 6.120
free space list
locating space, 1.102
FREELIST GROUPS clause, 1.102

G

GCS_SERVER_PROCESSES initialization parameter, 1.92
GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1.93
GLOBAL_NAME view, 6.121
GLOBAL_NAMES initialization parameter, 1.94
GLOBAL_TXN_PROCESSES initialization parameter, 1.95
GV$ views
for Real Application Clusters, 7.1.2

H

HASH_AREA_SIZE initialization parameter, 1.96
Heterogeneous Services
agents, 1.98
HI_SHARED_MEMORY_ADDRESS initialization parameter, 1.97
hints
precedence over initialization parameter settings, 1.238
HS_ALL_CAPS view, 6.122
HS_ALL_DD view, 6.123
HS_ALL_INITS view, 6.124
HS_AUTOREGISTER initialization parameter, 1.98
HS_BASE_CAPS view, 6.125
HS_BASE_DD view, 6.126
HS_CLASS_CAPS view, 6.127
HS_CLASS_DD view, 6.128
HS_CLASS_INIT view, 6.129
HS_FDS_CLASS view, 6.130
HS_FDS_INST view, 6.131
HS_INST_CAPS view, 6.132
HS_INST_DD view, 6.133
HS_INST_INIT view, 6.134

I

IDEPTREE view, 6.135
IFILE initialization parameter, 1.3.2.1.1, 1.99
IND synonym for USER_INDEXES view, 6.136
INDEX_HISTOGRAM view, 6.137
INDEX_STATS view, 6.138
initialization parameter file
common file, 1.99
embedded, 1.99
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
ASM_PREFERRED_READ_FAILURE_GROUPS, 1.13
AUDIT_FILE_DEST, 1.14
AUDIT_SYS_OPERATIONS, 1.15
AUDIT_SYSLOG_LEVEL, 1.16
AUDIT_TRAIL, 1.17
BACKGROUND_CORE_DUMP, 1.18
BACKGROUND_DUMP_DEST, 1.19
BACKUP_TAPE_IO_SLAVES, 1.20
basic, 1.2
BITMAP_MERGE_AREA_SIZE, 1.21
BLANK_TRIMMING, 1.22
case significance in filenames, 1.3.2.1.1
CIRCUITS, 1.23
CLIENT_RESULT_CACHE_LAG, 1.24
CLIENT_RESULT_CACHE_SIZE, 1.25
CLUSTER_DATABASE, 1.26
CLUSTER_DATABASE_INSTANCES, 1.27
CLUSTER_INTERCONNECTS, 1.28
COMMIT_LOGGING, 1.29
COMMIT_POINT_STRENGTH, 1.30
COMMIT_WAIT, 1.31
COMMIT_WRITE, 1.32
COMPATIBLE, 1.33
CONTROL_FILE_RECORD_KEEP_TIME, 1.34
CONTROL_FILES, 1.35
CONTROL_MANAGEMENT_PACK_ACCESS, 1.36
CORE_DUMP_DEST, 1.37
CPU_COUNT, 1.38
CREATE_BITMAP_AREA_SIZE, 1.39
CREATE_STORED_OUTLINES, 1.40
CURSOR_BIND_CAPTURE_DESTINATION, 1.41
CURSOR_SHARING, 1.42
CURSOR_SPACE_FOR_TIME, 1.43
DB_BLOCK_BUFFERS, 1.45
DB_BLOCK_CHECKING, 1.46
DB_BLOCK_CHECKSUM, 1.47
DB_BLOCK_SIZE, 1.48
DB_CACHE_ADVICE, 1.49
DB_CACHE_SIZE, 1.50
DB_CREATE_FILE_DEST, 1.51
DB_CREATE_ONLINE_LOG_DEST_n, 1.52
DB_DOMAIN, 1.53
DB_FILE_MULTIBLOCK_READ_COUNT, 1.54
DB_FILE_NAME_CONVERT, 1.55
DB_FILES, 1.56
DB_FLASH_CACHE_FILE, 1.57
DB_FLASH_CACHE_SIZE, 1.58
DB_FLASHBACK_RETENTION_TARGET, 1.59
DB_KEEP_CACHE_SIZE, 1.60
DB_LOST_WRITE_PROTECT, 1.61
DB_NAME, 1.62
DB_nK_CACHE_SIZE, 1.44
DB_RECOVERY_FILE_DEST, 1.63
DB_RECOVERY_FILE_DEST_SIZE, 1.64
DB_RECYCLE_CACHE_SIZE, 1.65
DB_SECUREFILE, 1.66
DB_ULTRA_SAFE, 1.67
DB_UNIQUE_NAME, 1.68
DB_UNRECOVERABLE_SCN_TRACKING, 1.69
DB_WRITER_PROCESSES, 1.70
DBWR_IO_SLAVES, 1.71
DDL_LOCK_TIMEOUT, 1.72
DEFERRED_SEGMENT_CREATION, 1.73
derived, 1.1.1.1
DG_BROKER_CONFIG_FILEn, 1.74
DG_BROKER_START, 1.75
DIAGNOSTIC_DEST, 1.76
DISK_ASYNCH_IO, 1.77
DISPATCHERS, 1.78
display current settings, 1.4.3
DISTRIBUTED_LOCK_TIMEOUT, 1.79
DML_LOCKS, 1.80
DST_UPGRADE_INSERT_CONV, 1.81
embedded initialization parameter files, 1.3.2.1.1
ENABLE_DDL_LOGGING, 1.82
EVENT, 1.83
FAL_CLIENT, 1.84
FAL_SERVER, 1.85
FAST_START_MTTR_TARGET, 1.86
FAST_START_PARALLEL_ROLLBACK, 1.87
FILE_MAPPING, 1.88
FILEIO_NETWORK_ADAPTERS, 1.89
FILESYSTEMIO_OPTIONS, 1.90
FIXED_DATE, 1.91
functional category, 1.4.1
GCS_SERVER_PROCESSES, 1.92
GLOBAL_CONTEXT_POOL_SIZE, 1.93
GLOBAL_NAMES, 1.94
GLOBAL_TXN_PROCESSES, 1.95
HASH_AREA_SIZE, 1.96
HI_SHARED_MEMORY_ADDRESS, 1.97
HS_AUTOREGISTER, 1.98
IFILE, 1.3.2.1.1, 1.99
INSTANCE_GROUPS, 1.100
INSTANCE_NAME, 1.101
INSTANCE_NUMBER, 1.102
INSTANCE_TYPE, 1.103
JAVA_JIT_ENABLED, 1.104
JAVA_MAX_SESSIONSPACE_SIZE, 1.105
JAVA_POOL_SIZE, 1.106
JAVA_SOFT_SESSIONSPACE_LIMIT, 1.107
JOB_QUEUE_PROCESSES, 1.108
LARGE_POOL_SIZE, 1.109
LDAP_DIRECTORY_ACCESS, 1.110
LDAP_DIRECTORY_SYSAUTH, 1.111
LICENSE_MAX_SESSIONS, 1.112
LICENSE_MAX_USERS, 1.113
LICENSE_SESSIONS_WARNING, 1.114
LISTENER_NETWORKS, 1.115
LOCAL_LISTENER, 1.116
LOCK_NAME_SPACE, 1.117
LOCK_SGA, 1.118
LOG_ARCHIVE_CONFIG, 1.119
LOG_ARCHIVE_DEST, 1.120
LOG_ARCHIVE_DEST_n, 1.121
LOG_ARCHIVE_DEST_STATE_n, 1.122
LOG_ARCHIVE_DUPLEX_DEST, 1.123
LOG_ARCHIVE_FORMAT, 1.124
LOG_ARCHIVE_LOCAL_FIRST, 1.125
LOG_ARCHIVE_MAX_PROCESSES, 1.126
LOG_ARCHIVE_MIN_SUCCEED_DEST, 1.127
LOG_ARCHIVE_TRACE, 1.128
LOG_BUFFER, 1.129
LOG_CHECKPOINT_INTERVAL, 1.130
LOG_CHECKPOINT_TIMEOUT, 1.131
LOG_CHECKPOINTS_TO_ALERT, 1.132
LOG_FILE_NAME_CONVERT, 1.133
MAX_DISPATCHERS, 1.134
MAX_DUMP_FILE_SIZE, 1.135
MAX_ENABLED_ROLES, 1.136
MAX_SHARED_SERVERS, 1.137
MEMORY_MAX_TARGET, 1.138
MEMORY_TARGET, 1.139
modifiable, 1.4.2
NLS_CALENDAR, 1.140
NLS_COMP, 1.141
NLS_CURRENCY, 1.142
NLS_DATE_FORMAT, 1.143
NLS_DATE_LANGUAGE, 1.144
NLS_DUAL_CURRENCY, 1.145
NLS_ISO_CURRENCY, 1.146
NLS_LANGUAGE, 1.147
NLS_LENGTH_SEMANTICS, 1.148
NLS_NCHAR_CONV_EXCP, 1.149
NLS_NUMERIC_CHARACTERS, 1.150
NLS_SORT, 1.151
NLS_TERRITORY, 1.152
NLS_TIMESTAMP_FORMAT, 1.153
NLS_TIMESTAMP_TZ_FORMAT, 1.154
O7_DICTIONARY_ACCESSIBILITY, 1.155
OBJECT_CACHE_MAX_SIZE_PERCENT, 1.156
OBJECT_CACHE_OPTIMAL_SIZE, 1.157
OLAP_PAGE_POOL_SIZE, 1.158
OPEN_CURSORS, 1.159
OPEN_LINKS, 1.160
OPEN_LINKS_PER_INSTANCE, 1.161
operating system-dependent values, 1.1.1.2
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES, 1.162
OPTIMIZER_DYNAMIC_SAMPLING, 1.163
OPTIMIZER_FEATURES_ENABLE, 1.164
OPTIMIZER_INDEX_CACHING, 1.165
OPTIMIZER_INDEX_COST_ADJ, 1.166
OPTIMIZER_MODE, 1.167
OPTIMIZER_SECURE_VIEW_MERGING, 1.168
OPTIMIZER_USE_INVISIBLE_INDEXES, 1.169
OPTIMIZER_USE_PENDING_STATISTICS, 1.170
OPTIMIZER_USE_SQL_PLAN_BASELINES, 1.171
OS_AUTHENT_PREFIX, 1.172
OS_ROLES, 1.173
PARALLEL_ADAPTIVE_MULTI_USER, 1.174
PARALLEL_AUTOMATIC_TUNING, 1.175
PARALLEL_DEGREE_LIMIT, 1.176
PARALLEL_DEGREE_POLICY, 1.177
PARALLEL_EXECUTION_MESSAGE_SIZE, 1.178
PARALLEL_FORCE_LOCAL, 1.179
PARALLEL_INSTANCE_GROUP, 1.180
PARALLEL_IO_CAP_ENABLED, 1.181
PARALLEL_MAX_SERVERS, 1.182
PARALLEL_MIN_PERCENT, 1.183
PARALLEL_MIN_SERVERS, 1.184
PARALLEL_MIN_TIME_THRESHOLD, 1.185
PARALLEL_SERVERS_TARGET, 1.186
PARALLEL_THREADS_PER_CPU, 1.187
parameter files, 1.3
performance tuning, 1.1.1.3
PGA_AGGREGATE_TARGET, 1.188
PLSCOPE_SETTINGS, 1.189
PLSQL_CCFLAGS, 1.190
PLSQL_CODE_TYPE, 1.191
PLSQL_DEBUG, 1.192
PLSQL_OPTIMIZE_LEVEL, 1.193
PLSQL_V2_COMPATIBILITY, 1.194
PLSQL_WARNINGS, 1.195
PRE_PAGE_SGA, 1.196
PROCESSES, 1.197
QUERY_REWRITE_ENABLED, 1.198
QUERY_REWRITE_INTEGRITY, 1.199
RDBMS_SERVER_DN, 1.200
READ_ONLY_OPEN_DELAYED, 1.201
RECOVERY_PARALLELISM, 1.202
RECYCLEBIN, 1.203
REDO_TRANSPORT_USER, 1.204
REMOTE_DEPENDENCIES_MODE, 1.205
REMOTE_LISTENER, 1.206
REMOTE_LOGIN_PASSWORDFILE, 1.207
REMOTE_OS_AUTHENT, 1.208
REMOTE_OS_ROLES, 1.209
REPLICATION_DEPENDENCY_TRACKING, 1.210
RESOURCE_LIMIT, 1.211
RESOURCE_MANAGER_CPU_ALLOCATION, 1.212
RESOURCE_MANAGER_PLAN, 1.213
RESULT_CACHE_MAX_RESULT, 1.214
RESULT_CACHE_MAX_SIZE, 1.215
RESULT_CACHE_MODE, 1.216
RESULT_CACHE_REMOTE_EXPIRATION, 1.217
RESUMABLE_TIMEOUT, 1.218
ROLLBACK_SEGMENTS, 1.219
SEC_CASE_SENSITIVE_LOGON, 1.220
SEC_MAX_FAILED_LOGIN_ATTEMPTS, 1.221
SEC_PROTOCOL_ERROR_FURTHER_ACTION, 1.222
SEC_PROTOCOL_ERROR_TRACE_ACTION, 1.223
SEC_RETURN_SERVER_RELEASE_BANNER, 1.224
SERIAL_REUSE, 1.225
SERVICE_NAMES, 1.226
SESSION_CACHED_CURSORS, 1.227
SESSION_MAX_OPEN_FILES, 1.228
SESSIONS, 1.229
SGA_MAX_SIZE, 1.230
SGA_TARGET, 1.231
SHADOW_CORE_DUMP, 1.232
SHARED_MEMORY_ADDRESS, 1.233
SHARED_POOL_RESERVED_SIZE, 1.234
SHARED_POOL_SIZE, 1.235
SHARED_SERVER_SESSIONS, 1.236
SHARED_SERVERS, 1.237
SKIP_UNUSABLE_INDEXES, 1.238
SMTP_OUT_SERVER, 1.239
SORT_AREA_RETAINED_SIZE, 1.240
SORT_AREA_SIZE, 1.241
specifying in initialization parameter files, 1.3.2.1
SPFILE, 1.242
SQL_TRACE, 1.243
SQL92_SECURITY, 1.244
SQLTUNE_CATEGORY, 1.245
STANDBY_ARCHIVE_DEST, 1.246
STANDBY_FILE_MANAGEMENT, 1.247
STAR_TRANSFORMATION_ENABLED, 1.248
STATISTICS_LEVEL, 1.249
STREAMS_POOL_SIZE, 1.250
TAPE_ASYNCH_IO, 1.251
THREAD, 1.252
TIMED_OS_STATISTICS, 1.253
TIMED_STATISTICS, 1.254
TRACE_ENABLED, 1.255
TRACEFILE_IDENTIFIER, 1.256
TRANSACTIONS, 1.257
TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1.258
UNDO_MANAGEMENT, 1.259
UNDO_RETENTION, 1.260
UNDO_TABLESPACE, 1.261
USE_INDIRECT_DATA_BUFFERS, 1.262
USER_DUMP_DEST, 1.263
UTL_FILE_DIR, 1.264
variable, 1.1.1.3
WORKAREA_SIZE_POLICY, 1.265
XML_DB_EVENTS, 1.266
INITJVM.SQL script, B.5
INIT.ORA file. See initialization parameter file
IN-list iterators
optimizer use of, 1.165
inserts
locating free space, 1.102
INST_ID column, 7.1.2
INSTANCE clause
of ALTER TABLE
allocating extents, 1.102
INSTANCE_GROUPS initialization parameter, 1.100
INSTANCE_NAME initialization parameter, 1.101
INSTANCE_NUMBER initialization parameter, 1.102
INSTANCE_TYPE initialization parameter, 1.103
instances
checkpoint, 1.130
startup order, 1.102
I/O
reading multiple blocks, 1.54
redo log files, 1.129

J

Java initialization parameters
JAVA_MAX_SESSIONSPACE_SIZE, 1.105
JAVA_POOL_SIZE, 1.106
JAVA_SOFT_SESSIONSPACE_LIMIT, 1.107
Java scripts, B.5
JAVA_JIT_ENABLED initialization parameter, 1.104
JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1.105
JAVA_POOL_SIZE initialization parameter, 1.106
JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1.107
JOB_QUEUE_PROCESSES initialization parameter, 1.108

L

language
database default language, 1.147
LARGE_POOL_SIZE initialization parameter, 1.109
LDAP_DIRECTORY_ACCESS initialization parameter, 1.110
LDAP_DIRECTORY_SYSAUTH initialization parameter, 1.111
LICENSE_MAX_SESSIONS initialization parameter, 1.112
LICENSE_MAX_USERS initialization parameter, 1.113
LICENSE_SESSIONS_WARNING initialization parameter, 1.114
licenses
maximum sessions, 1.112
maximum users, 1.113
warning for concurrent user sessions, 1.114
limits on the database, A
linguistic sorts, 1.151
LISTENER_NETWORKS initialization parameter, 1.115
local currency, 1.141, 1.142
LOCAL_LISTENER initialization parameter, 1.116
LOCK_NAME_SPACE initialization parameter, 1.117
LOCK_SGA initialization parameter, 1.118
locks
names, C.2
LOG_ARCHIVE_CONFIG initialization parameter, 1.119
LOG_ARCHIVE_DEST initialization parameter, 1.120
LOG_ARCHIVE_DEST_n initialization parameter, 1.121
LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1.122
LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1.123
LOG_ARCHIVE_FORMAT initialization parameter, 1.124
LOG_ARCHIVE_LOCAL_FIRST initialization parameter, 1.125
LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1.126
LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1.127
LOG_ARCHIVE_TRACE initialization parameter, 1.128
LOG_BUFFER initialization parameter, 1.129
LOG_CHECKPOINT_INTERVAL initialization parameter, 1.130
LOG_CHECKPOINT_TIMEOUT initialization parameter, 1.131
LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1.132
LOG_FILE_NAME_CONVERT initialization parameter, 1.133
LOGSTDBY_UNSUPPORTED_TABLES synonym for DBA_LOGSTDBY_UNSUPPORTED_TABLE view, 6.139
lowercase significance, 1.3.2.1.1

M

MAP_OBJECT table, 6.140
MAX_DISPATCHERS initialization parameter, 1.134
MAX_DUMP_FILE_SIZE initialization parameter, 1.135
MAX_ENABLED_ROLES initialization parameter, 1.136
MAX_SHARED_SERVERS initialization parameter, 1.137
memory
amount used for sorting, 1.240
virtual, 1.1.1.3
MEMORY_MAX_TARGET initialization parameter, 1.138
MEMORY_TARGET initialization parameter, 1.139
monitor
performance, 1.130
multiple-process systems
number of processes, 1.197

N

NLS_CALENDAR initialization parameter, 1.140
NLS_COMP initialization parameter, 1.141
NLS_CURRENCY initialization parameter, 1.142
defined by NLS_TERRITORY, 1.152
NLS_DATABASE_PARAMETERS view, 6.141
NLS_DATE_FORMAT initialization parameter, 1.143
defined by NLS_NUMERIC_CHARACTERS, 1.150
defined by NLS_TERRITORY, 1.152
NLS_DATE_LANGUAGE initialization parameter, 1.144
NLS_DUAL_CURRENCY initialization parameter, 1.145
NLS_INSTANCE_PARAMETERS view, 6.142
NLS_ISO_CURRENCY initialization parameter, 1.146
defined by NLS_TERRITORY, 1.152
NLS_LANGUAGE initialization parameter, 1.147
NLS_LENGTH_SEMANTICS initialization parameter, 1.148
NLS_NCHAR_CONV_EXCP initialization parameter, 1.149
NLS_NUMERIC_CHARACTERS initialization parameter, 1.150
NLS_SESSION_PARAMETERS view, 6.143
NLS_SORT initialization parameter, 1.151
NLS_TERRITORY initialization parameter, 1.152
NLS_TIME_FORMAT, 8.75
NLS_TIME_TZ_FORMAT, 8.75
NLS_TIMESTAMP_FORMAT initialization parameter, 1.153
NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1.154
numeric group separators, 1.150

O

O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1.155
OBJ synonym for USER_OBJECTS view, 6.144
OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1.156
OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1.157
objects
data dictionary, 2.1
OLAP_PAGE_POOL_SIZE initialization parameter, 1.158
online redo log
archiving mode, 1.120
block, 1.130
file size, 1.130
setting checkpoint interval, 1.130
OPEN_CURSORS initialization parameter, 1.159
OPEN_LINKS initialization parameter, 1.160
OPEN_LINKS_PER_INSTANCE initialization parameter, 1.161
operating system
authenticating remote clients, 1.208
authenticating users and passwords, 1.172
dependent parameters, 1.1.1.2
roles for remote clients, 1.209
optimization
trading cursor space for time, 1.43
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES initialization parameter, 1.162
OPTIMIZER_DYNAMIC_SAMPLING initialization parameter, 1.163
OPTIMIZER_FEATURES_ENABLE initialization parameter, 1.164
OPTIMIZER_INDEX_CACHING initialization parameter, 1.165
OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1.166
OPTIMIZER_MODE initialization parameter, 1.167
OPTIMIZER_SECURE_VIEW_MERGING initialization parameter, 1.168
OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter, 1.169
OPTIMIZER_USE_PENDING_STATISTICS initialization parameter, 1.170
OPTIMIZER_USE_SQL_PLAN_BASELINES initialization parameter, 1.171
ORPHAN_KEY_TABLE table. See DBA_ORPHAN_KEY_TABLE view
OS_AUTHENT_PREFIX initialization parameter, 1.172
OS_ROLES initialization parameter, 1.173

P

parallel query
maximum number of instances, 1.178
maximum number of servers, 1.182
minimum number of queries, 1.184
PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1.174
PARALLEL_AUTOMATIC_TUNING initialization parameter, 1.175
PARALLEL_DEGREE_LIMIT initialization parameter, 1.176
PARALLEL_DEGREE_POLICY initialization parameter, 1.177
PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1.178
PARALLEL_FORCE_LOCAL initialization parameter, 1.179
PARALLEL_INSTANCE_GROUP initialization parameter, 1.180
PARALLEL_IO_CAP_ENABLED initialization parameter, 1.181
PARALLEL_MAX_SERVERS initialization parameter, 1.182
PARALLEL_MIN_PERCENT initialization parameter, 1.183
PARALLEL_MIN_SERVERS initialization parameter, 1.184
PARALLEL_MIN_TIME_THRESHOLD initialization parameter, 1.185
PARALLEL_SERVERS_TARGET initialization parameter, 1.186
PARALLEL_THREADS_PER_CPU initialization parameter, 1.187
passwords
authenticating, 1.172, 1.208
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.207
PATH_VIEW view, 6.145
performance, 1.1.1.3
shared pool, 1.235
PGA_AGGREGATE_TARGET initialization parameter, 1.188
PLAN_TABLE table, 6.146
PLSCOPE_SETTINGS initialization parameter, 1.189
PLSQL_CCFLAGS initialization parameter, 1.190
PLSQL_CODE_TYPE initialization parameter, 1.191
PLSQL_DEBUG initialization parameter, 1.192
PLSQL_OPTIMIZE_LEVEL initialization parameter, 1.193
PLSQL_V2_COMPATIBILITY initialization parameter, 1.194
PLSQL_WARNINGS initialization parameter, 1.195
PLUGGABLE_SET_CHECK view, 6.147
PRE_PAGE_SGA initialization parameter, 1.196
privileges
remote login, 1.207
RESTRICTED_SESSION privilege, 1.112, 1.114
table-level select privileges, 1.244
procedures
shared pool, 1.235
processes
dispatcher process maximum number, 1.134
maximum shared server processes, 1.137
number of server processes, 1.105, 1.107, 1.236, 1.237
recovery, 1.202
trace files, 1.263
user processes, 1.197
PROCESSES initialization parameter, 1.197
PRODUCT_COMPONENT_VERSION view, 6.148
profiles
resource limits, 1.211, 1.213
PROXY_USERS view, 6.149
PSTUBTBL table, 6.150
PUBLIC clause
of ALTER DATABASE
thread of redo, 1.252
PUBLIC_DEPENDENCY view, 6.151
PUBLICSYN view, 6.152

Q

queries
hints, 1.167
QUERY_REWRITE_ENABLED initialization parameter, 1.198
QUERY_REWRITE_INTEGRITY initialization parameter, 1.199
QUEUE_PRIVILEGES view, 6.153

R

RC_ARCHIVED_LOG view, 2.1.3
RC_BACKUP_ARCHIVELOG_DETAILS view, 2.1.3
RC_BACKUP_ARCHIVELOG_SUMMARY view, 2.1.3
RC_BACKUP_CONTROLFILE view, 2.1.3
RC_BACKUP_CONTROLFILE_DETAILS view, 2.1.3
RC_BACKUP_CONTROLFILE_SUMMARY view, 2.1.3
RC_BACKUP_COPY_DETAILS view, 2.1.3
RC_BACKUP_COPY_SUMMARY view, 2.1.3
RC_BACKUP_CORRUPTION view, 2.1.3
RC_BACKUP_DATAFILE view, 2.1.3
RC_BACKUP_DATAFILE_DETAILS view, 2.1.3
RC_BACKUP_DATAFILE_SUMMARY view, 2.1.3
RC_BACKUP_FILES view, 2.1.3
RC_BACKUP_PIECE view, 2.1.3
RC_BACKUP_PIECE_DETAILS view, 2.1.3
RC_BACKUP_REDOLOG view, 2.1.3
RC_BACKUP_SET view, 2.1.3
RC_BACKUP_SET_DETAILS view, 2.1.3
RC_BACKUP_SET_SUMMARY view, 2.1.3
RC_BACKUP_SPFILE view, 2.1.3
RC_BACKUP_SPFILE_DETAILS view, 2.1.3
RC_BACKUP_SPFILE_SUMMARY 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_ARCHIVEDLOG view, 2.1.3
RC_PROXY_ARCHIVELOG_DETAILS view, 2.1.3
RC_PROXY_ARCHIVELOG_SUMMARY view, 2.1.3
RC_PROXY_CONTROLFILE view, 2.1.3
RC_PROXY_COPY_DETAILS view, 2.1.3
RC_PROXY_COPY_SUMMARY 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_RESTORE_POINT view, 2.1.3
RC_RESYNC view, 2.1.3
RC_RMAN_BACKUP_JOB_DETAILS view, 2.1.3
RC_RMAN_BACKUP_SUBJOB_DETAILS view, 2.1.3
RC_RMAN_BACKUP_TYPE view, 2.1.3
RC_RMAN_CONFIGURATION view, 2.1.3
RC_RMAN_OUTPUT view, 2.1.3
RC_RMAN_STATUS view, 2.1.3
RC_SITE 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
RC_TEMPFILE view, 2.1.3
RC_UNUSABLE_BACKUPFILE_DETAILS view, 2.1.3
RDBMS_SERVER_DN initialization parameter, 1.200
READ_ONLY_OPEN_DELAYED initialization parameter, 1.201
Real Application Clusters
dynamic performance views, 7.1.2
initialization parameters
CIRCUITS, 1.23
CLUSTER_DATABASE, 1.26
CLUSTER_DATABASE_INSTANCES, 1.27
CLUSTER_INTERCONNECTS, 1.28
DISPATCHERS, 1.78
FAST_START_PARALLEL_ROLLBACK, 1.87
PARALLEL_ADAPTIVE_MULTI_USER, 1.174
PARALLEL_AUTOMATIC_TUNING, 1.175
PARALLEL_EXECUTION_MESSAGE_SIZE, 1.178
PARALLEL_INSTANCE_GROUP, 1.180
PARALLEL_MAX_SERVERS, 1.182
PARALLEL_MIN_PERCENT, 1.183
PARALLEL_MIN_SERVERS, 1.184
PARALLEL_THREADS_PER_CPU, 1.187
recovery
number of required processes, 1.202
RECOVERY_PARALLELISM initialization parameter, 1.202
RECYCLEBIN initialization parameter, 1.203
RECYCLEBIN synonym for USER_RECYCLEBIN view, 6.154
redo logs
buffer size, 1.129
redo thread, 1.252
REDO_TRANSPORT_USER initialization parameter, 1.204
remote clients
authenticating, 1.208
remote logins, 1.207
REMOTE_DEPENDENCIES_MODE initialization parameter, 1.205
REMOTE_LISTENER initialization parameter, 1.206
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.207
REMOTE_OS_AUTHENT initialization parameter, 1.208
REMOTE_OS_ROLES initialization parameter, 1.209
REPAIR_TABLE table. See DBA_REPAIR_TABLE view
REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1.210
REPORT_COMPONENTS view, 6.155
REPORT_FILES view, 6.156
REPORT_FORMATS view, 6.157
resource limits for profiles, 1.211, 1.213
RESOURCE_COST view, 6.158
RESOURCE_LIMIT initialization parameter, 1.211
RESOURCE_MANAGER_CPU_ALLOCATION initialization parameter, 1.212
RESOURCE_MANAGER_PLAN initialization parameter, 1.213
RESOURCE_MAP table, 6.159
RESOURCE_VIEW view, 6.160
RESULT_CACHE_MAX_RESULT initialization parameter, 1.214
RESULT_CACHE_MAX_SIZE initialization parameter, 1.215
RESULT_CACHE_MODE initialization parameter, 1.216
RESULT_CACHE_REMOTE_EXPIRATION initialization parameter, 1.217
RESUMABLE_TIMEOUT initialization parameter, 1.218
RMJVM.SQL script, B.5
ROLE_ROLE_PRIVS view, 6.161
ROLE_SYS_PRIVS view, 6.162
ROLE_TAB_PRIVS view, 6.163
ROLE_WM_PRIVS view, 2.1.2
roles, 1.173
remote clients, 1.209
ROLLBACK_SEGMENTS initialization parameter, 1.219

S

SCHEDULER_BATCH_ERRORS view, 6.164
scripts
CATALOG.SQL, B.1
CATBLOCK.SQL, B.2
CATCLUST.SQL, B.1
CATDWGRD.SQL, B.4
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
CATNOSVM.SQL, B.3
CATNSNMP.SQL, B.3
CATOCTK.SQL, B.2
CATPROC.SQL, B.1
CATQUEUE.SQL, B.2
CATREP.SQL, B.2
CATUPGRD.SQL, B.4
data dictionary, B.2
DBMSIOTC.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
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
UTLU111I.SQL, B.4
UTLU111S.SQL, B.4
UTLVALID.SQL, B.2
UTLXPLAN.SQL, B.2
SEC_CASE_SENSITIVE_LOGON initialization parameter, 1.220
SEC_MAX_FAILED_LOGIN_ATTEMPTS initialization parameter, 1.221
SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter, 1.222
SEC_PROTOCOL_ERROR_TRACE_ACTION initialization parameter, 1.223
SEC_RETURN_SERVER_RELEASE_BANNER initialization parameter, 1.224
SEQ synonym for USER_SEQUENCES view, 6.165
SERIAL_REUSE initialization parameter, 1.225
server parameter file
overview, 1.3
server processes
number, 1.105, 1.107, 1.236, 1.237
SERVICE_NAMES initialization parameter, 1.226
SESSION_CACHED_CURSORS initialization parameter, 1.227
SESSION_CONTEXT view, 6.166
SESSION_MAX_OPEN_FILES initialization parameter, 1.228
SESSION_PRIVS view, 6.167
SESSION_ROLES view, 6.168
SESSIONS initialization parameter, 1.229
SGA_MAX_SIZE initialization parameter, 1.230
SGA_TARGET initialization parameter, 1.231
SHADOW_CORE_DUMP initialization parameter, 1.232
shared server
SESSIONS initialization parameter, 1.229
shared server processes
maximum number, 1.137
SHARED_MEMORY_ADDRESS initialization parameter, 1.233
SHARED_POOL_RESERVED_SIZE initialization parameter, 1.234
SHARED_POOL_SIZE initialization parameter, 1.235
SHARED_SERVER_SESSIONS initialization parameter, 1.236
SHARED_SERVERS initialization parameter, 1.237
SHOW PARAMETERS command, 1.4.3
SKIP_UNUSABLE_INDEXES initialization parameter, 1.238
SMTP_OUT_SERVER initialization parameter, 1.239
SORT_AREA_RETAINED_SIZE initialization parameter, 1.240
SORT_AREA_SIZE initialization parameter, 1.241
sorting
maximum memory, 1.240
ORDER BY queries, 1.151
SOURCE_SIZE view, 6.169
SPFILE initialization parameter, 1.242
SQL scripts
creating the data dictionary, B.1
optional, B.2
required, B.1
SQL_TRACE initialization parameter, 1.243
SQL92_SECURITY initialization parameter, 1.244
SQLTUNE_CATEGORY initialization parameter, 1.245
STANDBY_ARCHIVE_DEST initialization parameter, 1.246
STANDBY_FILE_MANAGEMENT initialization parameter, 1.247
STAR_TRANSFORMATION_ENABLED initialization parameter, 1.248
starting up
instance number, 1.102
startup order, 1.102
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
consistent gets direct, E.2
consistent gets from cache, 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 authentications, E.2
data blocks consistent reads - undo records applied, E.2
db block changes, E.2
db block gets, E.2
db block gets direct, E.2
db block gets from cache, E.2
DBWR buffers scanned, E.2
DBWR checkpoint buffers written, E.2
DBWR checkpoints, 1.130, 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
flashback log write bytes, E.2
flashback log writes, E.2
free buffer inspected, E.2
free buffer requested, E.2
global cache blocks corrupt, E.2
global cache convert time, E.2
global cache convert timeouts, E.2
global cache converts, E.2
global cache cr block log flush time, E.2, E.2
global cache cr block receive time, E.2
global cache cr block send time, E.2
global cache cr block serve time, E.2, E.2
global cache cr blocks served, E.2
global cache cr requests blocked, 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 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
lob reads, E.2
lob writes, E.2
lob writes unaligned, 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 (describe), E.2
parse count (hard), E.2
parse count (total), E.2
parse time cpu, E.2
parse time elapsed, E.2
physical read bytes, E.2
physical read IO requests, E.2
physical read total bytes, E.2
physical read total IO requests, E.2
physical read total multi block requests, E.2
physical reads, E.2
physical reads cache, E.2
physical reads direct, E.2
physical reads for flashback new, E.2
physical reads prefetch warmup, E.2
physical write bytes, E.2
physical write IO requests, E.2
physical write total bytes, E.2
physical write total IO requests, E.2
physical write total multi block requests, E.2
physical writes, E.2
physical writes direct, E.2
physical writes from cache, 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
recovery blocks read for lost write detection, E.2
recovery blocks skipped lost write checks, E.2
recursive calls, E.2
recursive cpu usage, E.2
redo blocks checksummed by FG (exclusive), E.2
redo blocks checksummed by LGWR, E.2
redo blocks written, E.2
redo buffer allocation retries, E.2
redo entries, E.2
redo entries for lost write detection, E.2
redo log space requests, E.2
redo log space wait time, E.2
redo ordering marks, E.2
redo size, E.2
redo size for lost write detection, E.2
redo synch time, E.2
redo synch writes, E.2
redo wastage, E.2
redo write time, E.2
redo writer latching time, E.2, 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
shared io pool buffer get failure, E.2
shared io pool buffer get success, 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.254
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.249
STMT_AUDIT_OPTION_MAP table, 6.170
STREAMS_POOL_SIZE initialization parameter, 1.250
switch redo log file, 1.130
SYN synonym for USER_SYNONYMS view, 6.171
SYNONYMS view, 6.172
SYS_OBJECTS view, 6.173
SYSCATALOG view, 6.174
SYSFILES view, 6.175
SYSSEGOBJ view, 6.176
system global area, 1.1.1.3
buffer areas, 1.129
system performance, 1.1.1.3
SYSTEM_PRIVILEGE_MAP table, 6.177

T

TAB view, 6.178
TABLE_PRIVILEGE_MAP table, 6.179
tables
data dictionary, 2.1
DML locks, 1.80
locating free space, 1.102
TABQUOTAS view, 6.180
TABS synonym for USER_TABLES view, 6.181
tape archiving destination, 1.120
TAPE_ASYNCH_IO initialization parameter, 1.251
territory, 1.145, 1.152
THREAD initialization parameter, 1.252
TIMED_OS_STATISTICS initialization parameter, 1.253
TIMED_STATISTICS initialization parameter, 1.254
file read/write statistics, 7.139, 9.108
TO_CHAR function, 1.143
TO_DATE function, 1.143
trace files
destination, 1.263
maximum size, 1.135
TRACE_ENABLED initialization parameter, 1.255
TRACEFILE_IDENTIFIER initialization parameter, 1.256
transactions
data locking, 1.80
TRANSACTIONS initialization parameter, 1.257
DML locks, 1.80
TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1.258
TRUSTED_SERVERS view, 6.182
TS_PITR_CHECK view, 6.183
TS_PITR_OBJECTS TO_BE_DROPPED view, 6.184

U

UNDO_MANAGEMENT initialization parameter, 1.259
UNDO_RETENTION initialization parameter, 1.260
UNDO_TABLESPACE initialization parameter, 1.261
UNI_PLUGGABLE_SET_CHECK view, 6.185
updates
locating free space, 1.102
upgrading
scripts, B.4
uppercase characters, 1.3.2.1.1
USE_INDIRECT_DATA_BUFFERS initialization parameter, 1.262
user processes
trace files, 1.263
USER_ADDM_FDG_BREAKDOWN view, 6.186
USER_ADDM_FINDINGS view, 6.187
USER_ADDM_INSTANCES view, 6.188
USER_ADDM_TASKS view, 6.189
USER_ADVISOR_ACTIONS view, 6.190
USER_ADVISOR_DIR_TASK_INST view, 6.191
USER_ADVISOR_EXEC_PARAMETERS view, 6.192
USER_ADVISOR_EXECUTIONS view, 6.193
USER_ADVISOR_FDG_BREAKDOWN view, 6.194
USER_ADVISOR_FINDINGS view, 6.195
USER_ADVISOR_JOURNAL view, 6.196
USER_ADVISOR_LOG view, 6.197
USER_ADVISOR_OBJECTS view, 6.198
USER_ADVISOR_PARAMETERS view, 6.199
USER_ADVISOR_RATIONALE view, 6.200
USER_ADVISOR_RECOMMENDATIONS view, 6.201
USER_ADVISOR_SQLA_REC_SUM view, 6.202
USER_ADVISOR_SQLA_TABLES view, 6.203
USER_ADVISOR_SQLA_WK_MAP view, 6.204
USER_ADVISOR_SQLA_WK_STMTS view, 6.205
USER_ADVISOR_SQLPLANS view, 6.206
USER_ADVISOR_SQLSTATS view, 6.207
USER_ADVISOR_SQLW_JOURNAL view, 6.208
USER_ADVISOR_SQLW_PARAMETERS view, 6.209
USER_ADVISOR_SQLW_STMTS view, 6.210
USER_ADVISOR_SQLW_SUM view, 6.211
USER_ADVISOR_SQLW_TABLES view, 6.212
USER_ADVISOR_SQLW_TEMPLATES view, 6.213
USER_ADVISOR_TASKS view, 6.214
USER_ADVISOR_TEMPLATES view, 6.215
USER_ALL_TABLES view, 6.216
USER_AQ_AGENT_PRIVS view, 6.217
USER_ARGUMENTS view, 6.218
USER_ASSEMBLIES view, 6.219
USER_ASSOCIATIONS view, 6.220
USER_ATTRIBUTE_TRANSFORMATIONS view, 6.221
USER_AUDIT_OBJECT view, 6.222
USER_AUDIT_POLICIES view, 6.223
USER_AUDIT_POLICY_COLUMNS view, 6.224
USER_AUDIT_SESSION view, 6.225
USER_AUDIT_STATEMENT view, 6.226
USER_AUDIT_TRAIL view, 6.227
USER_AW_PS view, 6.228
USER_AWS view, 6.229
USER_BASE_TABLE_MVIEWS view, 6.230
USER_CATALOG view, 6.231
CAT synonym, 3.147
USER_CHANGE_NOTIFICATION_REGS view, 6.232
USER_CLU_COLUMNS view, 6.233
USER_CLUSTER_HASH_EXPRESSIONS view, 6.234
USER_CLUSTERS view, 6.235
CLU synonym, 3.156
USER_COL_COMMENTS view, 6.236
USER_COL_PENDING_STATS view, 6.237
USER_COL_PRIVS view, 6.238
USER_COL_PRIVS_MADE view, 6.239
USER_COL_PRIVS_RECD view, 6.240
USER_COLL_TYPES view, 6.241
USER_COMPARISON view, 6.242
USER_COMPARISON_COLUMNS view, 6.243
USER_COMPARISON_ROW_DIF view, 6.244
USER_COMPARISON_SCAN view, 6.245
USER_COMPARISON_SCAN_VALUES view, 6.246
USER_CONS_COLUMNS view, 6.247
USER_CONS_OBJ_COLUMNS view, 6.248
USER_CONSTRAINTS view, 6.249
USER_CQ_NOTIFICATION_QUERIES view, 6.250
USER_CUBE_ATTR_VISIBILITY view, 6.251
USER_CUBE_ATTRIBUTES view, 6.252
USER_CUBE_BUILD_PROCESSES view, 6.253
USER_CUBE_CALCULATED_MEMBERS view, 6.254
USER_CUBE_DIM_LEVELS view, 6.255
USER_CUBE_DIM_MODELS view, 6.256
USER_CUBE_DIM_VIEW_COLUMNS view, 6.257
USER_CUBE_DIM_VIEWS view, 6.258
USER_CUBE_DIMENSIONALITY view, 6.259
USER_CUBE_DIMENSIONS view, 6.260
USER_CUBE_HIER_LEVELS view, 6.261
USER_CUBE_HIER_VIEW_COLUMNS view, 6.262
USER_CUBE_HIER_VIEWS view, 6.263
USER_CUBE_HIERARCHIES view, 6.264
USER_CUBE_MEASURES view, 6.265
USER_CUBE_VIEW_COLUMNS view, 6.266
USER_CUBE_VIEWS view, 6.267
USER_CUBES view, 6.268
USER_DATAPUMP_JOBS view, 6.269
USER_DB_LINKS view, 6.270
USER_DBFS_HS_FILES view, 6.271
USER_DEPENDENCIES view, 6.272
USER_DIM_ATTRIBUTES view, 6.273
USER_DIM_CHILD_OF view, 6.274
USER_DIM_HIERARCHIES view, 6.275
USER_DIM_JOIN_KEY view, 6.276
USER_DIM_LEVEL_KEY view, 6.277
USER_DIM_LEVELS view, 6.278
USER_DIMENSIONS view, 6.279
USER_DUMP_DEST initialization parameter, 1.263
USER_EDITIONING_VIEW_COLS view, 6.280
USER_EDITIONING_VIEW_COLS_AE view, 6.281
USER_EDITIONING_VIEWS view, 6.282
USER_EDITIONING_VIEWS_AE view, 6.283
USER_ENCRYPTED_COLUMNS view, 6.284
USER_EPG_DAD_AUTHORIZATION view, 6.285
USER_ERRORS view, 6.286
USER_ERRORS_AE view, 6.287
USER_EVALUATION_CONTEXT_TABLES view, 6.288
USER_EVALUATION_CONTEXT_VARS view, 6.289
USER_EVALUATION_CONTEXTS view, 6.290
USER_EXTENTS view, 6.291
USER_EXTERNAL_LOCATIONS view, 6.292
USER_EXTERNAL_TABLES view, 6.293
USER_FILE_GROUP_EXPORT_INFO view, 6.294
USER_FILE_GROUP_FILES view, 6.295
USER_FILE_GROUP_TABLES view, 6.296
USER_FILE_GROUP_TABLESPACES view, 6.297
USER_FILE_GROUP_VERSIONS view, 6.298
USER_FILE_GROUPS view, 6.299
USER_FLASHBACK_ARCHIVE view, 6.300
USER_FLASHBACK_ARCHIVE_TABLES view, 6.301
USER_FLASHBACK_TXN_REPORT view, 6.302
USER_FLASHBACK_TXN_STATE view, 6.303
USER_FREE_SPACE view, 6.304
USER_HISTOGRAMS synonym for USER_TAB_HISTOGRAMS, 6.305
USER_IDENTIFIERS view, 6.306
USER_IND_COLUMNS view, 6.307
USER_IND_EXPRESSIONS view, 6.308
USER_IND_PARTITIONS view, 6.309
USER_IND_PENDING_STATS view, 6.310
USER_IND_STATISTICS view, 6.311
USER_IND_SUBPARTITIONS view, 6.312
USER_INDEXES view, 6.313
IND synonym, 6.136
USER_INDEXTYPE_ARRAYTYPES view, 6.314
USER_INDEXTYPE_COMMENTS view, 6.315
USER_INDEXTYPE_OPERATORS view, 6.316
USER_INDEXTYPES view, 6.317
USER_INTERNAL_TRIGGERS view, 6.318
USER_JAVA_ARGUMENTS view, 6.319
USER_JAVA_CLASSES view, 6.320
USER_JAVA_COMPILER_OPTIONS view, 6.321
USER_JAVA_DERIVATIONS view, 6.322
USER_JAVA_FIELDS view, 6.323
USER_JAVA_IMPLEMENTS view, 6.324
USER_JAVA_INNERS view, 6.325
USER_JAVA_LAYOUTS view, 6.326
USER_JAVA_METHODS view, 6.327
USER_JAVA_NCOMPS view, 6.328
USER_JAVA_POLICY view, 6.329
USER_JAVA_RESOLVERS view, 6.330
USER_JAVA_THROWS view, 6.331
USER_JOBS view, 6.332
ALL_JOBS synonym, 2.124
USER_JOIN_IND_COLUMNS view, 6.333
USER_LIBRARIES view, 6.334
USER_LOB_PARTITIONS view, 6.335
USER_LOB_SUBPARTITIONS view, 6.336
USER_LOB_TEMPLATES view, 6.337
USER_LOBS view, 6.338
USER_LOG_GROUP_COLUMNS view, 6.339
USER_LOG_GROUPS view, 6.340
USER_MEASURE_FOLDER_CONTENTS view, 6.341
USER_MEASURE_FOLDERS view, 6.342
USER_METHOD_PARAMS view, 6.343
USER_METHOD_RESULTS view, 6.344
USER_MINING_MODEL_ATTRIBUTES view, 6.345
USER_MINING_MODEL_SETTINGS view, 6.346
USER_MINING_MODELS view, 6.347
USER_MP_GRAPH_WORKSPACES view, 2.1.2
USER_MP_PARENT_WORKSPACES view, 2.1.2
USER_MVIEW_AGGREGATES view, 6.348
USER_MVIEW_ANALYSIS view, 6.349
USER_MVIEW_COMMENTS view, 6.350
USER_MVIEW_DETAIL_PARTITION view, 6.351
USER_MVIEW_DETAIL_RELATIONS view, 6.352
USER_MVIEW_DETAIL_SUBPARTITION view, 6.353
USER_MVIEW_JOINS view, 6.354
USER_MVIEW_KEYS view, 6.355
USER_MVIEW_LOGS view, 6.356
USER_MVIEW_REFRESH_TIMES view, 6.357
USER_MVIEWS view, 6.358
USER_NESTED_TABLE_COLS view, 6.359
USER_NESTED_TABLES view, 6.360
USER_NETWORK_ACL_PRIVILEGES view, 6.361
USER_OBJ_AUDIT_OPTS view, 6.362
USER_OBJ_COLATTRS view, 6.363
USER_OBJECT_SIZE view, 6.364
USER_OBJECT_TABLES view, 6.365
USER_OBJECTS view, 6.366
OBJ synonym, 6.144
USER_OBJECTS_AE view, 6.367
USER_OPANCILLARY view, 6.368
USER_OPARGUMENTS view, 6.369
USER_OPBINDINGS view, 6.370
USER_OPERATOR_COMMENTS view, 6.371
USER_OPERATORS view, 6.372
USER_OUTLINE_HINTS view, 6.373
ALL_OUTLINE_HINTS synonym, 2.162
USER_OUTLINES view, 6.374
ALL_OUTLINES synonym, 2.163
USER_PARALLEL_EXECUTE_CHUNKS view, 6.375
USER_PARALLEL_EXECUTE_TASKS view, 6.376
USER_PART_COL_STATISTICS view, 6.377
USER_PART_HISTOGRAMS view, 6.378
USER_PART_INDEXES view, 6.379
USER_PART_KEY_COLUMNS view, 6.380
USER_PART_LOBS view, 6.381
USER_PART_TABLES view, 6.382
USER_PARTIAL_DROP_TABS view, 6.383
USER_PASSWORD_LIMITS view, 6.384
USER_PENDING_CONV_TABLES view, 6.385
USER_PLSQL_OBJECT_SETTINGS view, 6.386
USER_POLICIES view, 6.387
USER_POLICY_CONTEXTS view, 6.388
USER_POLICY_GROUPS view, 6.389
USER_PROCEDURES view, 6.390
USER_PROXIES view, 6.391
USER_PUBLISHED_COLUMNS view, 6.392
ALL_PUBLISHED_COLUMNS synonym, 3.15
USER_QUEUE_SCHEDULES view, 6.393
USER_QUEUE_SUBSCRIBERS view, 6.394
USER_QUEUE_TABLES view, 6.395
USER_QUEUES view, 6.396
USER_RECYCLEBIN view, 6.397
RECYCLEBIN synonym, 6.154
USER_REFRESH view, 6.398
USER_REFRESH_CHILDREN view, 6.399
USER_REFS view, 6.400
USER_REGISTERED_MVIEWS view, 6.401
USER_REGISTRY view, 6.402
USER_REMOVED_WORKSPACES view, 2.1.2
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, 6.403
USER_RESUMABLE view, 6.404
USER_REWRITE_EQUIVALENCES view, 6.405
USER_ROLE_PRIVS view, 6.406
USER_RSRC_CONSUMER_GROUP_PRIVS view, 6.407
USER_RSRC_MANAGER_SYSTEM_PRIVS view, 6.408
USER_RULE_SET_RULES view, 6.409
USER_RULE_SETS view, 6.410
USER_RULES view, 6.411
USER_SCHEDULER_CHAIN_RULES view, 6.412
USER_SCHEDULER_CHAIN_STEPS view, 6.413
USER_SCHEDULER_CHAINS view, 6.414
USER_SCHEDULER_CREDENTIALS view, 6.415
USER_SCHEDULER_DB_DESTS view, 6.416
USER_SCHEDULER_DESTS view, 6.417
USER_SCHEDULER_FILE_WATCHERS view, 6.418
USER_SCHEDULER_GROUP_MEMBERS view, 6.419
USER_SCHEDULER_GROUPS view, 6.420
USER_SCHEDULER_JOB_ARGS view, 6.421
USER_SCHEDULER_JOB_DESTS view, 6.422
USER_SCHEDULER_JOB_LOG view, 6.423
USER_SCHEDULER_JOB_RUN_DETAILS view, 6.424
USER_SCHEDULER_JOBS view, 6.425
USER_SCHEDULER_NOTIFICATIONS view, 6.426
USER_SCHEDULER_PROGRAM_ARGS view, 6.427
USER_SCHEDULER_PROGRAMS view, 6.428
USER_SCHEDULER_REMOTE_JOBSTATE view, 6.429
USER_SCHEDULER_RUNNING_CHAINS view, 6.430
USER_SCHEDULER_RUNNING_JOBS view, 6.431
USER_SCHEDULER_SCHEDULES view, 6.432
USER_SEC_RELEVANT_COLS view, 6.433
USER_SECONDARY_OBJECTS view, 6.434
USER_SEGMENTS view, 6.435
USER_SEQUENCES view, 6.436
SEQ synonym, 6.165
USER_SOURCE view, 6.437
USER_SOURCE_AE view, 6.438
USER_SOURCE_TABLES view, 6.439
ALL_SOURCE_TABLES synonym, 3.66
USER_SQLJ_TYPE_ATTRS view, 6.440
USER_SQLJ_TYPE_METHODS view, 6.441
USER_SQLJ_TYPES view, 6.442
USER_SQLSET view, 6.443
USER_SQLSET_BINDS view, 6.444
USER_SQLSET_PLANS view, 6.445
USER_SQLSET_REFERENCES view, 6.446
USER_SQLSET_STATEMENTS view, 6.447
USER_SQLTUNE_BINDS view, 6.448
USER_SQLTUNE_PLANS view, 6.449
USER_SQLTUNE_RATIONALE_PLAN view, 6.450
USER_SQLTUNE_STATISTICS view, 6.451
USER_STAT_EXTENSIONS view, 6.452
USER_STORED_SETTINGS view, 6.453
USER_SUBPART_COL_STATISTICS view, 6.454
USER_SUBPART_HISTOGRAMS view, 6.455
USER_SUBPART_KEY_COLUMNS view, 6.456
USER_SUBPARTITION_TEMPLATES view, 6.457
USER_SUBSCR_REGISTRATIONS view, 6.458
USER_SUBSCRIBED_COLUMNS view, 6.459
ALL_SUBSCRIBED_COLUMNS synonym, 3.93
USER_SUBSCRIBED_TABLES view, 6.460
ALL_SUBSCRIBED_TABLES synonym, 3.94
USER_SUBSCRIPTIONS view, 6.461
ALL_SUBSCRIPTIONS synonym, 3.95
USER_SYNONYMS view, 6.462
SYN synonym, 6.171
USER_SYS_PRIVS view, 6.463
USER_TAB_COL_STATISTICS view, 6.464
USER_TAB_COLS view, 6.465
USER_TAB_COLUMNS view, 6.466
COLS synonym, 3.158
USER_TAB_COMMENTS view, 6.467
USER_TAB_HISTGRM_PENDING_STATS view, 6.468
USER_TAB_HISTOGRAMS view, 6.469
USER_HISTOGRAMS synonym, 6.305
USER_TAB_MODIFICATIONS view, 6.470
USER_TAB_PARTITIONS view, 6.471
USER_TAB_PENDING_STATS view, 6.472
USER_TAB_PRIVS view, 6.473
USER_TAB_PRIVS_MADE view, 6.474
USER_TAB_PRIVS_RECD view, 6.475
USER_TAB_STAT_PREFS view, 6.476
USER_TAB_STATISTICS view, 6.477
USER_TAB_STATS_HISTORY view, 6.478
USER_TAB_SUBPARTITIONS view, 6.479
USER_TABLES view, 6.480
TABS synonym, 6.181
USER_TABLESPACES view, 6.481
USER_TRANSFORMATIONS view, 6.482
USER_TRIGGER_COLS view, 6.483
USER_TRIGGER_ORDERING view, 6.484
USER_TRIGGERS view, 6.485
USER_TS_QUOTAS view, 6.486
USER_TSTZ_TAB_COLS view, 6.487
USER_TSTZ_TABLES view, 6.488
USER_TUNE_MVIEW view, 6.489
USER_TYPE_ATTRS view, 6.490
USER_TYPE_METHODS view, 6.491
USER_TYPE_VERSIONS view, 6.492
USER_TYPES view, 6.493
USER_UNUSED_COL_TABS view, 6.494
USER_UPDATABLE_COLUMNS view, 6.495
USER_USERS view, 6.496
USER_USTATS view, 6.497
USER_VARRAYS view, 6.498
USER_VIEWS view, 6.499
USER_VIEWS_AE view, 6.500
USER_WARNING_SETTINGS view, 6.501
USER_WM_CONS_COLUMNS view, 2.1.2
USER_WM_CONSTRAINTS view, 2.1.2
USER_WM_IND_COLUMNS view, 2.1.2
USER_WM_IND_EXPRESSIONS view, 2.1.2
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_INDEXES view, 6.502
USER_XML_SCHEMAS view, 6.503
USER_XML_TAB_COLS view, 6.504
USER_XML_TABLES view, 6.505
USER_XML_VIEW_COLS view, 6.506
USER_XML_VIEWS view, 6.507
USERLOCK.SQL script, B.2
users
authenticating, 1.172
multiple, 1.80
UTL_FILE_DIR initialization parameter, 1.264
UTLBSTAT.SQL script, B.2
UTLCHN1.SQL script, B.2
UTLCONST.SQL script, B.2
UTLDTREE.SQL script, 6.112, 6.135, 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
UTLU111I.SQL script, B.4
UTLU111S.SQL script, B.4
UTLVALID.SQL script, B.2
UTLXPLAN.SQL script, B.2

V

V$ACCESS view, 7.3
V$ACTIVE_INSTANCES view, 7.4
V$ACTIVE_SERVICES view, 7.5
V$ACTIVE_SESS_POOL_MTH view, 7.6
V$ACTIVE_SESSION_HISTORY view, 7.7
V$ADVISOR_PROGRESS view, 7.8
V$ALERT_TYPES view, 7.9
V$AQ view, 7.10
V$ARCHIVE view, 7.11
V$ARCHIVE_DEST view, 7.12
V$ARCHIVE_DEST_STATUS view, 7.13
V$ARCHIVE_GAP view, 7.14
V$ARCHIVE_PROCESSES view, 7.15
V$ARCHIVED_LOG view, 7.16
V$ASM_ACFS_ENCRYPTION_INFO view, 7.17
V$ASM_ACFS_SECURITY_INFO view, 7.18
V$ASM_ACFSSNAPSHOTS view, 7.19
V$ASM_ACFSVOLUMES view, 7.20
V$ASM_ALIAS view, 7.21
V$ASM_ATTRIBUTE view, 7.22
V$ASM_CLIENT view, 7.23
V$ASM_DISK view, 7.24
V$ASM_DISK_IOSTAT view, 7.25
V$ASM_DISK_STAT view, 7.26
V$ASM_DISKGROUP view, 7.27
V$ASM_DISKGROUP_STAT view, 7.28
V$ASM_FILE view, 7.29
V$ASM_FILESYSTEM view, 7.30
V$ASM_OPERATION view, 7.31
V$ASM_TEMPLATE view, 7.32
V$ASM_USER view, 7.33
V$ASM_USERGROUP view, 7.34
V$ASM_USERGROUP_MEMBER view, 7.35
V$ASM_VOLUME view, 7.36
V$ASM_VOLUME_STAT view, 7.37
V$AW_AGGREGATE_OP view, 7.38
V$AW_ALLOCATE_OP view, 7.39
V$AW_CALC view, 7.40
V$AW_LONGOPS view, 7.41
V$AW_OLAP view, 7.42
V$AW_SESSION_INFO view, 7.43
V$BACKUP view, 7.44
V$BACKUP_ARCHIVELOG_DETAILS view, 7.45
V$BACKUP_ARCHIVELOG_SUMMARY view, 7.46
V$BACKUP_ASYNC_IO view, 7.47
V$BACKUP_CONTROLFILE_DETAILS view, 7.48
V$BACKUP_CONTROLFILE_SUMMARY view, 7.49
V$BACKUP_COPY_DETAILS view, 7.50
V$BACKUP_COPY_SUMMARY view, 7.51
V$BACKUP_CORRUPTION view, 7.52
V$BACKUP_DATAFILE view, 7.53
V$BACKUP_DATAFILE_DETAILS view, 7.54
V$BACKUP_DATAFILE_SUMMARY view, 7.55
V$BACKUP_DEVICE view, 7.56
V$BACKUP_FILES view, 7.57
V$BACKUP_PIECE view, 7.58
V$BACKUP_PIECE_DETAILS view, 7.59
V$BACKUP_REDOLOG view, 7.60
V$BACKUP_SET view, 7.61
V$BACKUP_SET_DETAILS view, 7.62
V$BACKUP_SET_SUMMARY view, 7.63
V$BACKUP_SPFILE view, 7.64
V$BACKUP_SPFILE_DETAILS view, 7.65
V$BACKUP_SPFILE_SUMMARY view, 7.66
V$BACKUP_SYNC_IO view, 7.67
V$BGPROCESS view, 7.68
V$BH view, 7.69
V$BLOCK_CHANGE_TRACKING view, 7.70
V$BLOCKING_QUIESCE view, 7.71
V$BUFFER_POOL view, 7.72
V$BUFFER_POOL_STATISTICS view, 7.73
V$BUFFERED_PUBLISHERS view, 7.74
V$BUFFERED_QUEUES view, 7.75
V$BUFFERED_SUBSCRIBERS view, 7.76
V$CACHE view, 7.77
V$CACHE_LOCK view, 7.78
V$CACHE_TRANSFER view, 7.79
V$CIRCUIT view, 7.80
V$CLASS_CACHE_TRANSFER view, 7.81
V$CLIENT_STATS view, 7.82
V$CLUSTER_INTERCONNECTS view, 7.83
V$CONFIGURED_INTERCONNECTS view, 7.84
V$CONTEXT view, 7.85
V$CONTROLFILE view, 7.86
V$CONTROLFILE_RECORD_SECTION view, 7.87
V$COPY_CORRUPTION view, 7.88
V$CORRUPT_XID_LIST view, 7.89
V$CPOOL_CC_INFO view, 7.90
V$CPOOL_CC_STATS view, 7.91
V$CPOOL_CONN_INFO view, 7.92
V$CPOOL_STATS view, 7.93
V$CR_BLOCK_SERVER view, 7.94
V$CURRENT_BLOCK_SERVER view, 7.95
V$DATABASE view, 7.96
V$DATABASE_BLOCK_CORRUPTION view, 7.97
V$DATABASE_INCARNATION view, 7.98
V$DATAFILE view, 7.99
V$DATAFILE_COPY view, 7.100
V$DATAFILE_HEADER view, 7.101
V$DATAGUARD_CONFIG view, 7.102
V$DATAGUARD_STATS view, 7.103
V$DATAGUARD_STATUS view, 7.104
V$DB_CACHE_ADVICE view, 7.105
V$DB_OBJECT_CACHE view, 7.106
V$DB_PIPES view, 7.107
V$DB_TRANSPORTABLE_PLATFORM view, 7.108
V$DBFILE view, 7.109
V$DBLINK view, 7.110
V$DELETED_OBJECT view, 7.111
V$DISPATCHER view, 7.112
V$DISPATCHER_CONFIG view, 7.113
V$DISPATCHER_RATE view, 7.114
V$DNFS_CHANNELS view, 7.115
V$DNFS_FILES view, 7.116
V$DNFS_SERVERS view, 7.117
V$DNFS_STATS view, 7.118
V$DYNAMIC_REMASTER_STATS view, 7.119
V$EMON view, 7.120
V$ENABLEDPRIVS view, 7.121
V$ENCRYPTED_TABLESPACES view, 7.122
V$ENCRYPTION_WALLET view, 7.123
V$ENQUEUE_LOCK view, 7.124
V$ENQUEUE_STAT view, 7.125
V$ENQUEUE_STATISTICS view, 7.126
V$EVENT_HISTOGRAM view, 7.127
V$EVENT_NAME view, 7.128
V$EVENTMETRIC view, 7.129
V$EXECUTION view, 7.130
V$FALSE_PING view, 7.131
V$FAST_START_SERVERS view, 7.132
V$FAST_START_TRANSACTIONS view, 7.133
V$FILE_CACHE_TRANSFER view, 7.134
V$FILE_HISTOGRAM view, 7.135
V$FILEMETRIC view, 7.136
V$FILEMETRIC_HISTORY view, 7.137
V$FILESPACE_USAGE view, 7.138
V$FILESTAT view, 7.139
V$FIXED_TABLE view, 7.140
V$FIXED_VIEW_DEFINITION view, 7.141
V$FLASHBACK_DATABASE_LOG view, 7.142
V$FLASHBACK_DATABASE_LOGFILE view, 7.143
V$FLASHBACK_DATABASE_STAT view, 7.144
V$FLASHBACK_TXN_GRAPH view, 7.145
V$FLASHBACK_TXN_MODS view, 7.146
V$FOREIGN_ARCHIVED_LOG view, 7.147
V$FS_FAILOVER_STATS view, 7.148
V$GC_ELEMENT view, 7.149
V$GC_ELEMENTS_WITH_COLLISIONS view, 7.150
V$GCSHVMASTER_INFO view, 7.151
V$GCSPFMASTER_INFO view, 7.152
V$GES_BLOCKING_ENQUEUE view, 7.153
V$GES_CONVERT_LOCAL view, 7.154
V$GES_CONVERT_REMOTE view, 7.155
V$GES_ENQUEUE view, 7.156
V$GES_LATCH view, 7.157
V$GES_RESOURCE view, 7.158
V$GES_STATISTICS view, 7.159
V$GLOBAL_BLOCKED_LOCKS view, 7.160
V$GLOBAL_TRANSACTION view, 7.161
V$HM_CHECK view, 7.162
V$HM_CHECK_PARAM view, 7.163
V$HM_FINDING view, 7.164
V$HM_INFO view, 7.165
V$HM_RECOMMENDATION view, 7.166
V$HM_RUN view, 7.167
V$HS_AGENT view, 7.168
V$HS_PARAMETER view, 7.169
V$HS_SESSION view, 7.170
V$HVMASTER_INFO view, 7.171
V$INDEXED_FIXED_COLUMN view, 8.1
V$INSTANCE view, 8.2
V$INSTANCE_CACHE_TRANSFER view, 8.3
V$INSTANCE_RECOVERY view, 8.4
V$IO_CALIBRATION_STATUS view, 8.5
V$IOFUNCMETRIC view, 8.6
V$IOFUNCMETRIC_HISTORY view, 8.7
V$IOSTAT_CONSUMER_GROUP view, 8.8
V$IOSTAT_FILE view, 8.9
V$IOSTAT_FUNCTION view, 8.10
V$IOSTAT_FUNCTION_DETAIL view, 8.11
V$IOSTAT_NETWORK view, 8.12
V$JAVA_LIBRARY_CACHE_MEMORY view, 8.13
V$JAVA_POOL_ADVICE view, 8.14
V$LATCH view, 8.15
V$LATCH_CHILDREN view, 8.16
V$LATCH_MISSES view, 8.17
V$LATCH_PARENT view, 8.18
V$LATCHHOLDER view, 8.19
V$LATCHNAME view, 8.20
V$LIBCACHE_LOCKS view, 8.21
V$LIBRARY_CACHE_MEMORY view, 8.22
V$LIBRARYCACHE view, 8.23
V$LICENSE view, 8.24
V$LOADISTAT view, 8.25
V$LOADPSTAT view, 8.26
V$LOCK view, 8.27
V$LOCK_ACTIVITY view, 8.28
V$LOCK_TYPE view, 8.29
V$LOCKED_OBJECT view, 8.30
V$LOG view, 8.31
V$LOG_HISTORY view, 8.32
V$LOGFILE view, 8.33
V$LOGHIST view, 8.34
V$LOGMNR_CONTENTS view, 8.35
V$LOGMNR_DICTIONARY view, 8.36
V$LOGMNR_DICTIONARY_LOAD view, 8.37
V$LOGMNR_LATCH view, 8.38
V$LOGMNR_LOGS view, 8.39
V$LOGMNR_PARAMETERS view, 8.40
V$LOGMNR_PROCESS view, 8.41
V$LOGMNR_SESSION view, 8.42
V$LOGMNR_STATS view, 8.43
V$LOGSTDBY view, 8.44
V$LOGSTDBY_PROCESS view, 8.45
V$LOGSTDBY_PROGRESS view, 8.46
V$LOGSTDBY_STATE view, 8.47
V$LOGSTDBY_STATS view, 8.48
V$LOGSTDBY_TRANSACTION view, 8.49
V$MANAGED_STANDBY view, 8.50
V$MAP_COMP_LIST view, 8.51
V$MAP_ELEMENT view, 8.52
V$MAP_EXT_ELEMENT view, 8.53
V$MAP_FILE view, 8.54
V$MAP_FILE_EXTENT view, 8.55
V$MAP_FILE_IO_STACK view, 8.56
V$MAP_LIBRARY view, 8.57
V$MAP_SUBELEMENT view, 8.58
V$MEMORY_CURRENT_RESIZE_OPS view, 8.59
V$MEMORY_DYNAMIC_COMPONENTS view, 8.60
V$MEMORY_RESIZE_OPS view, 8.61
V$MEMORY_TARGET_ADVICE view, 8.62
V$METRIC view, 8.63
V$METRIC_HISTORY view, 8.65
V$METRICGROUP view, 8.64
V$METRICNAME view, 8.66
V$MTTR_TARGET_ADVICE view, 8.67
V$MUTEX_SLEEP view, 8.68
V$MUTEX_SLEEP_HISTORY view, 8.69
V$MVREFRESH view, 8.70
V$MYSTAT view, 8.71
V$NFS_CLIENTS view, 8.72
V$NFS_LOCKS view, 8.73
V$NFS_OPEN_FILES view, 8.74
V$NLS_PARAMETERS view, 8.75
V$NLS_VALID_VALUES view, 8.76
V$OBJECT_DEPENDENCY view, 8.77
V$OBJECT_PRIVILEGE view, 8.78
V$OBJECT_USAGE view, 8.79
V$OBSOLETE_BACKUP_FILES view, 8.80
V$OBSOLETE_PARAMETER view, 8.81
V$OFFLINE_RANGE view, 8.82
V$OPEN_CURSOR view, 8.83
V$OPTION view, 8.84
V$OSSTAT view, 8.85
V$PARALLEL_DEGREE_LIMIT_MTH view, 8.86
V$PARAMETER view, 8.87
V$PARAMETER_VALID_VALUES view, 8.88
V$PARAMETER2 view, 8.89
V$PERSISTENT_PUBLISHERS view, 8.90
V$PERSISTENT_QMN_CACHE view, 8.91
V$PERSISTENT_QUEUES view, 8.92
V$PERSISTENT_SUBSCRIBERS view, 8.93
V$PGA_TARGET_ADVICE view, 8.94
V$PGA_TARGET_ADVICE_HISTOGRAM view, 8.95
V$PGASTAT view, 8.96
V$PQ_SESSTAT view, 8.97
V$PQ_SLAVE view, 8.98
V$PQ_SYSSTAT view, 8.99
V$PQ_TQSTAT view, 8.100
V$PROCESS view, 8.101
V$PROCESS_MEMORY view, 8.102
V$PROPAGATION_RECEIVER view, 8.103
V$PROPAGATION_SENDER view, 8.104
V$PROXY_ARCHIVEDLOG view, 8.105
V$PROXY_ARCHIVELOG_DETAILS view, 8.106
V$PROXY_ARCHIVELOG_SUMMARY view, 8.107
V$PROXY_COPY_DETAILS view, 8.108
V$PROXY_COPY_SUMMARY view, 8.109
V$PROXY_DATAFILE view, 8.110
V$PWFILE_USERS view, 8.111
V$PX_INSTANCE_GROUP view, 8.112
V$PX_PROCESS view, 8.113
V$PX_PROCESS_SYSSTAT view, 8.114
V$PX_SESSION view, 8.115
V$PX_SESSTAT view, 8.116
V$QMON_COORDINATOR_STATS view, 8.117
V$QMON_SERVER_STATS view, 8.118
V$QMON_TASK_STATS view, 8.119
V$QMON_TASKS view, 8.120
V$QUEUE view, 8.121
V$QUEUEING_MTH view, 8.122
V$RECOVER_FILE view, 8.123
V$RECOVERY_AREA_USAGE view, 8.124
V$RECOVERY_FILE_DEST view, 8.125
V$RECOVERY_FILE_STATUS view, 8.126
V$RECOVERY_LOG view, 8.127
V$RECOVERY_PROGRESS view, 8.128
V$RECOVERY_STATUS view, 8.129
V$REDO_DEST_RESP_HISTOGRAM view, 8.130
V$REPLPROP view, 8.131
V$REPLQUEUE view, 8.132
V$REQDIST view, 8.133
V$RESERVED_WORDS view, 8.134
V$RESOURCE view, 8.135
V$RESOURCE_LIMIT view, 8.136
V$RESTORE_POINT view, 8.137
V$RESULT_CACHE_DEPENDENCY view, 8.138
V$RESULT_CACHE_MEMORY view, 8.139
V$RESULT_CACHE_OBJECTS view, 8.140
V$RESULT_CACHE_STATISTICS view, 8.141
V$RMAN_BACKUP_JOB_DETAILS view, 8.142
V$RMAN_BACKUP_SUBJOB_DETAILS view, 8.143
V$RMAN_BACKUP_TYPE view, 8.144
V$RMAN_COMPRESSION_ALGORITHM view, 8.145
V$RMAN_CONFIGURATION view, 8.146
V$RMAN_ENCRYPTION_ALGORITHMS view, 8.147
V$RMAN_OUTPUT view, 8.148
V$RMAN_STATUS view, 8.149
V$ROLLNAME view, 8.150
V$ROLLSTAT view, 8.151
V$ROWCACHE view, 8.152
V$ROWCACHE_PARENT view, 8.153
V$ROWCACHE_SUBORDINATE view, 8.154
V$RSRC_CONS_GROUP_HISTORY view, 8.155
V$RSRC_CONSUMER_GROUP view, 8.156
V$RSRC_CONSUMER_GROUP_CPU_MTH view, 8.157
V$RSRC_PLAN view, 8.158
V$RSRC_PLAN_CPU_MTH view, 8.159
V$RSRC_PLAN_HISTORY view, 8.160
V$RSRC_SESSION_INFO view, 8.161
V$RSRCMGRMETRIC view, 8.162
V$RSRCMGRMETRIC_HISTORY view, 8.163
V$RULE view, 8.164
V$RULE_SET view, 8.165
V$RULE_SET_AGGREGATE_STATS view, 8.166
V$SCHEDULER_RUNNING_JOBS view, 9.1
V$SECUREFILE_TIMER view, 9.2
V$SEGMENT_STATISTICS view, 9.3
V$SEGSTAT view, 9.4
V$SEGSTAT_NAME view, 9.5
V$SERV_MOD_ACT_STATS view, 9.6
V$SERVICE_EVENT view, 9.7
V$SERVICE_STATS view, 9.8
V$SERVICE_WAIT_CLASS view, 9.9
V$SERVICEMETRIC view, 9.10
V$SERVICEMETRIC_HISTORY view, 9.11
V$SERVICES view, 9.12
V$SES_OPTIMIZER_ENV view, 9.13
V$SESS_IO view, 9.14
V$SESS_TIME_MODEL view, 9.15
V$SESSION view, 9.16
V$SESSION_BLOCKERS view, 9.17
V$SESSION_CONNECT_INFO view, 9.18
V$SESSION_CURSOR_CACHE view, 9.19
V$SESSION_EVENT view, 9.20, C
V$SESSION_FIX_CONTROL view, 9.21
V$SESSION_LONGOPS view, 9.22
V$SESSION_OBJECT_CACHE view, 9.23
V$SESSION_WAIT view, 9.24, C
V$SESSION_WAIT_CLASS view, 9.25
V$SESSION_WAIT_HISTORY view, 9.26
V$SESSMETRIC view, 9.27
V$SESSTAT view, 9.28, E, E.1
V$SGA view, 9.29
V$SGA_CURRENT_RESIZE_OPS view, 9.30
V$SGA_DYNAMIC_COMPONENTS view, 9.31
V$SGA_DYNAMIC_FREE_MEMORY view, 9.32
V$SGA_RESIZE_OPS view, 9.33
V$SGA_TARGET_ADVICE view, 9.34
V$SGAINFO view, 9.35
V$SGASTAT view, 9.36
V$SHARED_POOL_ADVICE view, 9.37
V$SHARED_POOL_RESERVED view, 9.38
V$SHARED_SERVER view, 9.39
V$SHARED_SERVER_MONITOR view, 9.40
V$SORT_SEGMENT view, 9.41
V$SPPARAMETER view, 9.42
V$SQL view, 9.43
V$SQL_BIND_CAPTURE view, 9.44
V$SQL_BIND_DATA view, 9.45
V$SQL_BIND_METADATA view, 9.46
V$SQL_CS_HISTOGRAM view, 9.47
V$SQL_CS_SELECTIVITY view, 9.48
V$SQL_CS_STATISTICS view, 9.49
V$SQL_CURSOR view, 9.50
V$SQL_JOIN_FILTER view, 9.51
V$SQL_MONITOR view, 9.52
V$SQL_OPTIMIZER_ENV view, 9.53
V$SQL_PLAN view, 9.54
V$SQL_PLAN_MONITOR view, 9.55
V$SQL_PLAN_STATISTICS view, 9.56
V$SQL_PLAN_STATISTICS_ALL view, 9.57
V$SQL_REDIRECTION view, 9.58
V$SQL_SHARED_CURSOR view, 9.59
V$SQL_SHARED_MEMORY view, 9.60
V$SQL_WORKAREA view, 9.61
V$SQL_WORKAREA_ACTIVE view, 9.62
V$SQL_WORKAREA_HISTOGRAM view, 9.63
V$SQLAREA view, 9.64
V$SQLAREA_PLAN_HASH view, 9.65
V$SQLCOMMAND view, 9.66
V$SQLFN_ARG_METADATA view, 9.67
V$SQLFN_METADATA view, 9.68
V$SQLSTATS view, 9.69
V$SQLSTATS_PLAN_HASH view, 9.70
V$SQLTEXT view, 9.71
V$SQLTEXT_WITH_NEWLINES view, 9.72
V$STANDBY_EVENT_HISTOGRAM view, 9.73
V$STANDBY_LOG view, 9.74
V$STATISTICS_LEVEL view, 9.75
V$STATNAME view, 9.76, E.1
V$STREAMS_APPLY_COORDINATOR view, 9.77
V$STREAMS_APPLY_READER view, 9.78
V$STREAMS_APPLY_SERVER view, 9.79
V$STREAMS_CAPTURE view, 9.80
V$STREAMS_MESSAGE_TRACKING view, 9.81
V$STREAMS_POOL_ADVICE view, 9.82
V$STREAMS_POOL_STATISTICS view, 9.83
V$STREAMS_TRANSACTION view, 9.84
V$SUBCACHE view, 9.85
V$SUBSCR_REGISTRATION_STATS view, 9.86
V$SYS_OPTIMIZER_ENV view, 9.87
V$SYS_TIME_MODEL view, 9.88
V$SYSAUX_OCCUPANTS view, 9.89
V$SYSMETRIC view, 9.90
V$SYSMETRIC_HISTORY view, 9.91
V$SYSMETRIC_SUMMARY view, 9.92
V$SYSSTAT view, 9.93, E
V$SYSTEM_CURSOR_CACHE view, 9.94
V$SYSTEM_EVENT view, 9.95, C
V$SYSTEM_FIX_CONTROL view, 9.96
V$SYSTEM_PARAMETER view, 9.97
V$SYSTEM_PARAMETER2 view, 9.98
V$SYSTEM_WAIT_CLASS view, 9.99
V$TABLESPACE view, 9.100
V$TEMP_CACHE_TRANSFER view, 9.101
V$TEMP_EXTENT_MAP view, 9.102
V$TEMP_EXTENT_POOL view, 9.103
V$TEMP_SPACE_HEADER view, 9.104
V$TEMPFILE view, 9.105
V$TEMPORARY_LOBS view, 9.106
V$TEMPSEG_USAGE view, 9.107
V$TEMPSTAT view, 9.108
V$THREAD view, 9.109
V$THRESHOLD_TYPES view, 9.110
V$TIMER view, 9.111
V$TIMEZONE_NAMES view, 9.112
V$TOPLEVELCALL view, 9.113
V$TRANSACTION view, 9.114
V$TRANSACTION_ENQUEUE view, 9.115
V$TRANSPORTABLE_PLATFORM view, 9.116
V$TYPE_SIZE view, 9.117
V$UNDOSTAT view, 9.118
V$UNUSABLE_BACKUPFILE_DETAILS view, 9.119
V$VERSION view, 9.120
V$VPD_POLICY view, 9.121
V$WAIT_CHAINS view, 9.122
V$WAITCLASSMETRIC view, 9.123
V$WAITCLASSMETRIC_HISTORY view, 9.124
V$WAITSTAT view, 9.125
V$WALLET view, 9.126
V$WORKLOAD_REPLAY_THREAD view, 9.127
V$XML_AUDIT_TRAIL view, 9.128
V$XS_SESSION view, 9.129
V$XS_SESSION_ATTRIBUTE view, 9.130
V$XS_SESSION_ROLE view, 9.131
V$XSTREAM_CAPTURE view, 9.132
V$XSTREAM_MESSAGE_TRACKING view, 9.133
V$XSTREAM_OUTBOUND_SERVER view, 9.134
V$XSTREAM_TRANSACTION view, 9.135
views
data dictionary views, 2

W

wait events
alter system set dispatcher, C.3.1
batched allocate scn lock request, C.3.2
BFILE check if exists, C.3.3
BFILE check if open, C.3.4
BFILE closure, C.3.5
BFILE get length, C.3.6
BFILE get name object, C.3.7
BFILE get path object, C.3.8
BFILE internal seek, C.3.9
BFILE open, C.3.10
BFILE read, C.3.11
broadcast mesg queue transition, C.3.12
broadcast mesg recovery queue transition, C.3.13
buffer busy waits, C.3.14
buffer deadlock, C.3.15
buffer latch, C.3.16
buffer read retry, C.3.17
checkpoint completed, C.3.18
cleanup of aborted processes, C.3.19
controlfile parallel write, C.3.20
controlfile sequential read, C.3.21
controlfile single write, C.3.22
cursor: mutex S, C.3.23
cursor: mutex X, C.3.24
cursor: pin S, C.3.25
cursor: pin S wait on X, C.3.26
cursor: pin X, C.3.27
Data Guard Broker: single instance, C.3.30
Data Guard: process cleanup, C.3.28
Data Guard: process exit, C.3.29
db file parallel read, C.3.31
db file parallel write, C.3.32
db file scattered read, C.3.33
db file sequential read, C.3.34
db file single write, C.3.35
DFS db file lock, C.3.36
DFS lock handle, C.3.37
direct path read, C.3.38
direct path write, C.3.39
Disk file operations I/O, C.3.40
dispatcher shutdown, C.3.41
dispatcher timer, C.3.42
duplicate cluster key, C.3.43
enq: OW - initialization, C.3.44
enq: OW - termination, C.3.45
enqueue, C.3.46
flashback buf free by RVWR, C.3.47
flashback logfile sync, C.3.48
free buffer waits, C.3.49
free global transaction table entry, C.3.50
free process state object, C.3.51
gc recovery quiesce, C.3.52
GCS lock open S, C.3.53
GCS lock open X, C.3.54
gcs remastering wait for drop pkey, C.3.55
global cache busy, C.3.56
global cache freelist, C.3.58
global cache lock cleanup, C.3.57
inactive session, C.3.59
inactive transaction branch, C.3.60
index block split, C.3.61
instance state change, C.3.62
io done, C.3.63
kcl bg acks, C.3.64
ksxr wait for mount shared, C.3.65
ktm: instance recovery, C.3.66
latch activity, C.3.67
latch free, C.3.68
library cache load lock, C.3.69
library cache lock, C.3.70
library cache pin, C.3.71
LMON global data update, C.3.73
lock manager wait for remote message, C.3.74
Log archive I/O, C.3.75
log buffer space, C.3.76
log file parallel write, C.3.77
log file sequential read, C.3.78
log file single write, C.3.79
log file switch (archiving needed), C.3.80
log file switch (checkpoint incomplete), C.3.81
log file switch (clearing log file), C.3.82
log file switch (private strand flush incomplete), C.3.83
log file switch completion, C.3.84
log file sync, C.3.85
log switch/archive, C.3.86
optimizer stats update retry, C.3.87
parallel recovery change buffer free, C.3.88
parallel recovery control message reply, C.3.89
parallel recovery coord send blocked, C.3.90
parallel recovery coord wait for reply, C.3.91
parallel recovery coordinator waits for slave cleanup, C.3.92
parallel recovery read buffer free, C.3.93
parallel recovery slave next change, C.3.94
pending global transaction(s), C.3.95
pipe get, C.3.96
pipe put, C.3.97
PL/SQL lock timer, C.3.98
pmon timer, C.3.99
prewarm transfer retry, C.3.100
prior process spawner to be cleaned up, C.3.101
process startup, C.3.102
PX dequeue wait, C.3.103
PX qref latch, C.3.104
PX server shutdown, C.3.105
PX signal server, C.3.106
rdbms ipc message, C.3.107
rdbms ipc message block, C.3.108
rdbms ipc reply, C.3.109
read by other session, C.3.110
recovery read, C.3.111
resmgr:become active, C.3.112
resmgr:cpu quantum, C.3.113
resmgr:pq queued, C.3.114
rolling migration: cluster quiesce, C.3.115
row cache lock, C.3.116
RVWR wait for flashback copy, C.3.117
sbtbufinfo, C.3.118
sbtgetbuf, C.3.119
sbtmapbuf, C.3.120
sbtrelbuf, C.3.121
scginq AST call, C.3.122
SGA: allocation forcing component growth, C.3.123
SGA: MMAN sleep for component shrink, C.3.124
SGA: sga_target resize, C.3.125
Shared IO Pool Memory, C.3.126
shared server idle event, C.3.128
single-task message, C.3.127
smon timer, C.3.129
SQL*Net break/reset to client, C.3.130
SQL*Net break/reset to dblink, C.3.131
SQL*Net message from client, C.3.132
SQL*Net message from dblink, C.3.133
SQL*Net message to client, C.3.134
SQL*Net message to dblink, C.3.135
SQL*Net more data from client, C.3.136
SQL*Net more data from dblink, C.3.137
SQL*Net more data to client, C.3.138
SQL*Net more data to dblink, C.3.139
Streams AQ: waiting for messages in the queue, C.3.140
switch logfile command, C.3.141
timer in sksawat, C.3.143
transaction, C.3.144
unbound tx, C.3.145
undo segment extension, C.3.147
undo segment recovery, C.3.148
undo segment tx slot, C.3.149
undo_retention publish retry, C.3.146
virtual circuit status, C.3.150
virtual circuit wait, C.3.151
WCR: replay client notify, C.3.152
WCR: replay clock, C.3.153
WCR: replay lock order, C.3.154
WCR: replay paused, C.3.155
WCR: Sync context busy, C.3.156
WMON goes to sleep, C.3.157
write complete waits, C.3.158
writes stopped by instance recovery or database suspension, C.3.159
WM_COMPRESS_BATCH_SIZES view, 2.1.2
WM_COMPRESSIBLE_TABLES view, 2.1.2
WM_EVENTS_INFO view, 2.1.2
WM_INSTALLATION view, 2.1.2
WM_REPLICATION_INFO view, 2.1.2
WORKAREA_SIZE_POLICY initialization parameter, 1.265

X

XML_DB_EVENTS initialization parameter, 1.266
XS_SESSION_ROLES view, 6.508