Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)
Part Number B28320-02
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_CONFLICT_COLUMNS view, 2.5
ALL_APPLY_DML_HANDLERS view, 2.6
ALL_APPLY_ENQUEUE view, 2.7
ALL_APPLY_ERROR view, 2.8
ALL_APPLY_EXECUTE view, 2.9
ALL_APPLY_KEY_COLUMNS view, 2.10
ALL_APPLY_PARAMETERS view, 2.11
ALL_APPLY_PROGRESS view, 2.12
ALL_APPLY_TABLE_COLUMNS view, 2.13
ALL_ARGUMENTS view, 2.14
ALL_ASSEMBLIES view, 2.15
ALL_ASSOCIATIONS view, 2.16
ALL_AUDIT_POLICIES view, 2.17
ALL_AUDIT_POLICY_COLUMNS view, 2.18
ALL_AW_PS view, 2.19
ALL_AWS view, 2.20
ALL_BASE_TABLE_MVIEWS view, 2.21
ALL_CAPTURE view, 2.22
ALL_CAPTURE_EXTRA_ATTRIBUTES view, 2.23
ALL_CAPTURE_PARAMETERS view, 2.24
ALL_CAPTURE_PREPARED_DATABASE view, 2.25
ALL_CAPTURE_PREPARED_SCHEMAS view, 2.26
ALL_CAPTURE_PREPARED_TABLES view, 2.27
ALL_CATALOG view, 2.28
ALL_CHANGE_PROPAGATION_SETS view, 2.29
CHANGE_PROPAGATION_SETS synonym, 3.130
ALL_CHANGE_PROPAGATIONS view, 2.30
CHANGE_PROPAGATIONS synonym, 3.131
ALL_CHANGE_SETS view, 2.31
CHANGE_SETS synonym, 3.132
ALL_CHANGE_SOURCES view, 2.32
CHANGE_SOURCES synonym, 3.133
ALL_CHANGE_TABLES view, 2.33
CHANGE_TABLES synonym, 3.134
ALL_CLUSTER_HASH_EXPRESSIONS view, 2.34
ALL_CLUSTERS view, 2.35
ALL_COL_COMMENTS view, 2.36
ALL_COL_PENDING_STATS view, 2.37
ALL_COL_PRIVS view, 2.38
ALL_COL_PRIVS_MADE view, 2.39
ALL_COL_PRIVS_RECD view, 2.40
ALL_COLL_TYPES view, 2.41
ALL_CONS_COLUMNS view, 2.42
ALL_CONS_OBJ_COLUMNS view, 2.43
ALL_CONSTRAINTS view, 2.44
ALL_CONTEXT view, 2.45
ALL_CUBE_ATTR_VISIBILITY view, 2.46
ALL_CUBE_ATTRIBUTES view, 2.47
ALL_CUBE_BUILD_PROCESSES view, 2.48
ALL_CUBE_CALCULATED_MEMBERS view, 2.49
ALL_CUBE_DIM_LEVELS view, 2.50
ALL_CUBE_DIM_MODELS view, 2.51
ALL_CUBE_DIM_VIEW_COLUMNS view, 2.52
ALL_CUBE_DIM_VIEWS view, 2.53
ALL_CUBE_DIMENSIONALITY view, 2.54
ALL_CUBE_DIMENSIONS view, 2.55
ALL_CUBE_HIER_LEVELS view, 2.56
ALL_CUBE_HIER_VIEW_COLUMNS view, 2.57
ALL_CUBE_HIER_VIEWS view, 2.58
ALL_CUBE_HIERARCHIES view, 2.59
ALL_CUBE_MEASURES view, 2.60
ALL_CUBE_VIEW_COLUMNS view, 2.61
ALL_CUBE_VIEWS view, 2.62
ALL_CUBES view, 2.63
ALL_DB_LINKS view, 2.64
ALL_DEF_AUDIT_OPTS view, 2.65
ALL_DEPENDENCIES view, 2.66
ALL_DEQUEUE_QUEUES view, 2.67
ALL_DIM_ATTRIBUTES view, 2.68
ALL_DIM_CHILD_OF view, 2.69
ALL_DIM_HIERARCHIES view, 2.70
ALL_DIM_JOIN_KEY view, 2.71
ALL_DIM_LEVEL_KEY view, 2.72
ALL_DIM_LEVELS view, 2.73
ALL_DIMENSIONS view, 2.74
ALL_DIRECTORIES view, 2.75
ALL_ENCRYPTED_COLUMNS view, 2.76
ALL_ERRORS view, 2.77
ALL_EVALUATION_CONTEXT_TABLES view, 2.78
ALL_EVALUATION_CONTEXT_VARS view, 2.79
ALL_EVALUATION_CONTEXTS view, 2.80
ALL_EXTERNAL_LOCATIONS view, 2.81
ALL_EXTERNAL_TABLES view, 2.82
ALL_FILE_GROUP_EXPORT_INFO view, 2.83
ALL_FILE_GROUP_FILES view, 2.84
ALL_FILE_GROUP_TABLES view, 2.85
ALL_FILE_GROUP_TABLESPACES view, 2.86
ALL_FILE_GROUP_VERSIONS view, 2.87
ALL_FILE_GROUPS view, 2.88
ALL_IDENTIFIERS view, 2.89
ALL_IND_COLUMNS view, 2.90
ALL_IND_EXPRESSIONS view, 2.91
ALL_IND_PARTITIONS view, 2.92
ALL_IND_PENDING_STATS view, 2.93
ALL_IND_STATISTICS view, 2.94
ALL_IND_SUBPARTITIONS view, 2.95
ALL_INDEXES view, 2.96
ALL_INDEXTYPE_ARRAYTYPES view, 2.97
ALL_INDEXTYPE_COMMENTS view, 2.98
ALL_INDEXTYPE_OPERATORS view, 2.99
ALL_INDEXTYPES view, 2.100
ALL_INTERNAL_TRIGGERS view, 2.101
ALL_JAVA_ARGUMENTS view, 2.102
ALL_JAVA_CLASSES view, 2.103
ALL_JAVA_COMPILER_OPTIONS view, 2.104
ALL_JAVA_DERIVATIONS view, 2.105
ALL_JAVA_FIELDS view, 2.106
ALL_JAVA_IMPLEMENTS view, 2.107
ALL_JAVA_INNERS view, 2.108
ALL_JAVA_LAYOUTS view, 2.109
ALL_JAVA_METHODS view, 2.110
ALL_JAVA_NCOMPS view, 2.111
ALL_JAVA_RESOLVERS view, 2.112
ALL_JAVA_THROWS view, 2.113
ALL_JOBS synonym for USER_JOBS view, 2.114
ALL_JOIN_IND_COLUMNS view, 2.115
ALL_LIBRARIES view, 2.116
ALL_LOB_PARTITIONS view, 2.117
ALL_LOB_SUBPARTITIONS view, 2.118
ALL_LOB_TEMPLATES view, 2.119
ALL_LOBS view, 2.120
ALL_LOG_GROUP_COLUMNS view, 2.121
ALL_LOG_GROUPS view, 2.122
ALL_MEASURE_FOLDER_CONTENTS view, 2.123
ALL_MEASURE_FOLDERS view, 2.124
ALL_METHOD_PARAMS view, 2.125
ALL_METHOD_RESULTS view, 2.126
ALL_MINING_MODEL_ATTRIBUTES view, 2.127
ALL_MINING_MODEL_SETTINGS view, 2.128
ALL_MINING_MODELS view, 2.129
ALL_MP_GRAPH_WORKSPACES view, 2.1.2
ALL_MP_PARENT_WORKSPACES view, 2.1.2
ALL_MVIEW_AGGREGATES view, 2.130
ALL_MVIEW_ANALYSIS view, 2.131
ALL_MVIEW_COMMENTS view, 2.132
ALL_MVIEW_DETAIL_PARTITION view, 2.133
ALL_MVIEW_DETAIL_RELATIONS view, 2.134
ALL_MVIEW_DETAIL_SUBPARTITION view, 2.135
ALL_MVIEW_JOINS view, 2.136
ALL_MVIEW_KEYS view, 2.137
ALL_MVIEW_LOGS view, 2.138
ALL_MVIEW_REFRESH_TIMES view, 2.139
ALL_MVIEWS view, 2.140
ALL_NESTED_TABLE_COLS view, 2.141
ALL_NESTED_TABLES view, 2.142
ALL_OBJ_COLATTRS view, 2.143
ALL_OBJECT_TABLES view, 2.144
ALL_OBJECTS view, 2.145
ALL_OPANCILLARY view, 2.146
ALL_OPARGUMENTS view, 2.147
ALL_OPBINDINGS view, 2.148
ALL_OPERATOR_COMMENTS view, 2.149
ALL_OPERATORS view, 2.150
ALL_OUTLINE_HINTS synonym for USER_OUTLINE_HINTS view, 2.151
ALL_OUTLINES synonym for USER_OUTLINES view, 2.152
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_SUBSCRIBERS view, 3.16
ALL_QUEUE_TABLES view, 3.17
ALL_QUEUES view, 3.18
ALL_REFRESH view, 3.19
ALL_REFRESH_CHILDREN view, 3.20
ALL_REFRESH_DEPENDENCIES view, 3.21
ALL_REFS view, 3.22
ALL_REGISTERED_MVIEWS view, 3.23
ALL_REGISTRY_BANNERS view, 3.24
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.25
ALL_RULE_SET_RULES view, 3.26
ALL_RULE_SETS view, 3.27
ALL_RULES view, 3.28
ALL_SCHEDULER_CHAIN_RULES view, 3.29
ALL_SCHEDULER_CHAIN_STEPS view, 3.30
ALL_SCHEDULER_CHAINS view, 3.31
ALL_SCHEDULER_CREDENTIALS view, 3.32
ALL_SCHEDULER_GLOBAL_ATTRIBUTE view, 3.33
ALL_SCHEDULER_JOB_ARGS view, 3.34
ALL_SCHEDULER_JOB_CLASSES view, 3.35
ALL_SCHEDULER_JOB_LOG view, 3.36
ALL_SCHEDULER_JOB_RUN_DETAILS view, 3.37
ALL_SCHEDULER_JOBS view, 3.38
ALL_SCHEDULER_PROGRAM_ARGS view, 3.39
ALL_SCHEDULER_PROGRAMS view, 3.40
ALL_SCHEDULER_REMOTE_DATABASES view, 3.41
ALL_SCHEDULER_REMOTE_JOBSTATE view, 3.42
ALL_SCHEDULER_RUNNING_CHAINS view, 3.43
ALL_SCHEDULER_RUNNING_JOBS view, 3.44
ALL_SCHEDULER_SCHEDULES view, 3.45
ALL_SCHEDULER_WINDOW_DETAILS view, 3.46
ALL_SCHEDULER_WINDOW_GROUPS view, 3.47
ALL_SCHEDULER_WINDOW_LOG view, 3.48
ALL_SCHEDULER_WINDOWS view, 3.49
ALL_SCHEDULER_WINGROUP_MEMBERS view, 3.50
ALL_SEC_RELEVANT_COLS view, 3.51
ALL_SECONDARY_OBJECTS view, 3.52
ALL_SEQUENCES view, 3.53
ALL_SERVICES view, 3.54
ALL_SOURCE view, 3.55
ALL_SOURCE_TABLES synonym for USER_SOURCE_TABLES view, 3.56
ALL_SQLJ_TYPE_ATTRS view, 3.57
ALL_SQLJ_TYPE_METHODS view, 3.58
ALL_SQLJ_TYPES view, 3.59
ALL_SQLSET view, 3.60
ALL_SQLSET_BINDS view, 3.61
ALL_SQLSET_PLANS view, 3.62
ALL_SQLSET_REFERENCES view, 3.63
ALL_SQLSET_STATEMENTS view, 3.64
ALL_STAT_EXTENSIONS view, 3.65
ALL_STORED_SETTINGS view, 3.66
ALL_STREAMS_COLUMNS view, 3.67
ALL_STREAMS_GLOBAL_RULES view, 3.68
ALL_STREAMS_MESSAGE_CONSUMERS view, 3.69
ALL_STREAMS_MESSAGE_RULES view, 3.70
ALL_STREAMS_NEWLY_SUPPORTED view, 3.71
ALL_STREAMS_RULES view, 3.72
ALL_STREAMS_SCHEMA_RULES view, 3.73
ALL_STREAMS_TABLE_RULES view, 3.74
ALL_STREAMS_TRANSFORM_FUNCTION view, 3.75
ALL_STREAMS_UNSUPPORTED view, 3.76
ALL_SUBPART_COL_STATISTICS view, 3.77
ALL_SUBPART_HISTOGRAMS view, 3.78
ALL_SUBPART_KEY_COLUMNS view, 3.79
ALL_SUBPARTITION_TEMPLATES view, 3.80
ALL_SUBSCRIBED_COLUMNS synonym for USER_SUBSCRIBED_COLUMNS view, 3.81
ALL_SUBSCRIBED_TABLES synonym for USER_SUBSCRIBED_TABLES view, 3.82
ALL_SUBSCRIPTIONS synonym for USER_SUBSCRIPTIONS view, 3.83
ALL_SUMDELTA view, 3.84
ALL_SYNC_CAPTURE view, 3.85
ALL_SYNC_CAPTURE_PREPARED_TABS view, 3.86
ALL_SYNC_CAPTURE_TABLES view, 3.87
ALL_SYNONYMS view, 3.88
ALL_TAB_COL_STATISTICS view, 3.89
ALL_TAB_COLS view, 3.90
ALL_TAB_COLUMNS view, 3.91
ALL_TAB_COMMENTS view, 3.92
ALL_TAB_HISTGRM_PENDING_STATS view, 3.93
ALL_TAB_HISTOGRAMS view, 3.94
ALL_TAB_MODIFICATIONS view, 3.95
ALL_TAB_PARTITIONS view, 3.96
ALL_TAB_PENDING_STATS view, 3.97
ALL_TAB_PRIVS view, 3.98
ALL_TAB_PRIVS_MADE view, 3.99
ALL_TAB_PRIVS_RECD view, 3.100
ALL_TAB_STAT_PREFS view, 3.101
ALL_TAB_STATISTICS view, 3.102
ALL_TAB_STATS_HISTORY view, 3.103
ALL_TAB_SUBPARTITIONS view, 3.104
ALL_TABLES view, 3.105
ALL_TRIGGER_COLS view, 3.106
ALL_TRIGGER_ORDERING view, 3.107
ALL_TRIGGERS view, 3.108
ALL_TYPE_ATTRS view, 3.109
ALL_TYPE_METHODS view, 3.110
ALL_TYPE_VERSIONS view, 3.111
ALL_TYPES view, 3.112
ALL_UNUSED_COL_TABS view, 3.113
ALL_UPDATABLE_COLUMNS view, 3.114
ALL_USERS view, 3.115
ALL_USTATS view, 3.116
ALL_VARRAYS view, 3.117
ALL_VERSION_HVIEW view, 2.1.2
ALL_VIEWS view, 3.118
ALL_WARNING_SETTINGS view, 3.119
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.120
ALL_XML_SCHEMAS view, 3.121
ALL_XML_TAB_COLS view, 3.122
ALL_XML_TABLES view, 3.123
ALL_XML_VIEW_COLS view, 3.124
ALL_XML_VIEWS view, 3.125
ALLOCATE EXTENT clause
of ALTER TABLE
instance number, 1.96
allocation
PCM locks, 1.85
ALTER DATABASE statement
ADD LOGFILE, 1.243
ENABLE THREAD, 1.243
THREAD, 1.243
ALTER TABLE statement
allocating extents, 1.96
ANALYZE statement, 2.96, 2.141, 3.90, 3.91, 3.105, 5.73, 5.141, 6.38, 6.39, 6.51, 6.333, 6.428, 6.429, 6.443
AQ_TM_PROCESSES initialization parameter, 1.8
ARCHIVE LOG START statement
automatic archiving, 1.113
ARCHIVE_LAG_TARGET initialization parameter, 1.9
archived redo logs
destination file, 1.113
storage device, 1.113, 1.117
ARCHIVELOG mode, 1.113
archiving destination, 1.113, 1.117
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.126
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.199
authenticating users, 1.166

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
PCM lock, 1.85
redo log, 1.123
size, 1.43, 1.47, 1.57

C

cache
dictionary, 8.144, 8.145, 8.146
statistics, 1.123
CAT synonym for USER_CATALOG view, 3.127
CATALOG view, 3.128
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.129
CHANGE_PROPAGATION_SETS synonym for ALL_CHANGE_PROPAGATION_SETS view, 3.130
CHANGE_PROPAGATIONS synonym for ALL_CHANGE_PROPAGATIONS view, 3.131
CHANGE_SETS synonym for ALL_CHANGE_SETS view, 3.132
CHANGE_SOURCES synonym for ALL_CHANGE_SOURCES view, 3.133
CHANGE_TABLES synonym for ALL_CHANGE_TABLES view, 3.134
characters
numeric group separators, 1.144
checkpoints
checkpoint interval, 1.123
statistics, 1.123
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.135
CLU synonym for USER_CLUSTERS view, 3.136
CLUSTER_DATABASE initialization parameter, 1.26
CLUSTER_DATABASE_INSTANCES initialization parameter, 1.27
CLUSTER_INTERCONNECTS initialization parameter, 1.28
COL view, 3.137
COLS synonym for USER_TAB_COLUMNS view, 3.138
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.117
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.161
favoring IN-list iterators, 1.159
CPU_COUNT initialization parameter, 1.38
CREATE TABLE statement
FREELIST GROUPS clause, 1.96
CREATE_BITMAP_AREA_SIZE initialization parameter, 1.39
CREATE_STORED_OUTLINES initialization parameter, 1.40
creating
a database
setting block size, 1.43, 1.47, 1.57
currency, 1.135, 1.136
international currency symbol, 1.140
CURSOR_SHARING initialization parameter, 1.41
CURSOR_SPACE_FOR_TIME initialization parameter, 1.42
cursors
OPEN_CURSORS initialization parameter, 1.153
shared pool, 1.226

D

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

F

FAL_CLIENT initialization parameter, 1.77
FAL_SERVER initialization parameter, 1.78
FAST_START_MTTR_TARGET initialization parameter, 1.79
FAST_START_PARALLEL_ROLLBACK initialization parameter, 1.80
FILE_MAPPING initialization parameter, 1.81
FILEIO_NETWORK_ADAPTERS initialization parameter, 1.82
filenames
case significance, 1.3.2.1.1
name and number, 1.85
FILESYSTEMIO_OPTIONS initialization parameter, 1.83
FIXED_DATE initialization parameter, 1.84
FLASHBACK_TRANSACTION_QUERY view, 6.101
free space list
locating space, 1.96
FREELIST GROUPS clause, 1.96

G

GC_FILES_TO_LOCKS initialization parameter, 1.85
GCS_SERVER_PROCESSES initialization parameter, 1.86
GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1.87
GLOBAL_NAME view, 6.102
GLOBAL_NAMES initialization parameter, 1.88
GLOBAL_TXN_PROCESSES initialization parameter, 1.89
GV$ views
for Real Application Clusters, 7.1.2

H

HASH_AREA_SIZE initialization parameter, 1.90
Heterogeneous Services
agents, 1.92
HI_SHARED_MEMORY_ADDRESS initialization parameter, 1.91
HS_ALL_CAPS view, 6.103
HS_ALL_DD view, 6.104
HS_ALL_INITS view, 6.105
HS_AUTOREGISTER initialization parameter, 1.92
HS_BASE_CAPS view, 6.106
HS_BASE_DD view, 6.107
HS_CLASS_CAPS view, 6.108
HS_CLASS_DD view, 6.109
HS_CLASS_INIT view, 6.110
HS_FDS_CLASS view, 6.111
HS_FDS_INST view, 6.112
HS_INST_CAPS view, 6.113
HS_INST_DD view, 6.114
HS_INST_INIT view, 6.115

I

IDEPTREE view, 6.116
IFILE initialization parameter, 1.3.2.1.1, 1.93
IND synonym for USER_INDEXES view, 6.117
INDEX_HISTOGRAM view, 6.118
INDEX_STATS view, 6.119
initialization parameter file
common file, 1.93
embedded, 1.93
INITDW.ORA