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.104

ALTER DATABASE statement

ADD LOGFILE, 1.254

ENABLE THREAD, 1.254

THREAD, 1.254

ALTER TABLE statement

allocating extents, 1.104

ANALYZE statement, 2.106, 2.151, 3.102, 3.103, 3.117, 5.80, 5.148, 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.122

ARCHIVE_LAG_TARGET initialization parameter, 1.9

archived redo logs

destination file, 1.122

storage device, 1.122, 1.126

ARCHIVELOG mode, 1.122

archiving destination, 1.122, 1.126

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.210

authenticating users, 1.174

AWR_SNAPSHOT_TIME_OFFSET initialization parameter, 1.18

---

B

BACKGROUND_CORE_DUMP initialization parameter, 1.19

BACKGROUND_DUMP_DEST initialization parameter, 1.20

BACKUP_TAPE_IO_SLAVES initialization parameter, 1.21

BITMAP_MERGE_AREA_SIZE initialization parameter, 1.22

BLANK_TRIMMING initialization parameter, 1.23

blocks

redo log, 1.132

size, 1.46, 1.50, 1.62

---

C

cache

dictionary, 8.152, 8.153, 8.154

statistics, 1.132

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.152

checkpoints

checkpoint interval, 1.132

statistics, 1.132

CIRCUITS initialization parameter, 1.24

CLIENT_RESULT_CACHE_LAG initialization parameter, 1.25

CLIENT_RESULT_CACHE_SIZE initialization parameter, 1.26

CLIENT_RESULT_CACHE_STATS$ view, 3.155

CLONEDB initialization parameter, 1.27

CLU synonym for USER_CLUSTERS view, 3.156

CLUSTER_DATABASE initialization parameter, 1.28

CLUSTER_DATABASE_INSTANCES initialization parameter, 1.29

CLUSTER_INTERCONNECTS initialization parameter, 1.30

COL view, 3.157

COLS synonym for USER_TAB_COLUMNS view, 3.158

COMMIT_LOGGING initialization parameter, 1.31

COMMIT_POINT_STRENGTH initialization parameter, 1.32

COMMIT_WAIT initialization parameter, 1.33

COMMIT_WRITE initialization parameter, 1.34

COMPATIBLE initialization parameter, 1.35

contention

block-level, 9.125

control files

names, 1.37

specifying, 1.37

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 1.36

CONTROL_FILES initialization parameter, 1.37

CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter, 1.38

CORE_DUMP_DEST initialization parameter, 1.39

cost-based optimization, 1.169

favoring IN-list iterators, 1.167

CPU_COUNT initialization parameter, 1.40

CREATE TABLE statement

FREELIST GROUPS clause, 1.104

CREATE_BITMAP_AREA_SIZE initialization parameter, 1.41

CREATE_STORED_OUTLINES initialization parameter, 1.42

creating

a database

setting block size, 1.46, 1.50, 1.62

currency, 1.143, 1.144

international currency symbol, 1.148

CURSOR_BIND_CAPTURE_DESTINATION initialization parameter, 1.43

CURSOR_SHARING initialization parameter, 1.44

CURSOR_SPACE_FOR_TIME initialization parameter, 1.45

cursors

OPEN_CURSORS initialization parameter, 1.161

shared pool, 1.237

---

D

data blocks

reading multiple, 1.56

size of, 1.46, 1.50, 1.62

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.132

DATABASE_PROPERTIES view, 3.159

databases

database limits, A

default language, 1.149

resource limits, 1.213, 1.215

datafiles

maximum number, 1.58

parameter, 1.58

dates

language used for, 1.146, 1.155, 1.156

setting SYSDATE, 1.93

TO_CHAR function, 1.145

TO_DATE function, 1.145

DB_BLOCK_BUFFERS initialization parameter, 1.47

DB_BLOCK_CHECKING initialization parameter, 1.48

DB_BLOCK_CHECKSUM initialization parameter, 1.49

DB_BLOCK_SIZE initialization parameter, 1.50

DB_CACHE_ADVICE initialization parameter, 1.51

DB_CACHE_SIZE initialization parameter, 1.52

DB_CREATE_FILE_DEST initialization parameter, 1.53

DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 1.54

DB_DOMAIN initialization parameter, 1.55

DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 1.56

DB_FILE_NAME_CONVERT initialization parameter, 1.57

DB_FILES initialization parameter, 1.58

DB_FLASH_CACHE_FILE initialization parameter, 1.59

DB_FLASH_CACHE_SIZE initialization parameter, 1.60

DB_FLASHBACK_RETENTION_TARGET initialization parameter, 1.61

DB_KEEP_CACHE_SIZE initialization parameter, 1.62

DB_LOST_WRITE_PROTECT initialization parameter, 1.63

DB_NAME initialization parameter, 1.64

DB_nK_CACHE_SIZE initialization parameter, 1.46

DB_RECOVERY_FILE_DEST initialization parameter, 1.65

DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 1.66

DB_RECYCLE_CACHE_SIZE initialization parameter, 1.67

DB_SECUREFILE initialization parameter, 1.68

DB_ULTRA_SAFE initialization parameter, 1.69

DB_UNIQUE_NAME initialization parameter, 1.70

DB_UNRECOVERABLE_SCN_TRACKING initialization parameter, 1.71

DB_WRITER_PROCESSES initialization parameter, 1.72

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_QMN_CACHE view, 5.19

DBA_HIST_PERSISTENT_QUEUES view, 5.20

DBA_HIST_PERSISTENT_SUBS view, 5.21

DBA_HIST_PGA_TARGET_ADVICE view, 5.22

DBA_HIST_PGASTAT view, 5.23

DBA_HIST_PLAN_OPERATION_NAME view, 5.24

DBA_HIST_PLAN_OPTION_NAME view, 5.25

DBA_HIST_PROCESS_MEM_SUMMARY view, 5.26

DBA_HIST_RESOURCE_LIMIT view, 5.27

DBA_HIST_ROWCACHE_SUMMARY view, 5.28

DBA_HIST_RSRC_CONSUMER_GROUP view, 5.29

DBA_HIST_RSRC_PLAN view, 5.30

DBA_HIST_RULE_SET view, 5.31

DBA_HIST_SEG_STAT view, 5.32

DBA_HIST_SEG_STAT_OBJ view, 5.33

DBA_HIST_SERVICE_NAME view, 5.34

DBA_HIST_SERVICE_STAT view, 5.35

DBA_HIST_SERVICE_WAIT_CLASS view, 5.36

DBA_HIST_SESS_TIME_STATS view, 5.37

DBA_HIST_SESSMETRIC_HISTORY view, 5.38

DBA_HIST_SGA view, 5.39

DBA_HIST_SGA_TARGET_ADVICE view, 5.40

DBA_HIST_SGASTAT view, 5.41

DBA_HIST_SHARED_POOL_ADVICE view, 5.42

DBA_HIST_SHARED_SERVER_SUMMARY view, 5.43

DBA_HIST_SNAP_ERROR view, 5.44

DBA_HIST_SNAPSHOT view, 5.45

DBA_HIST_SQL_BIND_METADATA view, 5.46

DBA_HIST_SQL_PLAN view, 5.47

DBA_HIST_SQL_SUMMARY view, 5.48

DBA_HIST_SQL_WORKAREA_HSTGRM view, 5.49

DBA_HIST_SQLBIND view, 5.50

DBA_HIST_SQLCOMMAND_NAME view, 5.51

DBA_HIST_SQLSTAT view, 5.52

DBA_HIST_SQLTEXT view, 5.53

DBA_HIST_STAT_NAME view, 5.54

DBA_HIST_STREAMS_APPLY_SUM view, 5.55

DBA_HIST_STREAMS_CAPTURE view, 5.56

DBA_HIST_STREAMS_POOL_ADVICE view, 5.57

DBA_HIST_SYS_TIME_MODEL view, 5.58

DBA_HIST_SYSMETRIC_HISTORY view, 5.59

DBA_HIST_SYSMETRIC_SUMMARY view, 5.60

DBA_HIST_SYSSTAT view, 5.61

DBA_HIST_SYSTEM_EVENT view, 5.62

DBA_HIST_TABLESPACE_STAT view, 5.63

DBA_HIST_TBSPC_SPACE_USAGE view, 5.64

DBA_HIST_TEMPFILE view, 5.65

DBA_HIST_TEMPSTATXS view, 5.66

DBA_HIST_THREAD view, 5.67

DBA_HIST_TOPLEVELCALL_NAME view, 5.68

DBA_HIST_UNDOSTAT view, 5.69

DBA_HIST_WAITCLASSMET_HISTORY view, 5.70

DBA_HIST_WAITSTAT view, 5.71

DBA_HIST_WR_CONTROL view, 5.72

DBA_HISTOGRAMS synonym for DBA_TAB_HISTOGRAMS, 5.73

DBA_IDENTIFIERS view, 5.74

DBA_IND_COLUMNS view, 5.75

DBA_IND_EXPRESSIONS view, 5.76

DBA_IND_PARTITIONS view, 5.77

DBA_IND_PENDING_STATS view, 5.78

DBA_IND_STATISTICS view, 5.79

DBA_IND_SUBPARTITIONS view, 5.80

DBA_INDEXES view, 5.81

collecting statistics for, 5.80

DBA_INDEXTYPE_ARRAYTYPES view, 5.82

DBA_INDEXTYPE_COMMENTS view, 5.83

DBA_INDEXTYPE_OPERATORS view, 5.84

DBA_INDEXTYPES view, 5.85

DBA_INTERNAL_TRIGGERS view, 5.86

DBA_JAVA_ARGUMENTS view, 5.87

DBA_JAVA_CLASSES view, 5.88

DBA_JAVA_COMPILER_OPTIONS view, 5.89

DBA_JAVA_DERIVATIONS view, 5.90

DBA_JAVA_FIELDS view, 5.91

DBA_JAVA_IMPLEMENTS view, 5.92

DBA_JAVA_INNERS view, 5.93

DBA_JAVA_LAYOUTS view, 5.94

DBA_JAVA_METHODS view, 5.95

DBA_JAVA_NCOMPS view, 5.96

DBA_JAVA_POLICY view, 5.97

DBA_JAVA_RESOLVERS view, 5.98

DBA_JAVA_THROWS view, 5.99

DBA_JOBS view, 5.100

DBA_JOBS_RUNNING view, 5.101

DBA_JOIN_IND_COLUMNS view, 5.102

DBA_KGLLOCK view, 5.103

DBA_LIBRARIES view, 5.104

DBA_LMT_FREE_SPACE view, 5.105

DBA_LMT_USED_EXTENTS view, 5.106

DBA_LOB_PARTITIONS view, 5.107

DBA_LOB_SUBPARTITIONS view, 5.108

DBA_LOB_TEMPLATES view, 5.109

DBA_LOBS view, 5.110

DBA_LOCK view, 5.111

DBA_LOCKS synonym, 5.113

DBA_LOCK_INTERNAL view, 5.112

DBA_LOCKS synonym for DBA_LOCK view, 5.113

DBA_LOG_GROUP_COLUMNS view, 5.114

DBA_LOG_GROUPS view, 5.115

DBA_LOGMNR_LOG view, 5.116

DBA_LOGMNR_PURGED_LOG view, 5.117

DBA_LOGMNR_SESSION view, 5.118

DBA_LOGSTDBY_EVENTS view, 5.119

DBA_LOGSTDBY_HISTORY view, 5.120

DBA_LOGSTDBY_LOG view, 5.121

DBA_LOGSTDBY_NOT_UNIQUE view, 5.122

DBA_LOGSTDBY_PARAMETERS view, 5.123

DBA_LOGSTDBY_PROGRESS view, 5.124

DBA_LOGSTDBY_SKIP view, 5.125

DBA_LOGSTDBY_SKIP_TRANSACTION view, 5.126

DBA_LOGSTDBY_UNSUPPORTED view, 5.127

DBA_LOGSTDBY_UNSUPPORTED_TABLE view, 5.128

LOGSTDBY_UNSUPPORTED_TABLES synonym, 6.139

DBA_MEASURE_FOLDER_CONTENTS view, 5.129

DBA_MEASURE_FOLDERS view, 5.130

DBA_METHOD_PARAMS view, 5.131

DBA_METHOD_RESULTS view, 5.132

DBA_MINING_MODEL_ATTRIBUTES view, 5.133

DBA_MINING_MODEL_SETTINGS view, 5.134

DBA_MINING_MODELS view, 5.135

DBA_MVIEW_AGGREGATES view, 5.136

DBA_MVIEW_ANALYSIS view, 5.137

DBA_MVIEW_COMMENTS view, 5.138

DBA_MVIEW_DETAIL_PARTITION view, 5.139

DBA_MVIEW_DETAIL_RELATIONS view, 5.140

DBA_MVIEW_DETAIL_SUBPARTITION view, 5.141

DBA_MVIEW_JOINS view, 5.142

DBA_MVIEW_KEYS view, 5.143

DBA_MVIEW_LOG_FILTER_COLS view, 5.144

DBA_MVIEW_LOGS view, 5.145

DBA_MVIEW_REFRESH_TIMES view, 5.146

DBA_MVIEWS view, 5.147

DBA_NESTED_TABLE_COLS view, 5.148

DBA_NESTED_TABLES view, 5.149

DBA_NETWORK_ACL_PRIVILEGES view, 5.150

DBA_NETWORK_ACLS view, 5.151

DBA_OBJ_AUDIT_OPTS view, 5.152

DBA_OBJ_COLATTRS view, 5.153

DBA_OBJECT_SIZE view, 5.154

DBA_OBJECT_TABLES view, 5.155

DBA_OBJECTS view, 5.156

DBA_OBJECTS_AE view, 5.157

DBA_OPANCILLARY view, 5.158

DBA_OPARGUMENTS view, 5.159

DBA_OPBINDINGS view, 5.160

DBA_OPERATOR_COMMENTS view, 5.161

DBA_OPERATORS view, 5.162

DBA_OPTSTAT_OPERATIONS view, 5.163

DBA_ORPHAN_KEY_TABLE view, 5.164

DBA_OUTLINE_HINTS view, 5.165

DBA_OUTLINES view, 5.166

DBA_OUTSTANDING_ALERTS view, 5.167

DBA_PARALLEL_EXECUTE_CHUNKS view, 5.168

DBA_PARALLEL_EXECUTE_TASKS view, 5.169

DBA_PART_COL_STATISTICS view, 5.170

DBA_PART_HISTOGRAMS view, 5.171

DBA_PART_INDEXES view, 5.172

DBA_PART_KEY_COLUMNS view, 5.173

DBA_PART_LOBS view, 5.174

DBA_PART_TABLES view, 5.175

DBA_PARTIAL_DROP_TABS view, 5.176

DBA_PENDING_CONV_TABLES view, 5.177

DBA_PENDING_TRANSACTIONS view, 5.178

DBA_PLSQL_OBJECT_SETTINGS view, 5.179

DBA_POLICIES view, 5.180

DBA_POLICY_CONTEXTS view, 5.181

DBA_POLICY_GROUPS view, 5.182

DBA_PRIV_AUDIT_OPTS view, 5.183

DBA_PROCEDURES view, 5.184

DBA_PROFILES view, 5.185

DBA_PROPAGATION view, 5.186

DBA_PROXIES view, 5.187

DBA_PUBLISHED_COLUMNS view, 5.188

DBA_QUEUE_SCHEDULES view, 5.189

DBA_QUEUE_SUBSCRIBERS view, 5.190

DBA_QUEUE_TABLES view, 5.191

DBA_QUEUES view, 5.192

DBA_RCHILD view, 5.193

DBA_RECOVERABLE_SCRIPT view, 5.194

DBA_RECOVERABLE_SCRIPT_BLOCKS view, 5.195

DBA_RECOVERABLE_SCRIPT_ERRORS view, 5.196

DBA_RECOVERABLE_SCRIPT_HIST view, 5.197

DBA_RECOVERABLE_SCRIPT_PARAMS view, 5.198

DBA_RECYCLEBIN view, 5.199

DBA_REDEFINITION_ERRORS view, 5.200

DBA_REDEFINITION_OBJECTS view, 5.201

DBA_REFRESH view, 5.202

DBA_REFRESH_CHILDREN view, 5.203

DBA_REFS view, 5.204

DBA_REGISTERED_ARCHIVED_LOG view, 5.205

DBA_REGISTERED_MVIEW_GROUPS view, 5.206

DBA_REGISTERED_MVIEWS view, 5.207

DBA_REGISTRY view, 5.208

DBA_REGISTRY_HIERARCHY view, 5.209

DBA_REGISTRY_HISTORY view, 5.210

DBA_REGISTRY_LOG view, 5.211

DBA_REPAIR_TABLE view, 5.212

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.213

DBA_RESUMABLE view, 5.214

DBA_REWRITE_EQUIVALENCES view, 5.215

DBA_RGROUP view, 5.216

DBA_ROLE_PRIVS view, 5.217

DBA_ROLES view, 5.218

DBA_ROLLBACK_SEGS view, 5.219

DBA_RSRC_CATEGORIES view, 5.220

DBA_RSRC_CONSUMER_GROUP_PRIVS view, 5.221

DBA_RSRC_CONSUMER_GROUPS view, 5.222

DBA_RSRC_GROUP_MAPPINGS view, 5.223

DBA_RSRC_IO_CALIBRATE view, 5.224

DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 5.225

DBA_RSRC_MAPPING_PRIORITY view, 5.226

DBA_RSRC_PLAN_DIRECTIVES view, 5.227

DBA_RSRC_PLANS view, 5.228

DBA_RULE_SET_RULES view, 5.229

DBA_RULE_SETS view, 5.230

DBA_RULES view, 5.231

DBA_SCHEDULER_CHAIN_RULES view, 5.232

DBA_SCHEDULER_CHAIN_STEPS view, 5.233

DBA_SCHEDULER_CHAINS view, 5.234

DBA_SCHEDULER_CREDENTIALS view, 5.235

DBA_SCHEDULER_DB_DESTS view, 5.236

DBA_SCHEDULER_DESTS view, 5.237

DBA_SCHEDULER_EXTERNAL_DESTS view, 5.238

DBA_SCHEDULER_FILE_WATCHERS view, 5.239

DBA_SCHEDULER_GLOBAL_ATTRIBUTE view, 5.240

DBA_SCHEDULER_GROUP_MEMBERS view, 5.241

DBA_SCHEDULER_GROUPS view, 5.242

DBA_SCHEDULER_JOB_ARGS view, 5.243

DBA_SCHEDULER_JOB_CLASSES view, 5.244

DBA_SCHEDULER_JOB_DESTS view, 5.245

DBA_SCHEDULER_JOB_LOG view, 5.246

DBA_SCHEDULER_JOB_ROLES view, 5.247

DBA_SCHEDULER_JOB_RUN_DETAILS view, 5.248

DBA_SCHEDULER_JOBS view, 5.249

DBA_SCHEDULER_NOTIFICATIONS view, 5.250

DBA_SCHEDULER_PROGRAM_ARGS view, 5.251

DBA_SCHEDULER_PROGRAMS view, 5.252

DBA_SCHEDULER_REMOTE_DATABASES view, 5.253

DBA_SCHEDULER_REMOTE_JOBSTATE view, 5.254

DBA_SCHEDULER_RUNNING_CHAINS view, 5.255

DBA_SCHEDULER_RUNNING_JOBS view, 5.256

DBA_SCHEDULER_SCHEDULES view, 5.257

DBA_SCHEDULER_WINDOW_DETAILS view, 5.258

DBA_SCHEDULER_WINDOW_GROUPS view, 5.259

DBA_SCHEDULER_WINDOW_LOG view, 5.260

DBA_SCHEDULER_WINDOWS view, 5.261

DBA_SCHEDULER_WINGROUP_MEMBERS view, 5.262

DBA_SEC_RELEVANT_COLS view, 5.263

DBA_SECONDARY_OBJECTS view, 5.264

DBA_SEGMENTS view, 5.265

DBA_SEGMENTS_OLD view, 5.266

DBA_SEQUENCES view, 5.267

DBA_SERVER_REGISTRY view, 5.268

DBA_SERVICES view, 5.269

DBA_SOURCE view, 5.270

DBA_SOURCE_AE view, 5.271

DBA_SOURCE_TABLES view, 5.272

DBA_SQL_MANAGEMENT_CONFIG view, 5.273

DBA_SQL_PATCHES view, 5.274

DBA_SQL_PLAN_BASELINES view, 5.275

DBA_SQL_PROFILES view, 5.276

DBA_SQLJ_TYPE_ATTRS view, 5.277

DBA_SQLJ_TYPE_METHODS view, 5.278

DBA_SQLJ_TYPES view, 5.279

DBA_SQLSET view, 5.280

DBA_SQLSET_BINDS view, 5.281

DBA_SQLSET_PLANS view, 5.282

DBA_SQLSET_REFERENCES view, 5.283

DBA_SQLSET_STATEMENTS view, 5.284

DBA_SQLTUNE_BINDS view, 5.285

DBA_SQLTUNE_PLANS view, 5.286

DBA_SQLTUNE_RATIONALE_PLAN view, 5.287

DBA_SQLTUNE_STATISTICS view, 5.288

DBA_SSCR_CAPTURE view, 5.289

DBA_SSCR_RESTORE view, 5.290

DBA_STAT_EXTENSIONS view, 5.291

DBA_STMT_AUDIT_OPTS view, 5.292

DBA_STORED_SETTINGS view, 5.293

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.73

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.73

DDL_LOCK_TIMEOUT initialization parameter, 1.74

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.75

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.122

overriding default, 1.122

USER_DUMP_DEST, 1.265

DG_BROKER_CONFIG_FILEn initialization parameter, 1.76

DG_BROKER_START initialization parameter, 1.77

DIAGNOSTIC_DEST initialization parameter, 1.78

DICT synonym for DICTIONARY, 6.113

DICT_COLUMNS view, 6.114

DICTIONARY view, 6.115

DICT synonym, 6.113

disk drives

archiving destination, 1.122

DISK_ASYNCH_IO initialization parameter, 1.79

dispatcher processes

maximum number, 1.136

DISPATCHERS initialization parameter, 1.80

distinguished name, 1.202

DISTRIBUTED_LOCK_TIMEOUT initialization parameter, 1.81

DM_USER_MODELS view, 6.116

DML_LOCKS initialization parameter, 1.82

DOCUMENT_LINKS view, 6.117

downgrading

scripts, B.4

DST_UPGRADE_INSERT_CONV initialization parameter, 1.83

dump files, 1.137

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.101

ENABLE_DDL_LOGGING initialization parameter, 1.84

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.82

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.202

ERROR_SIZE view, 6.118

EVENT initialization parameter, 1.85

EXCEPTIONS table, 6.119

extent

allocating to instance, 1.104

---

F

FAL_CLIENT initialization parameter, 1.86

FAL_SERVER initialization parameter, 1.87

FAST_START_MTTR_TARGET initialization parameter, 1.88

FAST_START_PARALLEL_ROLLBACK initialization parameter, 1.89

FILE_MAPPING initialization parameter, 1.90

FILEIO_NETWORK_ADAPTERS initialization parameter, 1.91

filenames

case significance, 1.3.2.1.1

FILESYSTEMIO_OPTIONS initialization parameter, 1.92

FIXED_DATE initialization parameter, 1.93

FLASHBACK_TRANSACTION_QUERY view, 6.120

free space list

locating space, 1.104

FREELIST GROUPS clause, 1.104

---

G

GCS_SERVER_PROCESSES initialization parameter, 1.94

GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1.95

GLOBAL_NAME view, 6.121

GLOBAL_NAMES initialization parameter, 1.96

GLOBAL_TXN_PROCESSES initialization parameter, 1.97

GV$ views

for Real Application Clusters, 7.1.2

---

H

HASH_AREA_SIZE initialization parameter, 1.98

Heterogeneous Services

agents, 1.100

HI_SHARED_MEMORY_ADDRESS initialization parameter, 1.99

hints

precedence over initialization parameter settings, 1.240

HS_ALL_CAPS view, 6.122

HS_ALL_DD view, 6.123

HS_ALL_INITS view, 6.124

HS_AUTOREGISTER initialization parameter, 1.100

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.101

IND synonym for USER_INDEXES view, 6.136

INDEX_HISTOGRAM view, 6.137

INDEX_STATS view, 6.138

initialization parameter file

common file, 1.101

embedded, 1.101

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

AWR_SNAPSHOT_TIME_OFFSET, 1.18

BACKGROUND_CORE_DUMP, 1.19

BACKGROUND_DUMP_DEST, 1.20

BACKUP_TAPE_IO_SLAVES, 1.21

basic, 1.2

BITMAP_MERGE_AREA_SIZE, 1.22

BLANK_TRIMMING, 1.23

case significance in filenames, 1.3.2.1.1

CIRCUITS, 1.24

CLIENT_RESULT_CACHE_LAG, 1.25

CLIENT_RESULT_CACHE_SIZE, 1.26

CLONEDB, 1.27

CLUSTER_DATABASE, 1.28

CLUSTER_DATABASE_INSTANCES, 1.29

CLUSTER_INTERCONNECTS, 1.30

COMMIT_LOGGING, 1.31

COMMIT_POINT_STRENGTH, 1.32

COMMIT_WAIT, 1.33

COMMIT_WRITE, 1.34

COMPATIBLE, 1.35

CONTROL_FILE_RECORD_KEEP_TIME, 1.36

CONTROL_FILES, 1.37

CONTROL_MANAGEMENT_PACK_ACCESS, 1.38

CORE_DUMP_DEST, 1.39

CPU_COUNT, 1.40

CREATE_BITMAP_AREA_SIZE, 1.41

CREATE_STORED_OUTLINES, 1.42

CURSOR_BIND_CAPTURE_DESTINATION, 1.43

CURSOR_SHARING, 1.44

CURSOR_SPACE_FOR_TIME, 1.45

DB_BLOCK_BUFFERS, 1.47

DB_BLOCK_CHECKING, 1.48

DB_BLOCK_CHECKSUM, 1.49

DB_BLOCK_SIZE, 1.50

DB_CACHE_ADVICE, 1.51

DB_CACHE_SIZE, 1.52

DB_CREATE_FILE_DEST, 1.53

DB_CREATE_ONLINE_LOG_DEST_n, 1.54

DB_DOMAIN, 1.55

DB_FILE_MULTIBLOCK_READ_COUNT, 1.56

DB_FILE_NAME_CONVERT, 1.57

DB_FILES, 1.58

DB_FLASH_CACHE_FILE, 1.59

DB_FLASH_CACHE_SIZE, 1.60

DB_FLASHBACK_RETENTION_TARGET, 1.61

DB_KEEP_CACHE_SIZE, 1.62

DB_LOST_WRITE_PROTECT, 1.63

DB_NAME, 1.64

DB_nK_CACHE_SIZE, 1.46

DB_RECOVERY_FILE_DEST, 1.65

DB_RECOVERY_FILE_DEST_SIZE, 1.66

DB_RECYCLE_CACHE_SIZE, 1.67

DB_SECUREFILE, 1.68

DB_ULTRA_SAFE, 1.69

DB_UNIQUE_NAME, 1.70

DB_UNRECOVERABLE_SCN_TRACKING, 1.71

DB_WRITER_PROCESSES, 1.72

DBWR_IO_SLAVES, 1.73

DDL_LOCK_TIMEOUT, 1.74

DEFERRED_SEGMENT_CREATION, 1.75

derived, 1.1.1.1

DG_BROKER_CONFIG_FILEn, 1.76

DG_BROKER_START, 1.77

DIAGNOSTIC_DEST, 1.78

DISK_ASYNCH_IO, 1.79

DISPATCHERS, 1.80

display current settings, 1.4.3

DISTRIBUTED_LOCK_TIMEOUT, 1.81

DML_LOCKS, 1.82

DST_UPGRADE_INSERT_CONV, 1.83

embedded initialization parameter files, 1.3.2.1.1

ENABLE_DDL_LOGGING, 1.84

EVENT, 1.85

FAL_CLIENT, 1.86

FAL_SERVER, 1.87

FAST_START_MTTR_TARGET, 1.88

FAST_START_PARALLEL_ROLLBACK, 1.89

FILE_MAPPING, 1.90

FILEIO_NETWORK_ADAPTERS, 1.91

FILESYSTEMIO_OPTIONS, 1.92

FIXED_DATE, 1.93

functional category, 1.4.1

GCS_SERVER_PROCESSES, 1.94

GLOBAL_CONTEXT_POOL_SIZE, 1.95

GLOBAL_NAMES, 1.96

GLOBAL_TXN_PROCESSES, 1.97

HASH_AREA_SIZE, 1.98

HI_SHARED_MEMORY_ADDRESS, 1.99

HS_AUTOREGISTER, 1.100

IFILE, 1.3.2.1.1, 1.101

INSTANCE_GROUPS, 1.102

INSTANCE_NAME, 1.103

INSTANCE_NUMBER, 1.104

INSTANCE_TYPE, 1.105

JAVA_JIT_ENABLED, 1.106

JAVA_MAX_SESSIONSPACE_SIZE, 1.107

JAVA_POOL_SIZE, 1.108

JAVA_SOFT_SESSIONSPACE_LIMIT, 1.109

JOB_QUEUE_PROCESSES, 1.110

LARGE_POOL_SIZE, 1.111

LDAP_DIRECTORY_ACCESS, 1.112

LDAP_DIRECTORY_SYSAUTH, 1.113

LICENSE_MAX_SESSIONS, 1.114

LICENSE_MAX_USERS, 1.115

LICENSE_SESSIONS_WARNING, 1.116

LISTENER_NETWORKS, 1.117

LOCAL_LISTENER, 1.118

LOCK_NAME_SPACE, 1.119

LOCK_SGA, 1.120

LOG_ARCHIVE_CONFIG, 1.121

LOG_ARCHIVE_DEST, 1.122

LOG_ARCHIVE_DEST_n, 1.123

LOG_ARCHIVE_DEST_STATE_n, 1.124

LOG_ARCHIVE_DUPLEX_DEST, 1.125

LOG_ARCHIVE_FORMAT, 1.126

LOG_ARCHIVE_LOCAL_FIRST, 1.127

LOG_ARCHIVE_MAX_PROCESSES, 1.128

LOG_ARCHIVE_MIN_SUCCEED_DEST, 1.129

LOG_ARCHIVE_TRACE, 1.130

LOG_BUFFER, 1.131

LOG_CHECKPOINT_INTERVAL, 1.132

LOG_CHECKPOINT_TIMEOUT, 1.133

LOG_CHECKPOINTS_TO_ALERT, 1.134

LOG_FILE_NAME_CONVERT, 1.135

MAX_DISPATCHERS, 1.136

MAX_DUMP_FILE_SIZE, 1.137

MAX_ENABLED_ROLES, 1.138

MAX_SHARED_SERVERS, 1.139

MEMORY_MAX_TARGET, 1.140

MEMORY_TARGET, 1.141

modifiable, 1.4.2

NLS_CALENDAR, 1.142

NLS_COMP, 1.143

NLS_CURRENCY, 1.144

NLS_DATE_FORMAT, 1.145

NLS_DATE_LANGUAGE, 1.146

NLS_DUAL_CURRENCY, 1.147

NLS_ISO_CURRENCY, 1.148

NLS_LANGUAGE, 1.149

NLS_LENGTH_SEMANTICS, 1.150

NLS_NCHAR_CONV_EXCP, 1.151

NLS_NUMERIC_CHARACTERS, 1.152

NLS_SORT, 1.153

NLS_TERRITORY, 1.154

NLS_TIMESTAMP_FORMAT, 1.155

NLS_TIMESTAMP_TZ_FORMAT, 1.156

O7_DICTIONARY_ACCESSIBILITY, 1.157

OBJECT_CACHE_MAX_SIZE_PERCENT, 1.158

OBJECT_CACHE_OPTIMAL_SIZE, 1.159

OLAP_PAGE_POOL_SIZE, 1.160

OPEN_CURSORS, 1.161

OPEN_LINKS, 1.162

OPEN_LINKS_PER_INSTANCE, 1.163

operating system-dependent values, 1.1.1.2

OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES, 1.164

OPTIMIZER_DYNAMIC_SAMPLING, 1.165

OPTIMIZER_FEATURES_ENABLE, 1.166

OPTIMIZER_INDEX_CACHING, 1.167

OPTIMIZER_INDEX_COST_ADJ, 1.168

OPTIMIZER_MODE, 1.169

OPTIMIZER_SECURE_VIEW_MERGING, 1.170

OPTIMIZER_USE_INVISIBLE_INDEXES, 1.171

OPTIMIZER_USE_PENDING_STATISTICS, 1.172

OPTIMIZER_USE_SQL_PLAN_BASELINES, 1.173

OS_AUTHENT_PREFIX, 1.174

OS_ROLES, 1.175

PARALLEL_ADAPTIVE_MULTI_USER, 1.176

PARALLEL_AUTOMATIC_TUNING, 1.177

PARALLEL_DEGREE_LIMIT, 1.178

PARALLEL_DEGREE_POLICY, 1.179

PARALLEL_EXECUTION_MESSAGE_SIZE, 1.180

PARALLEL_FORCE_LOCAL, 1.181

PARALLEL_INSTANCE_GROUP, 1.182

PARALLEL_IO_CAP_ENABLED, 1.183

PARALLEL_MAX_SERVERS, 1.184

PARALLEL_MIN_PERCENT, 1.185

PARALLEL_MIN_SERVERS, 1.186

PARALLEL_MIN_TIME_THRESHOLD, 1.187

PARALLEL_SERVERS_TARGET, 1.188

PARALLEL_THREADS_PER_CPU, 1.189

parameter files, 1.3

performance tuning, 1.1.1.3

PGA_AGGREGATE_TARGET, 1.190

PLSCOPE_SETTINGS, 1.191

PLSQL_CCFLAGS, 1.192

PLSQL_CODE_TYPE, 1.193

PLSQL_DEBUG, 1.194

PLSQL_OPTIMIZE_LEVEL, 1.195

PLSQL_V2_COMPATIBILITY, 1.196

PLSQL_WARNINGS, 1.197

PRE_PAGE_SGA, 1.198

PROCESSES, 1.199

QUERY_REWRITE_ENABLED, 1.200

QUERY_REWRITE_INTEGRITY, 1.201

RDBMS_SERVER_DN, 1.202

READ_ONLY_OPEN_DELAYED, 1.203

RECOVERY_PARALLELISM, 1.204

RECYCLEBIN, 1.205

REDO_TRANSPORT_USER, 1.206

REMOTE_DEPENDENCIES_MODE, 1.207

REMOTE_LISTENER, 1.208

REMOTE_LOGIN_PASSWORDFILE, 1.209

REMOTE_OS_AUTHENT, 1.210

REMOTE_OS_ROLES, 1.211

REPLICATION_DEPENDENCY_TRACKING, 1.212

RESOURCE_LIMIT, 1.213

RESOURCE_MANAGER_CPU_ALLOCATION, 1.214

RESOURCE_MANAGER_PLAN, 1.215

RESULT_CACHE_MAX_RESULT, 1.216

RESULT_CACHE_MAX_SIZE, 1.217

RESULT_CACHE_MODE, 1.218

RESULT_CACHE_REMOTE_EXPIRATION, 1.219

RESUMABLE_TIMEOUT, 1.220

ROLLBACK_SEGMENTS, 1.221

SEC_CASE_SENSITIVE_LOGON, 1.222

SEC_MAX_FAILED_LOGIN_ATTEMPTS, 1.223

SEC_PROTOCOL_ERROR_FURTHER_ACTION, 1.224

SEC_PROTOCOL_ERROR_TRACE_ACTION, 1.225

SEC_RETURN_SERVER_RELEASE_BANNER, 1.226

SERIAL_REUSE, 1.227

SERVICE_NAMES, 1.228

SESSION_CACHED_CURSORS, 1.229

SESSION_MAX_OPEN_FILES, 1.230

SESSIONS, 1.231

SGA_MAX_SIZE, 1.232

SGA_TARGET, 1.233

SHADOW_CORE_DUMP, 1.234

SHARED_MEMORY_ADDRESS, 1.235

SHARED_POOL_RESERVED_SIZE, 1.236

SHARED_POOL_SIZE, 1.237

SHARED_SERVER_SESSIONS, 1.238

SHARED_SERVERS, 1.239

SKIP_UNUSABLE_INDEXES, 1.240

SMTP_OUT_SERVER, 1.241

SORT_AREA_RETAINED_SIZE, 1.242

SORT_AREA_SIZE, 1.243

specifying in initialization parameter files, 1.3.2.1

SPFILE, 1.244

SQL_TRACE, 1.245

SQL92_SECURITY, 1.246

SQLTUNE_CATEGORY, 1.247

STANDBY_ARCHIVE_DEST, 1.248

STANDBY_FILE_MANAGEMENT, 1.249

STAR_TRANSFORMATION_ENABLED, 1.250

STATISTICS_LEVEL, 1.251

STREAMS_POOL_SIZE, 1.252

TAPE_ASYNCH_IO, 1.253

THREAD, 1.254

TIMED_OS_STATISTICS, 1.255

TIMED_STATISTICS, 1.256

TRACE_ENABLED, 1.257

TRACEFILE_IDENTIFIER, 1.258

TRANSACTIONS, 1.259

TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1.260

UNDO_MANAGEMENT, 1.261

UNDO_RETENTION, 1.262

UNDO_TABLESPACE, 1.263

USE_INDIRECT_DATA_BUFFERS, 1.264

USER_DUMP_DEST, 1.265

UTL_FILE_DIR, 1.266

variable, 1.1.1.3

WORKAREA_SIZE_POLICY, 1.267

XML_DB_EVENTS, 1.268

INITJVM.SQL script, B.5

INIT.ORA file. See initialization parameter file

IN-list iterators

optimizer use of, 1.167

inserts

locating free space, 1.104

INST_ID column, 7.1.2

INSTANCE clause

of ALTER TABLE

allocating extents, 1.104

INSTANCE_GROUPS initialization parameter, 1.102

INSTANCE_NAME initialization parameter, 1.103

INSTANCE_NUMBER initialization parameter, 1.104

INSTANCE_TYPE initialization parameter, 1.105

instances

checkpoint, 1.132

startup order, 1.104

I/O

reading multiple blocks, 1.56

redo log files, 1.131

---

J

Java initialization parameters

JAVA_MAX_SESSIONSPACE_SIZE, 1.107

JAVA_POOL_SIZE, 1.108

JAVA_SOFT_SESSIONSPACE_LIMIT, 1.109

Java scripts, B.5

JAVA_JIT_ENABLED initialization parameter, 1.106

JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1.107

JAVA_POOL_SIZE initialization parameter, 1.108

JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1.109

JOB_QUEUE_PROCESSES initialization parameter, 1.110

---

L

language

database default language, 1.149

LARGE_POOL_SIZE initialization parameter, 1.111

LDAP_DIRECTORY_ACCESS initialization parameter, 1.112

LDAP_DIRECTORY_SYSAUTH initialization parameter, 1.113

LICENSE_MAX_SESSIONS initialization parameter, 1.114

LICENSE_MAX_USERS initialization parameter, 1.115

LICENSE_SESSIONS_WARNING initialization parameter, 1.116

licenses

maximum sessions, 1.114

maximum users, 1.115

warning for concurrent user sessions, 1.116

limits on the database, A

linguistic sorts, 1.153

LISTENER_NETWORKS initialization parameter, 1.117

local currency, 1.143, 1.144

LOCAL_LISTENER initialization parameter, 1.118

LOCK_NAME_SPACE initialization parameter, 1.119

LOCK_SGA initialization parameter, 1.120

locks

names, C.2

LOG_ARCHIVE_CONFIG initialization parameter, 1.121

LOG_ARCHIVE_DEST initialization parameter, 1.122

LOG_ARCHIVE_DEST_n initialization parameter, 1.123

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1.124

LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1.125

LOG_ARCHIVE_FORMAT initialization parameter, 1.126

LOG_ARCHIVE_LOCAL_FIRST initialization parameter, 1.127

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1.128

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1.129

LOG_ARCHIVE_TRACE initialization parameter, 1.130

LOG_BUFFER initialization parameter, 1.131

LOG_CHECKPOINT_INTERVAL initialization parameter, 1.132

LOG_CHECKPOINT_TIMEOUT initialization parameter, 1.133

LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1.134

LOG_FILE_NAME_CONVERT initialization parameter, 1.135

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.136

MAX_DUMP_FILE_SIZE initialization parameter, 1.137

MAX_ENABLED_ROLES initialization parameter, 1.138

MAX_SHARED_SERVERS initialization parameter, 1.139

memory

amount used for sorting, 1.242

virtual, 1.1.1.3

MEMORY_MAX_TARGET initialization parameter, 1.140

MEMORY_TARGET initialization parameter, 1.141

monitor

performance, 1.132

multiple-process systems

number of processes, 1.199

---

N

NLS_CALENDAR initialization parameter, 1.142

NLS_COMP initialization parameter, 1.143

NLS_CURRENCY initialization parameter, 1.144

defined by NLS_TERRITORY, 1.154

NLS_DATABASE_PARAMETERS view, 6.141

NLS_DATE_FORMAT initialization parameter, 1.145

defined by NLS_NUMERIC_CHARACTERS, 1.152

defined by NLS_TERRITORY, 1.154

NLS_DATE_LANGUAGE initialization parameter, 1.146

NLS_DUAL_CURRENCY initialization parameter, 1.147

NLS_INSTANCE_PARAMETERS view, 6.142

NLS_ISO_CURRENCY initialization parameter, 1.148

defined by NLS_TERRITORY, 1.154

NLS_LANGUAGE initialization parameter, 1.149

NLS_LENGTH_SEMANTICS initialization parameter, 1.150

NLS_NCHAR_CONV_EXCP initialization parameter, 1.151

NLS_NUMERIC_CHARACTERS initialization parameter, 1.152

NLS_SESSION_PARAMETERS view, 6.143

NLS_SORT initialization parameter, 1.153

NLS_TERRITORY initialization parameter, 1.154

NLS_TIME_FORMAT, 8.75

NLS_TIME_TZ_FORMAT, 8.75

NLS_TIMESTAMP_FORMAT initialization parameter, 1.155

NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1.156

numeric group separators, 1.152

---

O

O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1.157

OBJ synonym for USER_OBJECTS view, 6.144

OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1.158

OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1.159

objects

data dictionary, 2.1

OLAP_PAGE_POOL_SIZE initialization parameter, 1.160

online redo log

archiving mode, 1.122

block, 1.132

file size, 1.132

setting checkpoint interval, 1.132

OPEN_CURSORS initialization parameter, 1.161

OPEN_LINKS initialization parameter, 1.162

OPEN_LINKS_PER_INSTANCE initialization parameter, 1.163

operating system

authenticating remote clients, 1.210

authenticating users and passwords, 1.174

dependent parameters, 1.1.1.2

roles for remote clients, 1.211

optimization

trading cursor space for time, 1.45

OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES initialization parameter, 1.164

OPTIMIZER_DYNAMIC_SAMPLING initialization parameter, 1.165

OPTIMIZER_FEATURES_ENABLE initialization parameter, 1.166

OPTIMIZER_INDEX_CACHING initialization parameter, 1.167

OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1.168

OPTIMIZER_MODE initialization parameter, 1.169

OPTIMIZER_SECURE_VIEW_MERGING initialization parameter, 1.170

OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter, 1.171

OPTIMIZER_USE_PENDING_STATISTICS initialization parameter, 1.172

OPTIMIZER_USE_SQL_PLAN_BASELINES initialization parameter, 1.173

ORPHAN_KEY_TABLE table. See DBA_ORPHAN_KEY_TABLE view

OS_AUTHENT_PREFIX initialization parameter, 1.174

OS_ROLES initialization parameter, 1.175

---

P

parallel query

maximum number of instances, 1.180

maximum number of servers, 1.184

minimum number of queries, 1.186

PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1.176

PARALLEL_AUTOMATIC_TUNING initialization parameter, 1.177

PARALLEL_DEGREE_LIMIT initialization parameter, 1.178

PARALLEL_DEGREE_POLICY initialization parameter, 1.179

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1.180

PARALLEL_FORCE_LOCAL initialization parameter, 1.181

PARALLEL_INSTANCE_GROUP initialization parameter, 1.182

PARALLEL_IO_CAP_ENABLED initialization parameter, 1.183

PARALLEL_MAX_SERVERS initialization parameter, 1.184

PARALLEL_MIN_PERCENT initialization parameter, 1.185

PARALLEL_MIN_SERVERS initialization parameter, 1.186

PARALLEL_MIN_TIME_THRESHOLD initialization parameter, 1.187

PARALLEL_SERVERS_TARGET initialization parameter, 1.188

PARALLEL_THREADS_PER_CPU initialization parameter, 1.189

passwords

authenticating, 1.174, 1.210

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.209

PATH_VIEW view, 6.145

performance, 1.1.1.3

shared pool, 1.237

PGA_AGGREGATE_TARGET initialization parameter, 1.190

PLAN_TABLE table, 6.146

PLSCOPE_SETTINGS initialization parameter, 1.191

PLSQL_CCFLAGS initialization parameter, 1.192

PLSQL_CODE_TYPE initialization parameter, 1.193

PLSQL_DEBUG initialization parameter, 1.194

PLSQL_OPTIMIZE_LEVEL initialization parameter, 1.195

PLSQL_V2_COMPATIBILITY initialization parameter, 1.196

PLSQL_WARNINGS initialization parameter, 1.197

PLUGGABLE_SET_CHECK view, 6.147

PRE_PAGE_SGA initialization parameter, 1.198

privileges

remote login, 1.209

RESTRICTED_SESSION privilege, 1.114, 1.116

table-level select privileges, 1.246

procedures

shared pool, 1.237

processes

dispatcher process maximum number, 1.136

maximum shared server processes, 1.139

number of server processes, 1.107, 1.109, 1.238, 1.239

recovery, 1.204

trace files, 1.265

user processes, 1.199

PROCESSES initialization parameter, 1.199

PRODUCT_COMPONENT_VERSION view, 6.148

profiles

resource limits, 1.213, 1.215

PROXY_USERS view, 6.149

PSTUBTBL table, 6.150

PUBLIC clause

of ALTER DATABASE

thread of redo, 1.254

PUBLIC_DEPENDENCY view, 6.151

PUBLICSYN view, 6.152

---

Q

queries

hints, 1.169

QUERY_REWRITE_ENABLED initialization parameter, 1.200

QUERY_REWRITE_INTEGRITY initialization parameter, 1.201

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.202

READ_ONLY_OPEN_DELAYED initialization parameter, 1.203

Real Application Clusters

dynamic performance views, 7.1.2

initialization parameters

CIRCUITS, 1.24

CLUSTER_DATABASE, 1.28

CLUSTER_DATABASE_INSTANCES, 1.29

CLUSTER_INTERCONNECTS, 1.30

DISPATCHERS, 1.80

FAST_START_PARALLEL_ROLLBACK, 1.89

PARALLEL_ADAPTIVE_MULTI_USER, 1.176

PARALLEL_AUTOMATIC_TUNING, 1.177

PARALLEL_EXECUTION_MESSAGE_SIZE, 1.180

PARALLEL_INSTANCE_GROUP, 1.182

PARALLEL_MAX_SERVERS, 1.184

PARALLEL_MIN_PERCENT, 1.185

PARALLEL_MIN_SERVERS, 1.186

PARALLEL_THREADS_PER_CPU, 1.189

recovery

number of required processes, 1.204

RECOVERY_PARALLELISM initialization parameter, 1.204

RECYCLEBIN initialization parameter, 1.205

RECYCLEBIN synonym for USER_RECYCLEBIN view, 6.154

redo logs

buffer size, 1.131

redo thread, 1.254

REDO_TRANSPORT_USER initialization parameter, 1.206

remote clients

authenticating, 1.210

remote logins, 1.209

REMOTE_DEPENDENCIES_MODE initialization parameter, 1.207

REMOTE_LISTENER initialization parameter, 1.208

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.209

REMOTE_OS_AUTHENT initialization parameter, 1.210

REMOTE_OS_ROLES initialization parameter, 1.211

REPAIR_TABLE table. See DBA_REPAIR_TABLE view

REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1.212

REPORT_COMPONENTS view, 6.155

REPORT_FILES view, 6.156

REPORT_FORMATS view, 6.157

resource limits for profiles, 1.213, 1.215

RESOURCE_COST view, 6.158

RESOURCE_LIMIT initialization parameter, 1.213

RESOURCE_MANAGER_CPU_ALLOCATION initialization parameter, 1.214

RESOURCE_MANAGER_PLAN initialization parameter, 1.215

RESOURCE_MAP table, 6.159

RESOURCE_VIEW view, 6.160

RESULT_CACHE_MAX_RESULT initialization parameter, 1.216

RESULT_CACHE_MAX_SIZE initialization parameter, 1.217

RESULT_CACHE_MODE initialization parameter, 1.218

RESULT_CACHE_REMOTE_EXPIRATION initialization parameter, 1.219

RESUMABLE_TIMEOUT initialization parameter, 1.220

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.175

remote clients, 1.211

ROLLBACK_SEGMENTS initialization parameter, 1.221

---

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.222

SEC_MAX_FAILED_LOGIN_ATTEMPTS initialization parameter, 1.223

SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter, 1.224

SEC_PROTOCOL_ERROR_TRACE_ACTION initialization parameter, 1.225

SEC_RETURN_SERVER_RELEASE_BANNER initialization parameter, 1.226

SEQ synonym for USER_SEQUENCES view, 6.165

SERIAL_REUSE initialization parameter, 1.227

server parameter file

overview, 1.3

server processes

number, 1.107, 1.109, 1.238, 1.239

SERVICE_NAMES initialization parameter, 1.228

SESSION_CACHED_CURSORS initialization parameter, 1.229

SESSION_CONTEXT view, 6.166

SESSION_MAX_OPEN_FILES initialization parameter, 1.230

SESSION_PRIVS view, 6.167

SESSION_ROLES view, 6.168

SESSIONS initialization parameter, 1.231

SGA_MAX_SIZE initialization parameter, 1.232

SGA_TARGET initialization parameter, 1.233

SHADOW_CORE_DUMP initialization parameter, 1.234

shared server

SESSIONS initialization parameter, 1.231

shared server processes

maximum number, 1.139

SHARED_MEMORY_ADDRESS initialization parameter, 1.235

SHARED_POOL_RESERVED_SIZE initialization parameter, 1.236

SHARED_POOL_SIZE initialization parameter, 1.237

SHARED_SERVER_SESSIONS initialization parameter, 1.238

SHARED_SERVERS initialization parameter, 1.239

SHOW PARAMETERS command, 1.4.3

SKIP_UNUSABLE_INDEXES initialization parameter, 1.240

SMTP_OUT_SERVER initialization parameter, 1.241

SORT_AREA_RETAINED_SIZE initialization parameter, 1.242

SORT_AREA_SIZE initialization parameter, 1.243

sorting

maximum memory, 1.242

ORDER BY queries, 1.153

SOURCE_SIZE view, 6.169

SPFILE initialization parameter, 1.244

SQL scripts

creating the data dictionary, B.1

optional, B.2

required, B.1

SQL_TRACE initialization parameter, 1.245

SQL92_SECURITY initialization parameter, 1.246

SQLTUNE_CATEGORY initialization parameter, 1.247

STANDBY_ARCHIVE_DEST initialization parameter, 1.248

STANDBY_FILE_MANAGEMENT initialization parameter, 1.249

STAR_TRANSFORMATION_ENABLED initialization parameter, 1.250

starting up

instance number, 1.104

startup order, 1.104

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.132, 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

flash cache eviction: aged out, E.2

flash cache eviction: buffer pinned, E.2

flash cache eviction: invalidated, E.2

flash cache insert skip: corrupt, E.2

flash cache insert skip: DBWR overloaded, E.2

flash cache insert skip: exists, E.2

flash cache insert skip: modification, E.2

flash cache insert skip: not current, E.2

flash cache insert skip: not useful, E.2

flash cache inserts, 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 flash cache hits, E.2

physical read IO requests, E.2

physical read requests optimized, 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 cache prefetch, E.2

physical reads direct, E.2

physical reads direct (lob), E.2

physical reads direct temporary tablespace, 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 direct (lob), E.2

physical writes direct temporary tablespace, E.2

physical writes from cache, E.2

physical writes non checkpoint, E.2

pinned buffers inspected, 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.256

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.251

STMT_AUDIT_OPTION_MAP table, 6.170

STREAMS_POOL_SIZE initialization parameter, 1.252

switch redo log file, 1.132

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.131

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.82

locating free space, 1.104

TABQUOTAS view, 6.180

TABS synonym for USER_TABLES view, 6.181

tape archiving destination, 1.122

TAPE_ASYNCH_IO initialization parameter, 1.253

territory, 1.147, 1.154

THREAD initialization parameter, 1.254

TIMED_OS_STATISTICS initialization parameter, 1.255

TIMED_STATISTICS initialization parameter, 1.256

file read/write statistics, 7.139, 9.108

TO_CHAR function, 1.145

TO_DATE function, 1.145

trace files

destination, 1.265

maximum size, 1.137

TRACE_ENABLED initialization parameter, 1.257

TRACEFILE_IDENTIFIER initialization parameter, 1.258

transactions

data locking, 1.82

TRANSACTIONS initialization parameter, 1.259

DML locks, 1.82

TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1.260

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.261

UNDO_RETENTION initialization parameter, 1.262

UNDO_TABLESPACE initialization parameter, 1.263

UNI_PLUGGABLE_SET_CHECK view, 6.185

updates

locating free space, 1.104

upgrading

scripts, B.4

uppercase characters, 1.3.2.1.1

USE_INDIRECT_DATA_BUFFERS initialization parameter, 1.264

user processes

trace files, 1.265

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.265

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.174

multiple, 1.82

UTL_FILE_DIR initialization parameter, 1.266

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$HANG_INFO view, 7.162

V$HANG_SESSION_INFO view, 7.163

V$HM_CHECK view, 7.164

V$HM_CHECK_PARAM view, 7.165

V$HM_FINDING view, 7.166

V$HM_INFO view, 7.167

V$HM_RECOMMENDATION view, 7.168

V$HM_RUN view, 7.169

V$HS_AGENT view, 7.170

V$HS_PARAMETER view, 7.171

V$HS_SESSION view, 7.172

V$HVMASTER_INFO view, 7.173

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$XSTREAM_CAPTURE view, 9.129

V$XSTREAM_MESSAGE_TRACKING view, 9.130

V$XSTREAM_OUTBOUND_SERVER view, 9.131

V$XSTREAM_TRANSACTION view, 9.132

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 sync, C.3.39

direct path write, C.3.40

Disk file operations I/O, C.3.41

dispatcher shutdown, C.3.42

dispatcher timer, C.3.43

duplicate cluster key, C.3.44

enq: OW - initialization, C.3.45

enq: OW - termination, C.3.46

enqueue, C.3.47

flashback buf free by RVWR, C.3.48

flashback logfile sync, C.3.49

free buffer waits, C.3.50

free global transaction table entry, C.3.51

free process state object, C.3.52

gc recovery quiesce, C.3.53

GCS lock open S, C.3.54

GCS lock open X, C.3.55

gcs remastering wait for drop pkey, C.3.56

global cache busy, C.3.57

global cache freelist, C.3.59

global cache lock cleanup, C.3.58

inactive session, C.3.60

inactive transaction branch, C.3.61

index block split, C.3.62

instance state change, C.3.63

io done, C.3.64

kcl bg acks, C.3.65

ksxr wait for mount shared, C.3.66

ktm: instance recovery, C.3.67

latch activity, C.3.68

latch free, C.3.69

library cache load lock, C.3.70

library cache lock, C.3.71

library cache pin, C.3.72

LMON global data update, C.3.74

lock manager wait for remote message, C.3.75

Log archive I/O, C.3.76

log buffer space, C.3.77

log file parallel write, C.3.78

log file sequential read, C.3.79

log file single write, C.3.80

log file switch (archiving needed), C.3.81

log file switch (checkpoint incomplete), C.3.82

log file switch (clearing log file), C.3.83

log file switch (private strand flush incomplete), C.3.84

log file switch completion, C.3.85

log file sync, C.3.86

log switch/archive, C.3.87

optimizer stats update retry, C.3.88

parallel recovery change buffer free, C.3.89

parallel recovery control message reply, C.3.90

parallel recovery coord send blocked, C.3.91

parallel recovery coord wait for reply, C.3.92

parallel recovery coordinator waits for slave cleanup, C.3.93

parallel recovery read buffer free, C.3.94

parallel recovery slave next change, C.3.95

pending global transaction(s), C.3.96

pipe get, C.3.97

pipe put, C.3.98

PL/SQL lock timer, C.3.99

pmon timer, C.3.100

prewarm transfer retry, C.3.101

prior process spawner to be cleaned up, C.3.102

process startup, C.3.103

PX dequeue wait, C.3.104

PX qref latch, C.3.105

PX server shutdown, C.3.106

PX signal server, C.3.107

rdbms ipc message, C.3.108

rdbms ipc message block, C.3.109

rdbms ipc reply, C.3.110

read by other session, C.3.111

recovery read, C.3.112

resmgr:become active, C.3.113

resmgr:cpu quantum, C.3.114

resmgr:pq queued, C.3.115

rolling migration: cluster quiesce, C.3.116

row cache lock, C.3.117

RVWR wait for flashback copy, C.3.118

sbtbufinfo, C.3.119

sbtgetbuf, C.3.120

sbtmapbuf, C.3.121

sbtrelbuf, C.3.122

scginq AST call, C.3.123

SGA: allocation forcing component growth, C.3.124

SGA: MMAN sleep for component shrink, C.3.125

SGA: sga_target resize, C.3.126

Shared IO Pool Memory, C.3.127

shared server idle event, C.3.129

single-task message, C.3.128

smon timer, C.3.130

SQL*Net break/reset to client, C.3.131

SQL*Net break/reset to dblink, C.3.132

SQL*Net message from client, C.3.133

SQL*Net message from dblink, C.3.134

SQL*Net message to client, C.3.135

SQL*Net message to dblink, C.3.136

SQL*Net more data from client, C.3.137

SQL*Net more data from dblink, C.3.138

SQL*Net more data to client, C.3.139

SQL*Net more data to dblink, C.3.140

Streams AQ: waiting for messages in the queue, C.3.141

switch logfile command, C.3.142

timer in sksawat, C.3.144

transaction, C.3.145

unbound tx, C.3.146

undo segment extension, C.3.148

undo segment recovery, C.3.149

undo segment tx slot, C.3.150

undo_retention publish retry, C.3.147

virtual circuit status, C.3.151

virtual circuit wait, C.3.152

WCR: replay client notify, C.3.153

WCR: replay clock, C.3.154

WCR: replay lock order, C.3.155

WCR: replay paused, C.3.156

WCR: Sync context busy, C.3.157

WMON goes to sleep, C.3.158

write complete waits, C.3.159

writes stopped by instance recovery or database suspension, C.3.160

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.267

---

X

XML_DB_EVENTS initialization parameter, 1.268

XS_SESSION_ROLES view, 6.508