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_ATTRIBUTE_TRANSFORMATIONS view, 2.19

ALL_AUDIT_POLICIES view, 2.20

ALL_AUDIT_POLICY_COLUMNS view, 2.21

ALL_AW_PS view, 2.22

ALL_AWS view, 2.23

ALL_BASE_TABLE_MVIEWS view, 2.24

ALL_CAPTURE view, 2.25

ALL_CAPTURE_EXTRA_ATTRIBUTES view, 2.26

ALL_CAPTURE_PARAMETERS view, 2.27

ALL_CAPTURE_PREPARED_DATABASE view, 2.28

ALL_CAPTURE_PREPARED_SCHEMAS view, 2.29

ALL_CAPTURE_PREPARED_TABLES view, 2.30

ALL_CATALOG view, 2.31

ALL_CHANGE_PROPAGATION_SETS view, 2.32

CHANGE_PROPAGATION_SETS synonym, 3.151

ALL_CHANGE_PROPAGATIONS view, 2.33

CHANGE_PROPAGATIONS synonym, 3.152

ALL_CHANGE_SETS view, 2.34

CHANGE_SETS synonym, 3.153

ALL_CHANGE_SOURCES view, 2.35

CHANGE_SOURCES synonym, 3.154

ALL_CHANGE_TABLES view, 2.36

CHANGE_TABLES synonym, 3.155

ALL_CLUSTER_HASH_EXPRESSIONS view, 2.37

ALL_CLUSTERS view, 2.38

ALL_COL_COMMENTS view, 2.39

ALL_COL_PENDING_STATS view, 2.40

ALL_COL_PRIVS view, 2.41

ALL_COL_PRIVS_MADE view, 2.42

ALL_COL_PRIVS_RECD view, 2.43

ALL_COLL_TYPES view, 2.44

ALL_CONS_COLUMNS view, 2.45

ALL_CONS_OBJ_COLUMNS view, 2.46

ALL_CONSTRAINTS view, 2.47

ALL_CONTEXT view, 2.48

ALL_CUBE_ATTR_VISIBILITY view, 2.49

ALL_CUBE_ATTRIBUTES view, 2.50

ALL_CUBE_BUILD_PROCESSES view, 2.51

ALL_CUBE_CALCULATED_MEMBERS view, 2.52

ALL_CUBE_DIM_LEVELS view, 2.53

ALL_CUBE_DIM_MODELS view, 2.54

ALL_CUBE_DIM_VIEW_COLUMNS view, 2.55

ALL_CUBE_DIM_VIEWS view, 2.56

ALL_CUBE_DIMENSIONALITY view, 2.57

ALL_CUBE_DIMENSIONS view, 2.58

ALL_CUBE_HIER_LEVELS view, 2.59

ALL_CUBE_HIER_VIEW_COLUMNS view, 2.60

ALL_CUBE_HIER_VIEWS view, 2.61

ALL_CUBE_HIERARCHIES view, 2.62

ALL_CUBE_MEASURES view, 2.63

ALL_CUBE_VIEW_COLUMNS view, 2.64

ALL_CUBE_VIEWS view, 2.65

ALL_CUBES view, 2.66

ALL_DB_LINKS view, 2.67

ALL_DEF_AUDIT_OPTS view, 2.68

ALL_DEPENDENCIES view, 2.69

ALL_DEQUEUE_QUEUES view, 2.70

ALL_DIM_ATTRIBUTES view, 2.71

ALL_DIM_CHILD_OF view, 2.72

ALL_DIM_HIERARCHIES view, 2.73

ALL_DIM_JOIN_KEY view, 2.74

ALL_DIM_LEVEL_KEY view, 2.75

ALL_DIM_LEVELS view, 2.76

ALL_DIMENSIONS view, 2.77

ALL_DIRECTORIES view, 2.78

ALL_EDITION_COMMENTS view, 2.79

ALL_EDITIONING_VIEW_COLS view, 2.80

ALL_EDITIONING_VIEW_COLS_AE view, 2.81

ALL_EDITIONING_VIEWS view, 2.82

ALL_EDITIONING_VIEWS_AE view, 2.83

ALL_EDITIONS view, 2.84

ALL_ENCRYPTED_COLUMNS view, 2.85

ALL_ERRORS view, 2.86

ALL_ERRORS_AE view, 2.87

ALL_EVALUATION_CONTEXT_TABLES view, 2.88

ALL_EVALUATION_CONTEXT_VARS view, 2.89

ALL_EVALUATION_CONTEXTS view, 2.90

ALL_EXTERNAL_LOCATIONS view, 2.91

ALL_EXTERNAL_TABLES view, 2.92

ALL_FILE_GROUP_EXPORT_INFO view, 2.93

ALL_FILE_GROUP_FILES view, 2.94

ALL_FILE_GROUP_TABLES view, 2.95

ALL_FILE_GROUP_TABLESPACES view, 2.96

ALL_FILE_GROUP_VERSIONS view, 2.97

ALL_FILE_GROUPS view, 2.98

ALL_GG_INBOUND_PROGRESS view, 2.99

ALL_GOLDENGATE_INBOUND view, 2.100

ALL_HISTOGRAMS synonym for ALL_TAB_HISTOGRAMS, 2.101

ALL_IDENTIFIERS view, 2.102

ALL_IND_COLUMNS view, 2.103

ALL_IND_EXPRESSIONS view, 2.104

ALL_IND_PARTITIONS view, 2.105

ALL_IND_PENDING_STATS view, 2.106

ALL_IND_STATISTICS view, 2.107

ALL_IND_SUBPARTITIONS view, 2.108

ALL_INDEXES view, 2.109

ALL_INDEXTYPE_ARRAYTYPES view, 2.110

ALL_INDEXTYPE_COMMENTS view, 2.111

ALL_INDEXTYPE_OPERATORS view, 2.112

ALL_INDEXTYPES view, 2.113

ALL_INTERNAL_TRIGGERS view, 2.114

ALL_JAVA_ARGUMENTS view, 2.115

ALL_JAVA_CLASSES view, 2.116

ALL_JAVA_COMPILER_OPTIONS view, 2.117

ALL_JAVA_DERIVATIONS view, 2.118

ALL_JAVA_FIELDS view, 2.119

ALL_JAVA_IMPLEMENTS view, 2.120

ALL_JAVA_INNERS view, 2.121

ALL_JAVA_LAYOUTS view, 2.122

ALL_JAVA_METHODS view, 2.123

ALL_JAVA_NCOMPS view, 2.124

ALL_JAVA_RESOLVERS view, 2.125

ALL_JAVA_THROWS view, 2.126

ALL_JOBS synonym for USER_JOBS view, 2.127

ALL_JOIN_IND_COLUMNS view, 2.128

ALL_LIBRARIES view, 2.129

ALL_LOB_PARTITIONS view, 2.130

ALL_LOB_SUBPARTITIONS view, 2.131

ALL_LOB_TEMPLATES view, 2.132

ALL_LOBS view, 2.133

ALL_LOG_GROUP_COLUMNS view, 2.134

ALL_LOG_GROUPS view, 2.135

ALL_MEASURE_FOLDER_CONTENTS view, 2.136

ALL_MEASURE_FOLDERS view, 2.137

ALL_METHOD_PARAMS view, 2.138

ALL_METHOD_RESULTS view, 2.139

ALL_MINING_MODEL_ATTRIBUTES view, 2.140

ALL_MINING_MODEL_SETTINGS view, 2.141

ALL_MINING_MODELS view, 2.142

ALL_MP_GRAPH_WORKSPACES view, 2.1.2

ALL_MP_PARENT_WORKSPACES view, 2.1.2

ALL_MVIEW_AGGREGATES view, 2.143

ALL_MVIEW_ANALYSIS view, 2.144

ALL_MVIEW_COMMENTS view, 2.145

ALL_MVIEW_DETAIL_PARTITION view, 2.146

ALL_MVIEW_DETAIL_RELATIONS view, 2.147

ALL_MVIEW_DETAIL_SUBPARTITION view, 2.148

ALL_MVIEW_JOINS view, 2.149

ALL_MVIEW_KEYS view, 2.150

ALL_MVIEW_LOGS view, 2.151

ALL_MVIEW_REFRESH_TIMES view, 2.152

ALL_MVIEWS view, 2.153

ALL_NESTED_TABLE_COLS view, 2.154

ALL_NESTED_TABLES view, 2.155

ALL_OBJ_COLATTRS view, 2.156

ALL_OBJECT_TABLES view, 2.157

ALL_OBJECTS view, 2.158

ALL_OBJECTS_AE view, 2.159

ALL_OPANCILLARY view, 2.160

ALL_OPARGUMENTS view, 2.161

ALL_OPBINDINGS view, 2.162

ALL_OPERATOR_COMMENTS view, 2.163

ALL_OPERATORS view, 2.164

ALL_OUTLINE_HINTS synonym for USER_OUTLINE_HINTS view, 2.165

ALL_OUTLINES synonym for USER_OUTLINES view, 2.166

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

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_TRANSFORMATIONS view, 3.118

ALL_TRIGGER_COLS view, 3.119

ALL_TRIGGER_ORDERING view, 3.120

ALL_TRIGGERS view, 3.121

ALL_TSTZ_TAB_COLS view, 3.122

ALL_TSTZ_TABLES view, 3.123

ALL_TYPE_ATTRS view, 3.124

ALL_TYPE_METHODS view, 3.125

ALL_TYPE_VERSIONS view, 3.126

ALL_TYPES view, 3.127

ALL_UNUSED_COL_TABS view, 3.128

ALL_UPDATABLE_COLUMNS view, 3.129

ALL_USERS view, 3.130

ALL_USTATS view, 3.131

ALL_VARRAYS view, 3.132

ALL_VERSION_HVIEW view, 2.1.2

ALL_VIEWS view, 3.133

ALL_VIEWS_AE view, 3.134

ALL_WARNING_SETTINGS view, 3.135

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

ALL_XML_SCHEMAS view, 3.137

ALL_XML_TAB_COLS view, 3.138

ALL_XML_TABLES view, 3.139

ALL_XML_VIEW_COLS view, 3.140

ALL_XML_VIEWS view, 3.141

ALL_XSTREAM_INBOUND view, 3.142

ALL_XSTREAM_INBOUND_PROGRESS view, 3.143

ALL_XSTREAM_OUTBOUND view, 3.144

ALL_XSTREAM_OUTBOUND_PROGRESS view, 3.145

ALL_XSTREAM_RULES view, 3.146

ALLOCATE EXTENT clause

of ALTER TABLE

instance number, 1.106

ALTER DATABASE statement

ADD LOGFILE, 1.257

ENABLE THREAD, 1.257

THREAD, 1.257

ALTER TABLE statement

allocating extents, 1.106

ANALYZE statement, 5.149, 6.475

AQ_TM_PROCESSES initialization parameter, 1.8

ARCHIVE LOG START statement

automatic archiving, 1.124

ARCHIVE_LAG_TARGET initialization parameter, 1.9

archived redo logs

destination file, 1.124

storage device, 1.124, 1.128

ARCHIVELOG mode, 1.124

archiving destination, 1.124, 1.128

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

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

authenticating users, 1.176

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

size, 1.46, 1.50, 1.62

---

C

cache

dictionary, 8.153, 8.154, 8.155

statistics, 1.134

CAT synonym for USER_CATALOG view, 3.148

CATALOG view, 3.149

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

CHANGE_PROPAGATION_SETS synonym for ALL_CHANGE_PROPAGATION_SETS view, 3.151

CHANGE_PROPAGATIONS synonym for ALL_CHANGE_PROPAGATIONS view, 3.152

CHANGE_SETS synonym for ALL_CHANGE_SETS view, 3.153

CHANGE_SOURCES synonym for ALL_CHANGE_SOURCES view, 3.154

CHANGE_TABLES synonym for ALL_CHANGE_TABLES view, 3.155

characters

numeric group separators, 1.154

checkpoints

checkpoint interval, 1.134

statistics, 1.134

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

CLONEDB initialization parameter, 1.27

CLU synonym for USER_CLUSTERS view, 3.157

CLUSTER_DATABASE initialization parameter, 1.28

CLUSTER_DATABASE_INSTANCES initialization parameter, 1.29

CLUSTER_INTERCONNECTS initialization parameter, 1.30

COL view, 3.158

COLS synonym for USER_TAB_COLUMNS view, 3.159

commit wait/nowait performed, E.2

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

favoring IN-list iterators, 1.169

CPU_COUNT initialization parameter, 1.40

CREATE TABLE statement

FREELIST GROUPS clause, 1.106

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.145, 1.146

international currency symbol, 1.150

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

shared pool, 1.240

---

D

data blocks

reading multiple, 1.56

size of, 1.46, 1.50, 1.62

data dictionary, 2

cache, 8.153, 8.154, 8.155

scripts, B.2

SQL scripts, B.1

tables, 2.1

views

overview, 2.1

user views, 2

database writer process (DBWR)

checkpoint, 1.134

DATABASE_PROPERTIES view, 3.160

databases

database limits, A

default language, 1.151

resource limits, 1.216, 1.218

datafiles

maximum number, 1.58

parameter, 1.58

dates

language used for, 1.148, 1.157, 1.158

setting SYSDATE, 1.95

TO_CHAR function, 1.147

TO_DATE function, 1.147

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_GG_INBOUND_PROGRESS view, 4.196

DBA_GOLDENGATE_INBOUND view, 4.197

DBA_GOLDENGATE_SUPPORT_MODE view, 4.198

DBA_HIGH_WATER_MARK_STATISTICS view, 4.199

DBA_HIST_ACTIVE_SESS_HISTORY view, 4.200

DBA_HIST_BASELINE view, 4.201

DBA_HIST_BASELINE_DETAILS view, 4.202

DBA_HIST_BASELINE_METADATA view, 4.203

DBA_HIST_BASELINE_TEMPLATE view, 4.204

DBA_HIST_BG_EVENT_SUMMARY view, 4.205

DBA_HIST_BUFFER_POOL_STAT view, 4.206

DBA_HIST_BUFFERED_QUEUES view, 4.207

DBA_HIST_BUFFERED_SUBSCRIBERS view, 4.208

DBA_HIST_CLUSTER_INTERCON view, 4.209

DBA_HIST_COLORED_SQL view, 4.210

DBA_HIST_COMP_IOSTAT view, 4.211

DBA_HIST_CR_BLOCK_SERVER view, 4.212

DBA_HIST_CURRENT_BLOCK_SERVER view, 4.213

DBA_HIST_DATABASE_INSTANCE view, 4.214

DBA_HIST_DATAFILE view, 4.215

DBA_HIST_DB_CACHE_ADVICE view, 4.216

DBA_HIST_DISPATCHER view, 4.217

DBA_HIST_DLM_MISC view, 4.218

DBA_HIST_DYN_REMASTER_STATS view, 4.219

DBA_HIST_ENQUEUE_STAT view, 4.220

DBA_HIST_EVENT_HISTOGRAM view, 4.221

DBA_HIST_EVENT_NAME view, 4.222

DBA_HIST_FILEMETRIC_HISTORY view, 4.223

DBA_HIST_FILESTATXS view, 4.224

DBA_HIST_IC_CLIENT_STATS view, 4.225

DBA_HIST_IC_DEVICE_STATS view, 4.226

DBA_HIST_INST_CACHE_TRANSFER view, 4.227

DBA_HIST_INSTANCE_RECOVERY view, 4.228

DBA_HIST_INTERCONNECT_PINGS view, 4.229

DBA_HIST_IOSTAT_DETAIL view, 4.230

DBA_HIST_IOSTAT_FILETYPE view, 4.231

DBA_HIST_IOSTAT_FILETYPE_NAME view, 4.232

DBA_HIST_IOSTAT_FUNCTION view, 4.233

DBA_HIST_IOSTAT_FUNCTION_NAME view, 4.234

DBA_HIST_JAVA_POOL_ADVICE view, 4.235

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

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_MODEL_TABLES view, 5.135

DBA_MINING_MODELS view, 5.136

DBA_MVIEW_AGGREGATES view, 5.137

DBA_MVIEW_ANALYSIS view, 5.138

DBA_MVIEW_COMMENTS view, 5.139

DBA_MVIEW_DETAIL_PARTITION view, 5.140

DBA_MVIEW_DETAIL_RELATIONS view, 5.141

DBA_MVIEW_DETAIL_SUBPARTITION view, 5.142

DBA_MVIEW_JOINS view, 5.143

DBA_MVIEW_KEYS view, 5.144

DBA_MVIEW_LOG_FILTER_COLS view, 5.145

DBA_MVIEW_LOGS view, 5.146

DBA_MVIEW_REFRESH_TIMES view, 5.147

DBA_MVIEWS view, 5.148

DBA_NESTED_TABLE_COLS view, 5.149

DBA_NESTED_TABLES view, 5.150

DBA_NETWORK_ACL_PRIVILEGES view, 5.151

DBA_NETWORK_ACLS view, 5.152

DBA_OBJ_AUDIT_OPTS view, 5.153

DBA_OBJ_COLATTRS view, 5.154

DBA_OBJECT_SIZE view, 5.155

DBA_OBJECT_TABLES view, 5.156

DBA_OBJECTS view, 5.157

DBA_OBJECTS_AE view, 5.158

DBA_OPANCILLARY view, 5.159

DBA_OPARGUMENTS view, 5.160

DBA_OPBINDINGS view, 5.161

DBA_OPERATOR_COMMENTS view, 5.162

DBA_OPERATORS view, 5.163

DBA_OPTSTAT_OPERATIONS view, 5.164

DBA_ORPHAN_KEY_TABLE view, 5.165

DBA_OUTLINE_HINTS view, 5.166

DBA_OUTLINES view, 5.167

DBA_OUTSTANDING_ALERTS view, 5.168

DBA_PARALLEL_EXECUTE_CHUNKS view, 5.169

DBA_PARALLEL_EXECUTE_TASKS view, 5.170

DBA_PART_COL_STATISTICS view, 5.171

DBA_PART_HISTOGRAMS view, 5.172

DBA_PART_INDEXES view, 5.173

DBA_PART_KEY_COLUMNS view, 5.174

DBA_PART_LOBS view, 5.175

DBA_PART_TABLES view, 5.176

DBA_PARTIAL_DROP_TABS view, 5.177

DBA_PENDING_CONV_TABLES view, 5.178

DBA_PENDING_TRANSACTIONS view, 5.179

DBA_PLSQL_OBJECT_SETTINGS view, 5.180

DBA_POLICIES view, 5.181

DBA_POLICY_CONTEXTS view, 5.182

DBA_POLICY_GROUPS view, 5.183

DBA_PRIV_AUDIT_OPTS view, 5.184

DBA_PROCEDURES view, 5.185

DBA_PROFILES view, 5.186

DBA_PROPAGATION view, 5.187

DBA_PROXIES view, 5.188

DBA_PUBLISHED_COLUMNS view, 5.189

DBA_QUEUE_SCHEDULES view, 5.190

DBA_QUEUE_SUBSCRIBERS view, 5.191

DBA_QUEUE_TABLES view, 5.192

DBA_QUEUES view, 5.193

DBA_RCHILD view, 5.194

DBA_RECOVERABLE_SCRIPT view, 5.195

DBA_RECOVERABLE_SCRIPT_BLOCKS view, 5.196

DBA_RECOVERABLE_SCRIPT_ERRORS view, 5.197

DBA_RECOVERABLE_SCRIPT_HIST view, 5.198

DBA_RECOVERABLE_SCRIPT_PARAMS view, 5.199

DBA_RECYCLEBIN view, 5.200

DBA_REDEFINITION_ERRORS view, 5.201

DBA_REDEFINITION_OBJECTS view, 5.202

DBA_REFRESH view, 5.203

DBA_REFRESH_CHILDREN view, 5.204

DBA_REFS view, 5.205

DBA_REGISTERED_ARCHIVED_LOG view, 5.206

DBA_REGISTERED_MVIEW_GROUPS view, 5.207

DBA_REGISTERED_MVIEWS view, 5.208

DBA_REGISTRY view, 5.209

DBA_REGISTRY_HIERARCHY view, 5.210

DBA_REGISTRY_HISTORY view, 5.211

DBA_REGISTRY_LOG view, 5.212

DBA_REPAIR_TABLE view, 5.213

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

DBA_RESUMABLE view, 5.215

DBA_REWRITE_EQUIVALENCES view, 5.216

DBA_RGROUP view, 5.217

DBA_ROLE_PRIVS view, 5.218

DBA_ROLES view, 5.219

DBA_ROLLBACK_SEGS view, 5.220

DBA_RSRC_CATEGORIES view, 5.221

DBA_RSRC_CONSUMER_GROUP_PRIVS view, 5.222

DBA_RSRC_CONSUMER_GROUPS view, 5.223

DBA_RSRC_GROUP_MAPPINGS view, 5.224

DBA_RSRC_IO_CALIBRATE view, 5.225

DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 5.226

DBA_RSRC_MAPPING_PRIORITY view, 5.227

DBA_RSRC_PLAN_DIRECTIVES view, 5.228

DBA_RSRC_PLANS view, 5.229

DBA_RULE_SET_RULES view, 5.230

DBA_RULE_SETS view, 5.231

DBA_RULES view, 5.232

DBA_SCHEDULER_CHAIN_RULES view, 5.233

DBA_SCHEDULER_CHAIN_STEPS view, 5.234

DBA_SCHEDULER_CHAINS view, 5.235

DBA_SCHEDULER_CREDENTIALS view, 5.236

DBA_SCHEDULER_DB_DESTS view, 5.237

DBA_SCHEDULER_DESTS view, 5.238

DBA_SCHEDULER_EXTERNAL_DESTS view, 5.239

DBA_SCHEDULER_FILE_WATCHERS view, 5.240

DBA_SCHEDULER_GLOBAL_ATTRIBUTE view, 5.241

DBA_SCHEDULER_GROUP_MEMBERS view, 5.242

DBA_SCHEDULER_GROUPS view, 5.243

DBA_SCHEDULER_JOB_ARGS view, 5.244

DBA_SCHEDULER_JOB_CLASSES view, 5.245

DBA_SCHEDULER_JOB_DESTS view, 5.246

DBA_SCHEDULER_JOB_LOG view, 5.247

DBA_SCHEDULER_JOB_ROLES view, 5.248

DBA_SCHEDULER_JOB_RUN_DETAILS view, 5.249

DBA_SCHEDULER_JOBS view, 5.250

DBA_SCHEDULER_NOTIFICATIONS view, 5.251

DBA_SCHEDULER_PROGRAM_ARGS view, 5.252

DBA_SCHEDULER_PROGRAMS view, 5.253

DBA_SCHEDULER_REMOTE_DATABASES view, 5.254

DBA_SCHEDULER_REMOTE_JOBSTATE view, 5.255

DBA_SCHEDULER_RUNNING_CHAINS view, 5.256

DBA_SCHEDULER_RUNNING_JOBS view, 5.257

DBA_SCHEDULER_SCHEDULES view, 5.258

DBA_SCHEDULER_WINDOW_DETAILS view, 5.259

DBA_SCHEDULER_WINDOW_GROUPS view, 5.260

DBA_SCHEDULER_WINDOW_LOG view, 5.261

DBA_SCHEDULER_WINDOWS view, 5.262

DBA_SCHEDULER_WINGROUP_MEMBERS view, 5.263

DBA_SEC_RELEVANT_COLS view, 5.264

DBA_SECONDARY_OBJECTS view, 5.265

DBA_SEGMENTS view, 5.266

DBA_SEGMENTS_OLD view, 5.267

DBA_SEQUENCES view, 5.268

DBA_SERVER_REGISTRY view, 5.269

DBA_SERVICES view, 5.270

DBA_SOURCE view, 5.271

DBA_SOURCE_AE view, 5.272

DBA_SOURCE_TABLES view, 5.273

DBA_SQL_MANAGEMENT_CONFIG view, 5.274

DBA_SQL_PATCHES view, 5.275

DBA_SQL_PLAN_BASELINES view, 5.276

DBA_SQL_PROFILES view, 5.277

DBA_SQLJ_TYPE_ATTRS view, 5.278

DBA_SQLJ_TYPE_METHODS view, 5.279

DBA_SQLJ_TYPES view, 5.280

DBA_SQLSET view, 5.281

DBA_SQLSET_BINDS view, 5.282

DBA_SQLSET_PLANS view, 5.283

DBA_SQLSET_REFERENCES view, 5.284

DBA_SQLSET_STATEMENTS view, 5.285

DBA_SQLTUNE_BINDS view, 5.286

DBA_SQLTUNE_PLANS view, 5.287

DBA_SQLTUNE_RATIONALE_PLAN view, 5.288

DBA_SQLTUNE_STATISTICS view, 5.289

DBA_SSCR_CAPTURE view, 5.290

DBA_SSCR_RESTORE view, 5.291

DBA_STAT_EXTENSIONS view, 5.292

DBA_STMT_AUDIT_OPTS view, 5.293

DBA_STORED_SETTINGS view, 5.294

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_ACTIVE_USER_MAP view, 6.90

DBA_WORKLOAD_CAPTURES view, 6.91

DBA_WORKLOAD_CONNECTION_MAP view, 6.92

DBA_WORKLOAD_FILTERS view, 6.93

DBA_WORKLOAD_REPLAY_DIVERGENCE view, 6.94

DBA_WORKLOAD_REPLAY_SCHEDULES view, 6.95

DBA_WORKLOAD_REPLAYS view, 6.96

DBA_WORKLOAD_SCHEDULE_CAPTURES view, 6.97

DBA_WORKLOAD_SCHEDULE_ORDERING view, 6.98

DBA_WORKLOAD_USER_MAP view, 6.99

DBA_WORKSPACE_SESSIONS view, 2.1.2

DBA_WORKSPACES view, 2.1.2

DBA_XML_INDEXES view, 6.100

DBA_XML_SCHEMAS view, 6.101

DBA_XML_TAB_COLS view, 6.102

DBA_XML_TABLES view, 6.103

DBA_XML_VIEW_COLS view, 6.104

DBA_XML_VIEWS view, 6.105

DBA_XSTREAM_ADMINISTRATOR view, 6.106

DBA_XSTREAM_INBOUND view, 6.107

DBA_XSTREAM_INBOUND_PROGRESS view, 6.108

DBA_XSTREAM_OUT_SUPPORT_MODE view, 6.109

DBA_XSTREAM_OUTBOUND view, 6.110

DBA_XSTREAM_OUTBOUND_PROGRESS view, 6.111

DBA_XSTREAM_RULES view, 6.112

DBFS_CONTENT view, 6.113

DBFS_CONTENT_PROPERTIES view, 6.114

DBMS_ALERT_INFO view, 6.115

DBMS_LOCK_ALLOCATED view, 6.116

DBMS_STATS package, 2.109, 2.154, 3.102, 3.103, 3.117, 5.80, 6.43, 6.44, 6.56, 6.368, 6.474, 6.489

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

destination

archiving redo log files, 1.124

overriding default, 1.124

USER_DUMP_DEST, 1.269

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

DICT_COLUMNS view, 6.119

DICTIONARY view, 6.120

DICT synonym, 6.118

disk drives

archiving destination, 1.124

DISK_ASYNCH_IO initialization parameter, 1.79

dispatcher processes

maximum number, 1.138

DISPATCHERS initialization parameter, 1.80

distinguished name, 1.205

DISTRIBUTED_LOCK_TIMEOUT initialization parameter, 1.81

DM_USER_MODELS view, 6.121

DML_LOCKS initialization parameter, 1.82

DNFS_BATCH_SIZE initialization parameter, 1.83

DOCUMENT_LINKS view, 6.122

downgrading

scripts, B.4

DST_UPGRADE_INSERT_CONV initialization parameter, 1.84

dump files, 1.139

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

ENABLE_DDL_LOGGING initialization parameter, 1.85

ENABLE_GOLDENGATE_REPLICATION initialization parameter, 1.86

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

ERROR_SIZE view, 6.123

EVENT initialization parameter, 1.87

EXCEPTIONS table, 6.124

extent

allocating to instance, 1.106

---

F

FAL_CLIENT initialization parameter, 1.88

FAL_SERVER initialization parameter, 1.89

FAST_START_MTTR_TARGET initialization parameter, 1.90

FAST_START_PARALLEL_ROLLBACK initialization parameter, 1.91

FILE_MAPPING initialization parameter, 1.92

FILEIO_NETWORK_ADAPTERS initialization parameter, 1.93

filenames

case significance, 1.3.2.1.1

FILESYSTEMIO_OPTIONS initialization parameter, 1.94

FIXED_DATE initialization parameter, 1.95

FLASHBACK_TRANSACTION_QUERY view, 6.125

free space list

locating space, 1.106

FREELIST GROUPS clause, 1.106

---

G

GCS_SERVER_PROCESSES initialization parameter, 1.96

GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1.97

GLOBAL_NAME view, 6.126

GLOBAL_NAMES initialization parameter, 1.98

GLOBAL_TXN_PROCESSES initialization parameter, 1.99

GV$ views

for Real Application Clusters, 7.1.2

---

H

HASH_AREA_SIZE initialization parameter, 1.100

Heterogeneous Services

agents, 1.102

HI_SHARED_MEMORY_ADDRESS initialization parameter, 1.101

hints

precedence over initialization parameter settings, 1.243

HS_ALL_CAPS view, 6.127

HS_ALL_DD view, 6.128

HS_ALL_INITS view, 6.129

HS_AUTOREGISTER initialization parameter, 1.102

HS_BASE_CAPS view, 6.130

HS_BASE_DD view, 6.131

HS_CLASS_CAPS view, 6.132

HS_CLASS_DD view, 6.133

HS_CLASS_INIT view, 6.134

HS_FDS_CLASS view, 6.135

HS_FDS_INST view, 6.136

HS_INST_CAPS view, 6.137

HS_INST_DD view, 6.138

HS_INST_INIT view, 6.139

---

I

IDEPTREE view, 6.140

IFILE initialization parameter, 1.3.2.1.1, 1.103

IND synonym for USER_INDEXES view, 6.141

INDEX_HISTOGRAM view, 6.142

INDEX_STATS view, 6.143

initialization parameter file

common file, 1.103

embedded, 1.103

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

DNFS_BATCH_SIZE, 1.83

DST_UPGRADE_INSERT_CONV, 1.84

embedded initialization parameter files, 1.3.2.1.1

ENABLE_DDL_LOGGING, 1.85

ENABLE_GOLDENGATE_REPLICATION, 1.86

EVENT, 1.87

FAL_CLIENT, 1.88

FAL_SERVER, 1.89

FAST_START_MTTR_TARGET, 1.90

FAST_START_PARALLEL_ROLLBACK, 1.91

FILE_MAPPING, 1.92

FILEIO_NETWORK_ADAPTERS, 1.93

FILESYSTEMIO_OPTIONS, 1.94

FIXED_DATE, 1.95

functional category, 1.4.1

GCS_SERVER_PROCESSES, 1.96

GLOBAL_CONTEXT_POOL_SIZE, 1.97

GLOBAL_NAMES, 1.98

GLOBAL_TXN_PROCESSES, 1.99

HASH_AREA_SIZE, 1.100

HI_SHARED_MEMORY_ADDRESS, 1.101

HS_AUTOREGISTER, 1.102

IFILE, 1.3.2.1.1, 1.103

INSTANCE_GROUPS, 1.104

INSTANCE_NAME, 1.105

INSTANCE_NUMBER, 1.106

INSTANCE_TYPE, 1.107

JAVA_JIT_ENABLED, 1.108

JAVA_MAX_SESSIONSPACE_SIZE, 1.109

JAVA_POOL_SIZE, 1.110

JAVA_SOFT_SESSIONSPACE_LIMIT, 1.111

JOB_QUEUE_PROCESSES, 1.112

LARGE_POOL_SIZE, 1.113

LDAP_DIRECTORY_ACCESS, 1.114

LDAP_DIRECTORY_SYSAUTH, 1.115

LICENSE_MAX_SESSIONS, 1.116

LICENSE_MAX_USERS, 1.117

LICENSE_SESSIONS_WARNING, 1.118

LISTENER_NETWORKS, 1.119

LOCAL_LISTENER, 1.120

LOCK_NAME_SPACE, 1.121

LOCK_SGA, 1.122

LOG_ARCHIVE_CONFIG, 1.123

LOG_ARCHIVE_DEST, 1.124

LOG_ARCHIVE_DEST_n, 1.125

LOG_ARCHIVE_DEST_STATE_n, 1.126

LOG_ARCHIVE_DUPLEX_DEST, 1.127

LOG_ARCHIVE_FORMAT, 1.128

LOG_ARCHIVE_LOCAL_FIRST, 1.129

LOG_ARCHIVE_MAX_PROCESSES, 1.130

LOG_ARCHIVE_MIN_SUCCEED_DEST, 1.131

LOG_ARCHIVE_TRACE, 1.132

LOG_BUFFER, 1.133

LOG_CHECKPOINT_INTERVAL, 1.134

LOG_CHECKPOINT_TIMEOUT, 1.135

LOG_CHECKPOINTS_TO_ALERT, 1.136

LOG_FILE_NAME_CONVERT, 1.137

MAX_DISPATCHERS, 1.138

MAX_DUMP_FILE_SIZE, 1.139

MAX_ENABLED_ROLES, 1.140

MAX_SHARED_SERVERS, 1.141

MEMORY_MAX_TARGET, 1.142

MEMORY_TARGET, 1.143

modifiable, 1.4.2

NLS_CALENDAR, 1.144

NLS_COMP, 1.145

NLS_CURRENCY, 1.146

NLS_DATE_FORMAT, 1.147

NLS_DATE_LANGUAGE, 1.148

NLS_DUAL_CURRENCY, 1.149

NLS_ISO_CURRENCY, 1.150

NLS_LANGUAGE, 1.151

NLS_LENGTH_SEMANTICS, 1.152

NLS_NCHAR_CONV_EXCP, 1.153

NLS_NUMERIC_CHARACTERS, 1.154

NLS_SORT, 1.155

NLS_TERRITORY, 1.156

NLS_TIMESTAMP_FORMAT, 1.157

NLS_TIMESTAMP_TZ_FORMAT, 1.158

O7_DICTIONARY_ACCESSIBILITY, 1.159

OBJECT_CACHE_MAX_SIZE_PERCENT, 1.160

OBJECT_CACHE_OPTIMAL_SIZE, 1.161

OLAP_PAGE_POOL_SIZE, 1.162

OPEN_CURSORS, 1.163

OPEN_LINKS, 1.164

OPEN_LINKS_PER_INSTANCE, 1.165

operating system-dependent values, 1.1.1.2

OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES, 1.166

OPTIMIZER_DYNAMIC_SAMPLING, 1.167

OPTIMIZER_FEATURES_ENABLE, 1.168

OPTIMIZER_INDEX_CACHING, 1.169

OPTIMIZER_INDEX_COST_ADJ, 1.170

OPTIMIZER_MODE, 1.171

OPTIMIZER_SECURE_VIEW_MERGING, 1.172

OPTIMIZER_USE_INVISIBLE_INDEXES, 1.173

OPTIMIZER_USE_PENDING_STATISTICS, 1.174

OPTIMIZER_USE_SQL_PLAN_BASELINES, 1.175

OS_AUTHENT_PREFIX, 1.176

OS_ROLES, 1.177

PARALLEL_ADAPTIVE_MULTI_USER, 1.178

PARALLEL_AUTOMATIC_TUNING, 1.179

PARALLEL_DEGREE_LIMIT, 1.180

PARALLEL_DEGREE_POLICY, 1.181

PARALLEL_EXECUTION_MESSAGE_SIZE, 1.182

PARALLEL_FORCE_LOCAL, 1.183

PARALLEL_INSTANCE_GROUP, 1.184

PARALLEL_IO_CAP_ENABLED, 1.185

PARALLEL_MAX_SERVERS, 1.186

PARALLEL_MIN_PERCENT, 1.187

PARALLEL_MIN_SERVERS, 1.188

PARALLEL_MIN_TIME_THRESHOLD, 1.189

PARALLEL_SERVERS_TARGET, 1.190

PARALLEL_THREADS_PER_CPU, 1.191

parameter files, 1.3

performance tuning, 1.1.1.3

PERMIT_92_WRAP_FORMAT, 1.192

PGA_AGGREGATE_TARGET, 1.193

PLSCOPE_SETTINGS, 1.194

PLSQL_CCFLAGS, 1.195

PLSQL_CODE_TYPE, 1.196

PLSQL_DEBUG, 1.197

PLSQL_OPTIMIZE_LEVEL, 1.198

PLSQL_V2_COMPATIBILITY, 1.199

PLSQL_WARNINGS, 1.200

PRE_PAGE_SGA, 1.201

PROCESSES, 1.202

QUERY_REWRITE_ENABLED, 1.203

QUERY_REWRITE_INTEGRITY, 1.204

RDBMS_SERVER_DN, 1.205

READ_ONLY_OPEN_DELAYED, 1.206

RECOVERY_PARALLELISM, 1.207

RECYCLEBIN, 1.208

REDO_TRANSPORT_USER, 1.209

REMOTE_DEPENDENCIES_MODE, 1.210

REMOTE_LISTENER, 1.211

REMOTE_LOGIN_PASSWORDFILE, 1.212

REMOTE_OS_AUTHENT, 1.213

REMOTE_OS_ROLES, 1.214

REPLICATION_DEPENDENCY_TRACKING, 1.215

RESOURCE_LIMIT, 1.216

RESOURCE_MANAGER_CPU_ALLOCATION, 1.217

RESOURCE_MANAGER_PLAN, 1.218

RESULT_CACHE_MAX_RESULT, 1.219

RESULT_CACHE_MAX_SIZE, 1.220

RESULT_CACHE_MODE, 1.221

RESULT_CACHE_REMOTE_EXPIRATION, 1.222

RESUMABLE_TIMEOUT, 1.223

ROLLBACK_SEGMENTS, 1.224

SEC_CASE_SENSITIVE_LOGON, 1.225

SEC_MAX_FAILED_LOGIN_ATTEMPTS, 1.226

SEC_PROTOCOL_ERROR_FURTHER_ACTION, 1.227

SEC_PROTOCOL_ERROR_TRACE_ACTION, 1.228

SEC_RETURN_SERVER_RELEASE_BANNER, 1.229

SERIAL_REUSE, 1.230

SERVICE_NAMES, 1.231

SESSION_CACHED_CURSORS, 1.232

SESSION_MAX_OPEN_FILES, 1.233

SESSIONS, 1.234

SGA_MAX_SIZE, 1.235

SGA_TARGET, 1.236

SHADOW_CORE_DUMP, 1.237

SHARED_MEMORY_ADDRESS, 1.238

SHARED_POOL_RESERVED_SIZE, 1.239

SHARED_POOL_SIZE, 1.240

SHARED_SERVER_SESSIONS, 1.241

SHARED_SERVERS, 1.242

SKIP_UNUSABLE_INDEXES, 1.243

SMTP_OUT_SERVER, 1.244

SORT_AREA_RETAINED_SIZE, 1.245

SORT_AREA_SIZE, 1.246

specifying in initialization parameter files, 1.3.2.1

SPFILE, 1.247

SQL_TRACE, 1.248

SQL92_SECURITY, 1.249

SQLTUNE_CATEGORY, 1.250

STANDBY_ARCHIVE_DEST, 1.251

STANDBY_FILE_MANAGEMENT, 1.252

STAR_TRANSFORMATION_ENABLED, 1.253

STATISTICS_LEVEL, 1.254

STREAMS_POOL_SIZE, 1.255

TAPE_ASYNCH_IO, 1.256

THREAD, 1.257

TIMED_OS_STATISTICS, 1.258

TIMED_STATISTICS, 1.259

TRACE_ENABLED, 1.260

TRACEFILE_IDENTIFIER, 1.261

TRANSACTIONS, 1.262

TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1.263

UNDO_MANAGEMENT, 1.264

UNDO_RETENTION, 1.265

UNDO_TABLESPACE, 1.266

USE_INDIRECT_DATA_BUFFERS, 1.267

USE_LARGE_PAGES, 1.268

USER_DUMP_DEST, 1.269

UTL_FILE_DIR, 1.270

variable, 1.1.1.3

WORKAREA_SIZE_POLICY, 1.271

XML_DB_EVENTS, 1.272

INITJVM.SQL script, B.5

INIT.ORA file. See initialization parameter file

IN-list iterators

optimizer use of, 1.169

inserts

locating free space, 1.106

INST_ID column, 7.1.2

INSTANCE clause

of ALTER TABLE

allocating extents, 1.106

INSTANCE_GROUPS initialization parameter, 1.104

INSTANCE_NAME initialization parameter, 1.105

INSTANCE_NUMBER initialization parameter, 1.106

INSTANCE_TYPE initialization parameter, 1.107

instances

checkpoint, 1.134

startup order, 1.106

I/O

reading multiple blocks, 1.56

redo log files, 1.133

---

J

Java initialization parameters

JAVA_MAX_SESSIONSPACE_SIZE, 1.109

JAVA_POOL_SIZE, 1.110

JAVA_SOFT_SESSIONSPACE_LIMIT, 1.111

Java scripts, B.5

JAVA_JIT_ENABLED initialization parameter, 1.108

JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1.109

JAVA_POOL_SIZE initialization parameter, 1.110

JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1.111

JOB_QUEUE_PROCESSES initialization parameter, 1.112

---

L

language

database default language, 1.151

LARGE_POOL_SIZE initialization parameter, 1.113

LDAP_DIRECTORY_ACCESS initialization parameter, 1.114

LDAP_DIRECTORY_SYSAUTH initialization parameter, 1.115

LICENSE_MAX_SESSIONS initialization parameter, 1.116

LICENSE_MAX_USERS initialization parameter, 1.117

LICENSE_SESSIONS_WARNING initialization parameter, 1.118

licenses

maximum sessions, 1.116

maximum users, 1.117

warning for concurrent user sessions, 1.118

limits on the database, A

linguistic sorts, 1.155

LISTENER_NETWORKS initialization parameter, 1.119

local currency, 1.145, 1.146

LOCAL_LISTENER initialization parameter, 1.120

LOCK_NAME_SPACE initialization parameter, 1.121

LOCK_SGA initialization parameter, 1.122

locks

names, C.2

LOG_ARCHIVE_CONFIG initialization parameter, 1.123

LOG_ARCHIVE_DEST initialization parameter, 1.124

LOG_ARCHIVE_DEST_n initialization parameter, 1.125

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1.126

LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1.127

LOG_ARCHIVE_FORMAT initialization parameter, 1.128

LOG_ARCHIVE_LOCAL_FIRST initialization parameter, 1.129

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1.130

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1.131

LOG_ARCHIVE_TRACE initialization parameter, 1.132

LOG_BUFFER initialization parameter, 1.133

LOG_CHECKPOINT_INTERVAL initialization parameter, 1.134

LOG_CHECKPOINT_TIMEOUT initialization parameter, 1.135

LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1.136

LOG_FILE_NAME_CONVERT initialization parameter, 1.137

LOGSTDBY_UNSUPPORTED_TABLES synonym for DBA_LOGSTDBY_UNSUPPORTED_TABLE view, 6.144

lowercase significance, 1.3.2.1.1

---

M

MAP_OBJECT table, 6.145

MAX_DISPATCHERS initialization parameter, 1.138

MAX_DUMP_FILE_SIZE initialization parameter, 1.139

MAX_ENABLED_ROLES initialization parameter, 1.140

MAX_SHARED_SERVERS initialization parameter, 1.141

memory

amount used for sorting, 1.245

virtual, 1.1.1.3

MEMORY_MAX_TARGET initialization parameter, 1.142

MEMORY_TARGET initialization parameter, 1.143

monitor

performance, 1.134

multiple-process systems

number of processes, 1.202

---

N

NLS_CALENDAR initialization parameter, 1.144

NLS_COMP initialization parameter, 1.145

NLS_CURRENCY initialization parameter, 1.146

defined by NLS_TERRITORY, 1.156

NLS_DATABASE_PARAMETERS view, 6.146

NLS_DATE_FORMAT initialization parameter, 1.147

defined by NLS_NUMERIC_CHARACTERS, 1.154

defined by NLS_TERRITORY, 1.156

NLS_DATE_LANGUAGE initialization parameter, 1.148

NLS_DUAL_CURRENCY initialization parameter, 1.149

NLS_INSTANCE_PARAMETERS view, 6.147

NLS_ISO_CURRENCY initialization parameter, 1.150

defined by NLS_TERRITORY, 1.156

NLS_LANGUAGE initialization parameter, 1.151

NLS_LENGTH_SEMANTICS initialization parameter, 1.152

NLS_NCHAR_CONV_EXCP initialization parameter, 1.153

NLS_NUMERIC_CHARACTERS initialization parameter, 1.154

NLS_SESSION_PARAMETERS view, 6.148

NLS_SORT initialization parameter, 1.155

NLS_TERRITORY initialization parameter, 1.156

NLS_TIME_FORMAT, 8.75

NLS_TIME_TZ_FORMAT, 8.75

NLS_TIMESTAMP_FORMAT initialization parameter, 1.157

NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1.158

numeric group separators, 1.154

---

O

O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1.159

OBJ synonym for USER_OBJECTS view, 6.149

OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1.160

OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1.161

objects

data dictionary, 2.1

OLAP_PAGE_POOL_SIZE initialization parameter, 1.162

online redo log

archiving mode, 1.124

block, 1.134

file size, 1.134

setting checkpoint interval, 1.134

OPEN_CURSORS initialization parameter, 1.163

OPEN_LINKS initialization parameter, 1.164

OPEN_LINKS_PER_INSTANCE initialization parameter, 1.165

operating system

authenticating remote clients, 1.213

authenticating users and passwords, 1.176

dependent parameters, 1.1.1.2

roles for remote clients, 1.214

optimization

trading cursor space for time, 1.45

OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES initialization parameter, 1.166

OPTIMIZER_DYNAMIC_SAMPLING initialization parameter, 1.167

OPTIMIZER_FEATURES_ENABLE initialization parameter, 1.168

OPTIMIZER_INDEX_CACHING initialization parameter, 1.169

OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1.170

OPTIMIZER_MODE initialization parameter, 1.171

OPTIMIZER_SECURE_VIEW_MERGING initialization parameter, 1.172

OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter, 1.173

OPTIMIZER_USE_PENDING_STATISTICS initialization parameter, 1.174

OPTIMIZER_USE_SQL_PLAN_BASELINES initialization parameter, 1.175

ORPHAN_KEY_TABLE table. See DBA_ORPHAN_KEY_TABLE view

OS_AUTHENT_PREFIX initialization parameter, 1.176

OS_ROLES initialization parameter, 1.177

---

P

parallel query

maximum number of instances, 1.182

maximum number of servers, 1.186

minimum number of queries, 1.188

PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1.178

PARALLEL_AUTOMATIC_TUNING initialization parameter, 1.179

PARALLEL_DEGREE_LIMIT initialization parameter, 1.180

PARALLEL_DEGREE_POLICY initialization parameter, 1.181

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1.182

PARALLEL_FORCE_LOCAL initialization parameter, 1.183

PARALLEL_INSTANCE_GROUP initialization parameter, 1.184

PARALLEL_IO_CAP_ENABLED initialization parameter, 1.185

PARALLEL_MAX_SERVERS initialization parameter, 1.186

PARALLEL_MIN_PERCENT initialization parameter, 1.187

PARALLEL_MIN_SERVERS initialization parameter, 1.188

PARALLEL_MIN_TIME_THRESHOLD initialization parameter, 1.189

PARALLEL_SERVERS_TARGET initialization parameter, 1.190

PARALLEL_THREADS_PER_CPU initialization parameter, 1.191

passwords

authenticating, 1.176, 1.213

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.212

PATH_VIEW view, 6.150

performance, 1.1.1.3

shared pool, 1.240

PERMIT_92_WRAP_FORMAT initialization parameter, 1.192

PGA_AGGREGATE_TARGET initialization parameter, 1.193

PLAN_TABLE table, 6.151

PLSCOPE_SETTINGS initialization parameter, 1.194

PLSQL_CCFLAGS initialization parameter, 1.195

PLSQL_CODE_TYPE initialization parameter, 1.196

PLSQL_DEBUG initialization parameter, 1.197

PLSQL_OPTIMIZE_LEVEL initialization parameter, 1.198

PLSQL_V2_COMPATIBILITY initialization parameter, 1.199

PLSQL_WARNINGS initialization parameter, 1.200

PLUGGABLE_SET_CHECK view, 6.152

PRE_PAGE_SGA initialization parameter, 1.201

privileges

remote login, 1.212

RESTRICTED_SESSION privilege, 1.116, 1.118

table-level select privileges, 1.249

procedures

shared pool, 1.240

processes

dispatcher process maximum number, 1.138

maximum shared server processes, 1.141

number of server processes, 1.109, 1.111, 1.241, 1.242

recovery, 1.207

trace files, 1.269

user processes, 1.202

PROCESSES initialization parameter, 1.202

PRODUCT_COMPONENT_VERSION view, 6.153

profiles

resource limits, 1.216, 1.218

PROXY_USERS view, 6.154

PSTUBTBL table, 6.155

PUBLIC clause

of ALTER DATABASE

thread of redo, 1.257

PUBLIC_DEPENDENCY view, 6.156

PUBLICSYN view, 6.157

---

Q

queries

hints, 1.171

QUERY_REWRITE_ENABLED initialization parameter, 1.203

QUERY_REWRITE_INTEGRITY initialization parameter, 1.204

QUEUE_PRIVILEGES view, 6.158

---

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

READ_ONLY_OPEN_DELAYED initialization parameter, 1.206

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

PARALLEL_ADAPTIVE_MULTI_USER, 1.178

PARALLEL_AUTOMATIC_TUNING, 1.179

PARALLEL_EXECUTION_MESSAGE_SIZE, 1.182

PARALLEL_INSTANCE_GROUP, 1.184

PARALLEL_MAX_SERVERS, 1.186

PARALLEL_MIN_PERCENT, 1.187

PARALLEL_MIN_SERVERS, 1.188

PARALLEL_THREADS_PER_CPU, 1.191

recovery

number of required processes, 1.207

RECOVERY_PARALLELISM initialization parameter, 1.207

RECYCLEBIN initialization parameter, 1.208

RECYCLEBIN synonym for USER_RECYCLEBIN view, 6.159

REDACTION_COLUMNS view, 6.160

REDACTION_POLICIES view, 6.161

REDACTION_VALUES_FOR_TYPE_FULL view, 6.162

redo logs

buffer size, 1.133

redo thread, 1.257

REDO_TRANSPORT_USER initialization parameter, 1.209

remote clients

authenticating, 1.213

remote logins, 1.212

REMOTE_DEPENDENCIES_MODE initialization parameter, 1.210

REMOTE_LISTENER initialization parameter, 1.211

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.212

REMOTE_OS_AUTHENT initialization parameter, 1.213

REMOTE_OS_ROLES initialization parameter, 1.214

REPAIR_TABLE table. See DBA_REPAIR_TABLE view

REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1.215

REPORT_COMPONENTS view, 6.163

REPORT_FILES view, 6.164

REPORT_FORMATS view, 6.165

resource limits for profiles, 1.216, 1.218

RESOURCE_COST view, 6.166

RESOURCE_LIMIT initialization parameter, 1.216

RESOURCE_MANAGER_CPU_ALLOCATION initialization parameter, 1.217

RESOURCE_MANAGER_PLAN initialization parameter, 1.218

RESOURCE_MAP table, 6.167

RESOURCE_VIEW view, 6.168

RESULT_CACHE_MAX_RESULT initialization parameter, 1.219

RESULT_CACHE_MAX_SIZE initialization parameter, 1.220

RESULT_CACHE_MODE initialization parameter, 1.221

RESULT_CACHE_REMOTE_EXPIRATION initialization parameter, 1.222

RESUMABLE_TIMEOUT initialization parameter, 1.223

RMJVM.SQL script, B.5

ROLE_ROLE_PRIVS view, 6.169

ROLE_SYS_PRIVS view, 6.170

ROLE_TAB_PRIVS view, 6.171

ROLE_WM_PRIVS view, 2.1.2

roles, 1.177

remote clients, 1.214

ROLLBACK_SEGMENTS initialization parameter, 1.224

---

S

SCHEDULER_BATCH_ERRORS view, 6.172

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

SEC_MAX_FAILED_LOGIN_ATTEMPTS initialization parameter, 1.226

SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter, 1.227

SEC_PROTOCOL_ERROR_TRACE_ACTION initialization parameter, 1.228

SEC_RETURN_SERVER_RELEASE_BANNER initialization parameter, 1.229

SEQ synonym for USER_SEQUENCES view, 6.173

SERIAL_REUSE initialization parameter, 1.230

server parameter file

overview, 1.3

server processes

number, 1.109, 1.111, 1.241, 1.242

SERVICE_NAMES initialization parameter, 1.231

SESSION_CACHED_CURSORS initialization parameter, 1.232

SESSION_CONTEXT view, 6.174

SESSION_MAX_OPEN_FILES initialization parameter, 1.233

SESSION_PRIVS view, 6.175

SESSION_ROLES view, 6.176

SESSIONS initialization parameter, 1.234

SGA_MAX_SIZE initialization parameter, 1.235

SGA_TARGET initialization parameter, 1.236

SHADOW_CORE_DUMP initialization parameter, 1.237

shared server

SESSIONS initialization parameter, 1.234

shared server processes

maximum number, 1.141

SHARED_MEMORY_ADDRESS initialization parameter, 1.238

SHARED_POOL_RESERVED_SIZE initialization parameter, 1.239

SHARED_POOL_SIZE initialization parameter, 1.240

SHARED_SERVER_SESSIONS initialization parameter, 1.241

SHARED_SERVERS initialization parameter, 1.242

SHOW PARAMETERS command, 1.4.3

SKIP_UNUSABLE_INDEXES initialization parameter, 1.243

SMTP_OUT_SERVER initialization parameter, 1.244

SORT_AREA_RETAINED_SIZE initialization parameter, 1.245

SORT_AREA_SIZE initialization parameter, 1.246

sorting

maximum memory, 1.245

ORDER BY queries, 1.155

SOURCE_SIZE view, 6.177

SPFILE initialization parameter, 1.247

SQL scripts

creating the data dictionary, B.1

optional, B.2

required, B.1

SQL_TRACE initialization parameter, 1.248

SQL92_SECURITY initialization parameter, 1.249

SQLTUNE_CATEGORY initialization parameter, 1.250

STANDBY_ARCHIVE_DEST initialization parameter, 1.251

STANDBY_FILE_MANAGEMENT initialization parameter, 1.252

STAR_TRANSFORMATION_ENABLED initialization parameter, 1.253

starting up

instance number, 1.106

startup order, 1.106

statistics

application wait time, E.2

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

cluster wait time, 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 nowait performed, E.2

commit nowait requested, E.2

Commit SCN cached, E.2

commit wait performed, E.2

commit wait requested, E.2

commit wait/nowait requested, E.2

concurrency wait time, 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.134, 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 enqueue CPU used by this session, E.2

global enqueue get time, E.2

global enqueue gets async, E.2

global enqueue gets sync, E.2

global enqueue releases, 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 hash latch upgrades - no wait, E.2

shared hash latch upgrades - wait, 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.259

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 I/O wait time, 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.254

STMT_AUDIT_OPTION_MAP table, 6.178

STREAMS_POOL_SIZE initialization parameter, 1.255

switch redo log file, 1.134

SYN synonym for USER_SYNONYMS view, 6.179

SYNONYMS view, 6.180

SYS_OBJECTS view, 6.181

SYSCATALOG view, 6.182

SYSFILES view, 6.183

SYSSEGOBJ view, 6.184

system global area, 1.1.1.3

buffer areas, 1.133

system performance, 1.1.1.3

SYSTEM_PRIVILEGE_MAP table, 6.185

---

T

TAB view, 6.186

TABLE_PRIVILEGE_MAP table, 6.187

tables

data dictionary, 2.1

DML locks, 1.82

locating free space, 1.106

TABQUOTAS view, 6.188

TABS synonym for USER_TABLES view, 6.189

tape archiving destination, 1.124

TAPE_ASYNCH_IO initialization parameter, 1.256

territory, 1.149, 1.156

THREAD initialization parameter, 1.257

TIMED_OS_STATISTICS initialization parameter, 1.258

TIMED_STATISTICS initialization parameter, 1.259

file read/write statistics, 7.141, 9.108

TO_CHAR function, 1.147

TO_DATE function, 1.147

trace files

destination, 1.269

maximum size, 1.139

TRACE_ENABLED initialization parameter, 1.260

TRACEFILE_IDENTIFIER initialization parameter, 1.261

transactions

data locking, 1.82

TRANSACTIONS initialization parameter, 1.262

DML locks, 1.82

TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1.263

TRUSTED_SERVERS view, 6.190

TS_PITR_CHECK view, 6.191

TS_PITR_OBJECTS TO_BE_DROPPED view, 6.192

---

U

UNDO_MANAGEMENT initialization parameter, 1.264

UNDO_RETENTION initialization parameter, 1.265

UNDO_TABLESPACE initialization parameter, 1.266

UNI_PLUGGABLE_SET_CHECK view, 6.193

updates

locating free space, 1.106

upgrading

scripts, B.4

uppercase characters, 1.3.2.1.1

USE_INDIRECT_DATA_BUFFERS initialization parameter, 1.267

USE_LARGE_PAGES initialization parameter, 1.268

user processes

trace files, 1.269

USER_ADDM_FDG_BREAKDOWN view, 6.194

USER_ADDM_FINDINGS view, 6.195

USER_ADDM_INSTANCES view, 6.196

USER_ADDM_TASKS view, 6.197

USER_ADVISOR_ACTIONS view, 6.198

USER_ADVISOR_DIR_TASK_INST view, 6.199

USER_ADVISOR_EXEC_PARAMETERS view, 6.200

USER_ADVISOR_EXECUTIONS view, 6.201

USER_ADVISOR_FDG_BREAKDOWN view, 6.202

USER_ADVISOR_FINDINGS view, 6.203

USER_ADVISOR_JOURNAL view, 6.204

USER_ADVISOR_LOG view, 6.205

USER_ADVISOR_OBJECTS view, 6.206

USER_ADVISOR_PARAMETERS view, 6.207

USER_ADVISOR_RATIONALE view, 6.208

USER_ADVISOR_RECOMMENDATIONS view, 6.209

USER_ADVISOR_SQLA_REC_SUM view, 6.210

USER_ADVISOR_SQLA_TABLES view, 6.211

USER_ADVISOR_SQLA_WK_MAP view, 6.212

USER_ADVISOR_SQLA_WK_STMTS view, 6.213

USER_ADVISOR_SQLPLANS view, 6.214

USER_ADVISOR_SQLSTATS view, 6.215

USER_ADVISOR_SQLW_JOURNAL view, 6.216

USER_ADVISOR_SQLW_PARAMETERS view, 6.217

USER_ADVISOR_SQLW_STMTS view, 6.218

USER_ADVISOR_SQLW_SUM view, 6.219

USER_ADVISOR_SQLW_TABLES view, 6.220

USER_ADVISOR_SQLW_TEMPLATES view, 6.221

USER_ADVISOR_TASKS view, 6.222

USER_ADVISOR_TEMPLATES view, 6.223

USER_ALL_TABLES view, 6.224

USER_APPLY_ERROR view, 6.225

USER_AQ_AGENT_PRIVS view, 6.226

USER_ARGUMENTS view, 6.227

USER_ASSEMBLIES view, 6.228

USER_ASSOCIATIONS view, 6.229

USER_ATTRIBUTE_TRANSFORMATIONS view, 6.230

USER_AUDIT_OBJECT view, 6.231

USER_AUDIT_POLICIES view, 6.232

USER_AUDIT_POLICY_COLUMNS view, 6.233

USER_AUDIT_SESSION view, 6.234

USER_AUDIT_STATEMENT view, 6.235

USER_AUDIT_TRAIL view, 6.236

USER_AW_PS view, 6.237

USER_AWS view, 6.238

USER_BASE_TABLE_MVIEWS view, 6.239

USER_CATALOG view, 6.240

CAT synonym, 3.148

USER_CHANGE_NOTIFICATION_REGS view, 6.241

USER_CLU_COLUMNS view, 6.242

USER_CLUSTER_HASH_EXPRESSIONS view, 6.243

USER_CLUSTERS view, 6.244

CLU synonym, 3.157

USER_COL_COMMENTS view, 6.245

USER_COL_PENDING_STATS view, 6.246

USER_COL_PRIVS view, 6.247

USER_COL_PRIVS_MADE view, 6.248

USER_COL_PRIVS_RECD view, 6.249

USER_COLL_TYPES view, 6.250

USER_COMPARISON view, 6.251

USER_COMPARISON_COLUMNS view, 6.252

USER_COMPARISON_ROW_DIF view, 6.253

USER_COMPARISON_SCAN view, 6.254

USER_COMPARISON_SCAN_VALUES view, 6.255

USER_CONS_COLUMNS view, 6.256

USER_CONS_OBJ_COLUMNS view, 6.257

USER_CONSTRAINTS view, 6.258

USER_CQ_NOTIFICATION_QUERIES view, 6.259

USER_CUBE_ATTR_VISIBILITY view, 6.260

USER_CUBE_ATTRIBUTES view, 6.261

USER_CUBE_BUILD_PROCESSES view, 6.262

USER_CUBE_CALCULATED_MEMBERS view, 6.263

USER_CUBE_DIM_LEVELS view, 6.264

USER_CUBE_DIM_MODELS view, 6.265

USER_CUBE_DIM_VIEW_COLUMNS view, 6.266

USER_CUBE_DIM_VIEWS view, 6.267

USER_CUBE_DIMENSIONALITY view, 6.268

USER_CUBE_DIMENSIONS view, 6.269

USER_CUBE_HIER_LEVELS view, 6.270

USER_CUBE_HIER_VIEW_COLUMNS view, 6.271

USER_CUBE_HIER_VIEWS view, 6.272

USER_CUBE_HIERARCHIES view, 6.273

USER_CUBE_MEASURES view, 6.274

USER_CUBE_VIEW_COLUMNS view, 6.275

USER_CUBE_VIEWS view, 6.276

USER_CUBES view, 6.277

USER_DATAPUMP_JOBS view, 6.278

USER_DB_LINKS view, 6.279

USER_DBFS_HS_FILES view, 6.280

USER_DEPENDENCIES view, 6.281

USER_DIM_ATTRIBUTES view, 6.282

USER_DIM_CHILD_OF view, 6.283

USER_DIM_HIERARCHIES view, 6.284

USER_DIM_JOIN_KEY view, 6.285

USER_DIM_LEVEL_KEY view, 6.286

USER_DIM_LEVELS view, 6.287

USER_DIMENSIONS view, 6.288

USER_DUMP_DEST initialization parameter, 1.269

USER_EDITIONING_VIEW_COLS view, 6.289

USER_EDITIONING_VIEW_COLS_AE view, 6.290

USER_EDITIONING_VIEWS view, 6.291

USER_EDITIONING_VIEWS_AE view, 6.292

USER_ENCRYPTED_COLUMNS view, 6.293

USER_EPG_DAD_AUTHORIZATION view, 6.294

USER_ERRORS view, 6.295

USER_ERRORS_AE view, 6.296

USER_EVALUATION_CONTEXT_TABLES view, 6.297

USER_EVALUATION_CONTEXT_VARS view, 6.298

USER_EVALUATION_CONTEXTS view, 6.299

USER_EXTENTS view, 6.300

USER_EXTERNAL_LOCATIONS view, 6.301

USER_EXTERNAL_TABLES view, 6.302

USER_FILE_GROUP_EXPORT_INFO view, 6.303

USER_FILE_GROUP_FILES view, 6.304

USER_FILE_GROUP_TABLES view, 6.305

USER_FILE_GROUP_TABLESPACES view, 6.306

USER_FILE_GROUP_VERSIONS view, 6.307

USER_FILE_GROUPS view, 6.308

USER_FLASHBACK_ARCHIVE view, 6.309

USER_FLASHBACK_ARCHIVE_TABLES view, 6.310

USER_FLASHBACK_TXN_REPORT view, 6.311

USER_FLASHBACK_TXN_STATE view, 6.312

USER_FREE_SPACE view, 6.313

USER_HISTOGRAMS synonym for USER_TAB_HISTOGRAMS, 6.314

USER_IDENTIFIERS view, 6.315

USER_IND_COLUMNS view, 6.316

USER_IND_EXPRESSIONS view, 6.317

USER_IND_PARTITIONS view, 6.318

USER_IND_PENDING_STATS view, 6.319

USER_IND_STATISTICS view, 6.320

USER_IND_SUBPARTITIONS view, 6.321

USER_INDEXES view, 6.322

IND synonym, 6.141

USER_INDEXTYPE_ARRAYTYPES view, 6.323

USER_INDEXTYPE_COMMENTS view, 6.324

USER_INDEXTYPE_OPERATORS view, 6.325

USER_INDEXTYPES view, 6.326

USER_INTERNAL_TRIGGERS view, 6.327

USER_JAVA_ARGUMENTS view, 6.328

USER_JAVA_CLASSES view, 6.329

USER_JAVA_COMPILER_OPTIONS view, 6.330

USER_JAVA_DERIVATIONS view, 6.331

USER_JAVA_FIELDS view, 6.332

USER_JAVA_IMPLEMENTS view, 6.333

USER_JAVA_INNERS view, 6.334

USER_JAVA_LAYOUTS view, 6.335

USER_JAVA_METHODS view, 6.336

USER_JAVA_NCOMPS view, 6.337

USER_JAVA_POLICY view, 6.338

USER_JAVA_RESOLVERS view, 6.339

USER_JAVA_THROWS view, 6.340

USER_JOBS view, 6.341

ALL_JOBS synonym, 2.127

USER_JOIN_IND_COLUMNS view, 6.342

USER_LIBRARIES view, 6.343

USER_LOB_PARTITIONS view, 6.344

USER_LOB_SUBPARTITIONS view, 6.345

USER_LOB_TEMPLATES view, 6.346

USER_LOBS view, 6.347

USER_LOG_GROUP_COLUMNS view, 6.348

USER_LOG_GROUPS view, 6.349

USER_MEASURE_FOLDER_CONTENTS view, 6.350

USER_MEASURE_FOLDERS view, 6.351

USER_METHOD_PARAMS view, 6.352

USER_METHOD_RESULTS view, 6.353

USER_MINING_MODEL_ATTRIBUTES view, 6.354

USER_MINING_MODEL_SETTINGS view, 6.355

USER_MINING_MODELS view, 6.356

USER_MP_GRAPH_WORKSPACES view, 2.1.2

USER_MP_PARENT_WORKSPACES view, 2.1.2

USER_MVIEW_AGGREGATES view, 6.357

USER_MVIEW_ANALYSIS view, 6.358

USER_MVIEW_COMMENTS view, 6.359

USER_MVIEW_DETAIL_PARTITION view, 6.360

USER_MVIEW_DETAIL_RELATIONS view, 6.361

USER_MVIEW_DETAIL_SUBPARTITION view, 6.362

USER_MVIEW_JOINS view, 6.363

USER_MVIEW_KEYS view, 6.364

USER_MVIEW_LOGS view, 6.365

USER_MVIEW_REFRESH_TIMES view, 6.366

USER_MVIEWS view, 6.367

USER_NESTED_TABLE_COLS view, 6.368

USER_NESTED_TABLES view, 6.369

USER_NETWORK_ACL_PRIVILEGES view, 6.370

USER_OBJ_AUDIT_OPTS view, 6.371

USER_OBJ_COLATTRS view, 6.372

USER_OBJECT_SIZE view, 6.373

USER_OBJECT_TABLES view, 6.374

USER_OBJECTS view, 6.375

OBJ synonym, 6.149

USER_OBJECTS_AE view, 6.376

USER_OPANCILLARY view, 6.377

USER_OPARGUMENTS view, 6.378

USER_OPBINDINGS view, 6.379

USER_OPERATOR_COMMENTS view, 6.380

USER_OPERATORS view, 6.381

USER_OUTLINE_HINTS view, 6.382

ALL_OUTLINE_HINTS synonym, 2.165

USER_OUTLINES view, 6.383

ALL_OUTLINES synonym, 2.166

USER_PARALLEL_EXECUTE_CHUNKS view, 6.384

USER_PARALLEL_EXECUTE_TASKS view, 6.385

USER_PART_COL_STATISTICS view, 6.386

USER_PART_HISTOGRAMS view, 6.387

USER_PART_INDEXES view, 6.388

USER_PART_KEY_COLUMNS view, 6.389

USER_PART_LOBS view, 6.390

USER_PART_TABLES view, 6.391

USER_PARTIAL_DROP_TABS view, 6.392

USER_PASSWORD_LIMITS view, 6.393

USER_PENDING_CONV_TABLES view, 6.394

USER_PLSQL_OBJECT_SETTINGS view, 6.395

USER_POLICIES view, 6.396

USER_POLICY_CONTEXTS view, 6.397

USER_POLICY_GROUPS view, 6.398

USER_PROCEDURES view, 6.399

USER_PROXIES view, 6.400

USER_PUBLISHED_COLUMNS view, 6.401

ALL_PUBLISHED_COLUMNS synonym, 3.15

USER_QUEUE_SCHEDULES view, 6.402

USER_QUEUE_SUBSCRIBERS view, 6.403

USER_QUEUE_TABLES view, 6.404

USER_QUEUES view, 6.405

USER_RECYCLEBIN view, 6.406

RECYCLEBIN synonym, 6.159

USER_REFRESH view, 6.407

USER_REFRESH_CHILDREN view, 6.408

USER_REFS view, 6.409

USER_REGISTERED_MVIEWS view, 6.410

USER_REGISTRY view, 6.411

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

USER_RESUMABLE view, 6.413

USER_REWRITE_EQUIVALENCES view, 6.414

USER_ROLE_PRIVS view, 6.415

USER_RSRC_CONSUMER_GROUP_PRIVS view, 6.416

USER_RSRC_MANAGER_SYSTEM_PRIVS view, 6.417

USER_RULE_SET_RULES view, 6.418

USER_RULE_SETS view, 6.419

USER_RULES view, 6.420

USER_SCHEDULER_CHAIN_RULES view, 6.421

USER_SCHEDULER_CHAIN_STEPS view, 6.422

USER_SCHEDULER_CHAINS view, 6.423

USER_SCHEDULER_CREDENTIALS view, 6.424

USER_SCHEDULER_DB_DESTS view, 6.425

USER_SCHEDULER_DESTS view, 6.426

USER_SCHEDULER_FILE_WATCHERS view, 6.427

USER_SCHEDULER_GROUP_MEMBERS view, 6.428

USER_SCHEDULER_GROUPS view, 6.429

USER_SCHEDULER_JOB_ARGS view, 6.430

USER_SCHEDULER_JOB_DESTS view, 6.431

USER_SCHEDULER_JOB_LOG view, 6.432

USER_SCHEDULER_JOB_RUN_DETAILS view, 6.433

USER_SCHEDULER_JOBS view, 6.434

USER_SCHEDULER_NOTIFICATIONS view, 6.435

USER_SCHEDULER_PROGRAM_ARGS view, 6.436

USER_SCHEDULER_PROGRAMS view, 6.437

USER_SCHEDULER_REMOTE_JOBSTATE view, 6.438

USER_SCHEDULER_RUNNING_CHAINS view, 6.439

USER_SCHEDULER_RUNNING_JOBS view, 6.440

USER_SCHEDULER_SCHEDULES view, 6.441

USER_SEC_RELEVANT_COLS view, 6.442

USER_SECONDARY_OBJECTS view, 6.443

USER_SEGMENTS view, 6.444

USER_SEQUENCES view, 6.445

SEQ synonym, 6.173

USER_SOURCE view, 6.446

USER_SOURCE_AE view, 6.447

USER_SOURCE_TABLES view, 6.448

ALL_SOURCE_TABLES synonym, 3.66

USER_SQLJ_TYPE_ATTRS view, 6.449

USER_SQLJ_TYPE_METHODS view, 6.450

USER_SQLJ_TYPES view, 6.451

USER_SQLSET view, 6.452

USER_SQLSET_BINDS view, 6.453

USER_SQLSET_PLANS view, 6.454

USER_SQLSET_REFERENCES view, 6.455

USER_SQLSET_STATEMENTS view, 6.456

USER_SQLTUNE_BINDS view, 6.457

USER_SQLTUNE_PLANS view, 6.458

USER_SQLTUNE_RATIONALE_PLAN view, 6.459

USER_SQLTUNE_STATISTICS view, 6.460

USER_STAT_EXTENSIONS view, 6.461

USER_STORED_SETTINGS view, 6.462

USER_SUBPART_COL_STATISTICS view, 6.463

USER_SUBPART_HISTOGRAMS view, 6.464

USER_SUBPART_KEY_COLUMNS view, 6.465

USER_SUBPARTITION_TEMPLATES view, 6.466

USER_SUBSCR_REGISTRATIONS view, 6.467

USER_SUBSCRIBED_COLUMNS view, 6.468

ALL_SUBSCRIBED_COLUMNS synonym, 3.93

USER_SUBSCRIBED_TABLES view, 6.469

ALL_SUBSCRIBED_TABLES synonym, 3.94

USER_SUBSCRIPTIONS view, 6.470

ALL_SUBSCRIPTIONS synonym, 3.95

USER_SYNONYMS view, 6.471

SYN synonym, 6.179

USER_SYS_PRIVS view, 6.472

USER_TAB_COL_STATISTICS view, 6.473

USER_TAB_COLS view, 6.474

USER_TAB_COLUMNS view, 6.475

COLS synonym, 3.159

USER_TAB_COMMENTS view, 6.476

USER_TAB_HISTGRM_PENDING_STATS view, 6.477

USER_TAB_HISTOGRAMS view, 6.478

USER_HISTOGRAMS synonym, 6.314

USER_TAB_MODIFICATIONS view, 6.479

USER_TAB_PARTITIONS view, 6.480

USER_TAB_PENDING_STATS view, 6.481

USER_TAB_PRIVS view, 6.482

USER_TAB_PRIVS_MADE view, 6.483

USER_TAB_PRIVS_RECD view, 6.484

USER_TAB_STAT_PREFS view, 6.485

USER_TAB_STATISTICS view, 6.486

USER_TAB_STATS_HISTORY view, 6.487

USER_TAB_SUBPARTITIONS view, 6.488

USER_TABLES view, 6.489

TABS synonym, 6.189

USER_TABLESPACES view, 6.490

USER_TRANSFORMATIONS view, 6.491

USER_TRIGGER_COLS view, 6.492

USER_TRIGGER_ORDERING view, 6.493

USER_TRIGGERS view, 6.494

USER_TS_QUOTAS view, 6.495

USER_TSTZ_TAB_COLS view, 6.496

USER_TSTZ_TABLES view, 6.497

USER_TUNE_MVIEW view, 6.498

USER_TYPE_ATTRS view, 6.499

USER_TYPE_METHODS view, 6.500

USER_TYPE_VERSIONS view, 6.501

USER_TYPES view, 6.502

USER_UNUSED_COL_TABS view, 6.503

USER_UPDATABLE_COLUMNS view, 6.504

USER_USERS view, 6.505

USER_USTATS view, 6.506

USER_VARRAYS view, 6.507

USER_VIEWS view, 6.508

USER_VIEWS_AE view, 6.509

USER_WARNING_SETTINGS view, 6.510

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

USER_XML_SCHEMAS view, 6.512

USER_XML_TAB_COLS view, 6.513

USER_XML_TABLES view, 6.514

USER_XML_VIEW_COLS view, 6.515

USER_XML_VIEWS view, 6.516

USERLOCK.SQL script, B.2

users

authenticating, 1.176

multiple, 1.82

UTL_FILE_DIR initialization parameter, 1.270

UTLBSTAT.SQL script, B.2

UTLCHN1.SQL script, B.2

UTLCONST.SQL script, B.2

UTLDTREE.SQL script, 6.117, 6.140, 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$CLONEDFILE view, 7.83

V$CLUSTER_INTERCONNECTS view, 7.84

V$CONFIGURED_INTERCONNECTS view, 7.85

V$CONTEXT view, 7.86

V$CONTROLFILE view, 7.87

V$CONTROLFILE_RECORD_SECTION view, 7.88

V$COPY_CORRUPTION view, 7.89

V$CORRUPT_XID_LIST view, 7.90

V$CPOOL_CC_INFO view, 7.91

V$CPOOL_CC_STATS view, 7.92

V$CPOOL_CONN_INFO view, 7.93

V$CPOOL_STATS view, 7.94

V$CR_BLOCK_SERVER view, 7.95

V$CURRENT_BLOCK_SERVER view, 7.96

V$DATABASE view, 7.97

V$DATABASE_BLOCK_CORRUPTION view, 7.98

V$DATABASE_INCARNATION view, 7.99

V$DATAFILE view, 7.100

V$DATAFILE_COPY view, 7.101

V$DATAFILE_HEADER view, 7.102

V$DATAGUARD_CONFIG view, 7.103

V$DATAGUARD_STATS view, 7.104

V$DATAGUARD_STATUS view, 7.105

V$DB_CACHE_ADVICE view, 7.106

V$DB_OBJECT_CACHE view, 7.107

V$DB_PIPES view, 7.108

V$DB_TRANSPORTABLE_PLATFORM view, 7.109

V$DBFILE view, 7.110

V$DBLINK view, 7.111

V$DEAD_CLEANUP view, 7.112

V$DELETED_OBJECT view, 7.113

V$DISPATCHER view, 7.114

V$DISPATCHER_CONFIG view, 7.115

V$DISPATCHER_RATE view, 7.116

V$DNFS_CHANNELS view, 7.117

V$DNFS_FILES view, 7.118

V$DNFS_SERVERS view, 7.119

V$DNFS_STATS view, 7.120

V$DYNAMIC_REMASTER_STATS view, 7.121

V$EMON view, 7.122

V$ENABLEDPRIVS view, 7.123

V$ENCRYPTED_TABLESPACES view, 7.124

V$ENCRYPTION_WALLET view, 7.125

V$ENQUEUE_LOCK view, 7.126

V$ENQUEUE_STAT view, 7.127

V$ENQUEUE_STATISTICS view, 7.128

V$EVENT_HISTOGRAM view, 7.129

V$EVENT_NAME view, 7.130

V$EVENTMETRIC view, 7.131

V$EXECUTION view, 7.132

V$FALSE_PING view, 7.133

V$FAST_START_SERVERS view, 7.134

V$FAST_START_TRANSACTIONS view, 7.135

V$FILE_CACHE_TRANSFER view, 7.136

V$FILE_HISTOGRAM view, 7.137

V$FILEMETRIC view, 7.138

V$FILEMETRIC_HISTORY view, 7.139

V$FILESPACE_USAGE view, 7.140

V$FILESTAT view, 7.141

V$FIXED_TABLE view, 7.142

V$FIXED_VIEW_DEFINITION view, 7.143

V$FLASHBACK_DATABASE_LOG view, 7.144

V$FLASHBACK_DATABASE_LOGFILE view, 7.145

V$FLASHBACK_DATABASE_STAT view, 7.146

V$FLASHBACK_TXN_GRAPH view, 7.147

V$FLASHBACK_TXN_MODS view, 7.148

V$FOREIGN_ARCHIVED_LOG view, 7.149

V$FS_FAILOVER_STATS view, 7.150

V$FS_OBSERVER_HISTOGRAM view, 7.151

V$GC_ELEMENT view, 7.152

V$GC_ELEMENTS_WITH_COLLISIONS view, 7.153

V$GCSHVMASTER_INFO view, 7.154

V$GCSPFMASTER_INFO view, 7.155

V$GES_BLOCKING_ENQUEUE view, 7.156

V$GES_CONVERT_LOCAL view, 7.157

V$GES_CONVERT_REMOTE view, 7.158

V$GES_ENQUEUE view, 7.159

V$GES_LATCH view, 7.160

V$GES_RESOURCE view, 7.161

V$GES_STATISTICS view, 7.162

V$GG_APPLY_COORDINATOR view, 7.163

V$GG_APPLY_READER view, 7.164

V$GG_APPLY_RECEIVER view, 7.165

V$GG_APPLY_SERVER view, 7.166

V$GLOBAL_BLOCKED_LOCKS view, 7.167

V$GLOBAL_TRANSACTION view, 7.168

V$GOLDENGATE_CAPTURE view, 7.169

V$HANG_INFO view, 7.170

V$HANG_SESSION_INFO view, 7.171

V$HANG_STATISTICS view, 7.172

V$HM_CHECK view, 7.173

V$HM_CHECK_PARAM view, 7.174

V$HM_FINDING view, 7.175

V$HM_INFO view, 7.176

V$HM_RECOMMENDATION view, 7.177

V$HM_RUN view, 7.178

V$HS_AGENT view, 7.179

V$HS_PARAMETER view, 7.180

V$HS_SESSION view, 7.181

V$HVMASTER_INFO view, 7.182

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$RO_USER_ACCOUNT view, 8.150

V$ROLLNAME view, 8.151

V$ROLLSTAT view, 8.152

V$ROWCACHE view, 8.153

V$ROWCACHE_PARENT view, 8.154

V$ROWCACHE_SUBORDINATE view, 8.155

V$RSRC_CONS_GROUP_HISTORY view, 8.156

V$RSRC_CONSUMER_GROUP view, 8.157

V$RSRC_CONSUMER_GROUP_CPU_MTH view, 8.158

V$RSRC_PLAN view, 8.159

V$RSRC_PLAN_CPU_MTH view, 8.160

V$RSRC_PLAN_HISTORY view, 8.161

V$RSRC_SESSION_INFO view, 8.162

V$RSRCMGRMETRIC view, 8.163

V$RSRCMGRMETRIC_HISTORY view, 8.164

V$RULE view, 8.165

V$RULE_SET view, 8.166

V$RULE_SET_AGGREGATE_STATS view, 8.167

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_APPLY_COORDINATOR view, 9.129

V$XSTREAM_APPLY_READER view, 9.130

V$XSTREAM_APPLY_RECEIVER view, 9.131

V$XSTREAM_APPLY_SERVER view, 9.132

V$XSTREAM_CAPTURE view, 9.133

V$XSTREAM_MESSAGE_TRACKING view, 9.134

V$XSTREAM_OUTBOUND_SERVER view, 9.135

V$XSTREAM_TRANSACTION view, 9.136

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

utl_file I/O, C.3.151

virtual circuit status, C.3.152

virtual circuit wait, C.3.153

WCR: replay client notify, C.3.154

WCR: replay clock, C.3.155

WCR: replay lock order, C.3.156

WCR: replay paused, C.3.157

WCR: Sync context busy, C.3.158

WMON goes to sleep, C.3.159

write complete waits, C.3.160

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

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

---

X

XML_DB_EVENTS initialization parameter, 1.272

XS_SESSION_ROLES view, 6.517