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</