<i>Oracle8i Reference</i> -- Index

acquiring rollback segments

ALLOCATE EXTENT option

instance number, 1-52

allocation

PCM locks, 1-44

rollback segments, 1-110

ALLOW_PARTIAL_SN_RESULTS parameter, 1-13

ALTER DATABASE command

ALTER SESSION command

SET HASH_AREA_SIZE option, 1-47, 1-48

SET HASH_JOIN_ENABLED option, 1-47

alter system set mts_dispatchers wait event, A-20

ALTER TABLE statement

allocating extents, 1-52

ALWAYS_ANTI_JOIN parameter, 1-14

ALWAYS_SEMI_JOIN parameter, 1-14

ANALYZE command, 2-19, 2-55, 2-60, 2-94, 2-145, 2-150, 2-206, 2-249, 2-254

AQ_TM_PROCESSES parameter, 1-15

ARCH_IO_SLAVES parameter, 1-15

ARCHIVE LOG command

destination file, 1-60

START and STOP, 1-66

archived redo log

automatic versus manual, 1-66

storage device, 1-60, 1-64

ARCHIVELOG mode

archiving destination, 1-60, 1-64

automatic archiving, 1-66

AUDIT_ACTIONS table, 2-68

AUDIT_FILE_DEST parameter, 1-15

AUDIT_TRAIL parameter, 1-15

authenticating remote clients, 1-107

authenticating users, 1-92

B_TREE_BITMAP_PLANS parameter, 1-16

background checkpoints completed statistic, C-5

background checkpoints started statistic, C-5

background processes

SNP background process, 1-53

specifying trace files, 1-17

BACKGROUND_CORE_DUMP parameter, 1-16

BACKGROUND_DUMP_DEST parameter, 1-16

ALERT file, 1-17

BACKUP_DISK_IO_SLAVES parameter, 1-17

BACKUP_TAPE_IO_SLAVES parameter, 1-17

batched allocate scn lock request wait event, A-20

being written redo log enqueue, B-3

BFILE check if exists wait event, A-13

BFILE check if open wait event, A-13

BFILE closure wait event, A-13

BFILE get length wait event, A-13

BFILE get name object wait event, A-14

BFILE get path object wait event, A-14

BFILE internal seek wait event, A-14

BFILE open wait event, A-15

BFILE read wait event, A-15

bind enqueue, B-2

BITMAP_MERGE_AREA_SIZE parameter, 1-18

BLANK_TRIMMING parameter, 1-18

block

PCM lock, 1-44

redo log, 1-67

rollback segment, 1-46

size, 1-28

when written to disk, 1-46

block size, 4-3

buffer busy waits wait event, A-20

buffer cache

database, 1-25

buffer cache management enqueue, B-2

buffer deadlock wait event, A-21

buffer for checkpoint wait event, A-21

buffer latch wait event, A-22

buffer read retry wait event, A-22

BUFFER_POOL_KEEP parameter, 1-19

BUFFER_POOL_RECYCLE parameter, 1-19

buffers

number of, 1-25

bytes received via SQL*Net from dblink statistic, C-6

bytes sent via SQL*Net to client statistic, C-6

bytes sent via SQL*Net to dblink statistic, C-6

cache

database blocks, 1-25

dictionary, 3-70, 3-89, 3-90, 3-91, 3-92

statistics, 1-68

CACHE_SIZE_THRESHOLD parameter, 1-19

Cached Commit SCN referenced statistic, C-2

calls to get snapshot scn

kcmgss statistic, C-6

CAT synonym for USER_CATALOG view, 2-68

CATALOG view, 2-68

CATALOG.SQL

creating V$ views, 3-2

CATALOG.SQL script, 5-2

CATAUDIT.SQL script

audit trail records created by, 2-191

audit trails for connections and disconnections, 2-192

auditing options created by, 2-224

CATBLOCK.SQL script, 5-3

CATEXP7.SQL script, 5-3

CATHS.SQL script, 5-3

CATIO.SQL script, 5-3

CATNOADT.SQL script, 5-6

CATNOAUD.SQL script, 5-6

CATNOHS.SQL script, 5-6

CATNOPRT.SQL script, 5-6

CATNOQUEUE.SQL script, 5-6

CATNORMN.SQL script, 5-6

CATNOSVM.SQL script, 5-6

CATNSNMP.SQL script, 5-6

CATOCTK.SQL script, 5-3

CATPARR.SQL script, 5-3

CATPROC.SQL script, 5-2

CATREP.SQL script, 5-3

CATRMAN.SQL script, 5-3

CHAINED_ROWS view, 2-68

change write time statistic, C-6

characters

numeric group separators, 1-81

checkpoint completed wait event, A-23

checkpoint range buffer not saved wait event, A-23

checkpoints

checkpoint interval, 1-67

statistics, 1-68

cleanouts and rollbacks - consistent read gets statistic, C-6

cleanouts only - consistent read gets statistic, C-6

CLEANUP_ROLLBACK_ENTRIES parameter, 1-19

CLOSE_CACHED_OPEN_CURSORS parameter, 1-20

CLU synonym for USER_CLUSTERS, 2-68

cluster key scan block gets statistic, C-6

cluster key scans statistic, C-7

CODE_PIECES view, 2-69

CODE_SIZE view, 2-69

COL view, 2-69

COLS synonym for USER_TAB_COLUMNS, 2-69

COLUMN_PRIVILEGES view, 2-69

commit cleanout failures

block lost statistic, C-7

buffer being written statistic, C-7

callback failure statistic, C-7

cannot pin statistic, C-7

hot backup in progress statistic, C-7

write disabled statistic, C-7

commit cleanouts statistic, C-7

commit cleanouts successfully completed statistic, C-7

Commit SCN referenced statistic, C-3

COMMIT_POINT_STRENGTH parameter, 1-20

COMPATIBLE parameter, 1-20

COMPATIBLE_NO_RECOVERY parameter, 1-21

COMPLEX_VIEW_MERGING parameter, 1-21

concurrency

ROW_LOCKING parameter, 1-111

transactions and, 1-125

transactions per rollback segment, 1-125

consistency

multiversion read, 1-46

rollback information, 1-46

consistent changes statistic, C-8

consistent gets statistic, C-8

contention

block-level, 3-130

control files

names, 1-22

specifying, 1-22

CONTROL_FILE_RECORD_KEEP_TIME parameter, 1-21

CONTROL_FILES parameter, 1-22

controlfile parallel write wait event, A-23

controlfile sequntial read wait event, A-24

controlfile single write wait event, A-24

controlfile transaction enqueue, B-2

conversion file read wait event, A-25

CORE_DUMP_DEST parameter, 1-23

cost-based optimizer, 1-88

CPU used by this session statistic, C-2

CPU used when call started, C-2

CPU_COUNT parameter, 1-23

CR blocks created statistic, C-2

CREATE DATABASE command

database name, 1-33

setting the block size, 1-28

setting the log mode, 1-66

CREATE TABLE statement

FREELIST GROUPS option, 1-52

CREATE_BITMAP_AREA_SIZE parameter, 1-24

creating

databases

setting block size, 1-27, 1-28

cross instance CR read statistic, C-8

cross-instance call invocation enqueue, B-2

currency, 1-78

international currency symbol, 1-80

Current blocks converted for CR statistic, C-3

CURSOR_SPACE_FOR_TIME parameter, 1-24

cursors

OPEN_CURSORS parameter, 1-84

shared pool, 1-49, 1-115, 1-116

data blocks

reading multiple, 1-30

size of, 1-27, 1-28

data blocks consistent reads - undo records applied statistic, C-8

data dictionary, 2-2

cache, 3-70, 3-89, 3-90, 3-91, 3-92

datafiles, 1-45

DICTIONARY view, 2-175

rollback segments, 1-110

database block size, 4-3

database mount enqueue, B-2

database writer process (DBWR)

checkpoint, 1-68

databases

database limits, 4-2

default language, 1-80

name, 1-32, 1-33

resource limits, 1-108, 1-109

valid characters for database name, 1-33

datafile enqueue, B-2

datafiles

mapping blocks to PCM locks, 1-44

maximum number, 1-32

parameter, 1-30, 1-32

unspecified for PCM locks, 1-45

dates

language used for, 1-79

setting SYSDATE, 1-42

TO_CHAR and TO_DATE functions, 1-78

db block changes statistic, C-8

db block gets statistic, C-8

db file parallel read wait event, A-25

db file parallel write wait event, A-26

db file scattered read wait event, A-26

db file sequential read wait event, A-26

db file single write wait event, A-27

DB_BLOCK_BUFFERS parameter, 1-25

DB_BLOCK_CHECKING parameter, 1-26

DB_BLOCK_CHECKPOINT_BATCH parameter, 1-25

DB_BLOCK_CHECKSUM parameter, 1-26

DB_BLOCK_LRU_EXTENDED_STATISTICS parameter, 1-27

DB_BLOCK_LRU_LATCHES parameter, 1-27

DB_BLOCK_LRU_STATISTICS parameter, 1-27

DB_BLOCK_MAX_DIRTY_TARGET parameter, 1-27

DB_BLOCK_SIZE parameter, 1-28

DB_DOMAIN parameter, 1-29

DB_FILE_DIRECT_IO_COUNT parameter, 1-30

DB_FILE_MULTIBLOCK_READ_COUNT parameter, 1-30

DB_FILE_NAME_CONVERT parameter, 1-31

DB_FILE_SIMULTANEOUS_WRITES parameter, 1-31

DB_FILES parameter, 1-32

DB_NAME parameter, 1-32

DB_WRITER_PROCESSES parameter, 1-33

DBA_2PC_NEIGHBORS view, 2-70

DBA_2PC_PENDING view, 2-71

DBA_ALL_TABLES view, 2-72

DBA_ANALYZE_OBJECTS view, 2-74

DBA_ASSOCIATIONS view, 2-74

DBA_AUDIT_EXISTS view, 2-74

DBA_AUDIT_OBJECT view, 2-75

DBA_AUDIT_SESSION view, 2-77

DBA_AUDIT_STATEMENT view, 2-77

DBA_AUDIT_TRAIL view, 2-79

DBA_BLOCKERS view, 2-80

DBA_CATALOG view, 2-80

DBA_CLU_COLUMNS view, 2-81

DBA_CLUSTER_HASH_EXPRESSIONS view, 2-82

DBA_CLUSTERS view, 2-81

DBA_COL_COMMENTS view, 2-82

DBA_COL_PRIVS view, 2-83

DBA_COLL_TYPES view, 2-83

DBA_CONS_COLUMNS view, 2-85

DBA_CONSTRAINTS view, 2-84

DBA_CONTEXT view, 2-85

DBA_DATA_FILES view, 1-45, 2-85, 2-165

DBA_DB_LINKS view, 2-86

DBA_DDL_LOCKS view, 2-86

DBA_DEPENDENCIES view, 2-87

DBA_DIM_ATTRIBUTES view, 2-88

DBA_DIM_CHILD_OF view, 2-88

DBA_DIM_HIERARCHIES view, 2-89

DBA_DIM_JOIN_KEY view, 2-88

DBA_DIM_LEVEL_KEY view, 2-89

DBA_DIM_LEVELS view, 2-89

DBA_DIMENSIONS view, 2-87

DBA_DIRECTORIES view, 2-90

DBA_DML_LOCKS view, 2-90

DBA_ERRORS view, 2-91

DBA_EXP_FILES view, 2-91

DBA_EXP_OBJECTS view, 2-92

DBA_EXP_VERSION view, 2-92

DBA_EXTENTS view, 2-92

DBA_FREE_SPACE view, 2-93

DBA_FREE_SPACE_COALESCED view, 2-93

DBA_IND_COLUMNS view, 2-96

DBA_IND_PARTITIONS view, 2-97

DBA_IND_SUBPARTITIONS view, 2-18, 2-99

DBA_INDEXES view, 2-94

DBA_INDEXTYPE_OPERATORS view, 2-100

DBA_INDEXTYPES view, 2-100

DBA_JOBS view, 2-101

DBA_JOBS_RUNNING view, 2-102

DBA_LIBRARIES view, 2-102

DBA_LOB_PARTITIONS view, 2-103

DBA_LOB_SUBPARTITIONS view, 2-104

DBA_LOBS view, 2-102

DBA_LOCK_INTERNAL view, 2-105

DBA_LOCKS view, 2-105

DBA_METHOD_PARAMS view, 2-106

DBA_METHOD_RESULTS view, 2-106

DBA_MVIEW_AGGREGATES view, 2-107

DBA_MVIEW_ANALYSIS view, 2-107

DBA_MVIEW_DETAIL_RELATIONS view, 2-108

DBA_MVIEW_JOINS view, 2-109

DBA_MVIEW_KEYS view, 2-109

DBA_NESTED_TABLES view, 2-110

DBA_OBJ_AUDIT_OPTS view, 2-113

DBA_OBJECT_SIZE view, 2-110

DBA_OBJECT_TABLES view, 2-111

DBA_OBJECTS view, 2-113

DBA_OPANCILLARY view, 2-114

DBA_OPARGUMENTS view, 2-114

DBA_OPBINDINGS view, 2-115

DBA_OPERATORS view, 2-115

DBA_OUTLINE_HINTS view, 2-115

DBA_OUTLINES view, 2-116

DBA_PART_COL_STATISTICS view, 2-116

DBA_PART_HISTOGRAMS view, 2-117

DBA_PART_INDEXES view, 2-117

DBA_PART_KEY_COLUMNS view, 2-119

DBA_PART_LOBS view, 2-119

DBA_PART_TABLES view, 2-120

DBA_PARTIAL_DROP_TABS view, 2-121

DBA_PENDING_TRANSACTIONS view, 2-121

DBA_POLICIES view, 2-122

DBA_PRIV_AUDIT_OPTS view, 2-122

DBA_PROFILES view, 2-123

DBA_QUEUE_SCHEDULES view, 2-123

DBA_QUEUE_TABLES view, 2-125

DBA_QUEUES view, 2-125

DBA_RCHILD view, 2-126

DBA_REFRESH view, 2-126

DBA_REFRESH_CHILDREN view, 2-127

DBA_REFS view, 2-128

DBA_REGISTERED_SNAPSHOT_GROUPS view, 2-129

DBA_REGISTERED_SNAPSHOTS view, 2-129

DBA_REPCAT_REFRESH_TEMPLATES view, 2-130

DBA_REPCAT_TEMPLATE_OBJECTS view, 2-130

DBA_REPCAT_TEMPLATE_PARMS view, 2-130

DBA_REPCAT_TEMPLATE_SITES view, 2-130

DBA_REPCAT_USER_AUTHORIZATIONS view, 2-130

DBA_REPCAT_USER_PARM_VALUES view, 2-130

DBA_REPCATLOG view, 2-129

DBA_REPCOLUMN view, 2-130

DBA_REPCOLUMN_GROUP view, 2-130

DBA_REPCONFLICT view, 2-131

DBA_REPDDL view, 2-131

DBA_REPGENERATED view, 2-131

DBA_REPGENOBJECTS view, 2-131

DBA_REPGROUP view, 2-131

DBA_REPGROUPED_COLUMN view, 2-131

DBA_REPKEY_COLUMNS view, 2-131

DBA_REPOBJECT view, 2-131

DBA_REPPARAMETER_COLUMN view, 2-132

DBA_REPPRIORITY view, 2-132

DBA_REPPRIORITY_GROUP view, 2-132

DBA_REPPROP view, 2-132

DBA_REPRESOL_STATS_CONTROL view, 2-132

DBA_REPRESOLUTION view, 2-132

DBA_REPRESOLUTION_METHOD view, 2-132

DBA_REPSITES view, 2-132

DBA_RGROUP view, 2-133

DBA_ROLE_PRIVS view, 2-134

DBA_ROLES view, 2-133

DBA_ROLLBACK_SEGS view, 2-134

DBA_RSRC_CONSUMER_GROUP_PRIVS view, 2-135

DBA_RSRC_CONSUMER_GROUPS view, 2-135

DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 2-135

DBA_RSRC_PLAN_DIRECTIVES view, 2-136

DBA_RSRC_PLANS view, 2-136

DBA_RULESETS view, 2-137

DBA_SEGMENTS view, 2-137

DBA_SEQUENCES view, 2-138

DBA_SNAPSHOT_LOG_FILTER_COLS view, 2-139

DBA_SNAPSHOT_LOGS view, 2-139

DBA_SNAPSHOT_REFRESH_TIMES view, 2-139

DBA_SNAPSHOTS view, 2-140

DBA_SOURCE view, 2-141

DBA_STMT_AUDIT_OPTS view, 2-142

DBA_SUBPART_COL_STATISTICS view, 2-142

DBA_SUBPART_HISTOGRAMS view, 2-143

DBA_SUBPART_KEY_COLUMNS view, 2-143

DBA_SYNONYMS view, 2-144

DBA_SYS_PRIVS view, 2-144

DBA_TAB_COL_STATISTICS view, 2-144

DBA_TAB_COLUMNS view, 2-145

DBA_TAB_COMMENTS view, 2-146

DBA_TAB_HISTOGRAMS view, 2-146

DBA_TAB_PARTITIONS view, 2-147

DBA_TAB_PRIVS view, 2-148

DBA_TAB_SUBPARTITIONS view, 2-148

DBA_TABLES view, 2-150

DBA_TABLESPACES view, 2-152

DBA_TEMP_FILES view, 2-152

DBA_TRIGGER_COLS view, 2-154

DBA_TRIGGERS view, 2-153

DBA_TS_QUOTAS view, 2-154

DBA_TYPE_ATTRS view, 2-154

DBA_TYPE_METHODS view, 2-155

DBA_TYPES view, 2-155

DBA_UPDATABLE_COLUMNS view, 2-156

DBA_USERS view, 2-156

DBA_USTATS view, 2-157

DBA_VARRAYS view, 2-158

DBA_VIEWS view, 2-158

DBA_WAITERS view, 2-159

DBLINK_ENCRYPT_LOGIN parameter, 1-34

DBMS_ALERT_INFO view, 2-159

DBMS_LOCK_ALLOCATED view, 2-159

DBMSIOTC.SQL script, 5-3

DBMSOTRC.SQL script, 5-4

DBMSPOOL.SQL script, 5-4

DBWR buffers scanned statistic, C-3

DBWR checkpoint buffers written statistic, C-3

DBWR checkpoints statistic, C-3

DBWR forced writes statistic, C-3

DBWR free buffers found statistic, C-3

DBWR lru scans statistic, C-3

DBWR make free requests statistic, C-4

DBWR revisited being-written buffer statistic, C-4

DBWR skip hot writes statistic, C-4

DBWR summed scan depth statistic, C-4

DBWR undo block writes statistic, C-4

DBWR_IO_SLAVES parameter, 1-34

DDL statements parallelized statistic, C-4

DEFCALL view, 2-160

DEFCALLDEST view, 2-160

DEFDEFAULTDEST view, 2-160

DEFERRCOUNT view, 2-160

deferred (CURRENT) blockk cleanout applications statistic, C-8

DEFERROR view, 2-160

DEFLOB view, 2-160

DEFPROPAGATOR view, 2-160

DEFSCHEDULE view, 2-160

DEFTRAN view, 2-161

DEFTRANDEST view, 2-161

DELAYED_LOGGING_BLOCK_CLEANOUTS parameter, 1-35

DEPTREE view, 2-161

derived parameters, 1-10

destination

archiving redo log files, 1-60

overriding default, 1-60

USER_DUMP_DEST, 1-126

DFS db file lock wait event, A-15

DFS lock handle wait event, A-16

DICT synonym for DICTIONARY, 2-161

DICT_COLUMNS view, 2-162

DICTIONARY view, 2-161

DICT synonym, 2-161

direct loader index creation enqueue, B-2

direct path read wait event, A-27

direct path write wait event, A-28

dirty buffers inspected statistic, C-8

DISCRETE_TRANSACTIONS_ENABLED parameter, 1-36

disk drives

archiving destination, 1-60

writing blocks, 1-46

DISK_ASYNCH_IO parameter, 1-36

dispatcher processes

maximum number, 1-75

dispatcher shutdown wait event, A-28

dispatcher timer wait event, A-28

distinguished name, 1-104

distributed lock

exclusive, 1-46

rollback segment, 1-46

distributed queries

disabling, 1-85

enabling, 1-85

links for, 1-85

distributed recovery enqueue, B-2

distributed transactions

limiting number of, 1-37

distributed TX enqueue, B-2

DISTRIBUTED_LOCK_TIMEOUT parameter, 1-36

DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME parameter, 1-36

DISTRIBUTED_TRANSACTIONS parameter, 1-37

DML enqueue, B-2

DML statements parallelized statistic, C-4

DML_LOCKS parameter, 1-37

PDML restrictions, 1-38

DROPCAT5.SQL script, 5-7

DROPCAT6.SQL script, 5-7

dump files, 1-71

duplicate cluster key wait event, A-29

dynamic initialization parameters, 1-6

dynamic performance tables

CATALOG.SQL script, 3-2

public synonyms (V$), 3-2

views (V_$), 3-2

embedded parameter files, 1-50

enqueue conversions statistic, C-9

enqueue deadlocks statistic, C-9

enqueue releases statistic, C-9

enqueue requests statistic, C-9

enqueue timeouts statistic, C-9

enqueue wait event, A-29

enqueue waits statistic, C-9

ENQUEUE_RESOURCES parameter, 1-39

enqueues

disabling, 1-38

ENQUEUE_RESOURCES parameter, 1-39

ENT_DOMAIN_NAME, 1-40

enterprise directory service, 1-40

enterprise domain, 1-40

enterprise roles, 1-40, 1-104

ERROR_SIZE view, 2-162

errors

archiving, 1-66

EVENT parameter, 1-40

EXCEPTIONS view, 2-162

exchange deadlocks statistic, C-9

exclusive distributed lock

rollback data, 1-46

exclusive mode

specifying instance number, 1-52

execute count statistic, C-9

extent

allocating to instance, 1-52

FAST_FULL_SCAN_ENABLED parameter, 1-40

FAST_START_PARALLEL_ROLLBACK parameter, 1-42

file identify wait event, A-29

file open wait event, A-29

file set enqueue, B-2

FILE_LOCK view, 2-162

FILE_PING view, 2-163

filenames

case significance, 1-3

name and number, 1-44

FILEXT$ view, 2-165

FIRST_ROWS, 1-89

FIXED_DATE parameter, 1-42

free buffer inspected statistic, C-9

free buffer requested statistic, C-10

free buffer waits wait event, A-30

free global transaction table entry wait event, A-30

free process state object wait event, A-30

free space list

locating space, 1-52

FREELIST GROUPS storage option, 1-52

FREELISTS storage option

maximum value, 1-28

FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY parameter, 1-43

GC_DEFER_TIME parameter, 1-44

GC_FILES_TO_LOCKS parameter, 1-44

GC_LATCHES parameter, 1-45

GC_LCK_PROCS parameter, 1-45

GC_RELEASABLE_LOCKS parameter, 1-46

GC_ROLLBACK_LOCKS parameter, 1-46

global cache control parameters, 1-10

global cache defers statistic, C-10

global cache freelist wait wait event, A-31

global cache freelist waits statistic, C-10

global cache lock busy wait event, A-31

global cache lock cleanup wait event, A-31

global cache lock null to s wait event, A-32

global cache lock null to x wait event, A-32

global cache lock open null wait event, A-32

global cache lock open s wait event, A-32

global cache lock open x wait event, A-33

global cache locks s to x wait event, A-33

global constant parameter

rollback segments, 1-46

global lock convert time statistic, C-10

global lock converts (async) statistic, C-10

global lock converts (non async) statistic, C-10

global lock get time statistic, C-10

global lock gets (async) statistic, C-10

global lock gets (non async) statistic, C-10

global lock release time statistic, C-11

global lock releases statistic, C-11

global user security, 1-40

GLOBAL_NAME view, 2-165

GLOBAL_NAMES parameter, 1-47

GV$ views

for parallel servers, 3-2

restrictions on, 3-3

HASH_AREA_SIZE parameter, 1-47

HASH_JOIN_ENABLED parameter, 1-47

HASH_MULTIBLOCK_IO_COUNT parameter, 1-48

Heterogeneous Services Parameters, 1-11

HI_SHARED_MEMORY_ADDRESS parameter, 1-49

hints

FIRST_ROWS, 1-89

RULE, 1-88, 1-89

hot buffers moved to head of LRU statistic, C-11

HS_ALL_CAPS view, 2-165

HS_ALL_DD view, 2-165

HS_ALL_INITS view, 2-166

HS_AUTOREGISTER parameter, 1-49

HS_BASE_CAPS view, 2-166

HS_BASE_DD view, 2-166

HS_CLASS_CAPS view, 2-167

HS_CLASS_DD view, 2-167

HS_CLASS_INIT view, 2-168

HS_EXTERNAL_OBJECT_PRIVILEGES view, 2-168

HS_EXTERNAL_OBJECTS view, 2-168

HS_EXTERNAL_USER_PRIVILEGES view, 2-169

HS_FDS_CLASS view, 2-169

HS_FDS_INST view, 2-169

HS_INST_CAPS view, 2-170

HS_INST_DD view, 2-170

HS_INST_INIT view, 2-171

IDEPTREE view, 2-171

IFILE, 1-4

IFILE keyword

nested files, 1-50

IFILE parameter, 1-50

immediate (CR) block cleanout applications statistic, C-11

immediate (CURRENT) block cleanout applications statistic, C-11

inactive session wait event, A-33

inactive transaction branch wait event, A-34

IND synonym for USER_INDEXES, 2-172

index block split wait event, A-34

INDEX_HISTOGRAM view, 2-172

INDEX_STATS view, 2-172

indexes

FREELISTS option, 1-28

INITDW.ORA file, 1-2

initialization parameters

ALLOW_PARTIAL_SN_RESULTS, 1-13

altering, 1-6

ALWAYS_ANTI_JOIN, 1-14

ALWAYS_SEMI_JOIN, 1-14

AQ_TM_PROCESSES, 1-15

ARCH_IO_SLAVES, 1-15

AUDIT_FILE_DEST, 1-15

AUDIT_TRAIL, 1-15

B_TREE_BITMAP_PLANS, 1-16

BACKGROUND_CORE_DUMP, 1-16

BACKGROUND_DUMP_DEST, 1-16

BACKUP_DISK_IO_SLAVES, 1-17

BACKUP_TAPE_IO_SLAVES, 1-17

BITMAP_MERGE_AREA_SIZE, 1-18

BLANK_TRIMMING, 1-18

BUFFER_POOL_KEEP, 1-19

BUFFER_POOL_RECYCLE, 1-19

CACHE_SIZE_THRESHOLD, 1-19

case significance in filenames, 1-3

CLEANUP_ROLLBACK_ENTRIES, 1-19

CLOSE_CACHED_OPEN_CURSORS, 1-20

COMMIT_POINT_STRENGTH, 1-20

COMPATIBLE, 1-20

COMPATIBLE_NO_RECOVERY, 1-21

COMPLEX_VIEW_MERGING, 1-21

CONTROL_FILE_RECORD_KEEP_TIME, 1-21

CONTROL_FILES, 1-22

CORE_DUMP_DEST, 1-23

CPU_COUNT, 1-23

CREATE_BITMAP_AREA_SIZE, 1-24

CURSOR_SPACE_FOR_TIME, 1-24

database creation, 1-33

DB_BLOCK_BUFFERS, 1-25

DB_BLOCK_CHECKING, 1-26

DB_BLOCK_CHECKPOINT_BATCH, 1-25

DB_BLOCK_CHECKSUM, 1-26

DB_BLOCK_LRU_EXTENDED_STATISTICS, 1-27

DB_BLOCK_LRU_LATCHES, 1-27

DB_BLOCK_LRU_STATISTICS, 1-27

DB_BLOCK_MAX_DIRTY_TARGET, 1-27

DB_BLOCK_SIZE, 1-28

DB_DOMAIN, 1-29

DB_FILE_DIRECT_IO_COUNT, 1-30

DB_FILE_MULTIBLOCK_READ_COUNT, 1-30

DB_FILE_NAME_CONVERT, 1-31

DB_FILE_SIMULTANEOUS_WRITES, 1-31

DB_FILES, 1-32

DB_NAME, 1-32

DB_WRITER_PROCESSES, 1-33

DBLINK_ENCRYPT_LOGIN, 1-34

DBWR_IO_SLAVES, 1-34

DELAYED_LOGGING_BLOCK_CLEANOUTS, 1-35

derived parameters, 1-10

DISCRETE_TRANSACTIONS_ENABLED, 1-36

DISK_ASYNCH_IO, 1-36

display current settings, 1-9

DISTRIBUTED_LOCK_TIMEOUT, 1-36

DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME, 1-36

DISTRIBUTED_TRANSACTIONS, 1-37

DML_LOCKS, 1-37

dynamic, 1-6

ENQUEUE_RESOURCES, 1-39

EVENT, 1-40

FAST_FULL_SCAN_ENABLED, 1-40

FAST_START_PARALLEL_ROLLBACK, 1-42

FIXED_DATE, 1-42

FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY, 1-43

GC parameters, 1-10

GC_DEFER_TIME, 1-44

GC_FILES_TO_LOCKS, 1-44

GC_LATCHES, 1-45

GC_LCK_PROCS, 1-45

GC_RELEASABLE_LOCKS, 1-46

GC_ROLLBACK_LOCKS, 1-46

global cache, 1-10

global constant parameters, 1-10

GLOBAL_NAMES, 1-47

HASH_AREA_SIZE, 1-47

HASH_JOIN_ENABLED, 1-47

HASH_MULTIBLOCK_IO_COUNT, 1-48

HI_SHARED_MEMORY_ADDRESS, 1-49

HS_AUTOREGISTER, 1-49

IFILE, 1-50

INSTANCE_GROUPS, 1-50

INSTANCE_NAME, 1-51

INSTANCE_NUMBER, 1-51

JAVA_POOL_SIZE, 1-52

JOB_QUEUE_INTERVAL, 1-52

JOB_QUEUE_PROCESSES, 1-53

LARGE_POOL_MIN_ALLOC, 1-53

LARGE_POOL_SIZE, 1-53

LICENSE_MAX_SESSIONS, 1-54

LICENSE_MAX_USERS, 1-55

LICENSE_SESSIONS_WARNING, 1-55

LOCK_NAME_SPACE, 1-59

LOCK_SGA, 1-59

LOCK_SGA_AREAS, 1-59

LOG_ARCHIVE_BUFFER_SIZE, 1-59

LOG_ARCHIVE_BUFFERS, 1-59

LOG_ARCHIVE_DEST, 1-60

LOG_ARCHIVE_DEST_n, 1-61

LOG_ARCHIVE_DEST_STATE_n, 1-62

LOG_ARCHIVE_DUPLEX_DEST, 1-63

LOG_ARCHIVE_FORMAT, 1-64

LOG_ARCHIVE_MAX_PROCESSES, 1-64

LOG_ARCHIVE_MIN_SUCCEED_DEST, 1-65

LOG_ARCHIVE_START, 1-66

LOG_BLOCK_CHECKSUM, 1-66

LOG_BUFFER, 1-67

LOG_CHECKPOINT_INTERVAL, 1-67

LOG_CHECKPOINT_TIMEOUT, 1-68

LOG_CHECKPOINTS_TO_ALERT, 1-69

LOG_FILE_NAME_CONVERT, 1-69

LOG_FILES, 1-70

LOG_SIMULTANEOUS_COPIES, 1-70

LOG_SMALL_ENTRY_MAX_SIZE, 1-70

MAX_COMMIT_PROPAGATION_DELAY, 1-70

MAX_DUMP_FILE_SIZE, 1-71

MAX_ENABLED_ROLES, 1-71

MAX_PARALLEL_SERVER parameter, 3-3

MAX_ROLLBACK_SEGMENTS, 1-72

MAX_TRANSACTION_BRANCHES, 1-72

MTS_DISPATCHERS, 1-72

MTS_LISTENER_ADDRESS, 1-75

MTS_MAX_DISPATCHERS, 1-75

MTS_MAX_SERVERS, 1-75

MTS_MULTIPLE_LISTENERS, 1-75

MTS_RATE_LOG_SIZE, 1-76

MTS_RATE_SCALE, 1-76

MTS_SERVERS, 1-76

MTS_SERVICE, 1-76

MVIEW_REWRITE_ENABLED, 1-103

NLS_CALENDAR, 1-76

NLS_COMP, 1-77

NLS_CURRENCY, 1-78

NLS_DATE_FORMAT, 1-78

NLS_DATE_LANGUAGE, 1-79

NLS_ISO_CURRENCY, 1-80

NLS_LANGUAGE, 1-80

NLS_NUMERIC_CHARACTERS, 1-81

NLS_SORT, 1-81

NLS_TERRITORY, 1-82

NLS_UNION_CURRENCY, 1-79

O7_DICTIONARY_ACCESSIBILITY, 1-13

OBJECT_CACHE_MAX_SIZE_PERCENT, 1-83

OBJECT_CACHE_OPTIMAL_SIZE, 1-83

OGMS_HOME, 1-83

OPEN_CURSORS, 1-84

OPEN_LINKS, 1-84

OPEN_LINKS_PER_INSTANCE, 1-85

operating system dependent parameters, 1-10

OPS_ADMIN_GROUP, 1-85, 3-3

OPTIMIZER_FEATURES_ENABLED, 1-86

OPTIMIZER_INDEX_CACHING, 1-86

OPTIMIZER_INDEX_COST_ADJ, 1-87

OPTIMIZER_MAX_PERMUTATIONS, 1-87

OPTIMIZER_MODE, 1-88

OPTIMIZER_PERCENT_PARALLEL, 1-88

OPTIMIZER_SEARCH_LIMIT, 1-89

ORACLE_TRACE_COLLECTION_NAME, 1-89

ORACLE_TRACE_COLLECTION_PATH, 1-90

ORACLE_TRACE_COLLECTION_SIZE, 1-90

ORACLE_TRACE_ENABLE, 1-90

ORACLE_TRACE_FACILITY_NAME, 1-91

ORACLE_TRACE_FACILITY_PATH, 1-91

OS_AUTHENT_PREFIX, 1-92

OS_ROLES, 1-92

overview, 1-2

PARALLEL_ADAPTIVE_MULTI_USER, 1-93

PARALLEL_AUTOMATIC_TUNING, 1-94

PARALLEL_BROADCAST_ENABLED, 1-94

PARALLEL_DEFAULT_MAX_INSTANCES, 1-95

PARALLEL_EXECUTION_MESSAGE_SIZE, 1-95

PARALLEL_INSTANCE_GROUP, 1-96

PARALLEL_MAX_SERVERS, 1-96

PARALLEL_MIN_MESSAGE_POOL, 1-97

PARALLEL_MIN_PERCENT, 1-97

PARALLEL_MIN_SERVERS, 1-98

PARALLEL_SERVER, 1-99

PARALLEL_SERVER_IDLE_TIME, 1-99

PARALLEL_SERVER_INSTANCES, 1-99

PARALLEL_THREADS_PER_CPU, 1-99

PARALLEL_TRANSACTION_RESOURCE_TIMEOUT, 1-100

PARTITION_VIEW_ENABLED, 1-100

performance tuning, 1-11

PLSQL_V2_COMPATIBILITY, 1-101

PRE_PAGE_SGA, 1-102

PROCESSES, 1-103

PUSH_JOIN_PREDICATE, 1-103

READ_ONLY_OPEN_DELAYED, 1-105

RECOVERY_PARALLELISM, 1-106

REDUCE_ALARM, 1-106

REMOTE_DEPENDENCIES_MODE, 1-106

REMOTE_LOGIN_PASSWORDFILE, 1-107

REMOTE_OS_AUTHENT, 1-107

REMOTE_OS_ROLES, 1-108

REPLICATION_DEPENDENCY_TRACKING, 1-108

RESOURCE_LIMIT, 1-108, 1-109

RESOURCE_MANAGER_PLAN, 1-109

REWRITE_INTEGRITY, 1-104

rollback segments, 1-125

ROLLBACK_SEGMENTS, 1-110

ROW_CACHE_CURSORS, 1-110

ROW_LOCKING, 1-111

SEQUENCE_CACHE_ENTRIES, 1-111

SEQUENCE_CACHE_HASH_BUCKET, 1-111

SERIAL_REUSE, 1-111

SERVICE_NAMES, 1-112

SESSION_CACHED_CURSORS, 1-113

SESSION_MAX_OPEN_FILES, 1-113

SESSIONS, 1-114

SHADOW_CORE_DUMP, 1-114

SHARED_MEMORY_ADDRESS, 1-115

SHARED_POOL_RESERVED_MIN_ALLOC, 1-115

SHARED_POOL_RESERVED_SIZE, 1-115, 3-105

SHARED_POOL_SIZE, 1-116

SORT_AREA_RETAINED_SIZE, 1-117

SORT_AREA_SIZE, 1-118

SORT_DIRECT_WRITES, 1-118

SORT_MULTIBLOCK_READ_COUNT, 1-119

SORT_READ_FAC, 1-119

SORT_SPACEMAP_SIZE, 1-119

SORT_WRITE_BUFFER_SIZE, 1-120

SORT_WRITE_BUFFERS, 1-120

specifying in parameter files, 1-3

SPIN_COUNT, 1-120

SQL_TRACE, 1-120

SQL92_SECURITY, 1-120

STANDBY_ARCHIVE_DEST, 1-121

STAR_TRANSFORMATION_ENABLED, 1-121

TEMPORARY_TABLE_LOCKS, 1-122

TEXT_ENABLE, 1-122

THREAD, 1-122

TIMED_OS_STATISTICS, 1-123

TIMED_STATISTICS, 1-124

TRANSACTION_AUDITING, 1-124

TRANSACTIONS, 1-125

TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1-125

USE_INDIRECT_DATA_BUFFERS, 1-126

USE_ISM, 1-126

USER_DUMP_DEST, 1-126

INIT.ORA

inserts

locating free space, 1-52

INST_ID column, 3-2

instance attribute lock enqueue, B-3

instance number enqueue, B-2

INSTANCE option

allocating extents, 1-52

Instance recovery, 1-43

instance recovery enqueue, B-2

instance recovery wait event, A-35

instance registration lock enqueue, B-3

instance state change wait event, A-35

instance state enqueue, B-2

INSTANCE_GROUPS parameter, 1-50

INSTANCE_NAME parameter, 1-51

INSTANCE_NUMBER parameter, 1-51

exclusive or parallel mode, 1-52

instances

checkpoint, 1-68

startup order, 1-52

I/O

reading multiple blocks, 1-30

redo log files, 1-67

reducing with buffer cache, 1-25

io done wait event, A-35

JAVA_POOL_SIZE parameter, 1-52

job queue enqueue, B-2

JOB_QUEUE_INTERVAL parameter, 1-52

JOB_QUEUE_PROCESSES parameter, 1-53

kcl bg acks wait event, A-36

kcmccs called get current scn statistic, C-11

kcmccs read scn without going to DLM statistic, C-11

kcmggs waited for batching statistic, C-11

language

database default language, 1-80

LARGE_POOL_MIN_ALLOC parameter, 1-53

LARGE_POOL_SIZE parameter, 1-53

latch activity wait event, A-36

latch free wait event, A-36

LGWR_IO_SLAVES parameter

initialization parameters

LGWR_IO_SLAVES, 1-54

library cache invalidation enqueue, B-2

library cache load lock wait event, A-37

library cache lock enqueue, B-2

library cache lock wait event, A-37

library cache pin enqueue, B-2

library cache pin wait event, A-38

LICENSE_MAX_SESSIONS parameter, 1-54

LICENSE_MAX_USERS parameter, 1-55

LICENSE_SESSIONS_WARNING parameter, 1-55

licenses

maximum sessions, 1-54

maximum users, 1-55

warning for concurrent user sessions, 1-55

limits on the database, 4-2

linguistic sorts, 1-81

LM_LOCKS parameter, 1-56

LM_PROCS parameter, 1-57

LM_RESS parameter, 1-57

local currency, 1-78

LOCAL_LISTENER parameter, 1-58

lock

names, A-12

lock conversion, 3-15, 3-18, 3-19, 3-43, 3-72

lock element

fixed, 1-46

non-fixed, 1-46

lock manager wait for remote message wait event, A-38

LOCK_NAME_SPACE parameter, 1-59

LOCK_SGA parameter, 1-59

LOCK_SGA_AREAS parameter, 1-59

locks

table lock, 1-111

log buffer space wait event, A-39

log file parallel write wait event, A-39

log file sequential read wait event, A-39

log file single write wait event, A-40

log file switch (archiving needed) wait event, A-40

log file switch (checkpoint incomplete) wait event, A-40

log file switch (clearing log file) wait event, A-40

log file switch completion wait event, A-41

log file sync wait event, A-41

log switch/archive wait event, A-41

LOG_ARCHIVE_BUFFER_SIZE parameter, 1-59

LOG_ARCHIVE_BUFFERS parameter, 1-59

LOG_ARCHIVE_DEST parameter, 1-60

LOG_ARCHIVE_DEST_n parameter, 1-61

LOG_ARCHIVE_DEST_STATE_n parameter, 1-62

LOG_ARCHIVE_DUPLEX_DEST parameter, 1-63

LOG_ARCHIVE_FORMAT parameter, 1-64

LOG_ARCHIVE_MAX_PROCESSES parameter, 1-64

LOG_ARCHIVE_MIN_SUCCEED_DEST parameter, 1-65

LOG_ARCHIVE_START parameter, 1-66

LOG_BLOCK_CHECKSUM parameter, 1-66

LOG_BUFFER parameter, 1-67

LOG_CHECKPOINT_INTERVAL parameter, 1-67

LOG_CHECKPOINT_TIMEOUT parameter, 1-68

LOG_CHECKPOINTS_TO_ALERT parameter, 1-69

LOG_FILE_NAME_CONVERT parameter, 1-69

LOG_FILES parameter, 1-70

LOG_SIMULTANEOUS_COPIES parameter, 1-70

LOG_SMALL_ENTRY_MAX_SIZE parameter, 1-70

logons cumulative statistic, C-11

logons current statistic, C-11

lowercase significance, 1-3

manual archiving, 1-66

MAX_COMMIT_PROPAGATION_DELAY parameter, 1-70

MAX_DUMP_FILE_SIZE parameter, 1-71

MAX_ENABLED_ROLES parameter, 1-71

MAX_ROLLBACK_SEGMENTS parameter, 1-72

MAX_TRANSACTION_BRANCHES parameter, 1-72

media recovery enqueue, B-2

memory

amount used for sorting, 1-117

virtual, 1-11

migration scripts, 5-7

modes

archiving, 1-66

monitor

performance, 1-68

MTS dispatcher request statistics, 3-85

MTS_DISPATCHERS parameter, 1-72

MTS_LISTENER_ADDRESS parameter, 1-75

MTS_MAX_DISPATCHERS parameter, 1-75

MTS_MAX_SERVERS parameter, 1-75

MTS_MULTIPLE_LISTENERS parameter, 1-75

MTS_RATE_LOG_SIZE parameter, 1-76

MTS_RATE_SCALE parameter, 1-76

MTS_SERVERS parameter, 1-76

MTS_SERVICE parameter, 1-76

multiple-process systems

number of processes, 1-103

multi-threaded server (MTS)

HASH_MULTIBLOCK_IO_COUNT, 1-48

SESSIONS parameter, 1-114

MVIEW_REWRITE_ENABLED parameter, 1-103

native hash arithmetic execute statistic, C-12

native hash arithmetic fail statistic, C-12

nested files, 1-50

next scns gotten without going to DLM statistic, C-12

NLS_CALENDAR parameter, 1-76

NLS_COMP parameter, 1-77

NLS_CURRENCY parameter, 1-78

defined by NLS_TERRITORY, 1-83

NLS_DATABASE_PARAMETERS view, 2-173

NLS_DATE_FORMAT parameter, 1-78

defined by NLS_NUMERIC_CHARACTERS, 1-83

defined by NLS_TERRITORY, 1-83

NLS_DATE_LANGUAGE parameter, 1-79

NLS_INSTANCE_PARAMETERS view, 2-173

NLS_ISO_CURRENCY parameter, 1-80

defined by NLS_TERRITORY, 1-83

NLS_LANGUAGE parameter, 1-80

NLS_NUMERIC_CHARACTERS parameter, 1-81

NLS_SESSION_PARAMETERS view, 2-174

NLS_SORT parameter, 1-81

NLS_TERRITORY parameter, 1-82

NLS_UNION_CURRENCY parameter, 1-79

no work - consistent read gets statistic, C-12

NOARCHIVELOG mode

creating a database, 1-66

numeric group separators, 1-81

O7_DICTIONARY_ACCESSIBILITY parameter, 1-13

OBJ synonym for USER_OBJECTS, 2-174

OBJECT_CACHE_MAX_SIZE_PERCENT parameter, 1-83

OBJECT_CACHE_OPTIMAL_SIZE parameter, 1-83

objects

data dictionary, 2-1

OGMS_HOME parameter, 1-83

on-going SCN fetch to complete wait event, A-41

online redo log

number of files, 1-66

setting checkpoint interval, 1-67

OPEN_CURSORS parameter, 1-84

OPEN_LINKS parameter, 1-84

OPEN_LINKS_PER_INSTANCE parameter, 1-85

opened cursors current statistic, C-12

opens of replaced files statistic, C-12

opens requiring cache replacement statistic, C-12

operating system

authenticating remote clients, 1-107

authenticating users and passwords, 1-92

operating system dependent parameters, 1-10

redo log blocks, 1-67

roles for remote clients, 1-108

OPS_ADMIN_GROUP parameter, 1-85, 3-3

optimization

trading cursor space for time, 1-24

optimizer mode

FIRST_ROWS, 1-89

RULE, 1-89

OPTIMIZER_FEATURES_ENABLED parameter, 1-86

OPTIMIZER_INDEX_CACHING parameter, 1-86

OPTIMIZER_INDEX_COST_ADJ parameter, 1-87

OPTIMIZER_MAX_PERMUTATIONS parameter, 1-87

OPTIMIZER_MODE parameter, 1-88

OPTIMIZER_PERCENT_PARALLEL parameter, 1-88

OPTIMIZER_SEARCH_LIMIT parameter, 1-89

ORACLE_TRACE_COLLECTION_NAME parameter, 1-89

ORACLE_TRACE_COLLECTION_PATH parameter, 1-90

ORACLE_TRACE_COLLECTION_SIZE parameter, 1-90

ORACLE_TRACE_ENABLE parameter, 1-90

ORACLE_TRACE_FACILITY_NAME parameter, 1-91

ORACLE_TRACE_FACILITY_PATH parameter, 1-91

OS_AUTHENT_PREFIX parameter, 1-92

OS_ROLES parameter, 1-92

parallel mode

instance number, 1-52

parallel query

idle time, 1-99

maximum number of instances, 1-94, 1-95

maximum number of servers, 1-96

minimum number of queries, 1-98

OPTIMIZER_PERCENT_PARALLEL, 1-89

parallel query create server wait event, A-41

parallel query dequeue wait wait event, A-42

parallel query qref latch wait event, A-42

parallel query server shutdown wait event, A-43

parallel query signal server wait event, A-43

parallel server parameters

FAST_START_PARALLEL_ROLLBACK, 1-42

LM_LOCKS, 1-56

LM_PROCS, 1-57

LM_RESS, 1-57

MTS_DISPATCHERS, 1-72

MTS_LISTENER_ADDRESS, 1-75

OPS_ADMIN_GROUP, 1-85

PARALLEL_ADAPTIVE_MULTI_USER, 1-93

PARALLEL_AUTOMATIC_TUNING, 1-94

PARALLEL_BROADCAST_ENABLE, 1-94

PARALLEL_EXECUTION_MESSAGE_SIZE, 1-95

PARALLEL_INSTANCE_GROUP, 1-96

PARALLEL_MAX_SERVERS, 1-96

PARALLEL_MIN_PERCENT, 1-97

PARALLEL_MIN_SERVERS, 1-98

PARALLEL_SERVER, 1-99

PARALLEL_SERVER_IDLE_TIME, 1-99

PARALLEL_THREADS_PER_CPU, 1-99

PARALLEL_TRANSACTION_RESOURCE_TIMEOUT, 1-100

parallel server views, 3-2

parallel slave synchronization enqueue, B-2

parallel slaves enqueue, B-2

PARALLEL_ADAPTIVE_MULTI_USER parameter, 1-93

PARALLEL_AUTOMATIC_TUNING parameter, 1-94

PARALLEL_BROADCAST_ENABLE parameter, 1-94

PARALLEL_BROADCAST_ENABLED parameter, 1-94

PARALLEL_DEFAULT_MAX_INSTANCES parameter, 1-95

PARALLEL_EXECUTION_MESSAGE_SIZE parameter, 1-95

PARALLEL_INSTANCE_GROUP parameter, 1-96

PARALLEL_MAX_SERVERS parameter, 1-96, 3-3

PARALLEL_MIN_MESSAGE_POOL parameter, 1-97

PARALLEL_MIN_PERCENT parameter, 1-97

PARALLEL_MIN_SERVERS parameter, 1-98

PARALLEL_SERVER parameter, 1-99

PARALLEL_SERVER_IDLE_TIME parameter, 1-99

PARALLEL_SERVER_INSTANCES parameter, 1-99

PARALLEL_THREADS_PER_CPU parameter, 1-99

PARALLEL_TRANSACTION_RESOURCE_TIMEOUT parameter, 1-100

parallelism

OPTIMIZER_PERCENT_PARALLEL, 1-89

parameter files

common file, 1-50

embedded files, 1-4

embedded parameter files, 1-50

line continuation character (), 1-4

parse count (hard) statistic, C-12

parse count (total) statistic, C-13

parse time cpu statistic, C-13

parse time elapsed statistic, C-13

PARSED_PIECES view, 2-174

PARSED_SIZE view, 2-175

partition

raw partition, 1-60

PARTITION_VIEW_ENABLED parameter, 1-100

password file enqueue, B-2

passwords

authenticating, 1-92, 1-107

REMOTE_LOGIN_PASSWORDFILE parameter, 1-107

PCM lock

mapping blocks to, 1-44

PDML Restrictions

for DML_LOCKS parameter, 1-38

pending global transaction(s) wait event, A-43

performance, 1-11

rule-based optimizer, 1-88

shared pool, 1-49, 1-115, 1-116

sort performance, 1-119

physical reads statistic, C-13

physical writes statistic, C-13

pinned buffers inspected statistic, C-14

pipe get wait event, A-44

pipe put wait event, A-44

PLAN_TABLE execution plan table, 2-175

PL/SQL lock timer wait event, A-16

PLSQL_V2_COMPATIBILITY parameter, 1-101

PLUGGABLE_SET_CHECK view, 2-176

pmon rdomain attach wait event, A-44

pmon timer wait event, A-44

PRE_PAGE_SGA parameter, 1-102

precision

NUMBER and FLOAT, 2-249

preface

Send Us Your Comments, xli

private rollback segments

specifying, 1-110

privileges

remote login, 1-107

RESTRICTED_SESSION privilege, 1-54, 1-55

table-level select privileges, 1-120, 1-121

procedures

shared pool, 1-49, 1-115, 1-116

process startup enqueue, B-2

process startup wait event, A-45

processes

derived parameter values, 1-125

dispatcher process maximum number, 1-75

maximum shared server processes, 1-75

number of server processes, 1-76, 1-103

recovery, 1-104, 1-106

trace files, 1-126

user processes, 1-103

PROCESSES parameter, 1-103

PRODUCT_COMPONENT_VERSION view, 2-177

profiles

resource limits, 1-108, 1-109

PROXY_USERS view, 2-177

PSTUBTBL view, 2-178

PUBLIC option

thread of redo, 1-123

public rollback segments, 1-110

using by default, 1-110

PUBLIC_DEPENDENCY view, 2-178

PUBLICSYN view, 2-178

PUSH_JOIN_PREDICATE parameter, 1-103

PX local messages recv'd statistic, C-4

PX local messages sent statistic, C-5

PX remote messages recv'd statistic, C-5

PX remote messages sent statistic, C-5

queries

dictionary views, 1-45

hints, 1-88

queries parallelized statistic, C-14

queue messages wait event, A-45

QUEUE_PRIVILEGES view, 2-179

R070304.SQL script, 5-7

raw partition

LOG_ARCHIVE_DEST parameter, 1-60

rdbms ipc message block wait event, A-46

rdbms ipc message wait event, A-45

rdbms ipc reply wait event, A-46

RDBMS_SERVER_DN, 1-104

read consistency

rollback information, 1-46

READ_ONLY_OPEN_DELAYED parameter, 1-105

recovery

number of required processes, 1-104, 1-106

recovery array read time statistic, C-14

recovery array reads statistic, C-14

recovery blocks read statistic, C-14

RECOVERY_PARALLELISM parameter, 1-106

recursive calls statistic, C-14

recursive cpu usage statistic, C-14

redo entries statistic, C-14

redo log "kick" enqueue, B-2

redo log buffers

size, 1-67

redo log space requests statistic, C-15

redo log space wait time statistic, C-15

redo log switch interrupts statistic, C-15

redo ordering marks statistic, C-15

redo size statistic, C-15

redo sync writes statistic, C-15

redo synch time statistic, C-15

redo thread, 1-122

redo thread enqueue, B-2

redo wait event, A-46

redo wastage statistic, C-16

redo write time statistic, C-16

redo writer latching time statistic, C-16

redo writes statistic, C-16

REDUCE_ALARM parameter, 1-106

remote clients

authenticating, 1-107

remote instance undo block writes statistic, C-16

remote instance undo header writes statistic, C-16

remote logins, 1-107

REMOTE_DEPENDENCIES_MODE parameter, 1-106

REMOTE_LOGIN_PASSWORDFILE parameter, 1-107

REMOTE_OS_AUTHENT parameter, 1-107

REMOTE_OS_ROLES parameter, 1-108

REPLICATION_DEPENDENCY_TRACKING parameter, 1-108

resource limits for profiles, 1-108, 1-109

RESOURCE_COST view, 2-180

RESOURCE_LIMIT parameter, 1-108, 1-109

RESOURCE_MANAGER_PLAN parameter, 1-109

RESOURCE_MAP view, 2-180

REWRITE_INTEGRITY parameter, 1-104

ROLE_ROLE_PRIVS view, 2-181

ROLE_SYS_PRIVS view, 2-181

ROLE_TAB_PRIVS view, 2-181

roles, 1-92

remote clients, 1-108

rollback changes - undo records applied statistic, C-16

rollback segments

acquiring, 1-110, 1-125

distributed locks, 1-46

global constant parameters, 1-46

initialization parameters, 1-46

maximum size, 1-72

number of concurrent transactions, 1-125

private rollback segments, 1-110

public rollback segments, 1-110

specifying, 1-110

SYSTEM, 1-110

ROLLBACK_SEGMENTS parameter, 1-110

unique values, 1-110

rollbacks only - consistent read gets statistic, C-16

row cache enqueue, B-2

row cache lock wait event, A-46

ROW_CACHE_CURSORS parameter, 1-110

ROW_LOCKING parameter, 1-111

RULE, 1-88, 1-89

rule-based optimizer, 1-88

scginq AST call wait event, A-47

scripts

data dictionary, 5-3

migration, 5-6, 5-7

SQL scripts, 5-2

Send Us Your Comments

boilerplate, xli

SEQ synonym for USER_SEQUENCES, 2-182

sequence number enqueue, B-2

sequence number value enqueue, B-2

SEQUENCE_CACHE_ENTRIES parameter, 1-111

SEQUENCE_CACHE_HASH_BUCKET parameter, 1-111

SERIAL_REUSE parameter, 1-111

serializable aborts statistic, C-17

server processes

number, 1-76, 1-103

SERVICE_NAMES parameter, 1-112

session connect time statistic, C-17

session cursor cache count statistic, C-17

session cursor cache hits statistic, C-17

session logical reads statistic, C-17

session pga memory max statistic, C-17

session pga memory statistic, C-17

session stored procedure space statistic, C-17

session uga memory max statistic, C-18

session uga memory statistic, C-18

SESSION_CACHED_CURSORS parameter, 1-113

SESSION_CONTEXT view, 2-182

SESSION_MAX_OPEN_FILES parameter, 1-113

SESSION_PRIVS view, 2-182

SESSION_ROLES view, 2-182

SESSIONS parameter, 1-114

SGA, 1-11

SHADOW_CORE_DUMP parameter, 1-114

shared server processes

maximum number, 1-75

SHARED_MEMORY_ADDRESS parameter, 1-115

SHARED_POOL_RESERVED_MIN_ALLOC parameter, 1-115

SHARED_POOL_RESERVED_SIZE parameter, 1-115

V$SHARED_POOL_RESERVED, 3-105

SHARED_POOL_SIZE parameter, 1-116

SHOW command

PARAMETERS option, 1-9

single-task message wait event, A-47

SMON enqueue, B-2

smon timer wait event, A-47

SNP background processes, 1-53

sort segment enqueue, B-2

SORT_AREA_RETAINED_SIZE parameter, 1-117

SORT_AREA_SIZE parameter, 1-118

SORT_DIRECT_WRITES parameter, 1-118

SORT_MULTIBLOCK_READ_COUNT parameter, 1-119

SORT_READ_FAC parameter, 1-119

SORT_SPACEMAP_SIZE parameter, 1-119

SORT_WRITE_BUFFER_SIZE parameter, 1-120

SORT_WRITE_BUFFERS parameter, 1-120

sorting

maximum memory, 1-117

ORDER BY queries, 1-81

sorts (disk) statistic, C-18

sorts (memory) statistic, C-18

sorts (rows) statistic, C-18

SOURCE_SIZE view, 2-182

space management transaction enqueue, B-2

SPIN_COUNT parameter, 1-120

SQL scripts

creating the data dictionary, 5-2

optional, 5-3

required, 5-2

SQL*Net break/reset to client wait event, A-16

SQL*Net break/reset to dblink wait event, A-17

SQL*Net message from client wait event, A-17

SQL*Net message from dblink wait event, A-17

SQL*Net message to client wait event, A-18

SQL*Net message to dblink wait event, A-18

SQL*Net more data from client wait event, A-18

SQL*Net more data from dblink wait event, A-19

SQL*Net more data to client wait event, A-19

SQL*Net more data to dblink wait event, A-19

SQL*Net roundtrips to/from client statistic, C-5

SQL*Net roundtrips to/from dblink statistic, C-5

SQL_TRACE parameter, 1-120

SQL92_SECURITY parameter, 1-120

STANDBY_ARCHIVE_DEST parameter, 1-121

STAR_TRANSFORMATION_ENABLED parameter, 1-121

START option

automatic archiving, 1-60

starting up

database name, 1-33

instance number, 1-52

startup order, 1-52

STARTUP command

database name, 1-33

statistics

dbwr checkpoints, 1-68

timed, 1-124

STMT_AUDIT_OPTION_MAP table

auditing option type codes, 2-183

summed dirty queue length statistic, C-18

Switch current to new buffer statistic, C-5

switch redo log file, 1-67

SYN synonym for USER_SYNONYMS, 2-183

synchronized replication enqueue, B-2

SYNONYMS view, 2-183

SYS_OBJECTS view, 2-184

SYSCATALOG view, 2-183

SYSFILES view, 2-183

SYSSEGOBJ view, 2-183

system commit number enqueue, B-2

System Global Area (SGA)

buffer areas, 1-25, 1-67

buffer cache, 1-25

maximum concurrent transactions, 1-125

rollback segment size, 1-72

size of, 1-25

system performance, 1-11

SYSTEM rollback segment, 1-110

SYSTEM_PRIVILEGE_MAP view, 2-183

TAB view, 2-184

table fetch by rowid statistic, C-18

table fetch continued row statistic, C-19

table scan blocks gotten statistic, C-19

table scan rows gotten statistic, C-19

table scans (cache partitions) statistic, C-19

table scans (direct read) statistic, C-19

table scans (long tables) statistic, C-20

table scans (rowid ranges) statistic, C-20

TABLE_PRIVILEGE_MAP table

access privilege codes, 2-185

TABLE_PRIVILEGES view, 2-184

tables

data dictionary, 2-1

DML locks, 1-37

free lists, 1-28

locating free space, 1-52

row locking, 1-111

TABQUOTAS view, 2-185

TABS synonym for USER_TABLES, 2-185

tape archiving destination, 1-60

TAPE_ASYNCH_IO parameter

initialization parameters

TAPE_ASYNCH_IO, 1-122

temporary segment enqueue, B-2

temporary table enqueue, B-2

TEMPORARY_TABLE_LOCKS parameter, 1-122

territory, 1-79, 1-82

TEXT_ENABLE parameter, 1-122

THREAD parameter, 1-122

TIMED_OS_STATISTICS parameter, 1-123

TIMED_STATISTICS parameter, 1-124

file read/write statistics, 3-46, 3-125

timer in sksawat wait event, A-48

TO_CHAR function, 1-78

TO_DATE function, 1-78

total file opens statistic, C-20

trace files

destination, 1-17, 1-126

location of, 1-17

maximum size, 1-71

transaction enqueue, B-2

transaction recovery enqueue, B-2

transaction rollbacks statistic, C-20

transaction tables consistent read rollbacks statistic, C-20

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

transaction wait event, A-48

TRANSACTION_AUDITING parameter, 1-124

transactions

concurrent, 1-125

data locking, 1-37

rollback segments, 1-125

TRANSACTIONS parameter, 1-110, 1-125

DML locks, 1-37

TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter, 1-110, 1-125

Trusted ORACLE

ALL_LABELS view, 2-23

data dictionary, 2-1

TRUSTED_SERVERS view, 2-185

TS_PITR_CHECK view, 2-186

TS_PITR_OBJECTS TO_BE_DROPPED view, 2-187

U703040.SQL script, 5-7

unbound tx wait event, A-48

undo segment extension wait event, A-48

undo segment recovery wait event, A-49

undo segment tx slot wait event, A-49

undo segment, serialization enqueue, B-2

UNI_PLUGGABLE_SET_CHECK view, 2-187

Unnecessary process cleanup for SCN batching statistic, C-5

updates

locating free space, 1-52

transaction processing option, 1-111

uppercase characters, 1-3

USE_INDIRECT_DATA_BUFFERS parameter, 1-126

USE_ISM parameter, 1-126

user calls statistic, C-20

user commits statistic, C-21

user name enqueue, B-2

user processes

trace files, 1-126

user rollbacks statistic, C-21

USER_ALL_TABLES view, 2-188

USER_ARGUMENTS view, 2-190

USER_ASSOCIATIONS view, 2-191

USER_AUDIT_OBJECT view, 2-191

USER_AUDIT_SESSION view, 2-192

USER_AUDIT_STATEMENT view, 2-193

USER_AUDIT_TRAIL view, 2-194

USER_CATALOG view, 2-196

CAT synonym, 2-68

USER_CLU_COLUMNS view, 2-198

USER_CLUSTER_HASH_EXPRESSIONS view, 2-197

USER_CLUSTERS view, 2-196

CLU synonym, 2-68

USER_COL_COMMENTS view, 2-198

USER_COL_PRIVS view, 2-198

USER_COL_PRIVS_MADE view, 2-199

USER_COL_PRIVS_RECD view, 2-199

USER_COLL_TYPES view, 2-199

USER_CONS_COLUMNS view, 2-201

USER_CONSTRAINTS view, 2-200

USER_DB_LINKS view, 2-202

USER_DEPENDENCIES view, 2-202

USER_DIM_ATTRIBUTES view, 2-203

USER_DIM_CHILD_OF view, 2-203

USER_DIM_HIERARCHIES view, 2-204

USER_DIM_JOIN_KEY view, 2-204

USER_DIM_LEVEL_KEY view, 2-205

USER_DIM_LEVELS view, 2-204

USER_DIMENSIONS view, 2-202

USER_DUMP_DEST parameter, 1-126

USER_ERRORS view, 2-205

USER_EXTENTS view, 2-205

USER_FREE_SPACE view, 2-206

USER_IND_COLUMNS view, 2-209

USER_IND_PARTITIONS view, 2-210

USER_IND_SUBPARTITIONS view, 2-211

USER_INDEXES view, 2-206

IND synonym, 2-172

USER_INDEXTYPE_OPERATORS view, 2-213

USER_INDEXTYPES view, 2-212

USER_JOBS view, 2-213

USER_LIBRARIES view, 2-214

USER_LOB_PARTITIONS view, 2-215

USER_LOB_SUBPARTITIONS view, 2-216

USER_LOBS view, 2-214

USER_METHOD_PARAMS view, 2-217

USER_METHOD_RESULTS view, 2-217

USER_MVIEW_AGGREGATES view, 2-218

USER_MVIEW_ANALYSIS view, 2-218

USER_MVIEW_DETAIL_RELATIONS view, 2-219

USER_MVIEW_JOINS view, 2-220

USER_MVIEW_KEYS view, 2-220

USER_NESTED_TABLES view, 2-221

USER_OBJ_AUDIT_OPTS view, 2-224

USER_OBJECT_SIZE view, 2-224

USER_OBJECT_TABLES view, 2-221

USER_OBJECTS view, 2-223

OBJ synonym, 2-174

USER_OPANCILLARY view, 2-225

USER_OPARGUMENTS view, 2-225

USER_OPBINDINGS view, 2-225

USER_OPERATORS view, 2-226

USER_OUTLINE_HINTS view, 2-226

USER_OUTLINES view, 2-227

USER_PART_COL_STATISTICS view, 2-227

USER_PART_HISTOGRAMS view, 2-228

USER_PART_INDEXES view, 2-228

USER_PART_KEY_COLUMNS view, 2-228

USER_PART_LOBS view, 2-230

USER_PART_TABLES view, 2-231

USER_PARTIAL_DROP_TABS view, 2-232

USER_PASSWORD_LIMITS view, 2-232

USER_POLICIES view, 2-232

USER_QUEUE_SCHEDULES view, 2-233

USER_QUEUE_TABLES view, 2-234

USER_QUEUES view, 2-235

USER_REFRESH view, 2-236

USER_REFRESH_CHILDREN view, 2-236

USER_REFS view, 2-237

USER_REGISTERED_SNAPSHOTS view, 2-238

USER_REPCATLOG view, 2-238

USER_REPCOLUMN view, 2-238

USER_REPCOLUMN_GROUP view, 2-239

USER_REPCONFLICT view, 2-239

USER_REPDDL view, 2-239

USER_REPGENERATED view, 2-239

USER_REPGENOBJECTS view, 2-239

USER_REPGROUP view, 2-239

USER_REPGROUPED_COLUMNS view, 2-239

USER_REPKEY_COLUMNS view, 2-239

USER_REPOBJECT view, 2-240

USER_REPPARAMETER_COLUMN view, 2-240

USER_REPPRIORITY view, 2-240

USER_REPPRIORITY_GROUP view, 2-240

USER_REPPROP view, 2-240

USER_REPRESOL_STATS_CONTROL view, 2-240

USER_REPRESOLUTION view, 2-240

USER_REPRESOLUTION_METHOD view, 2-240

USER_REPRESOLUTION_STATISTICS view, 2-241

USER_REPSITES view, 2-241

USER_RESOURCE_LIMITS view, 2-241

USER_ROLE_PRIVS view, 2-241

USER_RSRC_CONSUMER_GROUP_PRIVS view, 2-241

USER_RSRC_MANAGER_SYSTEM_PRIVS view, 2-242

USER_RULESETS view, 2-242

USER_SEGMENTS view, 2-242

USER_SEQUENCES view, 2-243

SEQ synonym, 2-182

USER_SNAPSHOT_LOGS view, 2-245

USER_SNAPSHOT_REFRESH_TIMES view, 2-245

USER_SNAPSHOTS view, 2-243

USER_SOURCE view, 2-245

USER_SUBPART_COL_STATISTICS view, 2-246

USER_SUBPART_HISTOGRAMS view, 2-246

USER_SUBPART_KEY_COLUMNS view, 2-247

USER_SYNONYMS view, 2-247

SYN synonym, 2-183

USER_SYS_PRIVS view, 2-248

USER_TAB_COL_STATISTICS view, 2-248

USER_TAB_COLUMNS

COLS synonym, 2-69

USER_TAB_COLUMNS view, 2-249

USER_TAB_COMMENTS view, 2-250

USER_TAB_HISTOGRAMS view, 2-250

USER_TAB_PARTITIONS view, 2-250

USER_TAB_PRIVS view, 2-252

USER_TAB_PRIVS_MADE view, 2-252

USER_TAB_PRIVS_RECD view, 2-253

USER_TAB_SUBPARTITIONS view, 2-253

USER_TABLES view, 2-254

USER_TABLESPACES view, 2-256

USER_TRIGGER_COLS view, 2-257

USER_TRIGGERS view, 2-257

USER_TS_QUOTAS view, 2-258

USER_TYPE_ATTRS view, 2-259

USER_TYPE_METHODS view, 2-259

USER_TYPES view, 2-258

USER_UPDATABLE_COLUMNS view, 2-260

USER_USERS view, 2-260

USER_USTATS view, 2-261

USER_VARRAYS view, 2-261

USER_VIEWS view, 2-262

user-defined locks enqueue, B-2

USERLOCK.SQL script, 5-4

users

authenticating, 1-92

multiple, 1-38

UTL_FILE_DIR parameter, 1-127

UTLBSTAT.SQL script, 5-4

UTLCHAIN1.SQL script, 5-4

UTLCONST.SQL script, 5-4

UTLDTREE.SQL script, 2-161, 2-171, 5-4

UTLESTAT.SQL script, 5-4

UTLEXCPT1.SQL script, 5-4

UTLHTTP.SQL script, 5-4

UTLIP.SQL script, 5-4

UTLIRP.SQL script, 5-5

UTLLOCKT.SQL script, 5-5

UTLPG.SQL script, 5-5

UTLPWDMG.SQL script, 5-5

UTLRP.SQL script, 5-5

UTLSAMPL.SQL script, 5-5

UTLSCLN.SQL script, 5-5

UTLTKPROF.SQL script, 5-5

UTLVALID.SQL script, 5-5

UTLXPLAN.SQL script, 5-5

V$ACCESS view, 3-3

V$ACTIVE_INSTANCES view, 3-4

V$AQ view, 3-4

V$ARCHIVE view, 3-4

V$ARCHIVE_DEST, 3-5

V$ARCHIVE_PROCESSES view, 3-7

V$ARCHIVED_LOG view, 3-6

V$BACKUP view, 3-7

V$BACKUP_ASYNC_IO view, 3-7

V$BACKUP_CORRUPTION view, 3-9

V$BACKUP_DATAFILE view, 3-9

V$BACKUP_DEVICE view, 3-10

V$BACKUP_PIECE view, 3-11

V$BACKUP_REDOLOG view, 3-12

V$BACKUP_SET view, 3-13

V$BACKUP_SYNC_IO view, 3-14

V$BGPROCESS view, 3-15

V$BH view, 3-15

V$BUFFER_POOL view, 3-17

V$CACHE view, 3-18

V$CACHE_LOCK view, 3-19

V$CIRCUIT view, 3-20

V$CLASS_PING view, 3-21

V$COMPATIBILITY view, 3-22

V$COMPATSEG view, 3-23

V$CONTEXT view, 3-23

V$CONTROLFILE view, 3-23

V$CONTROLFILE_RECORD_SECTION view, 3-24

V$COPY_CORRUPTION view, 3-24

V$DATABASE view, 3-25

V$DATAFILE view, 3-26

V$DATAFILE_COPY view, 3-27

V$DATAFILE_HEADER view, 3-29

V$DB_OBJECT_CACHE view, 3-30

V$DB_PIPES view, 3-31

V$DBFILE view, 3-30

V$DBLINK view, 3-30

V$DELETED_OBJECT view, 3-31

V$DISPATCHER view, 3-32

V$DISPATCHER_RATE view, 3-33

V$DLM_ALL_LOCKS view, 3-35

V$DLM_CONVERT_LOCAL view, 3-37

V$DLM_CONVERT_REMOTE view, 3-37

V$DLM_LATCH view, 3-38

V$DLM_LOCKS view, 3-38

V$DLM_MISC view, 3-40

V$DLM_RESS view, 3-40

V$ENABLEDPRIVS view, 3-40

V$ENQUEUE_LOCK view, 3-41

V$EVENT_NAME view, 3-41

V$EXECUTION view, 3-42

V$FALSE_PING view, 3-42

V$FAST_START_SERVERS view, 3-44

V$FAST_START_TRANSACTIONS view, 3-44

V$FILE_PING view, 3-45

V$FILESTAT view, 3-46

V$FIXED_TABLE view, 3-47

V$FIXED_VIEW_DEFINITION view, 3-47

V$GLOBAL_BLOCKED_LOCKS view, 3-48

V$GLOBAL_TRANSACTION view, 3-48

V$HS_AGENT view, 3-49

V$HS_SESSION view, 3-49

V$INDEXED_FIXED_COLUMN view, 3-50

V$INSTANCE view, 3-50

V$INSTANCE_RECOVERY view, 3-51

V$LATCH view, 3-52

V$LATCH_CHILDREN view, 3-53

V$LATCH_MISSES view, 3-54

V$LATCH_PARENT view, 3-54

V$LATCHHOLDER view, 3-53

V$LATCHNAME view, 3-53

V$LIBRARYCACHE view, 3-54

V$LICENSE view, 3-55

V$LOADCSTAT view, 3-56

V$LOADTSTAT view, 3-56

V$LOCK view, 3-56

V$LOCK_ACTIVITY view, 3-59

V$LOCK_ELEMENT view, 3-60

V$LOCKED_OBJECT view, 3-61

V$LOCKS_WITH_COLLISIONS view, 3-61

V$LOG view, 3-62

V$LOG_HISTORY view, 3-66

V$LOGFILE view, 3-63

V$LOGHIST view, 3-63

V$LOGMNR_CONTENTS view, 3-63

V$LOGMNR_DICTIONARY view, 3-65

V$LOGMNR_LOGS view, 3-65

V$LOGMNR_PARAMETERS view, 3-66

V$MLS_PARAMETERS view, 3-67

V$MTS view, 3-67

V$MYSTAT view, 3-68

V$NLS_PARAMETERS view, 3-68

V$NLS_VALID_VALUES view, 3-68

V$OBJECT_DEPENDENCY view, 3-68, 3-69

V$OFFLINE_RANGE view, 3-69

V$OPEN_CURSOR view, 3-70

V$OPTION view, 3-70

V$PARALLEL_DEGREE_LIMIT_MTH view, 3-70

V$PARAMETER view, 3-71

V$PING view, 3-71

V$PQ_SESSTAT view, 3-73

V$PQ_SLAVE view, 3-74

V$PQ_SYSSTAT view, 3-74

V$PQ_TQSTAT view, 3-75

V$PROCESS view, 3-76

V$PROXY_ARCHIVELOG view, 3-77

V$PROXY_DATAFILE view, 3-78

V$PWFILE_USERS view, 3-79

V$PX_PROCESS view, 3-80

V$PX_PROCESS_SYSSTAT view, 3-80

V$PX_SESSION view, 3-81

V$PX_SESSTAT view, 3-82

V$QUEUE view, 3-82

V$RECOVER_FILE view, 3-83

V$RECOVERY_FILE_STATUS view, 3-83

V$RECOVERY_LOG view, 3-84

V$RECOVERY_PROGRESS view, 3-84

V$RECOVERY_STATUS view, 3-85

V$REQDIST view, 3-85

V$RESERVED_WORDS view, 3-86

V$RESOURCE view, 3-86

V$RESOURCE_LIMIT view, 3-86

V$ROLLNAME view, 3-88

V$ROLLSTAT view, 3-88

V$ROWCACHE view, 3-89, 3-90, 3-91

V$RSCRC_CONSUMER_GROUP view, 3-91

V$RSCRC_CONSUMER_GROUP_CPU_MTH view, 3-92

V$RSCRC_PLAN view, 3-92

V$RSCRC_PLAN_CPU_MTH view, 3-92

V$SESS_IO view, 3-104

V$SESSION view, 3-92

V$SESSION_CONNECT_INFO view, 3-98

V$SESSION_CURSOR_CACHE view, 3-99

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

V$SESSION_LONGOPS view, 3-100

V$SESSION_OBJECT_CACHE view, 3-101

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

V$SESSTAT view, 3-103, C-1, C-2

V$SGA view, 3-104

V$SGASTAT view, 3-104

V$SHARED_POOL_RESERVED view, 3-105

V$SHARED_SERVER view, 3-106

V$SORT_SEGMENT view, 3-106

V$SORT_USAGE view, 3-107

V$SQL view, 3-108

V$SQL_BIND_DATA view, 3-110

V$SQL_BIND_METADATA view, 3-110

V$SQL_CURSOR view, 3-111

V$SQL_SHARED_MEMORY view, 3-111

V$SQLAREA view, 3-112

V$SQLTEXT view, 3-114

V$SQLTEXT_WITH_NEWLINES view, 3-114

V$STATNAME view, 3-115, C-2

V$SUBCACHE view, 3-119

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

V$SYSTEM_CURSOR_CACHE view, 3-120

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

V$SYSTEM_PARAMETER view, 3-121

V$TABLESPACE view, 3-121

V$TEMP_EXTENT_MAP view, 3-122

V$TEMP_EXTENT_POOL view, 3-123

V$TEMP_PING view, 3-123

V$TEMP_SPACE_HEADER view, 3-125

V$TEMPFILE view, 3-121

V$TEMPORARY_LOBS view, 3-122

V$TEMPSTAT view, 3-125

V$THREAD view, 3-126

V$TIMER view, 3-127

V$TRANSACTION view, 3-127

V$TRANSACTION_ENQUEUE view, 3-128

V$TYPE_SIZE view, 3-129

V$VERSION view, 3-129

V$WAITSTAT view, 3-130

variable parameters, 1-11

views

data dictionary views, 2-2

data files, 1-45

virtual circuit status wait event, A-49

wait event

parameter descriptions, A-9

WMON goes to sleep wait event, A-20

write complete wait event, A-50

writes stopped by instance recovery or database suspension wait event, A-50