Index

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

A

ACTIVE_INSTANCE_COUNT initialization parameter, 1-15

ALL_ALL_TABLES view, 2-6

ALL_APPLY view, 2-8

ALL_APPLY_CONFLICT_COLUMNS view, 2-9

ALL_APPLY_DML_HANDLERS view, 2-10

ALL_APPLY_ERROR view, 2-10

ALL_APPLY_KEY_COLUMNS view, 2-11

ALL_APPLY_PARAMETERS view, 2-12

ALL_APPLY_PROGRESS view, 2-12

ALL_ARGUMENTS view, 2-13

ALL_ASSOCIATIONS view, 2-14

ALL_AUDIT_POLICIES view, 2-15

ALL_BASE_TABLE_MVIEWS view, 2-16

ALL_CAPTURE view, 2-17

ALL_CAPTURE_PARAMETERS view, 2-18

ALL_CAPTURE_PREPARED_DATABASE view, 2-18

ALL_CAPTURE_PREPARED_SCHEMAS view, 2-19

ALL_CAPTURE_PREPARED_TABLES view, 2-19

ALL_CATALOG view, 2-20

ALL_CLUSTER_HASH_EXPRESSIONS view, 2-20

ALL_CLUSTERS view, 2-21

ALL_COL_COMMENTS view, 2-22

ALL_COL_PRIVS view, 2-22

ALL_COL_PRIVS_MADE view, 2-23

ALL_COL_PRIVS_RECD view, 2-24

ALL_COLL_TYPES view, 2-25

ALL_CONS_COLUMNS view, 2-25

ALL_CONS_OBJ_COLUMNS view, 2-26

ALL_CONSTRAINTS view, 2-27

ALL_CONTEXT view, 2-28

ALL_DB_LINKS view, 2-29

ALL_DEF_AUDIT_OPTS view, 2-29

ALL_DEPENDENCIES view, 2-30

ALL_DIM_ATTRIBUTES view, 2-31

ALL_DIM_CHILD_OF view, 2-32

ALL_DIM_HIERARCHIES view, 2-32

ALL_DIM_JOIN_KEY view, 2-33

ALL_DIM_LEVEL_KEY view, 2-33

ALL_DIM_LEVELS view, 2-34

ALL_DIMENSIONS view, 2-34

ALL_DIRECTORIES view, 2-35

ALL_ERRORS view, 2-35

ALL_EVALUATION_CONTEXT_TABLES view, 2-36

ALL_EVALUATION_CONTEXT_VARS view, 2-36

ALL_EVALUATION_CONTEXTS view, 2-37

ALL_EXTERNAL_LOCATIONS view, 2-38

ALL_EXTERNAL_TABLES view, 2-39

ALL_IND_COLUMNS view, 2-40

ALL_IND_EXPRESSIONS view, 2-41

ALL_IND_PARTITIONS view, 2-41

ALL_IND_SUBPARTITIONS view, 2-43

ALL_INDEXES view, 2-45

ALL_INDEXTYPE_COMMENTS view, 2-48

ALL_INDEXTYPE_OPERATORS view, 2-49

ALL_INDEXTYPES view, 2-50

ALL_INTERNAL_TRIGGERS view, 2-50

ALL_JAVA_ARGUMENTS view, 2-51

ALL_JAVA_CLASSES view, 2-52

ALL_JAVA_DERIVATIONS view, 2-53

ALL_JAVA_FIELDS view, 2-54

ALL_JAVA_IMPLEMENTS view, 2-55

ALL_JAVA_INNERS view, 2-56

ALL_JAVA_LAYOUTS view, 2-57

ALL_JAVA_METHODS view, 2-58

ALL_JAVA_NCOMPS view, 2-59

ALL_JAVA_RESOLVERS view, 2-60

ALL_JAVA_THROWS view, 2-61

ALL_JOBS view, 2-61

ALL_JOIN_IND_COLUMNS view, 2-63

ALL_LIBRARIES view, 2-63

ALL_LOB_PARTITIONS view, 2-64

ALL_LOB_SUBPARTITIONS view, 2-65

ALL_LOB_TEMPLATES view, 2-66

ALL_LOBS view, 2-67

ALL_LOG_GROUP_COLUMNS view, 2-68

ALL_LOG_GROUPS view, 2-69

ALL_METHOD_PARAMS view, 2-69

ALL_METHOD_RESULTS view, 2-70

ALL_MVIEW_AGGREGATES view, 2-71

ALL_MVIEW_ANALYSIS view, 2-72

ALL_MVIEW_DETAIL_RELATIONS view, 2-73

ALL_MVIEW_JOINS view, 2-74

ALL_MVIEW_KEYS view, 2-75

ALL_MVIEW_LOGS view, 2-76

ALL_MVIEW_REFRESH_TIMES view, 2-77

ALL_MVIEWS view, 2-77

ALL_NESTED_TABLES view, 2-82

ALL_OBJ_COLATTRS view, 2-82

ALL_OBJECT_TABLES view, 2-83

ALL_OBJECTS view, 2-85

ALL_OPANCILLARY view, 2-86

ALL_OPARGUMENTS view, 2-87

ALL_OPBINDINGS view, 2-87

ALL_OPERATOR_COMMENTS view, 2-88

ALL_OPERATORS view, 2-89

ALL_OUTLINE_HINTS view, 2-89

ALL_OUTLINES view, 2-90

ALL_PART_COL_STATISTICS view, 2-91

ALL_PART_HISTOGRAMS view, 2-92

ALL_PART_INDEXES view, 2-92

ALL_PART_KEY_COLUMNS view, 2-94

ALL_PART_LOBS view, 2-95

ALL_PART_TABLES view, 2-96

ALL_PARTIAL_DROP_TABS view, 2-98

ALL_PENDING_CONV_TABLES view, 2-98

ALL_POLICIES view, 2-99

ALL_POLICY_CONTEXTS view, 2-100

ALL_POLICY_GROUPS view, 2-101

ALL_PROCEDURES view, 2-101

ALL_PROPAGATION view, 2-102

ALL_PUBLISHED_COLUMNS view, 2-103

ALL_QUEUE_TABLES view, 2-103

ALL_QUEUES view, 2-105

ALL_REFRESH view, 2-105

ALL_REFRESH_CHILDREN view, 2-106

ALL_REFRESH_DEPENDENCIES view, 2-107

ALL_REFS view, 2-108

ALL_REGISTERED_MVIEWS view, 2-108

ALL_REGISTRY_BANNERS view, 2-109

ALL_REPAUDIT_ATTRIBUTE view, 2-2

ALL_REPAUDIT_COLUMN view, 2-2

ALL_REPCAT view, 2-2

ALL_REPCAT_REFRESH_TEMPLATES view, 2-2

ALL_REPCAT_TEMPLATE_OBJECTS view, 2-2

ALL_REPCAT_TEMPLATE_PARMS view, 2-2

ALL_REPCAT_TEMPLATE_SITES view, 2-2

ALL_REPCAT_USER_AUTHORIZATIONS view, 2-2

ALL_REPCAT_USER_PARM_VALUES view, 2-2

ALL_REPCATLOG view, 2-2

ALL_REPCOLUMN view, 2-2

ALL_REPCOLUMN_GROUP view, 2-2

ALL_REPCONFLICT view, 2-2

ALL_REPDDL view, 2-2

ALL_REPFLAVOR_COLUMNS view, 2-2

ALL_REPFLAVOR_OBJECTS view, 2-2

ALL_REPFLAVORS view, 2-2

ALL_REPGENERATED view, 2-2

ALL_REPGENOBJECTS view, 2-2

ALL_REPGROUP view, 2-2

ALL_REPGROUP_PRIVILEGES view, 2-2

ALL_REPGROUPED_COLUMN view, 2-2

ALL_REPKEY_COLUMNS view, 2-2

ALL_REPOBJECT view, 2-2

ALL_REPPARAMETER_COLUMN view, 2-2

ALL_REPPRIORITY view, 2-2

ALL_REPPRIORITY_GROUP view, 2-2

ALL_REPPROP view, 2-2

ALL_REPRESOL_STATS_CONTROL view, 2-2

ALL_REPRESOLUTION view, 2-2

ALL_REPRESOLUTION_METHOD view, 2-2

ALL_REPRESOLUTION_STATISTICS view, 2-2

ALL_REPSCHEMA view, 2-2

ALL_REPSITES view, 2-2

ALL_RULE_SET_RULES view, 2-110

ALL_RULE_SETS view, 2-110

ALL_RULES view, 2-111

ALL_SEQUENCES view, 2-112

ALL_SOURCE view, 2-112

ALL_SOURCE_TABLES view, 2-113

ALL_SQLJ_TYPE_ATTRS view, 2-113

ALL_SQLJ_TYPE_METHODS view, 2-114

ALL_SQLJ_TYPES view, 2-115

ALL_STORED_SETTINGS view, 2-116

ALL_STREAMS_GLOBAL_RULES view, 2-117

ALL_STREAMS_SCHEMA_RULES view, 2-118

ALL_STREAMS_TABLE_RULES view, 2-119

ALL_SUBPART_COL_STATISTICS view, 2-121

ALL_SUBPART_HISTOGRAMS view, 2-122

ALL_SUBPART_KEY_COLUMNS view, 2-123

ALL_SUBPARTITION_TEMPLATES view, 2-124

ALL_SUBSCRIBED_COLUMNS view, 2-124

ALL_SUBSCRIBED_TABLES view, 2-125

ALL_SUBSCRIPTIONS view, 2-125

ALL_SUMDELTA view, 2-126

ALL_SYNONYMS view, 2-126

ALL_TAB_COL_STATISTICS view, 2-127

ALL_TAB_COLUMNS view, 2-128

ALL_TAB_COMMENTS view, 2-130

ALL_TAB_HISTOGRAMS view, 2-130

ALL_TAB_MODIFICATIONS view, 2-131

ALL_TAB_PARTITIONS view, 2-132

ALL_TAB_PRIVS view, 2-133

ALL_TAB_PRIVS_MADE view, 2-134

ALL_TAB_PRIVS_RECD view, 2-135

ALL_TAB_SUBPARTITIONS view, 2-136

ALL_TABLES view, 2-137

ALL_TRIGGER_COLS view, 2-140

ALL_TRIGGERS view, 2-141

ALL_TYPE_ATTRS view, 2-142

ALL_TYPE_METHODS view, 2-143

ALL_TYPE_VERSIONS view, 2-144

ALL_TYPES view, 2-144

ALL_UNUSED_COL_TABS view, 2-145

ALL_UPDATABLE_COLUMNS view, 2-146

ALL_USERS view, 2-146

ALL_USTATS view, 2-147

ALL_VARRAYS view, 2-148

ALL_VERSION_HVIEW view, 2-3

ALL_VIEWS view, 2-148

ALL_WM_LOCKED_TABLES view, 2-3

ALL_WM_MODIFIED_TABLES view, 2-3

ALL_WM_RIC_INFO view, 2-3

ALL_WM_TAB_TRIGGERS view, 2-3

ALL_WM_VERSIONED_TABLES view, 2-3

ALL_WM_VT_ERRORS view, 2-3

ALL_WORKSPACE_PRIVS view, 2-3

ALL_WORKSPACE_SAVEPOINTS view, 2-3

ALL_WORKSPACES view, 2-3

ALL_XML_SCHEMAS view, 2-149

ALL_XML_TAB_COLS view, 2-150

ALL_XML_TABLES view, 2-151

ALL_XML_VIEW_COLS view, 2-151

ALL_XML_VIEWS view, 2-152

ALLOCATE EXTENT clause

of ALTER TABLE

instance number, 1-67

allocation

PCM locks, 1-60

ALTER DATABASE statement

ADD LOGFILE, 1-160

database name, 1-44

ENABLE THREAD, 1-160

THREAD, 1-160

ALTER SESSION statement

SET HASH_AREA_SIZE clause, 1-63

SET HASH_JOIN_ENABLED clause, 1-64

ALTER TABLE statement

allocating extents, 1-67

ANALYZE statement, 2-45, 2-128, 2-130, 2-137, 2-183, 2-226, 2-227, 2-289, 2-291

AQ_TM_PROCESSES initialization parameter, 1-15

ARCHIVE LOG START statement

automatic archiving, 1-75

ARCHIVE_LAG_TARGET initialization parameter, 1-16

archived redo logs

automatic versus manual, 1-83

destination file, 1-75

storage device, 1-75, 1-80

ARCHIVELOG mode, 1-75

archiving destination, 1-75, 1-80

automatic archiving, 1-83

AUDIT_ACTIONS table, 2-153

AUDIT_FILE_DEST initialization parameter, 1-17

AUDIT_SYS_OPERATIONS initialization parameter, 1-17

AUDIT_TRAIL initialization parameter, 1-17

authenticating remote clients, 1-140

authenticating users, 1-119

B

BACKGROUND_CORE_DUMP initialization parameter, 1-18

BACKGROUND_DUMP_DEST initialization parameter, 1-18

BACKUP_TAPE_IO_SLAVES initialization parameter, 1-19

BITMAP_MERGE_AREA_SIZE initialization parameter, 1-20

BLANK_TRIMMING initialization parameter, 1-21

blocks

PCM lock, 1-60

redo log, 1-86

size, 1-32, 1-36, 1-44, 4-2

BUFFER_POOL_KEEP initialization parameter, 1-21

BUFFER_POOL_RECYCLE initialization parameter, 1-22

C

cache

dictionary, 3-98, 3-123, 3-124, 3-126, 3-127

statistics, 1-86

CAT synonym for USER_CATALOG view, 2-153

CATALOG view, 2-153

CATALOG.SQL script, 5-2

creating V$ views, 3-1

CATAUDIT.SQL script

audit trail records created by, 2-264

audit trails for connections and disconnections, 2-264

auditing characteristics described by, 2-278

CATBLOCK.SQL script, 5-3

CATCLUST.SQL script, 5-2

CATEXP7.SQL script, 5-3

CATHS.SQL script, 5-3

CATIO.SQL script, 5-3

CATJAVA.SQL script, 5-8

CATNOADT.SQL script, 5-6

CATNOAUD.SQL script, 5-6

CATNOHS.SQL script, 5-6

CATNOPRT.SQL script, 5-6

CATNOQUE.SQL script, 5-6

CATNORMN.SQL script, 5-6

CATNOSVM.SQL script, 5-6

CATNSNMP.SQL script, 5-6

CATOCTK.SQL script, 5-3

CATPROC.SQL script, 5-2

CATQUEUE.SQL script, 5-3

CATREP.SQL script, 5-3

CATRMAN.SQL script, 5-3

CHAINED_ROWS table, 2-153

CHANGE_SETS view, 2-154

CHANGE_SOURCES view, 2-154

CHANGE_TABLES view, 2-155

characters

numeric group separators, 1-101

checkpoints

checkpoint interval, 1-86

statistics, 1-86

CIRCUITS initialization parameter, 1-24

CLU synonym for USER_CLUSTERS view, 2-155

CLUSTER_DATABASE initialization parameter, 1-24

CLUSTER_DATABASE_INSTANCES initialization parameter, 1-25

CLUSTER_INTERCONNECTS initialization parameter, 1-25

CMPDBMIG.SQL script, 5-7

CODE_PIECES view, 2-156

CODE_SIZE view, 2-156

COL view, 2-156

COLS synonym for USER_TAB_COLUMNS view, 2-156

COLUMN_PRIVILEGES view, 2-156

COMMIT_POINT_STRENGTH initialization parameter, 1-26

COMPATIBLE initialization parameter, 1-27

concurrency

ROW_LOCKING initialization parameter, 1-144

contention

block-level, 3-189

control files

names, 1-28

specifying, 1-28

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 1-28

CONTROL_FILES initialization parameter, 1-28

CORE_DUMP_DEST initialization parameter, 1-29

cost-based optimization, 1-114

favoring IN-list iterators, 1-112

CPU_COUNT initialization parameter, 1-29

CREATE DATABASE statement

database name, 1-44

setting the log mode, 1-83

CREATE TABLE statement

FREELIST GROUPS clause, 1-67

CREATE_BITMAP_AREA_SIZE initialization parameter, 1-30

creating

a database

setting block size, 1-32, 1-36, 1-44

currency, 1-96

international currency symbol, 1-99

CURSOR_SHARING initialization parameter, 1-31

CURSOR_SPACE_FOR_TIME initialization parameter, 1-31

cursors

OPEN_CURSORS initialization parameter, 1-107

shared pool, 1-64, 1-149, 1-151

D

D0801070.SQL script, 5-7

D0900010.SQL script, 5-7

data blocks

reading multiple, 1-40

size of, 1-32, 1-36, 1-44

data dictionary, 2-1

cache, 3-98, 3-123, 3-124, 3-126, 3-127

datafiles, 1-60

scripts, 5-3

SQL scripts, 5-2

tables, 2-1

views, 1-60

overview, 2-1

user views, 2-1

database migration

scripts, 5-7

database writer process (DBWR)

checkpoint, 1-86

DATABASE_PROPERTIES view, 2-156

databases

block size, 4-2

database limits, 4-1

default language, 1-99

name, 1-44, 1-45

resource limits, 1-141, 1-142

valid characters for database name, 1-44

datafiles

mapping blocks to PCM locks, 1-60

maximum number, 1-43

parameter, 1-43

unspecified for PCM locks, 1-60

dates

language used for, 1-98, 1-103, 1-104

setting SYSDATE, 1-60

TO_CHAR function, 1-97

TO_DATE function, 1-97

DB_BLOCK_BUFFERS initialization parameter, 1-33

DB_BLOCK_CHECKING initialization parameter, 1-35

DB_BLOCK_CHECKSUM initialization parameter, 1-35

DB_BLOCK_SIZE initialization parameter, 1-36

DB_CACHE_ADVICE initialization parameter, 1-37

DB_CACHE_SIZE initialization parameter, 1-38

DB_CREATE_FILE_DEST initialization parameter, 1-38

DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 1-39

DB_DOMAIN initialization parameter, 1-39

DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 1-40

DB_FILE_NAME_CONVERT initialization parameter, 1-41

DB_FILES initialization parameter, 1-43

DB_KEEP_CACHE_SIZE initialization parameter, 1-44

DB_NAME initialization parameter, 1-44

DB_nK_CACHE_SIZE initialization parameter, 1-32

DB_RECYCLE_CACHE_SIZE initialization parameter, 1-45

DB_WRITER_PROCESSES initialization parameter, 1-45

DBA_2PC_NEIGHBORS view, 2-157

DBA_2PC_PENDING view, 2-157

DBA_ALL_TABLES view, 2-158

DBA_APPLICATION_ROLES view, 2-158

DBA_APPLY view, 2-158

DBA_APPLY_CONFLICT_COLUMNS view, 2-159

DBA_APPLY_DML_HANDLERS view, 2-159

DBA_APPLY_ERROR view, 2-159

DBA_APPLY_INSTANTIATED_OBJECTS view, 2-159

DBA_APPLY_KEY_COLUMNS view, 2-160

DBA_APPLY_PARAMETERS view, 2-160

DBA_APPLY_PROGRESS view, 2-160

DBA_AQ_AGENT_PRIVS view, 2-160

DBA_AQ_AGENTS view, 2-161

DBA_ASSOCIATIONS view, 2-161

DBA_ATTRIBUTE_TRANSFORMATIONS view, 2-161

DBA_AUDIT_EXISTS view, 2-162

DBA_AUDIT_OBJECT view, 2-163

DBA_AUDIT_POLICIES view, 2-164

DBA_AUDIT_SESSION view, 2-164

DBA_AUDIT_STATEMENT view, 2-165

DBA_AUDIT_TRAIL view, 2-167

DBA_AW_PS view, 2-169

DBA_AWS view, 2-169

DBA_BASE_TABLE_MVIEWS view, 2-170

DBA_BLOCKERS view, 2-170

DBA_CAPTURE view, 2-170

DBA_CAPTURE_PARAMETERS view, 2-171

DBA_CAPTURE_PREPARED_DATABASE view, 2-171

DBA_CAPTURE_PREPARED_SCHEMAS view, 2-171

DBA_CAPTURE_PREPARED_TABLES view, 2-171

DBA_CATALOG view, 2-171

DBA_CLU_COLUMNS view, 2-172

DBA_CLUSTER_HASH_EXPRESSIONS view, 2-172

DBA_CLUSTERS view, 2-172

DBA_COL_COMMENTS view, 2-172

DBA_COL_PRIVS view, 2-172

DBA_COLL_TYPES view, 2-173

DBA_CONS_COLUMNS view, 2-173

DBA_CONS_OBJ_COLUMNS view, 2-173

DBA_CONSTRAINTS view, 2-174

DBA_CONTEXT view, 2-174

DBA_DATA_FILES view, 1-60, 2-174, 2-239

DBA_DB_LINKS view, 2-174

DBA_DDL_LOCKS view, 2-175

DBA_DEPENDENCIES view, 2-175

DBA_DIM_ATTRIBUTES view, 2-176

DBA_DIM_CHILD_OF view, 2-176

DBA_DIM_HIERARCHIES view, 2-176

DBA_DIM_JOIN_KEY view, 2-176

DBA_DIM_LEVEL_KEY view, 2-176

DBA_DIM_LEVELS view, 2-176

DBA_DIMENSIONS view, 2-177

DBA_DIRECTORIES view, 2-177

DBA_DML_LOCKS view, 2-177

DBA_DMT_FREE_SPACE view, 2-178

DBA_DMT_USED_EXTENTS view, 2-178

DBA_ERRORS view, 2-178

DBA_EVALUATION_CONTEXT_TABLES view, 2-178

DBA_EVALUATION_CONTEXT_VARS view, 2-179

DBA_EVALUATION_CONTEXTS view, 2-179

DBA_EXP_FILES view, 2-179

DBA_EXP_OBJECTS view, 2-179

DBA_EXP_VERSION view, 2-180

DBA_EXTENTS view, 2-180

DBA_EXTERNAL_LOCATIONS view, 2-181

DBA_EXTERNAL_TABLES view, 2-181

DBA_FGA_AUDIT_TRAIL view, 2-181

DBA_FREE_SPACE view, 2-182

DBA_FREE_SPACE_COALESCED view, 2-182

DBA_IND_COLUMNS view, 2-183

DBA_IND_EXPRESSIONS view, 2-183

DBA_IND_PARTITIONS view, 2-183

DBA_IND_SUBPARTITIONS view, 2-183

DBA_INDEXES view, 2-183

collecting statistics for, 2-183

DBA_INDEXTYPE_COMMENTS view, 2-183

DBA_INDEXTYPE_OPERATORS view, 2-184

DBA_INDEXTYPES view, 2-184

DBA_INTERNAL_TRIGGERS view, 2-184

DBA_JAVA_ARGUMENTS view, 2-184

DBA_JAVA_CLASSES view, 2-184

DBA_JAVA_DERIVATIONS view, 2-184

DBA_JAVA_FIELDS view, 2-185

DBA_JAVA_IMPLEMENTS view, 2-185

DBA_JAVA_INNERS view, 2-185

DBA_JAVA_LAYOUTS view, 2-185

DBA_JAVA_METHODS view, 2-185

DBA_JAVA_NCOMPS view, 2-185

DBA_JAVA_POLICY view, 2-186

DBA_JAVA_RESOLVERS view, 2-186

DBA_JAVA_THROWS view, 2-187

DBA_JOBS view, 2-187

DBA_JOBS_RUNNING view, 2-187

DBA_JOIN_IND_COLUMNS view, 2-187

DBA_KGLLOCK view, 2-188

DBA_LIBRARIES view, 2-188

DBA_LMT_FREE_SPACE view, 2-188

DBA_LMT_USED_EXTENTS view, 2-188

DBA_LOB_PARTITIONS view, 2-189

DBA_LOB_SUBPARTITIONS view, 2-189

DBA_LOB_TEMPLATES view, 2-189

DBA_LOBS view, 2-189

DBA_LOCK view, 2-189

DBA_LOCKS synonym, 2-190

DBA_LOCK_INTERNAL view, 2-190

DBA_LOCKS synonym for DBA_LOCK view, 2-190

DBA_LOG_GROUP_COLUMNS view, 2-191

DBA_LOG_GROUPS view, 2-191

DBA_LOGSTDBY_EVENTS view, 2-191

DBA_LOGSTDBY_LOG view, 2-191

DBA_LOGSTDBY_NOT_UNIQUE view, 2-192

DBA_LOGSTDBY_PARAMETERS view, 2-193

DBA_LOGSTDBY_PROGRESS view, 2-194

DBA_LOGSTDBY_SKIP view, 2-195

DBA_LOGSTDBY_SKIP_TRANSACTION view, 2-195

DBA_LOGSTDBY_UNSUPPORTED view, 2-196

DBA_METHOD_PARAMS view, 2-196

DBA_METHOD_RESULTS view, 2-196

DBA_MVIEW_AGGREGATES view, 2-196

DBA_MVIEW_ANALYSIS view, 2-197

DBA_MVIEW_DETAIL_RELATIONS view, 2-197

DBA_MVIEW_JOINS view, 2-197

DBA_MVIEW_KEYS view, 2-197

DBA_MVIEW_LOG_FILTER_COLS view, 2-197

DBA_MVIEW_LOGS view, 2-198

DBA_MVIEW_REFRESH_TIMES view, 2-198

DBA_MVIEWS view, 2-198

DBA_NESTED_TABLES view, 2-198

DBA_OBJ_AUDIT_OPTS view, 2-198

DBA_OBJ_COLATTRS view, 2-199

DBA_OBJECT_SIZE view, 2-200

DBA_OBJECT_TABLES view, 2-200

DBA_OBJECTS view, 2-200

DBA_OPANCILLARY view, 2-200

DBA_OPARGUMENTS view, 2-201

DBA_OPBINDINGS view, 2-201

DBA_OPERATOR_COMMENTS view, 2-201

DBA_OPERATORS view, 2-201

DBA_OUTLINE_HINTS view, 2-202

DBA_OUTLINES view, 2-202

DBA_PART_COL_STATISTICS view, 2-202

DBA_PART_HISTOGRAMS view, 2-202

DBA_PART_INDEXES view, 2-202

DBA_PART_KEY_COLUMNS view, 2-203

DBA_PART_LOBS view, 2-203

DBA_PART_TABLES view, 2-203

DBA_PARTIAL_DROP_TABS view, 2-203

DBA_PENDING_CONV_TABLES view, 2-203

DBA_PENDING_TRANSACTIONS view, 2-203

DBA_POLICIES view, 2-204

DBA_POLICY_CONTEXTS view, 2-204

DBA_POLICY_GROUPS view, 2-204

DBA_PRIV_AUDIT_OPTS view, 2-204

DBA_PROCEDURES view, 2-205

DBA_PROFILES view, 2-205

DBA_PROPAGATION view, 2-205

DBA_PROXIES view, 2-205

DBA_PUBLISHED_COLUMNS view, 2-206

DBA_QUEUE_SCHEDULES view, 2-207

DBA_QUEUE_TABLES view, 2-208

DBA_QUEUES view, 2-208

DBA_RCHILD view, 2-209

DBA_REFRESH view, 2-209

DBA_REFRESH_CHILDREN view, 2-209

DBA_REFS view, 2-209

DBA_REGISTERED_MVIEW_GROUPS view, 2-209

DBA_REGISTERED_MVIEWS view, 2-210

DBA_REGISTRY view, 2-210

DBA_REGISTRY_HIERARCHY view, 2-211

DBA_REPAIR_TABLE view, 2-212

DBA_REPAUDIT_ATTRIBUTE view, 2-2

DBA_REPAUDIT_COLUMN view, 2-2

DBA_REPCAT view, 2-2

DBA_REPCAT_EXCEPTIONS view, 2-2

DBA_REPCAT_REFRESH_TEMPLATES view, 2-2

DBA_REPCAT_TEMPLATE_OBJECTS view, 2-2

DBA_REPCAT_TEMPLATE_PARMS view, 2-2

DBA_REPCAT_TEMPLATE_SITES view, 2-2

DBA_REPCAT_USER_AUTHORIZATIONS view, 2-2

DBA_REPCAT_USER_PARM_VALUES view, 2-2

DBA_REPCATLOG view, 2-2

DBA_REPCOLUMN view, 2-2

DBA_REPCOLUMN_GROUP view, 2-2

DBA_REPCONFLICT view, 2-2

DBA_REPDDL view, 2-2

DBA_REPEXTENSIONS view, 2-2

DBA_REPFLAVOR_COLUMNS view, 2-2

DBA_REPFLAVOR_OBJECTS view, 2-2

DBA_REPFLAVORS view, 2-2

DBA_REPGENERATED view, 2-2

DBA_REPGENOBJECTS view, 2-2

DBA_REPGROUP view, 2-2

DBA_REPGROUP_PRIVILEGES view, 2-2

DBA_REPGROUPED_COLUMN view, 2-2

DBA_REPKEY_COLUMNS view, 2-2

DBA_REPOBJECT view, 2-2

DBA_REPPARAMETER_COLUMN view, 2-2

DBA_REPPRIORITY view, 2-2

DBA_REPPRIORITY_GROUP view, 2-2

DBA_REPPROP view, 2-2

DBA_REPRESOL_STATS_CONTROL view, 2-2

DBA_REPRESOLUTION view, 2-2

DBA_REPRESOLUTION_METHOD view, 2-2

DBA_REPRESOLUTION_STATISTICS view, 2-2

DBA_REPSCHEMA view, 2-2

DBA_REPSITES view, 2-2

DBA_REPSITES_NEW view, 2-2

DBA_RESUMABLE view, 2-213

DBA_RGROUP view, 2-214

DBA_ROLE_PRIVS view, 2-215

DBA_ROLES view, 2-215

DBA_ROLLBACK_SEGS view, 2-215

DBA_RSRC_CONSUMER_GROUP_PRIVS view, 2-216

DBA_RSRC_CONSUMER_GROUPS view, 2-217

DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 2-217

DBA_RSRC_PLAN_DIRECTIVES view, 2-218

DBA_RSRC_PLANS view, 2-219

DBA_RULE_SET_RULES view, 2-220

DBA_RULE_SETS view, 2-220

DBA_RULES view, 2-220

DBA_SEGMENTS view, 2-220

DBA_SEQUENCES view, 2-221

DBA_SOURCE view, 2-222

DBA_SOURCE_TABLES view, 2-222

DBA_SQLJ_TYPE_ATTRS view, 2-222

DBA_SQLJ_TYPE_METHODS view, 2-222

DBA_SQLJ_TYPES view, 2-222

DBA_STMT_AUDIT_OPTS view, 2-222

DBA_STORED_SETTINGS view, 2-223

DBA_STREAMS_GLOBAL_RULES view, 2-223

DBA_STREAMS_SCHEMA_RULES view, 2-223

DBA_STREAMS_TABLE_RULES view, 2-224

DBA_SUBPART_COL_STATISTICS view, 2-224

DBA_SUBPART_HISTOGRAMS view, 2-224

DBA_SUBPART_KEY_COLUMNS view, 2-224

DBA_SUBPARTITION_TEMPLATES view, 2-224

DBA_SUBSCRIBED_COLUMNS view, 2-224

DBA_SUBSCRIBED_TABLES view, 2-225

DBA_SUBSCRIPTIONS view, 2-225

DBA_SYNONYMS view, 2-225

DBA_SYS_PRIVS view, 2-225

DBA_TAB_COL_STATISTICS view, 2-226

DBA_TAB_COLUMNS view, 2-226

DBA_TAB_COMMENTS view, 2-226

DBA_TAB_HISTOGRAMS view, 2-226

DBA_TAB_MODIFICATIONS view, 2-226

DBA_TAB_PARTITIONS view, 2-226

DBA_TAB_PRIVS view, 2-227

DBA_TAB_SUBPARTITIONS view, 2-227

DBA_TABLES view, 2-227

DBA_TABLESPACES view, 2-228

DBA_TEMP_FILES view, 2-229

DBA_TRANSFORMATIONS view, 2-230

DBA_TRIGGER_COLS view, 2-230

DBA_TRIGGERS view, 2-230

DBA_TS_QUOTAS view, 2-230

DBA_TYPE_ATTRS view, 2-231

DBA_TYPE_METHODS view, 2-231

DBA_TYPE_VERSIONS view, 2-231

DBA_TYPES view, 2-231

DBA_UNDO_EXTENTS view, 2-232

DBA_UNUSED_COL_TABS view, 2-232

DBA_UPDATABLE_COLUMNS view, 2-232

DBA_USERS view, 2-233

DBA_USTATS view, 2-234

DBA_VARRAYS view, 2-234

DBA_VIEWS view, 2-234

DBA_WAITERS view, 2-234

DBA_WORKSPACE_SESSIONS view, 2-3

DBA_XML_SCHEMAS view, 2-234

DBA_XML_TAB_COLS view, 2-235

DBA_XML_TABLES view, 2-235

DBA_XML_VIEW_COLS view, 2-235

DBA_XML_VIEWS view, 2-235

DBLINK_ENCRYPT_LOGIN initialization parameter, 1-46

DBMS_ALERT_INFO view, 2-235

DBMS_LOCK_ALLOCATED view, 2-236

DBMSIOTC.SQL script, 5-3

DBMSOTRC.SQL script, 5-3

DBMSPOOL.SQL script, 5-4

DBWR_IO_SLAVES initialization parameter, 1-46

DEFCALL view, 2-2

DEFCALLDEST view, 2-2

DEFDEFAULTDEST view, 2-2

DEFERRCOUNT view, 2-2

DEFERROR view, 2-2

DEFLOB view, 2-2

DEFPROPAGATOR view, 2-2

DEFSCHEDULE view, 2-2

DEFTRAN view, 2-2

DEFTRANDEST view, 2-2

DEPTREE view, 2-236

destination

archiving redo log files, 1-75

overriding default, 1-75

USER_DUMP_DEST, 1-169

DG_BROKER_CONFIG_FILEn initialization parameter, 1-47

DG_BROKER_START initialization parameter, 1-48

DICT synonym for DICTIONARY, 2-236

DICT_COLUMNS view, 2-236

DICTIONARY view, 2-237

DICT synonym, 2-236

disk drives

archiving destination, 1-75

DISK_ASYNCH_IO initialization parameter, 1-48

dispatcher processes

maximum number, 1-92

DISPATCHERS initialization parameter, 1-49

distinguished name, 1-135

DISTRIBUTED_LOCK_TIMEOUT initialization parameter, 1-53

DML_LOCKS initialization parameter, 1-53

DRS_START initialization parameter, 1-54

dump files, 1-93

dynamic performance tables

CATALOG.SQL script, 3-1

public synonyms (V$), 3-2

views (V_$), 3-2

E

embedded parameter files, 1-65

ENQUEUE_RESOURCES initialization parameter, 1-55

enqueues

being written redo log, B-1

bind, B-1

buffer cache management, B-1

controlfile transaction, B-1

cross-instance call invocation, B-1

database mount, B-1

datafile, B-1

direct loader index creation, B-1

disabling, 1-53

distributed recovery, B-1

distributed TX, B-1

DML, B-1

ENQUEUE_RESOURCES initialization parameter, 1-55

file set, B-1

instance attribute lock, B-1

instance number, B-1

instance recovery, B-1

instance registration lock, B-1

instance state, B-1

job queue, B-1

library cache invalidation, B-1

library cache lock, B-1

library cache pin, B-1

media recovery, B-1

parallel slave synchronization, B-1

parallel slaves, B-1

password file, B-1

process startup, B-1

redo log "kick", B-1

redo thread, B-1

row cache, B-1

sequence number, B-1

SMON, B-1

sort segment, B-1

space management transaction, B-1

synchronized replication, B-1

system commit number, B-1

temporary segment, B-1

temporary table, B-1

transaction, B-1

transaction recovery, B-1

undo segment, serialization, B-1

user name, B-1

user-defined locks, B-1

enterprise roles, 1-135

ERROR_SIZE view, 2-237

errors

archiving, 1-83

EVENT initialization parameter, 1-56

EXCEPTIONS view, 2-237

exclusive mode

specifying instance number, 1-67

extent

allocating to instance, 1-67

F

FAL_CLIENT initialization parameter, 1-56

FAL_SERVER initialization parameter, 1-57

FAST_START_IO_TARGET initialization parameter, 1-57

FAST_START_MTTR_TARGET initialization parameter, 1-58

FAST_START_PARALLEL_ROLLBACK initialization parameter, 1-59

FILE_LOCK view, 2-237

FILE_MAPPING initialization parameter, 1-59

FILE_PING view, 2-238

filenames

case significance, 1-5

name and number, 1-60

FILESYSTEMIO_OPTIONS initialization parameter, 1-60

FILEXT$ view, 2-239

FIXED_DATE initialization parameter, 1-60

free space list

locating space, 1-67

FREELIST GROUPS clause, 1-67

G

GC_FILES_TO_LOCKS initialization parameter, 1-60

GLOBAL_CONTEXT_POOL_SIZE initialization parameter, 1-62

GLOBAL_NAME view, 2-240

GLOBAL_NAMES initialization parameter, 1-62

GV$ views

for parallel servers, 3-2

H

HASH_AREA_SIZE initialization parameter, 1-63

HASH_JOIN_ENABLED initialization parameter, 1-64

Heterogeneous Services

agents, 1-64

HI_SHARED_MEMORY_ADDRESS initialization parameter, 1-64

hints

RULE, 1-114

HS_ALL_CAPS view, 2-240

HS_ALL_DD view, 2-240

HS_ALL_INITS view, 2-241

HS_AUTOREGISTER initialization parameter, 1-64

HS_BASE_CAPS view, 2-241

HS_BASE_DD view, 2-241

HS_CLASS_CAPS view, 2-242

HS_CLASS_DD view, 2-242

HS_CLASS_INIT view, 2-243

HS_EXTERNAL_OBJECT_PRIVILEGES view, 2-243

HS_EXTERNAL_OBJECTS view, 2-243

HS_EXTERNAL_USER_PRIVILEGES view, 2-244

HS_FDS_CLASS view, 2-244

HS_FDS_INST view, 2-244

HS_INST_CAPS view, 2-245

HS_INST_DD view, 2-245

HS_INST_INIT view, 2-246

I

IDEPTREE view, 2-246

IFILE initialization parameter, 1-6, 1-65

IND synonym for USER_INDEXES view, 2-247

INDEX_HISTOGRAM view, 2-247

INDEX_STATS view, 2-247

initialization parameter file

common file, 1-65

embedded, 1-65

INITDW.ORA, 1-4

line continuation character (), 1-6

overview, 1-4

initialization parameters

ACTIVE_INSTANCE_COUNT, 1-15

altering, 1-7

AQ_TM_PROCESSES, 1-15

ARCHIVE_LAG_TARGET, 1-16

AUDIT_FILE_DEST, 1-17

AUDIT_SYS_OPERATIONS, 1-17

AUDIT_TRAIL, 1-17

BACKGROUND_CORE_DUMP, 1-18

BACKGROUND_DUMP_DEST, 1-18

BACKUP_TAPE_IO_SLAVES, 1-19

BITMAP_MERGE_AREA_SIZE, 1-20

BLANK_TRIMMING, 1-21

BUFFER_POOL_KEEP, 1-21

BUFFER_POOL_RECYCLE, 1-22

case significance in filenames, 1-5

CIRCUITS, 1-24

CLUSTER_DATABASE, 1-24

CLUSTER_DATABASE_INSTANCES, 1-25

CLUSTER_INTERCONNECTS, 1-25

COMMIT_POINT_STRENGTH, 1-26

COMPATIBLE, 1-27

CONTROL_FILE_RECORD_KEEP_TIME, 1-28

CONTROL_FILES, 1-28

CORE_DUMP_DEST, 1-29

CPU_COUNT, 1-29

CREATE_BITMAP_AREA_SIZE, 1-30

CURSOR_SHARING, 1-31

CURSOR_SPACE_FOR_TIME, 1-31

database creation, 1-44

DB_BLOCK_BUFFERS, 1-33

DB_BLOCK_CHECKING, 1-35

DB_BLOCK_CHECKSUM, 1-35

DB_BLOCK_SIZE, 1-36

DB_CACHE_ADVICE, 1-37

DB_CACHE_SIZE, 1-38

DB_CREATE_FILE_DEST, 1-38

DB_CREATE_ONLINE_LOG_DEST_n, 1-39

DB_DOMAIN, 1-39

DB_FILE_MULTIBLOCK_READ_COUNT, 1-40

DB_FILE_NAME_CONVERT, 1-41

DB_FILES, 1-43

DB_KEEP_CACHE_SIZE, 1-44

DB_NAME, 1-44

DB_nK_CACHE_SIZE, 1-32

DB_RECYCLE_CACHE_SIZE, 1-45

DB_WRITER_PROCESSES, 1-45

DBLINK_ENCRYPT_LOGIN, 1-46

DBWR_IO_SLAVES, 1-46

derived, 1-3

DG_BROKER_CONFIG_FILEn, 1-47

DG_BROKER_START, 1-48

DISK_ASYNCH_IO, 1-48

DISPATCHERS, 1-49

display current settings, 1-11

DISTRIBUTED_LOCK_TIMEOUT, 1-53

DML_LOCKS, 1-53

DRS_START, 1-54

dynamic, 1-8

embedded initialization parameter files, 1-6

ENQUEUE_RESOURCES, 1-55

EVENT, 1-56

FAL_CLIENT, 1-56

FAL_SERVER, 1-57

FAST_START_IO_TARGET, 1-57

FAST_START_MTTR_TARGET, 1-58

FAST_START_PARALLEL_ROLLBACK, 1-59

FILE_MAPPING, 1-59

FILESYSTEMIO_OPTIONS, 1-60

FIXED_DATE, 1-60

GC_FILES_TO_LOCKS, 1-60

GLOBAL_CONTEXT_POOL_SIZE, 1-62

GLOBAL_NAMES, 1-62

HASH_AREA_SIZE, 1-63

HASH_JOIN_ENABLED, 1-64

HI_SHARED_MEMORY_ADDRESS, 1-64

HS_AUTOREGISTER, 1-64

IFILE, 1-6, 1-65

INSTANCE_GROUPS, 1-66

INSTANCE_NAME, 1-67

INSTANCE_NUMBER, 1-67

JAVA_MAX_SESSIONSPACE_SIZE, 1-68

JAVA_POOL_SIZE, 1-68

JAVA_SOFT_SESSIONSPACE_LIMIT, 1-69

JOB_QUEUE_PROCESSES, 1-69

LARGE_POOL_SIZE, 1-70

LICENSE_MAX_SESSIONS, 1-71

LICENSE_MAX_USERS, 1-72

LICENSE_SESSIONS_WARNING, 1-72

LOCAL_LISTENER, 1-73

LOCK_NAME_SPACE, 1-74

LOCK_SGA, 1-74

LOG_ARCHIVE_DEST, 1-75

LOG_ARCHIVE_DEST_n, 1-76

LOG_ARCHIVE_DEST_STATE_n, 1-78

LOG_ARCHIVE_DUPLEX_DEST, 1-79

LOG_ARCHIVE_FORMAT, 1-80

LOG_ARCHIVE_MAX_PROCESSES, 1-81

LOG_ARCHIVE_MIN_SUCCEED_DEST, 1-82

LOG_ARCHIVE_START, 1-83

LOG_ARCHIVE_TRACE, 1-84

LOG_BUFFER, 1-85

LOG_CHECKPOINT_INTERVAL, 1-86

LOG_CHECKPOINT_TIMEOUT, 1-87

LOG_CHECKPOINTS_TO_ALERT, 1-88

LOG_FILE_NAME_CONVERT, 1-88

LOG_PARALLELISM, 1-90

LOGMNR_MAX_PERSISTENT_SESSIONS, 1-90

MAX_COMMIT_PROPAGATION_DELAY, 1-91

MAX_DISPATCHERS, 1-92

MAX_DUMP_FILE_SIZE, 1-93

MAX_ENABLED_ROLES, 1-94

MAX_ROLLBACK_SEGMENTS, 1-94

MAX_SHARED_SERVERS, 1-94

NLS_CALENDAR, 1-95

NLS_COMP, 1-96

NLS_CURRENCY, 1-96

NLS_DATE_FORMAT, 1-97

NLS_DATE_LANGUAGE, 1-98

NLS_DUAL_CURRENCY, 1-98

NLS_ISO_CURRENCY, 1-99

NLS_LANGUAGE, 1-99

NLS_LENGTH_SEMANTICS, 1-100

NLS_NCHAR_CONV_EXCP, 1-100

NLS_NUMERIC_CHARACTERS, 1-101

NLS_SORT, 1-101

NLS_TERRITORY, 1-102

NLS_TIMESTAMP_FORMAT, 1-103

NLS_TIMESTAMP_TZ_FORMAT, 1-104

O7_DICTIONARY_ACCESSIBILITY, 1-104

OBJECT_CACHE_MAX_SIZE_PERCENT, 1-105

OBJECT_CACHE_OPTIMAL_SIZE, 1-106

OLAP_PAGE_POOL_SIZE, 1-106

OPEN_CURSORS, 1-107

OPEN_LINKS, 1-107

operating system-dependent values, 1-3

OPTIMIZER_DYNAMIC_SAMPLING, 1-109

OPTIMIZER_FEATURES_ENABLE, 1-109

OPTIMIZER_INDEX_CACHING, 1-112

OPTIMIZER_INDEX_COST_ADJ, 1-113

OPTIMIZER_MAX_PERMUTATIONS, 1-113

OPTIMIZER_MODE, 1-114

ORACLE_TRACE_COLLECTION_NAME, 1-115

ORACLE_TRACE_COLLECTION_PATH, 1-116

ORACLE_TRACE_COLLECTION_SIZE, 1-116

ORACLE_TRACE_ENABLE, 1-117

ORACLE_TRACE_FACILITY_NAME, 1-117

ORACLE_TRACE_FACILITY_PATH, 1-118

OS_AUTHENT_PREFIX, 1-119

OS_ROLES, 1-120

PARALLEL_ADAPTIVE_MULTI_USER, 1-120

PARALLEL_AUTOMATIC_TUNING, 1-121

PARALLEL_EXECUTION_MESSAGE_SIZE, 1-122

PARALLEL_INSTANCE_GROUP, 1-122

PARALLEL_MAX_SERVERS, 1-123

PARALLEL_MIN_PERCENT, 1-124

PARALLEL_MIN_SERVERS, 1-125

PARALLEL_THREADS_PER_CPU, 1-126

parameter files, 1-4

PARTITION_VIEW_ENABLED, 1-126

performance tuning, 1-3

PGA_AGGREGATE_TARGET, 1-127

PLSQL_COMPILER_FLAGS, 1-128

PLSQL_NATIVE_C_COMPILER, 1-129

PLSQL_NATIVE_LIBRARY_DIR, 1-129

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT, 1-129

PLSQL_NATIVE_LINKER, 1-130

PLSQL_NATIVE_MAKE_FILE_NAME, 1-130

PLSQL_NATIVE_MAKE_UTILITY, 1-131

PLSQL_V2_COMPATIBILITY, 1-131

PRE_PAGE_SGA, 1-132

PROCESSES, 1-133

QUERY_REWRITE_ENABLED, 1-133

QUERY_REWRITE_INTEGRITY, 1-134

RDBMS_SERVER_DN, 1-135

READ_ONLY_OPEN_DELAYED, 1-136

RECOVERY_PARALLELISM, 1-136

REMOTE_ARCHIVE_ENABLE, 1-137

REMOTE_DEPENDENCIES_MODE, 1-138

REMOTE_LISTENER, 1-138

REMOTE_LOGIN_PASSWORDFILE, 1-139

REMOTE_OS_AUTHENT, 1-140

REMOTE_OS_ROLES, 1-140

REPLICATION_DEPENDENCY_TRACKING, 1-141

RESOURCE_LIMIT, 1-141

RESOURCE_MANAGER_PLAN, 1-142

ROLLBACK_SEGMENTS, 1-143

ROW_LOCKING, 1-144

SERIAL_REUSE, 1-145

SERVICE_NAMES, 1-146

SESSION_CACHED_CURSORS, 1-146

SESSION_MAX_OPEN_FILES, 1-147

SESSIONS, 1-148

SGA_MAX_SIZE, 1-148

SHADOW_CORE_DUMP, 1-149

SHARED_MEMORY_ADDRESS, 1-149

SHARED_POOL_RESERVED_SIZE, 1-150, 3-142

SHARED_POOL_SIZE, 1-151

SHARED_SERVER_SESSIONS, 1-151

SHARED_SERVERS, 1-152

SORT_AREA_RETAINED_SIZE, 1-152

SORT_AREA_SIZE, 1-153

specifying in initialization parameter files, 1-5

SPFILE, 1-155

SQL_TRACE, 1-156

SQL92_SECURITY, 1-157

STANDBY_ARCHIVE_DEST, 1-157

STANDBY_FILE_MANAGEMENT, 1-158

STAR_TRANSFORMATION_ENABLED, 1-159

STATISTICS_LEVEL, 1-159

TAPE_ASYNCH_IO, 1-160

THREAD, 1-160

TIMED_OS_STATISTICS, 1-161

TIMED_STATISTICS, 1-162

TRACE_ENABLED, 1-163

TRACEFILE_IDENTIFIER, 1-163

TRANSACTION_AUDITING, 1-164

TRANSACTIONS, 1-165

TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1-165

UNDO_MANAGEMENT, 1-166

UNDO_RETENTION, 1-166

UNDO_SUPPRESS_ERRORS, 1-167

UNDO_TABLESPACE, 1-168

USE_INDIRECT_DATA_BUFFERS, 1-168

USER_DUMP_DEST, 1-169

UTL_FILE_DIR, 1-169

variable, 1-3

WORKAREA_SIZE_POLICY, 1-170

INITJVM.SQL script, 5-8

INIT.ORA file. See initialization parameter file

IN-list iterators

optimizer use of, 1-112

inserts

locating free space, 1-67

INST_ID column, 3-2

INSTANCE clause

of ALTER TABLE

allocating extents, 1-67

INSTANCE_GROUPS initialization parameter, 1-66

INSTANCE_NAME initialization parameter, 1-67

INSTANCE_NUMBER initialization parameter, 1-67

exclusive or parallel mode, 1-67

instances

checkpoint, 1-86

startup order, 1-67

I/O

reading multiple blocks, 1-40

redo log files, 1-85

J

Java initialization parameters

JAVA_MAX_SESSIONSPACE_SIZE, 1-68

JAVA_POOL_SIZE, 1-68

JAVA_SOFT_SESSIONSPACE_LIMIT, 1-69

Java scripts, 5-8

JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1-68

JAVA_POOL_SIZE initialization parameter, 1-68

JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1-69

JOB_QUEUE_PROCESSES initialization parameter, 1-69

L

language

database default language, 1-99

LARGE_POOL_SIZE initialization parameter, 1-70

LICENSE_MAX_SESSIONS initialization parameter, 1-71

LICENSE_MAX_USERS initialization parameter, 1-72

LICENSE_SESSIONS_WARNING initialization parameter, 1-72

licenses

maximum sessions, 1-71

maximum users, 1-72

warning for concurrent user sessions, 1-72

limits on the database, 4-1

linguistic sorts, 1-101

local currency, 1-96

LOCAL_LISTENER initialization parameter, 1-73

lock

conversion, 3-26

LOCK_NAME_SPACE initialization parameter, 1-74

LOCK_SGA initialization parameter, 1-74

locks

conversion, 3-22, 3-25, 3-29, 3-56

names, A-16

on KGL objects, 2-188

table lock, 1-144

LOG_ARCHIVE_DEST initialization parameter, 1-75

LOG_ARCHIVE_DEST_n initialization parameter, 1-76

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1-78

LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1-79

LOG_ARCHIVE_FORMAT initialization parameter, 1-80

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1-81

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1-82

LOG_ARCHIVE_START initialization parameter, 1-83

LOG_ARCHIVE_TRACE initialization parameter, 1-84

LOG_BUFFER initialization parameter, 1-85

LOG_CHECKPOINT_INTERVAL initialization parameter, 1-86

LOG_CHECKPOINT_TIMEOUT initialization parameter, 1-87

LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1-88

LOG_FILE_NAME_CONVERT initialization parameter, 1-88

LOG_PARALLELISM initialization parameter, 1-90

LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 1-90

lowercase significance, 1-5

M

manual archiving, 1-83

MAP_OBJECT table, 2-248

MAX_COMMIT_PROPAGATION_DELAY initialization parameter, 1-91

MAX_DISPATCHERS initialization parameter, 1-92

MAX_DUMP_FILE_SIZE initialization parameter, 1-93

MAX_ENABLED_ROLES initialization parameter, 1-94

MAX_ROLLBACK_SEGMENTS initialization parameter, 1-94

MAX_SHARED_SERVERS initialization parameter, 1-94

memory

amount used for sorting, 1-152

virtual, 1-3

modes

archiving, 1-83

monitor

performance, 1-86

multiple-process systems

number of processes, 1-133

N

nested files, 1-65

NLS_CALENDAR initialization parameter, 1-95

NLS_COMP initialization parameter, 1-96

NLS_CURRENCY initialization parameter, 1-96

defined by NLS_TERRITORY, 1-102

NLS_DATABASE_PARAMETERS view, 2-249

NLS_DATE_FORMAT initialization parameter, 1-97

defined by NLS_NUMERIC_CHARACTERS, 1-102

defined by NLS_TERRITORY, 1-102

NLS_DATE_LANGUAGE initialization parameter, 1-98

NLS_DUAL_CURRENCY initialization parameter, 1-98

NLS_INSTANCE_PARAMETERS view, 2-249

NLS_ISO_CURRENCY initialization parameter, 1-99

defined by NLS_TERRITORY, 1-102

NLS_LANGUAGE initialization parameter, 1-99

NLS_LENGTH_SEMANTICS initialization parameter, 1-100

NLS_NCHAR_CONV_EXCP initialization parameter, 1-100

NLS_NUMERIC_CHARACTERS initialization parameter, 1-101

NLS_SESSION_PARAMETERS view, 2-249

NLS_SORT initialization parameter, 1-101

NLS_TERRITORY initialization parameter, 1-102

NLS_TIMESTAMP_FORMAT initialization parameter, 1-103

NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 1-104

NOARCHIVELOG mode

creating a database, 1-83

numeric group separators, 1-101

O

O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1-104

OBJ synonym for USER_OBJECTS view, 2-250

OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1-105

OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1-106

objects

data dictionary, 2-1

OLAP_PAGE_POOL_SIZE initialization parameter, 1-106

online redo log

archiving, 1-83

archiving mode, 1-75

block, 1-86

file size, 1-86

number of files, 1-83

setting checkpoint interval, 1-86

OPEN_CURSORS initialization parameter, 1-107

OPEN_LINKS initialization parameter, 1-107

operating system

authenticating remote clients, 1-140

authenticating users and passwords, 1-119

dependent parameters, 1-3

roles for remote clients, 1-140

optimization

trading cursor space for time, 1-31

OPTIMIZER_DYNAMIC_SAMPLING initialization parameter, 1-109

OPTIMIZER_FEATURES_ENABLE initialization parameter, 1-109

OPTIMIZER_INDEX_CACHING initialization parameter, 1-112

OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1-113

OPTIMIZER_MAX_PERMUTATIONS initialization parameter, 1-113

OPTIMIZER_MODE initialization parameter, 1-114

ORACLE_TRACE_COLLECTION_NAME initialization parameter, 1-115

ORACLE_TRACE_COLLECTION_PATH initialization parameter, 1-116

ORACLE_TRACE_COLLECTION_SIZE initialization parameter, 1-116

ORACLE_TRACE_ENABLE initialization parameter, 1-117

ORACLE_TRACE_FACILITY_NAME initialization parameter, 1-117

ORACLE_TRACE_FACILITY_PATH initialization parameter, 1-118

Oracle9i Real Application Clusters

dynamic performance views, 3-2

initialization parameters

CIRCUITS, 1-24

CLUSTER_DATABASE, 1-24

CLUSTER_DATABASE_INSTANCES, 1-25

CLUSTER_INTERCONNECTS, 1-25

DISPATCHERS, 1-49

FAST_START_PARALLEL_ROLLBACK, 1-59

PARALLEL_ADAPTIVE_MULTI_USER, 1-120

PARALLEL_AUTOMATIC_TUNING, 1-121

PARALLEL_EXECUTION_MESSAGE_SIZE, 1-122

PARALLEL_INSTANCE_GROUP, 1-122

PARALLEL_MAX_SERVERS, 1-123

PARALLEL_MIN_PERCENT, 1-124

PARALLEL_MIN_SERVERS, 1-125

PARALLEL_THREADS_PER_CPU, 1-126

ORPHAN_KEY_TABLE view. See DBA_ORPHAN_KEY_TABLE. DBA_ORPHAN_KEY_TABLE view, 2-201

OS_AUTHENT_PREFIX initialization parameter, 1-119

OS_ROLES initialization parameter, 1-120

P

parallel mode

instance number, 1-67

parallel query

maximum number of instances, 1-122

maximum number of servers, 1-123

minimum number of queries, 1-125

PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1-120

PARALLEL_AUTOMATIC_TUNING initialization parameter, 1-121

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1-122

PARALLEL_INSTANCE_GROUP initialization parameter, 1-122

PARALLEL_MAX_SERVERS initialization parameter, 1-123

PARALLEL_MIN_PERCENT initialization parameter, 1-124

PARALLEL_MIN_SERVERS initialization parameter, 1-125

PARALLEL_THREADS_PER_CPU initialization parameter, 1-126

PARSED_PIECES view, 2-250

PARSED_SIZE view, 2-250

PARTITION_VIEW_ENABLED initialization parameter, 1-126

partitions

raw, 1-75

passwords

authenticating, 1-119, 1-140

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1-139

PCM lock

mapping blocks to, 1-60

performance, 1-3

rule-based optimization, 1-114

shared pool, 1-64, 1-149, 1-151

PGA_AGGREGATE_TARGET initialization parameter, 1-127

pins

on KGL objects, 2-188

PLAN_TABLE execution plan table, 2-250

PLSQL_COMPILER_FLAGS initialization parameter, 1-128

PLSQL_NATIVE_C_COMPILER initialization parameter, 1-129

PLSQL_NATIVE_LIBRARY_DIR initialization parameter, 1-129

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT initialization parameter, 1-129

PLSQL_NATIVE_LINKER initialization parameter, 1-130

PLSQL_NATIVE_MAKE_FILE_NAME initialization parameter, 1-130

PLSQL_NATIVE_MAKE_UTILITY initialization parameter, 1-131

PLSQL_V2_COMPATIBILITY initialization parameter, 1-131

PLUGGABLE_SET_CHECK view, 2-252

PRE_PAGE_SGA initialization parameter, 1-132

privileges

remote login, 1-139

RESTRICTED_SESSION privilege, 1-71, 1-72

table-level select privileges, 1-157, 1-159

procedures

shared pool, 1-64, 1-149, 1-151

processes

derived parameter values, 1-165

dispatcher process maximum number, 1-92

maximum shared server processes, 1-94

number of server processes, 1-68, 1-69, 1-133, 1-151, 1-152

recovery, 1-134, 1-136

trace files, 1-169

user processes, 1-133

PROCESSES initialization parameter, 1-133

PRODUCT_COMPONENT_VERSION view, 2-253

profiles

resource limits, 1-141, 1-142

PROXY_USERS view, 2-253

PSTUBTBL view, 2-254

PUBLIC clause

of ALTER DATABASE

thread of redo, 1-160

PUBLIC_DEPENDENCY view, 2-254

PUBLICSYN view, 2-254

Q

queries

dictionary views, 1-60

hints, 1-114

QUERY_REWRITE_ENABLED initialization parameter, 1-133

QUERY_REWRITE_INTEGRITY initialization parameter, 1-134

QUEUE_PRIVILEGES view, 2-255

R

raw partition

LOG_ARCHIVE_DEST initialization parameter, 1-75

RC_ARCHIVED_LOG view, 2-4

RC_BACKUP_CONTROLFILE view, 2-4

RC_BACKUP_CORRUPTION view, 2-4

RC_BACKUP_DATAFILE view, 2-4

RC_BACKUP_PIECE view, 2-4

RC_BACKUP_REDOLOG view, 2-4

RC_BACKUP_SET view, 2-4

RC_BACKUP_SPFILE view, 2-4

RC_CHECKPOINT view, 2-4

RC_CONTROLFILE_COPY view, 2-4

RC_COPY_CORRUPTION view, 2-4

RC_DATABASE view, 2-4

RC_DATABASE_BLOCK_CORRUPTION view, 2-4

RC_DATABASE_INCARNATION view, 2-4

RC_DATAFILE view, 2-4

RC_DATAFILE_COPY view, 2-4

RC_LOG_HISTORY view, 2-4

RC_OFFLINE_RANGE view, 2-4

RC_PROXY_CONTROLFILE view, 2-4

RC_PROXY_DATAFILE view, 2-4

RC_REDO_LOG view, 2-4

RC_REDO_THREAD view, 2-4

RC_RESYNC view, 2-4

RC_RMAN_CONFIGURATION view, 2-4

RC_STORED_SCRIPT view, 2-4

RC_STORED_SCRIPT_LINE view, 2-4

RC_TABLESPACE view, 2-4

RDBMS_SERVER_DN initialization parameter, 1-135

READ_ONLY_OPEN_DELAYED initialization parameter, 1-136

recovery

number of required processes, 1-134, 1-136

RECOVERY_PARALLELISM initialization parameter, 1-136

redo logs

buffer size, 1-85

redo thread, 1-160

remote clients

authenticating, 1-140

remote logins, 1-139

REMOTE_ARCHIVE_ENABLE initialization parameter, 1-137

REMOTE_DEPENDENCIES_MODE initialization parameter, 1-138

REMOTE_LISTENER initialization parameter, 1-138

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1-139

REMOTE_OS_AUTHENT initialization parameter, 1-140

REMOTE_OS_ROLES initialization parameter, 1-140

REPAIR_TABLE view. See DBA_REPAIR_TABLE view.

REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1-141

resource limits for profiles, 1-141, 1-142

RESOURCE_COST view, 2-255

RESOURCE_LIMIT initialization parameter, 1-141

RESOURCE_MANAGER_PLAN initialization parameter, 1-142

RESOURCE_MAP table, 2-255

RMJVM.SQL script, 5-8

ROLE_ROLE_PRIVS view, 2-256

ROLE_SYS_PRIVS view, 2-256

ROLE_TAB_PRIVS view, 2-256

ROLE_WM_PRIVS view, 2-3

roles, 1-120

remote clients, 1-140

rollback segments

maximum size, 1-94

ROLLBACK_SEGMENTS initialization parameter, 1-143

ROW_LOCKING initialization parameter, 1-144

rule-based optimization, 1-114

S

scripts

CATALOG.SQL, 5-2

CATBLOCK.SQL, 5-3

CATCLUST.SQL, 5-2

CATEXP7.SQL, 5-3

CATHS.SQL, 5-3

CATIO.SQL, 5-3

CATJAVA.SQL, 5-8

CATNOADT.SQL, 5-6

CATNOAUD.SQL, 5-6

CATNOHS.SQL, 5-6

CATNOPRT.SQL, 5-6

CATNOQUE.SQL, 5-6

CATNORMN.SQL, 5-6

CATNOSVM.SQL, 5-6

CATNSNMP.SQL, 5-6

CATOCTK.SQL, 5-3

CATPROC.SQL, 5-2

CATQUEUE.SQL, 5-3

CATREP.SQL, 5-3

CATRMAN.SQL, 5-3

CMPDBMIG.SQL, 5-7

D0801070.SQL, 5-7

D0900010.SQL, 5-7

data dictionary, 5-3

database migration, 5-7

DBMSIOTC.SQL, 5-3

DBMSOTRC.SQL, 5-3

DBMSPOOL.SQL, 5-4

INITJVM.SQL, 5-8

Java, 5-8

RMJVM.SQL, 5-8

SQL scripts, 5-2

U0703040.SQL, 5-7

U0800060.SQL, 5-7

U0801070.SQL, 5-7

U0900010.SQL, 5-7

USERLOCK.SQL, 5-4

UTLBSTAT.SQL, 5-4

UTLCHN1.SQL, 5-4

UTLCONST.SQL, 5-4

UTLDTREE.SQL, 5-4

UTLESTAT.SQL, 5-4

UTLEXPT1.SQL, 5-4

UTLINCMP.SQL, 5-7

UTLIP.SQL, 5-4

UTLIRP.SQL, 5-5

UTLLOCKT.SQL, 5-5

UTLPWDMG.SQL, 5-5

UTLRP.SQL, 5-5

UTLSAMPL.SQL, 5-5

UTLSCLN.SQL, 5-5

UTLTKPRF.SQL, 5-5

UTLVALID.SQL, 5-5

UTLXPLAN.SQL, 5-5

SEQ synonym for USER_SEQUENCES view, 2-256

SERIAL_REUSE initialization parameter, 1-145

server parameter file

overview, 1-4

server processes

number, 1-68, 1-69, 1-133, 1-151, 1-152

SERVICE_NAMES initialization parameter, 1-146

SESSION_CACHED_CURSORS initialization parameter, 1-146

SESSION_CONTEXT view, 2-257

SESSION_MAX_OPEN_FILES initialization parameter, 1-147

SESSION_PRIVS view, 2-257

SESSION_ROLES view, 2-257

SESSIONS initialization parameter, 1-148

SGA_MAX_SIZE initialization parameter, 1-148

SHADOW_CORE_DUMP initialization parameter, 1-149

shared server

SESSIONS initialization parameter, 1-148

shared server dispatcher request statistics, 3-119

shared server processes

maximum number, 1-94

SHARED_MEMORY_ADDRESS initialization parameter, 1-149

SHARED_POOL_RESERVED_SIZE initialization parameter, 1-150

V$SHARED_POOL_RESERVED, 3-142

SHARED_POOL_SIZE initialization parameter, 1-151

SHARED_SERVER_SESSIONS initialization parameter, 1-151

SHARED_SERVERS initialization parameter, 1-152

SHOW PARAMETERS command, 1-11

SORT_AREA_RETAINED_SIZE initialization parameter, 1-152

SORT_AREA_SIZE initialization parameter, 1-153

sorting

maximum memory, 1-152

ORDER BY queries, 1-101

SOURCE_SIZE view, 2-257

SPFILE initialization parameter, 1-155

SQL scripts

creating the data dictionary, 5-2

optional, 5-3

required, 5-2

SQL_TRACE initialization parameter, 1-156

SQL92_SECURITY initialization parameter, 1-157

STANDBY_ARCHIVE_DEST initialization parameter, 1-157

STANDBY_FILE_MANAGEMENT initialization parameter, 1-158

STAR_TRANSFORMATION_ENABLED initialization parameter, 1-159

starting up

database name, 1-44

instance number, 1-67

startup order, 1-67

STARTUP statement

database name, 1-44

statistics

background checkpoints completed, C-3

background checkpoints started, C-3

branch node splits, C-3

buffer is not pinned count, C-3

buffer is pinned count, C-3

bytes received via SQL*Net from client, C-3

bytes received via SQL*Net from dblink, C-3

bytes sent via SQL*Net to client, C-3

bytes sent via SQL*Net to dblink, C-3

Cached Commit SCN referenced, C-3

calls to get snapshot scn

kcmgss, C-3

calls to kcmgas, C-3

calls to kcmgcs, C-4

calls to kcmgrs, C-4

change write time, C-4

cleanouts and rollbacks - consistent read gets, C-4

cleanouts only - consistent read gets, C-4

cluster key scan block gets, C-4

cluster key scans, C-4

cold recycle reads, C-4

commit cleanout failures

block lost, C-4

buffer being written, C-4

callback failure, C-4

cannot pin, C-4

hot backup in progress, C-4

write disabled, C-4

commit cleanouts, C-4

commit cleanouts successfully completed, C-5

Commit SCN cached, C-5

consistent changes, C-5

consistent gets, C-5

CPU used by this session, C-5

CPU used when call started, C-5

CR blocks created, C-5

cross instance CR read, C-6

current blocks converted for CR, C-5

cursor authentication, C-5

data blocks consistent reads - undo records applied, C-5

db block changes, C-6

db block gets, C-6

DBWR buffers scanned, C-6

DBWR checkpoint buffers written, C-6

DBWR checkpoints, 1-86, C-6

DBWR cross instance writes, C-6

DBWR free buffers found, C-6

DBWR lru scans, C-6

DBWR make free requests, C-6

DBWR revisited being-written buffer, C-7

DBWR summed scan depth, C-7

DBWR transaction table writes, C-7

DBWR undo block writes, C-7

DDL statements parallelized, C-7

deferred (CURRENT) block cleanout applications, C-7

DFO trees parallelized, C-7

dirty buffers inspected, C-7

DML statements parallelized, C-7

enqueue conversions, C-7

enqueue deadlocks, C-7

enqueue releases, C-7

enqueue requests, C-7

enqueue timeouts, C-8

enqueue waits, C-8

exchange deadlocks, C-8

execute count, C-8

free buffer inspected, C-8

free buffer requested, C-8

global cache blocks corrupt, C-8

global cache cr block log flush time, C-9

global cache cr block send time, C-9

global cache cr timeouts, C-9

global cache defers, C-9

global cache freelist waits, C-9

global cache get time, C-9

global cache gets, C-9

global cache prepare failures, C-9

global lock async converts, C-9

global lock async gets, C-9

global lock convert time, C-9

global lock get time, C-9

global lock release time, C-10

global lock releases, C-10

global lock sync converts, C-10

global lock sync gets, C-10

hot buffers moved to head of LRU, C-10

immediate (CR) block cleanout applications, C-10

immediate (CURRENT) block cleanout applications, C-10

index fast full scans (direct read), C-10

index fast full scans (full), C-10

index fast full scans (rowid ranges), C-10

instance recovery database freeze count, C-10

kcmccs called get current scn, C-10

kcmccs read scn without going to DLM, C-10

kcmggs waited for batching, C-10

leaf node splits, C-10

logons cumulative, C-10

logons current, C-10

messages received, C-10

messages sent, C-10

native hash arithmetic execute, C-11

native hash arithmetic fail, C-11

next scns gotten without going to DLM, C-11

no buffer to keep pinned count, C-11

no work - consistent read gets, C-11

opened cursors cumulative, C-11

opened cursors current, C-11

opens of replaced files, C-11

opens requiring cache replacement, C-11

operating system

OS All other sleep time, C-11

OS Chars read and written, C-11

OS Data page fault sleep time, C-11

OS Input blocks, C-11

OS Involuntary context switches, C-12

OS Kernel page fault sleep time, C-12

OS Major page faults, C-12

OS Messages received, C-12

OS Messages sent, C-12

OS Minor page faults, C-12

OS Other system trap CPU time, C-12

OS Output blocks, C-12

OS Process heap time, C-12

OS Signals received, C-12

OS Swaps, C-12

OS System call CPU time, C-12

OS System calls, C-12

OS Text page fault sleep time, C-12

OS User level CPU time, C-12

OS User lock wait sleep time, C-12

OS Voluntary context switches, C-12

OS Wait-cpu (latency) time, C-12

Process stack size, C-12

OS Input blocks, C-12

Parallel operations downgraded 1 to 25 pct, C-13

Parallel operations downgraded 25 to 50 pct, C-13

Parallel operations downgraded 50 to 75 pct, C-13

Parallel operations downgraded 75 to 99 pct, C-13

Parallel operations downgraded to serial, C-13

Parallel operations not downgraded, C-13

parse count (hard), C-13

parse count (total), C-13

parse time cpu, C-13

parse time elapsed, C-13

physical reads, C-13

physical reads direct, C-13

physical writes, C-14

physical writes direct, C-14

physical writes non checkpoint, C-14

pinned buffers inspected, C-14

prefetched blocks, C-14

prefetched blocks aged out before use, C-14

process last non-idle time, C-14

PX local messages recv'd, C-14

PX local messages sent, C-14

PX remote messages recv'd, C-14

PX remote messages sent, C-14

queries parallelized, C-14

recovery array read time, C-14

recovery array reads, C-14

recovery blocks read, C-15

recursive calls, C-15

recursive cpu usage, C-15

redo blocks written, C-15

redo buffer allocation retries, C-15

redo entries, C-15

redo log space requests, C-15

redo log space wait time, C-15

redo log switch interrupts, C-15

redo ordering marks, C-16

redo size, C-16

redo sync writes, C-16

redo synch time, C-16

redo wastage, C-16

redo write time, C-16

redo writer latching time, C-16

redo writes, C-16

remote instance undo block writes, C-16

remote instance undo header writes, C-16

rollback changes - undo records applied, C-16

rollbacks only - consistent read gets, C-16

rows fetched via callback, C-16

serializable aborts, C-17

session connect time, C-17

session cursor cache count, C-17

session cursor cache hits, C-17

session logical reads, C-17

session pga memory, C-17

session pga memory max, C-17

session stored procedure space, C-17

session uga memory, C-17

session uga memory max, C-17

sorts (disk), C-17

sorts (memory), C-18

sorts (rows), C-18

SQL*Net roundtrips to/from client, C-18

SQL*Net roundtrips to/from dblink, C-18

summed dirty queue length, C-18

switch current to new buffer, C-18

table fetch by rowid, C-18

table fetch continued row, C-18

table scan blocks gotten, C-19

table scan rows gotten, C-19

table scans (cache partitions), C-19

table scans (direct read), C-19

table scans (long tables), C-19

table scans (rowid ranges), C-19

table scans (short tables), C-19

timed, 1-162

total file opens, C-19

transaction lock background get time, C-19

transaction lock background gets, C-19

transaction lock foreground requests, C-19

transaction lock foreground wait time, C-19

transaction rollbacks, C-19

transaction tables consistent read rollbacks, C-20

transaction tables consistent reads - undo records applied, C-20

Unnecessary process cleanup for SCN batching, C-20

user calls, C-20

user commits, C-20

user rollbacks, C-20

write clones created in background, C-20

write clones created in foreground, C-20

STATISTICS_LEVEL initialization parameter, 1-159

STMT_AUDIT_OPTION_MAP table, 2-258

switch redo log file, 1-86

SYN synonym for USER_SYNONYMS view, 2-258

SYNONYMS view, 2-258

SYS_OBJECTS view, 2-259

SYSCATALOG view, 2-258

SYSFILES view, 2-258

SYSSEGOBJ view, 2-258

system global area, 1-3

buffer areas, 1-85

maximum concurrent transactions, 1-165

rollback segment size, 1-94

system performance, 1-3

SYSTEM_PRIVILEGE_MAP table, 2-258

T

TAB view, 2-259

TABLE_PRIVILEGE_MAP table, 2-259

TABLE_PRIVILEGES view, 2-259

tables

data dictionary, 2-1

DML locks, 1-53

locating free space, 1-67

row locking, 1-144

TABQUOTAS view, 2-260

TABS synonym for USER_TABLES view, 2-260

tape archiving destination, 1-75

TAPE_ASYNCH_IO initialization parameter, 1-160

territory, 1-98, 1-102

THREAD initialization parameter, 1-160

TIMED_OS_STATISTICS initialization parameter, 1-161

TIMED_STATISTICS initialization parameter, 1-162

file read/write statistics, 3-58, 3-182

TO_CHAR function, 1-97

TO_DATE function, 1-97

trace files

destination, 1-169

maximum size, 1-93

TRACE_ENABLED initialization parameter, 1-163

TRACEFILE_IDENTIFIER initialization parameter, 1-163

TRANSACTION_AUDITING initialization parameter, 1-164

transactions

concurrent, 1-165

data locking, 1-53

TRANSACTIONS initialization parameter, 1-165

DML locks, 1-53

TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1-165

TRUSTED_SERVERS view, 2-260

TS_PITR_CHECK view, 2-261

TS_PITR_OBJECTS TO_BE_DROPPED view, 2-262

U

U0703040.SQL script, 5-7

U0800060.SQL script, 5-7

U0801070.SQL script, 5-7

U0900010.SQL script, 5-7

UNDO_MANAGEMENT initialization parameter, 1-166

UNDO_RETENTION initialization parameter, 1-166

UNDO_SUPPRESS_ERRORS initialization parameter, 1-167

UNDO_TABLESPACE initialization parameter, 1-168

UNI_PLUGGABLE_SET_CHECK view, 2-262

updates

locating free space, 1-67

transaction processing option, 1-144

uppercase characters, 1-5

USE_INDIRECT_DATA_BUFFERS initialization parameter, 1-168

user processes

trace files, 1-169

USER_ALL_TABLES view, 2-263

USER_AQ_AGENT_PRIVS view, 2-263

USER_ARGUMENTS view, 2-263

USER_ASSOCIATIONS view, 2-264

USER_ATTRIBUTE_TRANSFORMATIONS view, 2-264

USER_AUDIT_OBJECT view, 2-264

USER_AUDIT_POLICIES view, 2-264

USER_AUDIT_SESSION view, 2-264

USER_AUDIT_STATEMENT view, 2-264

USER_AUDIT_TRAIL view, 2-265

USER_AW_PS view, 2-265

USER_AWS view, 2-265

USER_BASE_TABLE_MVIEWS view, 2-265

USER_CATALOG view, 2-266

CAT synonym, 2-153

USER_CLU_COLUMNS view, 2-266

USER_CLUSTER_HASH_EXPRESSIONS view, 2-266

USER_CLUSTERS view, 2-266

CLU synonym, 2-155

USER_COL_COMMENTS view, 2-266

USER_COL_PRIVS view, 2-266

USER_COL_PRIVS_MADE view, 2-267

USER_COL_PRIVS_RECD view, 2-267

USER_COLL_TYPES view, 2-267

USER_CONS_COLUMNS view, 2-267

USER_CONS_OBJ_COLUMNS view, 2-267

USER_CONSTRAINTS view, 2-268

USER_DB_LINKS view, 2-268

USER_DEPENDENCIES view, 2-268

USER_DIM_ATTRIBUTES view, 2-268

USER_DIM_CHILD_OF view, 2-268

USER_DIM_HIERARCHIES view, 2-268

USER_DIM_JOIN_KEY view, 2-269

USER_DIM_LEVEL_KEY view, 2-269

USER_DIM_LEVELS view, 2-269

USER_DIMENSIONS view, 2-269

USER_DUMP_DEST initialization parameter, 1-169

USER_ERRORS view, 2-269

USER_EVALUATION_CONTEXT_TABLES view, 2-269

USER_EVALUATION_CONTEXT_VARS view, 2-270

USER_EVALUATION_CONTEXTS view, 2-270

USER_EXTENTS view, 2-270

USER_EXTERNAL_LOCATIONS view, 2-270

USER_EXTERNAL_TABLES view, 2-270

USER_FREE_SPACE view, 2-271

USER_IND_COLUMNS view, 2-271

USER_IND_EXPRESSIONS view, 2-271

USER_IND_PARTITIONS view, 2-271

USER_IND_SUBPARTITIONS view, 2-271

USER_INDEXES view, 2-271

IND synonym, 2-247

USER_INDEXTYPE_COMMENTS view, 2-272

USER_INDEXTYPE_OPERATORS view, 2-272

USER_INDEXTYPES view, 2-272

USER_INTERNAL_TRIGGERS view, 2-272

USER_JAVA_ARGUMENTS view, 2-272

USER_JAVA_CLASSES view, 2-273

USER_JAVA_DERIVATIONS view, 2-273

USER_JAVA_FIELDS view, 2-273

USER_JAVA_IMPLEMENTS view, 2-273

USER_JAVA_INNERS view, 2-273

USER_JAVA_LAYOUTS view, 2-274

USER_JAVA_METHODS view, 2-274

USER_JAVA_NCOMPS view, 2-274

USER_JAVA_POLICY view, 2-274

USER_JAVA_RESOLVERS view, 2-274

USER_JAVA_THROWS view, 2-275

USER_JOBS view, 2-275

USER_JOIN_IND_COLUMNS view, 2-275

USER_LIBRARIES view, 2-275

USER_LOB_PARTITIONS view, 2-275

USER_LOB_SUBPARTITIONS view, 2-275

USER_LOB_TEMPLATES view, 2-276

USER_LOBS view, 2-276

USER_LOG_GROUP_COLUMNS view, 2-276

USER_LOG_GROUPS view, 2-276

USER_METHOD_PARAMS view, 2-276

USER_METHOD_RESULTS view, 2-276

USER_MVIEW_AGGREGATES view, 2-277

USER_MVIEW_ANALYSIS view, 2-277

USER_MVIEW_DETAIL_RELATIONS view, 2-277

USER_MVIEW_JOINS view, 2-277

USER_MVIEW_KEYS view, 2-277

USER_MVIEW_LOGS view, 2-278

USER_MVIEW_REFRESH_TIMES view, 2-278

USER_MVIEWS view, 2-278

USER_NESTED_TABLES view, 2-278

USER_OBJ_AUDIT_OPTS view, 2-278

USER_OBJ_COLATTRS view, 2-278

USER_OBJECT_SIZE view, 2-279

USER_OBJECT_TABLES view, 2-279

USER_OBJECTS view, 2-279

OBJ synonym, 2-250

USER_OPANCILLARY view, 2-279

USER_OPARGUMENTS view, 2-279

USER_OPBINDINGS view, 2-279

USER_OPERATOR_COMMENTS view, 2-279

USER_OPERATORS view, 2-280

USER_OUTLINE_HINTS view, 2-280

USER_OUTLINES view, 2-280

USER_PART_COL_STATISTICS view, 2-280

USER_PART_HISTOGRAMS view, 2-280

USER_PART_INDEXES view, 2-280

USER_PART_KEY_COLUMNS view, 2-281

USER_PART_LOBS view, 2-281

USER_PART_TABLES view, 2-281

USER_PARTIAL_DROP_TABS view, 2-281

USER_PASSWORD_LIMITS view, 2-281

USER_PENDING_CONV_TABLES view, 2-282

USER_POLICIES view, 2-282

USER_POLICY_CONTEXTS view, 2-282

USER_POLICY_GROUPS view, 2-282

USER_PROCEDURES view, 2-282

USER_PROXIES view, 2-283

USER_PUBLISHED_COLUMNS view, 2-283

USER_QUEUE_SCHEDULES view, 2-283

USER_QUEUE_TABLES view, 2-283

USER_QUEUES view, 2-284

USER_REFRESH view, 2-284

USER_REFRESH_CHILDREN view, 2-284

USER_REFS view, 2-284

USER_REGISTERED_MVIEWS view, 2-284

USER_REGISTRY view, 2-284

USER_REPAUDIT_ATTRIBUTE view, 2-2

USER_REPAUDIT_COLUMN view, 2-2

USER_REPCAT view, 2-2

USER_REPCAT_REFRESH_TEMPLATES view, 2-2

USER_REPCAT_TEMPLATE_OBJECTS view, 2-2

USER_REPCAT_TEMPLATE_PARMS view, 2-2

USER_REPCAT_TEMPLATE_SITES view, 2-2

USER_REPCAT_USER_AUTHORIZATION view, 2-2

USER_REPCAT_USER_PARM_VALUES view, 2-2

USER_REPCATLOG view, 2-2

USER_REPCOLUMN view, 2-2

USER_REPCOLUMN_GROUP view, 2-2

USER_REPCONFLICT view, 2-2

USER_REPDDL view, 2-2

USER_REPFLAVOR_COLUMNS view, 2-2

USER_REPFLAVOR_OBJECTS view, 2-2

USER_REPFLAVORS view, 2-2

USER_REPGENERATED view, 2-2

USER_REPGENOBJECTS view, 2-2

USER_REPGROUP view, 2-2

USER_REPGROUP_PRIVILEGES view, 2-2

USER_REPGROUPED_COLUMN view, 2-2

USER_REPKEY_COLUMNS view, 2-2

USER_REPOBJECT view, 2-2

USER_REPPARAMETER_COLUMN view, 2-2

USER_REPPRIORITY view, 2-2

USER_REPPRIORITY_GROUP view, 2-2

USER_REPPROP view, 2-2

USER_REPRESOL_STATS_CONTROL view, 2-2

USER_REPRESOLUTION view, 2-2

USER_REPRESOLUTION_METHOD view, 2-2

USER_REPRESOLUTION_STATISTICS view, 2-2

USER_REPSCHEMA view, 2-2

USER_REPSITES view, 2-2

USER_RESOURCE_LIMITS view, 2-285

USER_RESUMABLE view, 2-285

USER_ROLE_PRIVS view, 2-285

USER_RSRC_CONSUMER_GROUP_PRIVS view, 2-285

USER_RSRC_MANAGER_SYSTEM_PRIVS view, 2-286

USER_RULE_SET_RULES view, 2-286

USER_RULE_SETS view, 2-286

USER_RULES view, 2-286

USER_SEGMENTS view, 2-286

USER_SEQUENCES view, 2-286

SEQ synonym, 2-256

USER_SOURCE view, 2-287

USER_SOURCE_TABLES view, 2-287

USER_SQLJ_TYPE_ATTRS view, 2-287

USER_SQLJ_TYPE_METHODS view, 2-287

USER_SQLJ_TYPES view, 2-287

USER_STORED_SETTINGS view, 2-287

USER_SUBPART_COL_STATISTICS view, 2-288

USER_SUBPART_HISTOGRAMS view, 2-288

USER_SUBPART_KEY_COLUMNS view, 2-288

USER_SUBPARTITION_TEMPLATES view, 2-288

USER_SUBSCRIBED_COLUMNS view, 2-288

USER_SUBSCRIBED_TABLES view, 2-289

USER_SUBSCRIPTIONS view, 2-289

USER_SYNONYMS view, 2-289

SYN synonym, 2-258

USER_SYS_PRIVS view, 2-289

USER_TAB_COL_STATISTICS view, 2-289

USER_TAB_COLUMNS view, 2-289

COLS synonym, 2-156

USER_TAB_COMMENTS view, 2-289

USER_TAB_HISTOGRAMS view, 2-290

USER_TAB_MODIFICATIONS view, 2-290

USER_TAB_PARTITIONS view, 2-290

USER_TAB_PRIVS view, 2-290

USER_TAB_PRIVS_MADE view, 2-290

USER_TAB_PRIVS_RECD view, 2-291

USER_TAB_SUBPARTITIONS view, 2-291

USER_TABLES view, 2-291

TABS synonym, 2-260

USER_TABLESPACES view, 2-291

USER_TRANSFORMATIONS view, 2-291

USER_TRIGGER_COLS view, 2-292

USER_TRIGGERS view, 2-292

USER_TS_QUOTAS view, 2-292

USER_TYPE_ATTRS view, 2-292

USER_TYPE_METHODS view, 2-292

USER_TYPE_VERSIONS view, 2-292

USER_TYPES view, 2-293

USER_UNUSED_COL_TABS view, 2-293

USER_UPDATABLE_COLUMNS view, 2-293

USER_USERS view, 2-293

USER_USTATS view, 2-293

USER_VARRAYS view, 2-293

USER_VIEWS view, 2-294

USER_WM_LOCKED_TABLES view, 2-3

USER_WM_MODIFIED_TABLES view, 2-3

USER_WM_PRIVS view, 2-3

USER_WM_RIC_INFO view, 2-3

USER_WM_TAB_TRIGGERS view, 2-3

USER_WM_VERSIONED_TABLES view, 2-3

USER_WM_VT_ERRORS view, 2-3

USER_WORKSPACE_PRIVS view, 2-3

USER_WORKSPACE_SAVEPOINTS view, 2-3

USER_WORKSPACES view, 2-3

USER_XML_SCHEMAS view, 2-294

USER_XML_TAB_COLS view, 2-294

USER_XML_TABLES view, 2-294

USER_XML_VIEW_COLS view, 2-294

USER_XML_VIEWS view, 2-294

USERLOCK.SQL script, 5-4

users

authenticating, 1-119

multiple, 1-53

UTL_FILE_DIR initialization parameter, 1-169

UTLBSTAT.SQL script, 5-4

UTLCHN1.SQL script, 5-4

UTLCONST.SQL script, 5-4

UTLDTREE.SQL script, 2-236, 5-4

utldtree.sql script, 2-246

UTLESTAT.SQL script, 5-4

UTLEXPT1.SQL script, 5-4

UTLINCMP.SQL script, 5-7

UTLIP.SQL script, 5-4

UTLIRP.SQL script, 5-5

UTLLOCKT.SQL script, 5-5

UTLPWDMG.SQL script, 5-5

UTLRP.SQL script, 5-5

UTLSAMPL.SQL script, 5-5

UTLSCLN.SQL script, 5-5

UTLTKPRF.SQL script, 5-5

UTLVALID.SQL script, 5-5

UTLXPLAN.SQL script, 5-5

V

V$ACCESS view, 3-4

V$ACTIVE_INSTANCES view, 3-4

V$ACTIVE_SESS_POOL_MTH view, 3-4

V$AQ view, 3-4

V$ARCHIVE view, 3-5

V$ARCHIVE_DEST view, 3-5

V$ARCHIVE_DEST_STATUS view, 3-8

V$ARCHIVE_GAP view, 3-10

V$ARCHIVE_PROCESSES view, 3-10

V$ARCHIVED_LOG view, 3-10

V$BACKUP view, 3-12

V$BACKUP_ASYNC_IO view, 3-13

V$BACKUP_CORRUPTION view, 3-14

V$BACKUP_DATAFILE view, 3-15

V$BACKUP_DEVICE view, 3-16

V$BACKUP_PIECE view, 3-17

V$BACKUP_REDOLOG view, 3-18

V$BACKUP_SET view, 3-18

V$BACKUP_SPFILE view, 3-20

V$BACKUP_SYNC_IO view, 3-20

V$BGPROCESS view, 3-21

V$BH view, 3-21

V$BUFFER_POOL view, 3-23

V$BUFFER_POOL_STATISTICS view, 3-24

V$CACHE view, 3-25

V$CACHE_LOCK view, 3-26

V$CACHE_TRANSFER view, 3-29

V$CIRCUIT view, 3-30

V$CLASS_CACHE_TRANSFER view, 3-31

V$COMPATIBILITY view, 3-31

V$COMPATSEG view, 3-32

V$CONTEXT view, 3-32

V$CONTROLFILE view, 3-32

V$CONTROLFILE_RECORD_SECTION view, 3-32

V$COPY_CORRUPTION view, 3-33

V$CR_BLOCK_SERVER view, 3-34

V$DATABASE view, 3-35

V$DATABASE_BLOCK_CORRUPTION view, 3-38

V$DATABASE_INCARNATION view, 3-39

V$DATAFILE view, 3-39

V$DATAFILE_COPY view, 3-41

V$DATAFILE_HEADER view, 3-42

V$DATAGUARD_STATUS view, 3-43

V$DB_CACHE_ADVICE view, 3-44

V$DB_OBJECT_CACHE view, 3-45

V$DB_PIPES view, 3-46

V$DBFILE view, 3-46

V$DBLINK view, 3-46

V$DELETED_OBJECT view, 3-47

V$DISPATCHER view, 3-47

V$DISPATCHER_RATE view, 3-48

V$ENABLEDPRIVS view, 3-53

V$ENQUEUE_LOCK view, 3-53

V$ENQUEUE_STAT view, 3-54

V$EVENT_NAME view, 3-55

V$EXECUTION view, 3-55

V$FALSE_PING view, 3-55

V$FAST_START_SERVERS view, 3-56

V$FAST_START_TRANSACTIONS view, 3-57

V$FILE_CACHE_TRANSFER view, 3-57

V$FILESTAT view, 3-58

V$FIXED_TABLE view, 3-59

V$FIXED_VIEW_DEFINITION view, 3-59

V$GC_ELEMENT view, 3-60

V$GC_ELEMENTS_WITH_COLLISIONS view, 3-60

V$GCSHVMASTER_INFO view, 3-61

V$GCSPFMASTER_INFO view, 3-61

V$GES_BLOCKING_ENQUEUE view, 3-61

V$GES_CONVERT_LOCAL view, 3-63

V$GES_CONVERT_REMOTE view, 3-63

V$GES_ENQUEUE view, 3-64

V$GES_LATCH view, 3-65

V$GES_RESOURCE view, 3-65

V$GES_STATISTICS view, 3-66

V$GLOBAL_BLOCKED_LOCKS view, 3-66

V$GLOBAL_TRANSACTION view, 3-66

V$HS_AGENT view, 3-67

V$HS_PARAMETER view, 3-67

V$HS_SESSION view, 3-68

V$HVMASTER_INFO view, 3-68

V$INDEXED_FIXED_COLUMN view, 3-68

V$INSTANCE view, 3-69

V$INSTANCE_RECOVERY view, 3-70

V$LATCH view, 3-71

V$LATCH_CHILDREN view, 3-72

V$LATCH_MISSES view, 3-73

V$LATCH_PARENT view, 3-74

V$LATCHHOLDER view, 3-74

V$LATCHNAME view, 3-74

V$LIBRARY_CACHE_MEMORY view, 3-75

V$LIBRARYCACHE view, 3-75

V$LICENSE view, 3-76

V$LOADISTAT view, 3-76

V$LOADPSTAT view, 3-76

V$LOCK view, 3-77

V$LOCK_ACTIVITY view, 3-79

V$LOCKED_OBJECT view, 3-79

V$LOG view, 3-80

V$LOG_HISTORY view, 3-81

V$LOGFILE view, 3-81

V$LOGHIST view, 3-82

V$LOGMNR_CONTENTS view, 3-82

V$LOGMNR_DICTIONARY view, 3-84

V$LOGMNR_LOGS view, 3-85

V$LOGMNR_PARAMETERS view, 3-86

V$LOGSTDBY view, 3-86

V$LOGSTDBY_STATS view, 3-87

V$MANAGED_STANDBY view, 3-87

V$MAP_COMP_LIST view, 3-89

V$MAP_ELEMENT view, 3-89

V$MAP_EXT_ELEMENT view, 3-90

V$MAP_FILE view, 3-91

V$MAP_FILE_EXTENT view, 3-91

V$MAP_FILE_IO_STACK view, 3-92

V$MAP_LIBRARY view, 3-92

V$MAP_SUBELEMENT view, 3-93

V$MTTR_TARGET_ADVICE view, 3-93

V$MVREFRESH view, 3-2

V$MYSTAT view, 3-94

V$NLS_PARAMETERS view, 3-95

V$NLS_VALID_VALUES view, 3-95

V$OBJECT_DEPENDENCY view, 3-95

V$OBJECT_USAGE view, 3-96

V$OBSOLETE_PARAMETER view, 3-96

V$OFFLINE_RANGE view, 3-96

V$OPEN_CURSOR view, 3-97

V$OPTION view, 3-97

V$PARALLEL_DEGREE_LIMIT_MTH view, 3-98

V$PARAMETER view, 3-98

V$PARAMETER2 view, 3-99

V$PGA_TARGET_ADVICE view, 3-100

V$PGA_TARGET_ADVICE_HISTOGRAM view, 3-101

V$PGASTAT view, 3-103

V$PQ_SESSTAT view, 3-106

V$PQ_SLAVE view, 3-106

V$PQ_SYSSTAT view, 3-107

V$PQ_TQSTAT view, 3-108

V$PROCESS view, 3-109

V$PROXY_ARCHIVEDLOG view, 3-110

V$PROXY_DATAFILE view, 3-111

V$PWFILE_USERS view, 3-113

V$PX_PROCESS view, 3-113

V$PX_PROCESS_SYSSTAT view, 3-113

V$PX_SESSION view, 3-115

V$PX_SESSTAT view, 3-115

V$QUEUE view, 3-116

V$QUEUEING_MTH view, 3-116

V$RECOVER_FILE view, 3-116

V$RECOVERY_FILE_STATUS view, 3-117

V$RECOVERY_LOG view, 3-117

V$RECOVERY_PROGRESS view, 3-118

V$RECOVERY_STATUS view, 3-118

V$REPLPROP view, 3-2

V$REPLQUEUE view, 3-2

V$REQDIST view, 3-119

V$RESERVED_WORDS view, 3-119

V$RESOURCE view, 3-120

V$RESOURCE_LIMIT view, 3-120

V$RMAN_CONFIGURATION view, 3-121

V$ROLLNAME view, 3-121

V$ROLLSTAT view, 3-122

V$ROWCACHE view, 3-122

V$ROWCACHE_PARENT view, 3-123

V$ROWCACHE_SUBORDINATE view, 3-124

V$RSRC_CONSUMER_GROUP view, 3-124

V$RSRC_CONSUMER_GROUP_CPU_MTH view, 3-125

V$RSRC_PLAN view, 3-126

V$RSRC_PLAN_CPU_MTH view, 3-126

V$SEGMENT_STATISTICS view, 3-127

V$SEGSTAT view, 3-127

V$SEGSTAT_NAME view, 3-127

V$SESS_IO view, 3-128

V$SESSION view, 3-128

V$SESSION_CONNECT_INFO view, 3-133

V$SESSION_CURSOR_CACHE view, 3-134

V$SESSION_EVENT view, 3-134, A-2

V$SESSION_LONGOPS view, 3-135

V$SESSION_OBJECT_CACHE view, 3-136

V$SESSION_WAIT view, 3-137, A-2

V$SESSTAT view, 3-138, C-1

V$SGA view, 3-139

V$SGA_CURRENT_RESIZE_OPS view, 3-139

V$SGA_DYNAMIC_COMPONENTS view, 3-140

V$SGA_DYNAMIC_FREE_MEMORY view, 3-141

V$SGA_RESIZE_OPS view, 3-140

V$SGASTAT view, 3-141

V$SHARED_POOL_ADVICE view, 3-142

V$SHARED_POOL_RESERVED view, 3-142

V$SHARED_SERVER view, 3-143

V$SHARED_SERVER_MONITOR view, 3-144

V$SORT_SEGMENT view, 3-145

V$SPPARAMETER view, 3-146

V$SQL view, 3-146

V$SQL_BIND_DATA view, 3-148

V$SQL_BIND_METADATA view, 3-149

V$SQL_CURSOR view, 3-149

V$SQL_PLAN view, 3-150

V$SQL_PLAN_STATISTICS view, 3-152

V$SQL_PLAN_STATISTICS_ALL view, 3-153

V$SQL_REDIRECTION view, 3-156

V$SQL_SHARED_CURSOR view, 3-157

V$SQL_SHARED_MEMORY view, 3-158

V$SQL_WORKAREA view, 3-159

V$SQL_WORKAREA_ACTIVE view, 3-160

V$SQL_WORKAREA_HISTOGRAM view, 3-162

V$SQLAREA view, 3-163

V$SQLTEXT view, 3-164

V$SQLTEXT_WITH_NEWLINES view, 3-165

V$STANDBY_LOG view, 3-165

V$STATISTICS_LEVEL view, 3-166

V$STATNAME view, 3-167, C-1

V$STREAMS_APPLY_COORDINATOR view, 3-168

V$STREAMS_APPLY_READER view, 3-169

V$STREAMS_APPLY_SERVER view, 3-170

V$STREAMS_CAPTURE view, 3-172

V$SUBCACHE view, 3-174

V$SYSSTAT view, 3-174, C-1

V$SYSTEM_CURSOR_CACHE view, 3-175

V$SYSTEM_EVENT view, 3-175, A-2

V$SYSTEM_PARAMETER view, 3-176

V$SYSTEM_PARAMETER2 view, 3-177

V$TABLESPACE view, 3-178

V$TEMP_CACHE_TRANSFER view, 3-178

V$TEMP_EXTENT_MAP view, 3-179

V$TEMP_EXTENT_POOL view, 3-180

V$TEMP_SPACE_HEADER view, 3-180

V$TEMPFILE view, 3-181

V$TEMPORARY_LOBS view, 3-181

V$TEMPSEG_USAGE view, 3-181

V$TEMPSTAT view, 3-182

V$THREAD view, 3-183

V$TIMER view, 3-184

V$TIMEZONE_NAMES view, 3-184

V$TRANSACTION view, 3-184

V$TRANSACTION_ENQUEUE view, 3-185

V$TYPE_SIZE view, 3-186

V$UNDOSTAT view, 3-187

V$VERSION view, 3-188

V$VPD_POLICY view, 3-188

V$WAITSTAT view, 3-189

views

data dictionary views, 2-1

data files, 1-60

virtual circuit status, A-51

W

wait events

alter system set dispatchers, A-17

batched allocate scn lock request, A-17

BFILE check if exists, A-17

BFILE check if open, A-17

BFILE closure, A-18

BFILE get length, A-18

BFILE get name object, A-18

BFILE get path object, A-18

BFILE internal seek, A-19

BFILE open, A-19

BFILE read, A-19

buffer busy waits, A-20

buffer deadlock, A-20

buffer for checkpoint, A-20

buffer latch, A-21

buffer read retry, A-21

checkpoint completed, A-22

checkpoint range buffer not saved, A-22

controlfile parallel write, A-22

controlfile sequential read, A-23

controlfile single write, A-23

conversion file read, A-24

db file parallel read, A-24

db file parallel write, A-24

db file scattered read, A-25

db file sequential read, A-25

db file single write, A-25

DFS db file lock, A-26

DFS lock handle, A-26

direct path read, A-26

direct path write, A-27

dispatcher shutdown, A-27

dispatcher timer, A-28

duplicate cluster key, A-28

enqueue, A-28

file identify, A-29

file open, A-29

free buffer waits, A-29

free global transaction table entry, A-29

free process state object, A-30

global cache busy, A-30

global cache freelist wait, A-31

global cache lock cleanup, A-30

global cache null to s, A-31

global cache null to x, A-31

global cache open s, A-31

global cache open x, A-32

global cache s to x, A-32

inactive session, A-32

inactive transaction branch, A-33

index block split, A-33

instance recovery, A-33

instance state change, A-34

io done, A-34

kcl bg acks, A-34

latch activity, A-35

latch free, A-35

library cache load lock, A-36

library cache lock, A-36

library cache pin, A-37

lock manager wait for remote message, A-37

log file parallel write, A-38

log file sequential read, A-38

log file single write, A-38

log file switch (archiving needed), A-39

log file switch (checkpoint incomplete), A-39

log file switch (clearing log file), A-39

log file switch completion, A-39

log file sync, A-39

log switch/archive, A-40

on-going SCN fetch to complete, A-40

parallel query create server, A-40

parallel query dequeue wait, A-40

parallel query qref latch, A-41

parallel query server shutdown, A-41

parallel query signal server, A-41

pending global transaction(s), A-42

pipe get, A-42

pipe put, A-42

PL/SQL lock timer, A-17, A-43

pmon rdomain attach, A-43

pmon timer, A-43

process startup, A-43

queue messages, A-44

rdbms ipc message, A-44

rdbms ipc message block, A-44

rdbms ipc reply, A-44

redo, A-45

row cache lock, A-45

scginq AST call, A-45

single-task message, A-45

smon timer, A-46

SQL*Net break/reset to client, A-46

SQL*Net break/reset to dblink, A-46

SQL*Net message from client, A-47

SQL*Net message from dblink, A-47

SQL*Net message to client, A-47

SQL*Net message to dblink, A-47

SQL*Net more data from client, A-48

SQL*Net more data from dblink, A-48

SQL*Net more data to client, A-48

SQL*Net more data to dblink, A-49

switch logfile command, A-49

timer in sksawat, A-49

transaction, A-49

unbound tx, A-50

undo segment extension, A-50

undo segment recovery, A-50

undo segment tx slot, A-50

wait events

log buffer space, A-37

WMON goes to sleep, A-17, A-51

write complete, A-51

writes stopped by instance recovery or database suspension, A-51

WM_INSTALLATION view, 2-3

WM_REPLICATION_INFO view, 2-3

WORKAREA_SIZE_POLICY initialization parameter, 1-170