Oracle8i Reference -- Index

acquiring rollback segments

ALLOCATE EXTENT clause

of ALTER TABLE

instance number, 1-47

allocation

PCM locks, 1-39

rollback segments, 1-105

ALLOW_PARTIAL_SN_RESULTS initialization parameter: obsolete

ALTER DATABASE statement

ALTER SESSION statement

SET HASH_AREA_SIZE clause, 1-43

SET HASH_JOIN_ENABLED clause, 1-43

ALTER TABLE statement

allocating extents, 1-47

ALWAYS_ANTI_JOIN initialization parameter, 1-13

ALWAYS_SEMI_JOIN initialization parameter, 1-14

ANALYZE statement, 2-27, 2-75, 2-77, 2-83, 2-111, 2-135, 2-136, 2-182, 2-184

AQ_TM_PROCESSES initialization parameter, 1-14

ARCH_IO_SLAVES initialization parameter: obsolete

ARCHIVE LOG START statement

automatic archiving, 1-55

archived redo logs

automatic versus manual, 1-60

destination file, 1-55

storage device, 1-55, 1-58

ARCHIVELOG mode, 1-55

archiving destination, 1-55, 1-58

automatic archiving, 1-60

attributes

maximum number of in object type, 4-2

AUDIT_ACTIONS table, 2-93

AUDIT_FILE_DEST initialization parameter, 1-14

AUDIT_TRAIL initialization parameter, 1-15

authenticating remote clients, 1-102

authenticating users, 1-90

B_TREE_BITMAP_PLANS initialization parameter: obsolete

background processes

SNP background process, 1-50

specifying trace files, 1-16

BACKGROUND_CORE_DUMP initialization parameter, 1-15

BACKGROUND_DUMP_DEST initialization parameter, 1-16

ALERT file, 1-16

BACKUP_DISK_IO_SLAVES initialization parameter: obsolete

BACKUP_TAPE_IO_SLAVES initialization parameter, 1-16

BITMAP_MERGE_AREA_SIZE initialization parameter, 1-17

BLANK_TRIMMING initialization parameter, 1-17

blocks

PCM lock, 1-39

redo log, 1-63

rollback segment, 1-41

size, 1-28, 4-4

when written to disk, 1-41

buffer cache

database, 1-24

BUFFER_POOL_KEEP initialization parameter, 1-18

BUFFER_POOL_RECYCLE initialization parameter, 1-18

buffers

number of, 1-24

cache

database blocks, 1-24

dictionary, 3-69, 3-86, 3-87, 3-88, 3-89, 3-90

statistics, 1-63

CACHE_SIZE_THRESHOLD initialization parameter: obsolete

CAT synonym for USER_CATALOG view, 2-93

CATALOG view, 2-93

CATALOG.SQL script, 5-2

creating V$ views, 3-1

CATAUDIT.SQL script

audit trail records created by, 2-167

audit trails for connections and disconnections, 2-167

auditing characteristics described by, 2-176

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

CATQUEUE.SQL script, 5-3

CATREP.SQL script, 5-3

CATRMAN.SQL script, 5-3

CHAINED_ROWS view, 2-93

characters

numeric group separators, 1-77

checkpoints

checkpoint interval, 1-63

statistics, 1-63

CLEANUP_ROLLBACK_ENTRIES initialization parameter: obsolete

CLOSE_CACHED_OPEN_CURSORS initialization parameter: obsolete

CLU synonym for USER_CLUSTERS, 2-94

CODE_PIECES view, 2-94

CODE_SIZE view, 2-94

COL view, 2-94

COLS synonym for USER_TAB_COLUMNS, 2-94

COLUMN_PRIVILEGES view, 2-95

columns

maximum number of, 4-2

COMMIT_POINT_STRENGTH initialization parameter, 1-19

COMPATIBLE initialization parameter, 1-20

COMPATIBLE_NO_RECOVERY initialization parameter: obsolete

COMPLEX_VIEW_MERGING initialization parameter: obsolete

concurrency

ROW_LOCKING initialization parameter, 1-106

transactions per rollback segment, 1-119

consistency

multiversion read, 1-41

rollback information, 1-41

contention

block-level, 3-121

control files

names, 1-21

specifying, 1-21

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 1-21

CONTROL_FILES initialization parameter, 1-21

CORE_DUMP_DEST initialization parameter, 1-22

cost-based optimization, 1-85, 1-86

favoring IN-list iterators, 1-84

CPU_COUNT initialization parameter, 1-22

CREATE DATABASE statement

database name, 1-32

setting the block size, 1-28

setting the log mode, 1-60

CREATE TABLE statement

FREELIST GROUPS clause, 1-47

CREATE_BITMAP_AREA_SIZE initialization parameter, 1-22

creating

a database

setting block size, 1-27

currency, 1-74

international currency symbol, 1-76

CURSOR_SHARING initialization parameter, 1-23

CURSOR_SPACE_FOR_TIME initialization parameter, 1-23

cursors

OPEN_CURSORS initialization parameter, 1-81

shared pool, 1-44, 1-45, 1-110, 1-111

data blocks

reading multiple, 1-30

size of, 1-27

data dictionary, 2-1

cache, 3-69, 3-86, 3-87, 3-88, 3-89, 3-90

datafiles, 1-39

DICTIONARY view, 2-154

rollback segments, 1-105

database writer process (DBWR)

checkpoint, 1-63

databases

block size, 4-4

database limits, 4-1

default language, 1-77

name, 1-32, 1-33

resource limits, 1-103, 1-104

valid characters for database name, 1-32

datafiles

mapping blocks to PCM locks, 1-39

maximum number, 1-31

parameter, 1-29, 1-31

unspecified for PCM locks, 1-39

dates

language used for, 1-75

setting SYSDATE, 1-39

TO_CHAR and TO_DATE functions, 1-75

DB_BLOCK_BUFFERS initialization parameter, 1-24

DB_BLOCK_CHECKING initialization parameter, 1-25

DB_BLOCK_CHECKPOINT_BATCH initialization parameter: obsolete

DB_BLOCK_CHECKSUM initialization parameter, 1-26

DB_BLOCK_LRU_EXTENDED_STATISTICS initialization parameter: obsolete

DB_BLOCK_LRU_STATISTICS initialization parameter: obsolete

DB_BLOCK_MAX_DIRTY_TARGET initialization parameter, 1-27

DB_BLOCK_SIZE initialization parameter, 1-27

DB_DOMAIN initialization parameter, 1-28

DB_FILE_DIRECT_IO_COUNT initialization parameter, 1-29

DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 1-30

DB_FILE_NAME_CONVERT initialization parameter, 1-30

DB_FILE_SIMULTANEOUS_WRITES initialization parameter: obsolete

DB_FILES initialization parameter, 1-31

DB_NAME initialization parameter, 1-32

DB_WRITER_PROCESSES initialization parameter, 1-33

DBA_2PC_NEIGHBORS view, 2-95

DBA_2PC_PENDING view, 2-95

DBA_ALL_TABLES view, 2-3, 2-96

DBA_ANALYZE_OBJECTS view, 2-96

DBA_ASSOCIATIONS view, 2-6, 2-96

DBA_AUDIT_EXISTS view, 2-96

DBA_AUDIT_OBJECT view, 2-97

DBA_AUDIT_SESSION view, 2-99

DBA_AUDIT_STATEMENT view, 2-99

DBA_AUDIT_TRAIL view, 2-101

DBA_BLOCKERS view, 2-103

DBA_CATALOG view, 2-103

DBA_CLU_COLUMNS view, 2-103

DBA_CLUSTER_HASH_EXPRESSIONS view, 2-103

DBA_CLUSTERS view, 2-103

DBA_COL_COMMENTS view, 2-104

DBA_COL_PRIVS view, 2-104

DBA_COLL_TYPES view, 2-104

DBA_CONS_COLUMNS view, 2-104

DBA_CONSTRAINTS view, 2-104

DBA_CONTEXT view, 2-104

DBA_DATA_FILES view, 1-39, 2-104, 2-145

DBA_DB_LINKS view, 2-105

DBA_DDL_LOCKS view, 2-105

DBA_DEPENDENCIES view, 2-106

DBA_DIM_ATTRIBUTES view, 2-106

DBA_DIM_CHILD_OF view, 2-106

DBA_DIM_HIERARCHIES view, 2-106

DBA_DIM_JOIN_KEY view, 2-106

DBA_DIM_LEVEL_KEY view, 2-107

DBA_DIM_LEVELS view, 2-107

DBA_DIMENSIONS view, 2-106

DBA_DIRECTORIES view, 2-107

DBA_DML_LOCKS view, 2-107

DBA_ERRORS view, 2-108

DBA_EXP_FILES view, 2-108

DBA_EXP_OBJECTS view, 2-108

DBA_EXP_VERSION view, 2-109

DBA_EXTENTS view, 2-109

DBA_FREE_SPACE view, 2-110

DBA_FREE_SPACE_COALESCED view, 2-110

DBA_IND_COLUMNS view, 2-111

DBA_IND_EXPRESSIONS view, 2-111

DBA_IND_PARTITIONS view, 2-111

DBA_IND_SUBPARTITIONS view, 2-25, 2-111

DBA_INDEXES view, 2-111

collecting statistics for, 2-111

DBA_INDEXTYPE_OPERATORS view, 2-112

DBA_INDEXTYPES view, 2-112

DBA_INTERNAL_TRIGGERS view, 2-112

DBA_JOBS view, 2-112

DBA_JOBS_RUNNING view, 2-112

DBA_KGLLOCK view, 2-113

DBA_LIBRARIES view, 2-113

DBA_LOB_PARTITIONS view, 2-113

DBA_LOB_SUBPARTITIONS view, 2-113

DBA_LOBS view, 2-113

DBA_LOCK_INTERNAL view, 2-114

DBA_LOCKS view, 2-114

DBA_METHOD_PARAMS view, 2-114

DBA_METHOD_RESULTS view, 2-115

DBA_MVIEW_AGGREGATES view, 2-115

DBA_MVIEW_ANALYSIS view, 2-115

DBA_MVIEW_DETAIL_RELATIONS view, 2-115

DBA_MVIEW_JOINS view, 2-115

DBA_MVIEW_KEYS view, 2-116

DBA_MVIEWS view, 2-43, 2-116

DBA_NESTED_TABLES view, 2-116

DBA_OBJ_AUDIT_OPTS view, 2-117

DBA_OBJECT_SIZE view, 2-116

DBA_OBJECT_TABLES view, 2-117

DBA_OBJECTS view, 2-117

DBA_OPANCILLARY view, 2-118

DBA_OPARGUMENTS view, 2-118

DBA_OPBINDINGS view, 2-118

DBA_OPERATORS view, 2-118

DBA_OUTLINE_HINTS view, 2-119

DBA_OUTLINES view, 2-119

DBA_PART_COL_STATISTICS view, 2-119

DBA_PART_HISTOGRAMS view, 2-119

DBA_PART_INDEXES view, 2-120

DBA_PART_KEY_COLUMNS view, 2-120

DBA_PART_LOBS view, 2-120

DBA_PART_TABLES view, 2-120

DBA_PARTIAL_DROP_TABS view, 2-120

DBA_PENDING_TRANSACTIONS view, 2-120

DBA_POLICIES view, 2-121

DBA_PRIV_AUDIT_OPTS view, 2-121

DBA_PROFILES view, 2-121

DBA_QUEUE_SCHEDULES view, 2-121

DBA_QUEUE_TABLES view, 2-123

DBA_QUEUES view, 2-123

DBA_RCHILD view, 2-123

DBA_REFRESH view, 2-124

DBA_REFRESH_CHILDREN view, 2-124

DBA_REFS view, 2-124

DBA_REGISTERED_SNAPSHOT_GROUPS view, 2-124

DBA_REGISTERED_SNAPSHOTS view, 2-125

DBA_REPAIR_TABLE view, 2-125

DBA_REPCAT_REFRESH_TEMPLATES view, 2-1

DBA_REPCAT_TEMPLATE_OBJECTS view, 2-1

DBA_REPCAT_TEMPLATE_PARMS view, 2-1

DBA_REPCAT_TEMPLATE_SITES view, 2-1

DBA_REPCAT_USER_AUTHORIZATIONS view, 2-1

DBA_REPCAT_USER_PARM_VALUES view, 2-1

DBA_REPCATLOG view, 2-1

DBA_REPCOLUMN view, 2-1

DBA_REPCOLUMN_GROUP view, 2-1

DBA_REPCONFLICT view, 2-1

DBA_REPDDL view, 2-1

DBA_REPGENERATED view, 2-1

DBA_REPGENOBJECTS view, 2-1

DBA_REPGROUP view, 2-1

DBA_REPGROUPED_COLUMN view, 2-1

DBA_REPKEY_COLUMNS view, 2-1

DBA_REPOBJECT view, 2-1

DBA_REPPARAMETER_COLUMN view, 2-1

DBA_REPPRIORITY view, 2-1

DBA_REPPRIORITY_GROUP view, 2-1

DBA_REPPROP view, 2-1

DBA_REPRESOL_STATS_CONTROL view, 2-1

DBA_REPRESOLUTION view, 2-1

DBA_REPRESOLUTION_METHOD view, 2-1

DBA_REPSITES view, 2-1

DBA_RGROUP view, 2-126

DBA_ROLE_PRIVS view, 2-127

DBA_ROLES view, 2-126

DBA_ROLLBACK_SEGS view, 2-127

DBA_RSRC_CONSUMER_GROUP_PRIVS view, 2-127

DBA_RSRC_CONSUMER_GROUPS view, 2-128

DBA_RSRC_MANAGER_SYSTEM_PRIVS view, 2-128

DBA_RSRC_PLAN_DIRECTIVES view, 2-130

DBA_RSRC_PLANS view, 2-129

DBA_RULESETS view, 2-131

DBA_SEGMENTS view, 2-131

DBA_SEQUENCES view, 2-132

DBA_SNAPSHOT_LOG_FILTER_COLS view, 2-132

DBA_SNAPSHOT_LOGS view, 2-132

DBA_SNAPSHOT_REFRESH_TIMES view, 2-133

DBA_SNAPSHOTS view, 2-133

DBA_SOURCE view, 2-133

DBA_STMT_AUDIT_OPTS view, 2-133

DBA_SUBPART_COL_STATISTICS view, 2-133

DBA_SUBPART_HISTOGRAMS view, 2-134

DBA_SUBPART_KEY_COLUMNS view, 2-134

DBA_SYNONYMS view, 2-134

DBA_SYS_PRIVS view, 2-134

DBA_TAB_COL_STATISTICS view, 2-135

DBA_TAB_COLUMNS view, 2-135

DBA_TAB_COMMENTS view, 2-135

DBA_TAB_HISTOGRAMS view, 2-135

DBA_TAB_PARTITIONS view, 2-135

DBA_TAB_PRIVS view, 2-136

DBA_TAB_SUBPARTITIONS view, 2-136

DBA_TABLES view, 2-136

DBA_TABLESPACES view, 2-136

DBA_TEMP_FILES view, 2-137

DBA_TRIGGER_COLS view, 2-138

DBA_TRIGGERS view, 2-137

DBA_TS_QUOTAS view, 2-138

DBA_TYPE_ATTRS view, 2-138

DBA_TYPE_METHODS view, 2-138

DBA_TYPES view, 2-138

DBA_UPDATABLE_COLUMNS view, 2-139

DBA_USERS view, 2-139

DBA_USTATS view, 2-140

DBA_VARRAYS view, 2-140

DBA_VIEWS view, 2-140

DBA_WAITERS view, 2-140

DBLINK_ENCRYPT_LOGIN initialization parameter, 1-33

DBMS_ALERT_INFO view, 2-140

DBMS_LOCK_ALLOCATED view, 2-141

DBMSIOTC.SQL script, 5-3

DBMSOTRC.SQL script, 5-3

DBMSPOOL.SQL script, 5-3

DBWR_IO_SLAVES initialization parameter, 1-34

DEFCALL view, 2-1, 2-141

DEFCALLDEST view, 2-1, 2-141

DEFDEFAULTDEST view, 2-1, 2-141

DEFERRCOUNT view, 2-1, 2-141

DEFERROR view, 2-1, 2-141

DEFLOB view, 2-1, 2-141

DEFPROPAGATOR view, 2-1, 2-141

DEFSCHEDULE view, 2-1, 2-141

DEFTRAN view, 2-1, 2-141

DEFTRANDEST view, 2-1, 2-141

DELAYED_LOGGING_BLOCK_CLEANOUTS initialization parameter: obsolete

DEPTREE view, 2-141

destination

archiving redo log files, 1-55

overriding default, 1-55

USER_DUMP_DEST, 1-120

DICT synonym for DICTIONARY, 2-141

DICT_COLUMNS view, 2-142

DICTIONARY view, 2-142

DICT synonym, 2-141

DISCRETE_TRANSACTIONS_ENABLED initialization parameter: obsolete

disk drives

archiving destination, 1-55

writing blocks, 1-41

DISK_ASYNCH_IO initialization parameter, 1-34

dispatcher processes

maximum number, 1-71

distinguished name, 1-100

distributed lock

exclusive, 1-41

rollback segment, 1-41

distributed queries

disabling, 1-82

enabling, 1-82

links for, 1-82

distributed transactions

limiting number of, 1-35

DISTRIBUTED_LOCK_TIMEOUT initialization parameter: obsolete

DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME initialization parameter: obsolete

DISTRIBUTED_TRANSACTIONS initialization parameter, 1-35

DML_LOCKS initialization parameter, 1-35

DROPCAT5.SQL script, 5-6

DROPCAT6.SQL script, 5-6

dump files, 1-66

dynamic performance tables

CATALOG.SQL script, 3-1

public synonyms (V$), 3-2

views (V_$), 3-2

embedded parameter files, 1-45

ENQUEUE_RESOURCES initialization parameter, 1-36

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

distributed recovery, B-1

distributed TX, B-1

DML, B-1

ENQUEUE_RESOURCES initialization parameter, 1-36

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

SMON, 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

ENT_DOMAIN_NAME initialization parameter: obsolete

enterprise roles, 1-100

ERROR_SIZE view, 2-142

errors

archiving, 1-60

EVENT initialization parameter, 1-37

EXCEPTIONS view, 2-142

exclusive distributed lock

rollback data, 1-41

exclusive mode

specifying instance number, 1-47

extent

allocating to instance, 1-47

FAST_FULL_SCAN_ENABLED initialization parameter: obsolete

FAST_START_IO_TARGET initialization parameter, 1-37

FAST_START_PARALLEL_ROLLBACK initialization parameter, 1-38

FILE_LOCK view, 2-143

FILE_PING view, 2-143

filenames

case significance, 1-3

name and number, 1-39

FILEXT$ view, 2-145

FIRST_ROWS, 1-86

FIXED_DATE initialization parameter, 1-39

free space list

locating space, 1-47

FREELIST GROUPS clause, 1-47

FREELISTS clause

maximum value, 1-28

FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY initialization parameter: obsolete

GC_DEFER_TIME initialization parameter, 1-39

GC_FILES_TO_LOCKS initialization parameter, 1-39

GC_LATCHES initialization parameter: obsolete

GC_LCK_PROCS initialization parameter: obsolete

GC_RELEASABLE_LOCKS initialization parameter, 1-41

GC_ROLLBACK_LOCKS initialization parameter, 1-41

global cache control parameters, 1-10

global constant parameter

rollback segments, 1-41

GLOBAL_NAME view, 2-145

GLOBAL_NAMES initialization parameter, 1-42

GV$ views

for parallel servers, 3-2

HASH_AREA_SIZE initialization parameter, 1-43

HASH_JOIN_ENABLED initialization parameter, 1-43

HASH_MULTIBLOCK_IO_COUNT initialization parameter, 1-44

Heterogeneous Services

agents, 1-45

parameters, 1-11

HI_SHARED_MEMORY_ADDRESS initialization parameter, 1-44

hints

FIRST_ROWS, 1-86

RULE, 1-85, 1-86

HS_ALL_CAPS view, 2-145

HS_ALL_DD view, 2-146

HS_ALL_INITS view, 2-146

HS_AUTOREGISTER initialization parameter, 1-45

HS_BASE_CAPS view, 2-147

HS_BASE_DD view, 2-147

HS_CLASS_CAPS view, 2-147

HS_CLASS_DD view, 2-148

HS_CLASS_INIT view, 2-148

HS_EXTERNAL_OBJECT_PRIVILEGES view, 2-148

HS_EXTERNAL_OBJECTS view, 2-149

HS_EXTERNAL_USER_PRIVILEGES view, 2-149

HS_FDS_CLASS view, 2-149

HS_FDS_INST view, 2-150

HS_INST_CAPS view, 2-150

HS_INST_DD view, 2-151

HS_INST_INIT view, 2-151

IDEPTREE view, 2-152

IFILE initialization parameter, 1-4, 1-45

IND synonym for USER_INDEXES, 2-152

INDEX_HISTOGRAM view, 2-152

INDEX_STATS view, 2-152

indexes

FREELISTS clause, 1-28

initialization parameter file, 1-1

common file, 1-45

embedded, 1-45

INITDW.ORA, 1-1

line continuation character (), 1-3

initialization parameters

ACTIVE_INSTANCE_COUNT, 1-12

altering, 1-5

ALWAYS_ANTI_JOIN, 1-13

ALWAYS_SEMI_JOIN, 1-14

AQ_TM_PROCESSES, 1-14

AUDIT_FILE_DEST, 1-14

AUDIT_TRAIL, 1-15

BACKGROUND_CORE_DUMP, 1-15

BACKGROUND_DUMP_DEST, 1-16

BACKUP_TAPE_IO_SLAVES, 1-16

BITMAP_MERGE_AREA_SIZE, 1-17

BLANK_TRIMMING, 1-17

BUFFER_POOL_KEEP, 1-18

BUFFER_POOL_RECYCLE, 1-18

case significance in filenames, 1-3

COMMIT_POINT_STRENGTH, 1-19

COMPATIBLE, 1-20

CONTROL_FILE_RECORD_KEEP_TIME, 1-21

CONTROL_FILES, 1-21

CORE_DUMP_DEST, 1-22

CPU_COUNT, 1-22

CREATE_BITMAP_AREA_SIZE, 1-22

CURSOR_SHARING, 1-23

CURSOR_SPACE_FOR_TIME, 1-23

database creation, 1-32

DB_BLOCK_BUFFERS, 1-24

DB_BLOCK_CHECKING, 1-25

DB_BLOCK_CHECKSUM, 1-26

DB_BLOCK_MAX_DIRTY_TARGET, 1-27

DB_BLOCK_SIZE, 1-27

DB_DOMAIN, 1-28

DB_FILE_DIRECT_IO_COUNT, 1-29

DB_FILE_MULTIBLOCK_READ_COUNT, 1-30

DB_FILE_NAME_CONVERT, 1-30

DB_FILES, 1-31

DB_NAME, 1-32

DB_WRITER_PROCESSES, 1-33

DBLINK_ENCRYPT_LOGIN, 1-33

DBWR_IO_SLAVES, 1-34

derived, 1-10

DISK_ASYNCH_IO, 1-34

display current settings, 1-9

DISTRIBUTED_TRANSACTIONS, 1-35

DML_LOCKS, 1-35

dynamic, 1-6

ENQUEUE_RESOURCES, 1-36

EVENT, 1-37

FAST_START_IO_TARGET, 1-37

FAST_START_PARALLEL_ROLLBACK, 1-38

files, 1-1

FIXED_DATE, 1-39

GC parameters, 1-10

GC_DEFER_TIME, 1-39

GC_FILES_TO_LOCKS, 1-39

GC_RELEASABLE_LOCKS, 1-41

GC_ROLLBACK_LOCKS, 1-41

global cache, 1-10

global constant parameters, 1-10

GLOBAL_NAMES, 1-42

HASH_AREA_SIZE, 1-43

HASH_JOIN_ENABLED, 1-43

HASH_MULTIBLOCK_IO_COUNT, 1-44

HI_SHARED_MEMORY_ADDRESS, 1-44

HS_AUTOREGISTER, 1-45

IFILE, 1-4, 1-45

INSTANCE_GROUPS, 1-46

INSTANCE_NAME, 1-46

JAVA_POOL_SIZE, 1-48

JOB_QUEUE_INTERVAL, 1-49

JOB_QUEUE_PROCESSES, 1-49

LARGE_POOL_SIZE, 1-50

LICENSE_MAX_SESSIONS, 1-51

LICENSE_MAX_USERS, 1-51

LICENSE_SESSIONS_WARNING, 1-52

LM_LOCKS, 1-52

LM_RESS, 1-53

LOCAL_LISTENER, 1-54

LOCK_NAME_SPACE, 1-54

LOCK_SGA, 1-54

LOG_ARCHIVE_DEST, 1-55

LOG_ARCHIVE_DEST_n, 1-56

LOG_ARCHIVE_DEST_STATE_n, 1-57

LOG_ARCHIVE_DUPLEX_DEST, 1-57

LOG_ARCHIVE_FORMAT, 1-58

LOG_ARCHIVE_MAX_PROCESSES, 1-59

LOG_ARCHIVE_MIN_SUCCEED_DEST, 1-59

LOG_ARCHIVE_START, 1-60

LOG_ARCHIVE_TRACE, 1-61

LOG_BUFFER, 1-62

LOG_CHECKPOINT_INTERVAL, 1-63

LOG_CHECKPOINT_TIMEOUT, 1-63

LOG_CHECKPOINTS_TO_ALERT, 1-64

LOG_FILE_NAME_CONVERT, 1-64

MAX_COMMIT_PROPAGATION_DELAY, 1-65

MAX_DUMP_FILE_SIZE, 1-66

MAX_ENABLED_ROLES, 1-66

MAX_ROLLBACK_SEGMENTS, 1-67

MTS_CIRCUITS, 1-67

MTS_DISPATCHERS, 1-68

MTS_MAX_DISPATCHERS, 1-71

MTS_MAX_SERVERS, 1-72

NLS_DATE_FORMAT, 1-75

NLS_DATE_LANGUAGE, 1-75

NLS_ISO_CURRENCY, 1-76

NLS_LANGUAGE, 1-77

NLS_NUMERIC_CHARACTERS, 1-77

NLS_SORT, 1-78

NLS_TERRITORY, 1-79

NLS_UNION_CURRENCY, 1-76

O7_DICTIONARY_ACCESSIBILITY, 1-79

OBJECT_CACHE_MAX_SIZE_PERCENT, 1-80

OBJECT_CACHE_OPTIMAL_SIZE, 1-81

OPEN_CURSORS, 1-81

OPEN_LINKS, 1-82

OPEN_LINKS_PER_INSTANCE, 1-82

operating system dependent values, 1-10

OPTIMIZER_INDEX_CACHING, 1-84

OPTIMIZER_INDEX_COST_ADJ, 1-85

OPTIMIZER_MAX_PERMUTATIONS, 1-85

OPTIMIZER_MODE, 1-85

OPTIMIZER_PERCENT_PARALLEL, 1-86

ORACLE_TRACE_COLLECTION_NAME, 1-87

ORACLE_TRACE_COLLECTION_PATH, 1-87

ORACLE_TRACE_COLLECTION_SIZE, 1-88

ORACLE_TRACE_ENABLE, 1-88

ORACLE_TRACE_FACILITY_NAME, 1-89

ORACLE_TRACE_FACILITY_PATH, 1-89

OS_AUTHENT_PREFIX, 1-90

OS_ROLES, 1-90

overview, 1-1

PARALLEL_ADAPTIVE_MULTI_USER, 1-91

PARALLEL_AUTOMATIC_TUNING, 1-92

PARALLEL_BROADCAST_ENABLED, 1-92

PARALLEL_EXECUTION_MESSAGE_SIZE, 1-93

PARALLEL_INSTANCE_GROUP, 1-93

PARALLEL_MAX_SERVERS, 1-94

PARALLEL_MIN_PERCENT, 1-94

PARALLEL_MIN_SERVERS, 1-95

PARALLEL_SERVER, 1-96

PARALLEL_SERVER_INSTANCES, 1-96

PARALLEL_THREADS_PER_CPU, 1-96

PARTITION_VIEW_ENABLED, 1-97

performance tuning, 1-10

PLSQL_V2_COMPATIBILITY, 1-97

PRE_PAGE_SGA, 1-98

PROCESSES, 1-98

QUERY_REWRITE_ENABLED, 1-99

READ_ONLY_OPEN_DELAYED, 1-100

RECOVERY_PARALLELISM, 1-101

REMOTE_DEPENDENCIES_MODE, 1-101

REMOTE_LOGIN_PASSWORDFILE, 1-102

REMOTE_OS_AUTHENT, 1-102

REMOTE_OS_ROLES, 1-103

REPLICATION_DEPENDENCY_TRACKING, 1-103

RESOURCE_LIMIT, 1-103, 1-104

RESOURCE_MANAGER_PLAN, 1-104

REWRITE_INTEGRITY, 1-99

rollback segments, 1-119

ROLLBACK_SEGMENTS, 1-105

ROW_LOCKING, 1-106

SERIAL_REUSE, 1-106

SERVICE_NAMES, 1-107

SESSION_CACHED_CURSORS, 1-108

SESSION_MAX_OPEN_FILES, 1-108

SESSIONS, 1-109

SHADOW_CORE_DUMP, 1-109

SHARED_MEMORY_ADDRESS, 1-110

SHARED_POOL_RESERVED_SIZE, 1-110, 3-100

SHARED_POOL_SIZE, 1-111

SORT_AREA_RETAINED_SIZE, 1-111

SORT_AREA_SIZE, 1-112

SORT_MULTIBLOCK_READ_COUNT, 1-113

specifying in parameter files, 1-2

SQL_TRACE, 1-114

SQL92_SECURITY, 1-114

STANDBY_ARCHIVE_DEST, 1-115

STAR_TRANSFORMATION_ENABLED, 1-115

THREAD, 1-116

TIMED_OS_STATISTICS, 1-117

TIMED_STATISTICS, 1-118

TRANSACTION_AUDITING, 1-118

TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1-119

USE_INDIRECT_DATA_BUFFERS, 1-120

USER_DUMP_DEST, 1-120

UTL_FILE_DIR, 1-121

variable, 1-10

INITJVM.SQL script, 5-7

INIT.ORA file. See initialization parameter file

IN-list iterators

optimizer use of, 1-84

inserts

locating free space, 1-47

INST_ID column, 3-2

INSTANCE clause

of ALTER TABLE

allocating extents, 1-47

INSTANCE_GROUPS initialization parameter, 1-46

INSTANCE_NAME initialization parameter, 1-46

INSTANCE_NUMBER initialization parameter

exclusive or parallel mode, 1-47

instances

checkpoint, 1-63

startup order, 1-47

I/O

reading multiple blocks, 1-30

redo log files, 1-62

reducing with buffer cache, 1-24

Java initialization parameters

JAVA_MAX_SESSIONSPACE_SIZE, 1-48

JAVA_SOFT_SESSIONSPACE_LIMIT, 1-48

Java scripts, 5-7

JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, 1-48

JAVA_POOL_SIZE initialization parameter, 1-48

JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, 1-48

JOB_QUEUE_INTERVAL initialization parameter, 1-49

JOB_QUEUE_KEEP_CONNECTIONS initialization parameter: obsolete

JOB_QUEUE_PROCESSES parameter, 1-49

language

database default language, 1-77

LARGE_POOL_MIN_ALLOC initialization parameter: obsolete

LARGE_POOL_SIZE initialization parameter, 1-50

LGWR_IO_SLAVES initialization parameter: obsolete

LICENSE_MAX_SESSIONS initialization parameter, 1-51

LICENSE_MAX_USERS initialization parameter, 1-51

LICENSE_SESSIONS_WARNING initialization parameter, 1-52

licenses

maximum sessions, 1-51

maximum users, 1-51

warning for concurrent user sessions, 1-52

limits on the database, 4-1

linguistic sorts, 1-78

LM_LOCKS parameter, 1-52

LM_PROCS initialization parameter

obsolete

LM_RESS initialization parameter, 1-53

local currency, 1-74

LOCAL_LISTENER initialization parameter, 1-54

lock

conversion, 3-19

LOCK_NAME_SPACE initialization parameter, 1-54

LOCK_SGA parameter, 1-54

LOCK_SGA_AREAS initialization parameter: obsolete

locks

conversion, 3-14, 3-18, 3-44, 3-70

elements

fixed, 1-41

non-fixed, 1-41

names, A-11

on KGL objects, 2-113

table lock, 1-106

LOG_ARCHIVE_BUFFER_SIZE initialization parameter: obsolete

LOG_ARCHIVE_BUFFERS initialization parameter: obsolete

LOG_ARCHIVE_DEST initialization parameter, 1-55

LOG_ARCHIVE_DEST_n initialization parameter, 1-56

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1-57

LOG_ARCHIVE_DUPLEX_DEST initialization parameter, 1-57

LOG_ARCHIVE_FORMAT initialization parameter, 1-58

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 1-59

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 1-59

LOG_ARCHIVE_START initialization parameter, 1-60

LOG_ARCHIVE_TRACE initialization parameter, 1-61

LOG_BLOCK_CHECKSUM initialization parameter: obsolete

LOG_BUFFER initialization parameter, 1-62

LOG_CHECKPOINT_INTERVAL initialization parameter, 1-63

LOG_CHECKPOINT_TIMEOUT initialization parameter, 1-63

LOG_CHECKPOINTS_TO_ALERT initialization parameter, 1-64

LOG_FILE_NAME_CONVERT initialization parameter, 1-64

LOG_FILES initialization parameter: obsolete

LOG_SIMULTANEOUS_COPIES initialization parameter: obsolete

LOG_SMALL_ENTRY_MAX_SIZE initialization parameter: obsolete

lowercase significance, 1-3

manual archiving, 1-60

MAX_COMMIT_PROPAGATION_DELAY initialization parameter, 1-65

MAX_DUMP_FILE_SIZE initialization parameter, 1-66

MAX_ENABLED_ROLES initialization parameter, 1-66

MAX_ROLLBACK_SEGMENTS initialization parameter, 1-67

MAX_TRANSACTION_BRANCHES initialization parameter: obsolete

memory

amount used for sorting, 1-111

migration

modes

monitor

MTS dispatcher request statistics, 3-82

MTS. See multi-threaded server

MTS_CIRCUITS initialization parameter, 1-67

MTS_DISPATCHERS initialization parameter, 1-68

MTS_LISTENER_ADDRESS initialization parameter: obsolete

MTS_MAX_DISPATCHERS initialization parameter, 1-71

MTS_MAX_SERVERS initialization parameter, 1-72

MTS_MULTIPLE_LISTENERS initialization parameter: obsolete

MTS_RATE_LOG_SIZE initialization parameter: obsolete

MTS_RATE_SCALE initialization parameter: obsolete

MTS_SERVERS initialization parameter, 1-72

MTS_SERVICE initialization parameter: obsolete

MTS_SESSIONS initialization parameter, 1-73

multiple-process systems

number of processes, 1-98

multi-threaded server

and HASH_MULTIBLOCK_IO_COUNT initialization parameter, 1-44

SESSIONS initialization parameter, 1-109

nested files, 1-45

NLS_CALENDAR initialization parameter, 1-73

NLS_COMP initialization parameter, 1-74

NLS_CURRENCY initialization parameter, 1-74

defined by NLS_TERRITORY, 1-79

NLS_DATABASE_PARAMETERS view, 2-153

NLS_DATE_FORMAT initialization parameter, 1-75

defined by NLS_NUMERIC_CHARACTERS, 1-79

defined by NLS_TERRITORY, 1-79

NLS_DATE_LANGUAGE initialization parameter, 1-75

NLS_INSTANCE_PARAMETERS view, 2-154

NLS_ISO_CURRENCY initialization parameter, 1-76

defined by NLS_TERRITORY, 1-79

NLS_LANGUAGE initialization parameter, 1-77

NLS_NUMERIC_CHARACTERS initialization parameter, 1-77

NLS_SESSION_PARAMETERS view, 2-154

NLS_SORT initialization parameter, 1-78

NLS_TERRITORY initialization parameter, 1-79

NLS_UNION_CURRENCY initialization parameter, 1-76

NOARCHIVELOG mode

creating a database, 1-60

numeric group separators, 1-77

O7_DICTIONARY_ACCESSIBILITY initialization parameter, 1-79

OBJ synonym for USER_OBJECTS, 2-154

OBJECT_CACHE_MAX_SIZE_PERCENT initialization parameter, 1-80

OBJECT_CACHE_OPTIMAL_SIZE initialization parameter, 1-81

objects

data dictionary, 2-1

OGMS_HOME initialization parameter: obsolete

online redo log

number of files, 1-60

setting checkpoint interval, 1-63

OPEN_CURSORS initialization parameter, 1-81

OPEN_LINKS initialization parameter, 1-82

OPEN_LINKS_PER_INSTANCE initialization parameter, 1-82

operating system

authenticating remote clients, 1-102

authenticating users and passwords, 1-90

dependent parameters, 1-10

redo log blocks, 1-63

roles for remote clients, 1-103

OPS_ADMIN_GROUP initialization parameter: obsolete

optimization

trading cursor space for time, 1-23

optimizer mode

FIRST_ROWS, 1-86

RULE, 1-86

OPTIMIZER_INDEX_CACHING initialization parameter, 1-84

OPTIMIZER_INDEX_COST_ADJ initialization parameter, 1-85

OPTIMIZER_MAX_PERMUTATIONS initialization parameter, 1-85

OPTIMIZER_MODE initialization parameter, 1-85

OPTIMIZER_PERCENT_PARALLEL initialization parameter, 1-86

OPTIMIZER_SEARH_LIMIT initialization parameter: obsolete

Oracle Parallel Server

dynamic performance views, 3-2

initialization parameters

FAST_START_PARALLEL_ROLLBACK, 1-38

LM_LOCKS, 1-52

LM_RESS, 1-53

MTS_CIRCUITS, 1-67

MTS_DISPATCHERS, 1-68

PARALLEL_ADAPTIVE_MULTI_USER, 1-91

PARALLEL_AUTOMATIC_TUNING, 1-92

PARALLEL_BROADCAST_ENABLE, 1-92

PARALLEL_EXECUTION_MESSAGE_SIZE, 1-93

PARALLEL_INSTANCE_GROUP, 1-93

PARALLEL_MAX_SERVERS, 1-94

PARALLEL_MIN_PERCENT, 1-94

PARALLEL_MIN_SERVERS, 1-95

PARALLEL_SERVER, 1-96

PARALLEL_SERVER_IDLE_TIME, 1-12, 1-96

PARALLEL_THREADS_PER_CPU, 1-96

ORACLE_TRACE_COLLECTION_NAME initialization parameter, 1-87

ORACLE_TRACE_COLLECTION_PATH initialization parameter, 1-87

ORACLE_TRACE_COLLECTION_SIZE initialization parameter, 1-88

ORACLE_TRACE_ENABLE initialization parameter, 1-88

ORACLE_TRACE_FACILITY_NAME initialization parameter, 1-89

ORACLE_TRACE_FACILITY_PATH initialization parameter, 1-89

Oracle8i

Enterprise Edition

features and functionality, xxxi

OS_AUTHENT_PREFIX initialization parameter, 1-90

OS_ROLES initialization parameter, 1-90

parallel mode

instance number, 1-47

parallel query

idle time, 1-12, 1-96

maximum number of instances, 1-92, 1-93

maximum number of servers, 1-94

minimum number of queries, 1-95

OPTIMIZER_PERCENT_PARALLEL, 1-86

PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 1-91

PARALLEL_AUTOMATIC_TUNING initialization parameter, 1-92

PARALLEL_BROADCAST_ENABLE initialization parameter, 1-92

PARALLEL_BROADCAST_ENABLED initialization parameter, 1-92

PARALLEL_DEFAULT_MAX_INSTANCES initialization parameter: obsolete

PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 1-93

PARALLEL_INSTANCE_GROUP initialization parameter, 1-93

PARALLEL_MAX_SERVERS initialization parameter, 1-94

PARALLEL_MIN_MESSAGE_POOL initialization parameter: obsolete

PARALLEL_MIN_PERCENT initialization parameter, 1-94

PARALLEL_MIN_SERVERS initialization parameter, 1-95

PARALLEL_SERVER initialization parameter, 1-96

PARALLEL_SERVER_IDLE_TIME initialization parameter, 1-12, 1-96

PARALLEL_SERVER_IDLE_TIME initialization parameter: obsolete

PARALLEL_SERVER_INSTANCES initialization parameter, 1-96

PARALLEL_THREADS_PER_CPU initialization parameter, 1-96

PARALLEL_TRANSACTION_RESOURCE_TIMEOUT initialization parameter: obsolete

parallelism

OPTIMIZER_PERCENT_PARALLEL, 1-86

parameters

embedded parameter files, 1-4

PARSED_PIECES view, 2-154

PARSED_SIZE view, 2-154

PARTITION_VIEW_ENABLED initialization parameter, 1-97

partitions

raw, 1-55

passwords

authenticating, 1-90, 1-102

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1-102

PCM lock

mapping blocks to, 1-39

performance, 1-11

rule-based optimization, 1-85

shared pool, 1-44, 1-45, 1-110, 1-111

sort performance, 1-113

PIN_COUNT initialization parameter: obsolete

pins

on KGL objects, 2-113

PLAN_TABLE execution plan table, 2-154

PLSQL_V2_COMPATIBILITY initialization parameter, 1-97

PLUGGABLE_SET_CHECK view, 2-156

PRE_PAGE_SGA initialization parameter, 1-98

private rollback segments

specifying, 1-105

privileges

remote login, 1-102

RESTRICTED_SESSION privilege, 1-51, 1-52

table-level select privileges, 1-114, 1-115

procedures

shared pool, 1-44, 1-45, 1-110, 1-111

processes

derived parameter values, 1-119

dispatcher process maximum number, 1-71

maximum shared server processes, 1-72

number of server processes, 1-48, 1-72, 1-73, 1-99

recovery, 1-99, 1-101

trace files, 1-120

user processes, 1-98

PROCESSES initialization parameter, 1-98

PRODUCT_COMPONENT_VERSION view, 2-157

profiles

resource limits, 1-103, 1-104

PROXY_USERS view, 2-157

PSTUBTBL view, 2-157

PUBLIC clause

of ALTER DATABASE

thread of redo, 1-116

public rollback segments, 1-105

using by default, 1-105

PUBLIC_DEPENDENCY view, 2-158

PUBLICSYN view, 2-158

PUSH_JOIN_PREDICATE initialization parameter: obsolete

queries

dictionary views, 1-39

hints, 1-85

QUERY_REWRITE_ENABLED initialization parameter, 1-99

QUEUE_PRIVILEGES view, 2-158

R070304.SQL script, 5-7

raw partition

LOG_ARCHIVE_DEST initialization parameter, 1-55

RC_ views, 2-159

RDBMS_SERVER_DN, 1-100

read consistency

rollback information, 1-41

READ_ONLY_OPEN_DELAYED initialization parameter, 1-100

recovery

number of required processes, 1-99, 1-101

RECOVERY_PARALLELISM initialization parameter, 1-101

redo logs

buffer size, 1-62

redo thread, 1-116

REDUCE_ALARM initialization parameter: obsolete

remote clients

authenticating, 1-102

remote logins, 1-102

REMOTE_DEPENDENCIES_MODE initialization parameter, 1-101

REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1-102

REMOTE_OS_AUTHENT initialization parameter, 1-102

REMOTE_OS_ROLES initialization parameter, 1-103

REPAIR_TABLE view. See DBA_REPAIR_TABLE view.

REPLICATION_DEPENDENCY_TRACKING initialization parameter, 1-103

resource limits for profiles, 1-103, 1-104

RESOURCE_COST view, 2-159

RESOURCE_LIMIT initialization parameter, 1-103, 1-104

RESOURCE_MANAGER_PLAN initialization parameter, 1-104

RESOURCE_MAP view, 2-159

REWRITE_INTEGRITY initialization parameter, 1-99

RM804813.SQL script, 5-7

RMJVM.SQL script, 5-7

ROLE_ROLE_PRIVS view, 2-160

ROLE_SYS_PRIVS view, 2-160

ROLE_TAB_PRIVS view, 2-160

roles, 1-90

remote clients, 1-103

rollback segments

acquiring, 1-105, 1-119

distributed locks, 1-41

global constant parameters, 1-41

initialization parameters, 1-41

maximum size, 1-67

number of concurrent transactions, 1-119

private rollback segments, 1-105

public rollback segments, 1-105

specifying, 1-105

SYSTEM, 1-105

ROLLBACK_SEGMENTS initialization parameter, 1-105

unique values, 1-105

ROW_CACHE_CURSORS initialization parameter: obsolete

ROW_LOCKING initialization parameter, 1-106

RULE, 1-86

rule-based optimization, 1-85

scripts

data dictionary, 5-2

Java, 5-7

migration, 5-5, 5-6, 5-7

SQL scripts, 5-2

SEQ synonym for USER_SEQUENCES, 2-161

SEQUENCE_CACHE_ENTRIES initialization parameter: obsolete

SEQUENCE_CACHE_HASH_BUCKETS initialization parameter: obsolete

SERIAL_REUSE initialization parameter, 1-106

server processes

number, 1-48, 1-72, 1-73, 1-99

SERVICE_NAMES initialization parameter, 1-107

SESSION_CACHED_CURSORS initialization parameter, 1-108

SESSION_CONTEXT view, 2-161

SESSION_MAX_OPEN_FILES initialization parameter, 1-108

SESSION_PRIVS view, 2-161

SESSION_ROLES view, 2-161

SESSIONS initialization parameter, 1-109

SGA. See system global area

SHADOW_CORE_DUMP initialization parameter, 1-109

shared server processes

maximum number, 1-72

SHARED_MEMORY_ADDRESS initialization parameter, 1-110

SHARED_POOL_RESERVED_MIN_ALLOC initialization parameter: obsolete

SHARED_POOL_RESERVED_SIZE initialization parameter, 1-110

SHARED_POOL_RESERVED_SIZE parameter

V$SHARED_POOL_RESERVED, 3-100

SHARED_POOL_SIZE initialization parameter, 1-111

SHOW PARAMETERS statement, 1-9

SNAPSHOT_REFRESH_KEEP_CONNECTIONS initialization parameter: obsolete

SNAPSHOT_REFRESH_PROCESSES initialization parameter: obsolete

SNP background processes, 1-50

SORT_AREA_RETAINED_SIZE initialization parameter, 1-111

SORT_AREA_SIZE initialization parameter, 1-112

SORT_DIRECT_WRITES initialization parameter: obsolete

SORT_MULTIBLOCK_READ_COUNT initialization parameter, 1-113

SORT_READ_FAC initialization parameter: obsolete

SORT_SPACEMAP_SIZE initialization parameter: obsolete

SORT_WRITE_BUFFER_SIZE initialization parameter: obsolete

SORT_WRITE_BUFFERS initialization parameter: obsolete

sorting

maximum memory, 1-111

ORDER BY queries, 1-78

SOURCE_SIZE view, 2-161

SQL scripts

CATQUEUE.SQL, 5-3

creating the data dictionary, 5-2

optional, 5-2

required, 5-2

SQL_TRACE initialization parameter, 1-114

SQL92_SECURITY initialization parameter, 1-114

STANDBY_ARCHIVE_DEST initialization parameter, 1-115

STAR_TRANSFORMATION_ENABLED initialization parameter, 1-115

starting up

database name, 1-32

instance number, 1-47

startup order, 1-47

STARTUP statement

database name, 1-32

statistics

background checkpoints completed, C-2

background checkpoints started, C-2

branch node splits, C-2

buffer is not pinned count, C-2

buffer is pinned count, C-2

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

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

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

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

Cached Commit SCN referenced, C-3

calls to get snapshot scn

change write time, C-3

cleanouts and rollbacks - consistent read gets, C-3

cleanouts only - consistent read gets, C-3

cluster key scan block gets, C-3

cluster key scans, C-3

cold recycle reads, C-3

commit cleanout failures

block lost, C-3

buffer being written, C-3

callback failure, C-4

cannot pin, C-4

hot backup in progress, C-4

write disabled, C-4

commit cleanouts, C-4

commit cleanouts successfully completed, C-4

Commit SCN cached, C-4

consistent changes, C-4

consistent gets, C-4

CPU used by this session, C-4

CPU used when call started, C-4

CR blocks created, C-5

cross instance CR read, C-5

current blocks converted for CR, C-5

cursor authentication, C-5

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

db block changes, C-5

db block gets, C-5

DBWR buffers scanned, C-5

DBWR checkpoint buffers written, C-5

DBWR checkpoints, 1-63, C-5

DBWR cross instance writes, C-5

DBWR free buffers found, C-5

DBWR lru scans, C-6

DBWR make free requests, C-6

DBWR revisited being-written buffer, C-6

DBWR summed scan depth, C-6

DBWR transaction table writes, C-6

DBWR undo block writes, C-6

DDL statements parallelized, C-6

deferred (CURRENT) block cleanout applications, C-6

DFO trees parallelized, C-6

dirty buffers inspected, C-6

DML statements parallelized, C-6

enqueue conversions, C-6

enqueue deadlocks, C-7

enqueue releases, C-7

enqueue requests, C-7

enqueue timeouts, C-7

enqueue waits, C-7

exchange deadlocks, C-7

execute count, C-7

free buffer inspected, C-7

free buffer requested, C-7

global cache cr block log flush time, C-8

global cache cr block send time, C-8

global cache cr timeouts, C-8

global cache defers, C-8

global cache freelist waits, C-8

global cache get time, C-8

global cache gets, C-8

global cache prepare failures, C-8

global lock async converts, C-8

global lock async gets, C-8

global lock convert time, C-8

global lock get time, C-9

global lock release time, C-9

global lock releases, C-9

global lock sync converts, C-9

global lock sync gets, C-9

hot buffers moved to head of LRU, C-9

immediate (CR) block cleanout applications, C-9

immediate (CURRENT) block cleanout applications, C-9

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

index fast full scans (full), C-9

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

instance recovery database freeze count, C-9

kcmccs called get current scn, C-9

kcmccs read scn without going to DLM, C-9

kcmggs waited for batching, C-9

leaf node splits, C-9

logons cumulative, C-9

logons current, C-10

messages received, C-10

messages sent, C-10

native hash arithmetic execute, C-10

native hash arithmetic fail, C-10

next scns gotten without going to DLM, C-10

no buffer to keep pinned count, C-10

no work - consistent read gets, C-10

opened cursors cumulative, C-10

opened cursors current, C-10

opens of replaced files, C-10

opens requiring cache replacement, C-10

operating system

OS Input blocks, C-11

Parallel operations downgraded 1 to 25 pct, C-12

Parallel operations downgraded 25 to 50 pct, C-12

Parallel operations downgraded 50 to 75 pct, C-12

Parallel operations downgraded 75 to 99 pct, C-12

Parallel operations downgraded to serial, C-12

Parallel operations not downgraded, C-12

parse count (hard), C-12

parse count (total), C-12

parse time cpu, C-12

parse time elapsed, C-12

physical reads, C-12

physical reads direct, C-12

physical writes, C-13

physical writes direct, C-13

physical writes non checkpoint, C-13

pinned buffers inspected, C-13

prefetched blocks, C-13

prefetched blocks aged out before use, C-13

process last non-idle time, C-13

PX local messages recv'd, C-13

PX local messages sent, C-13

PX remote messages recv'd, C-13

PX remote messages sent, C-13

queries parallelized, C-13

recovery array read time, C-13

recovery array reads, C-13

recovery blocks read, C-13

recursive calls, C-14

recursive cpu usage, C-14

redo blocks written, C-14

redo buffer allocation retries, C-14

redo entries, C-14

redo log space requests, C-14

redo log space wait time, C-14

redo log switch interrupts, C-14

redo ordering marks, C-14

redo size, C-15

redo sync writes, C-15

redo synch time, C-15

redo wastage, C-15

redo write time, C-15

redo writer latching time, C-15

redo writes, C-15

remote instance undo block writes, C-15

remote instance undo header writes, C-15

rollback changes - undo records applied, C-15

rollbacks only - consistent read gets, C-15

rows fetched via callback, C-15

serializable aborts, C-15

session connect time, C-15

session cursor cache count, C-16

session cursor cache hits, C-16

session logical reads, C-16

session pga memory, C-16

session pga memory max, C-16

session stored procedure space, C-16

session uga memory, C-16

session uga memory max, C-16

sorts (disk), C-16

sorts (memory), C-16

sorts (rows), C-16

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

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

summed dirty queue length, C-17

switch current to new buffer, C-17

table fetch by rowid, C-17

table fetch continued row, C-17

table scan blocks gotten, C-17

table scan rows gotten, C-17

table scans (cache partitions), C-17

table scans (direct read), C-18

table scans (long tables), C-18

table scans (rowid ranges), C-18

table scans (short tables), C-18

timed, 1-118

total file opens, C-18

transaction lock background get time, C-18

transaction lock background gets, C-18

transaction lock foreground requests, C-18

transaction lock foreground wait time, C-18

transaction rollbacks, C-18

transaction tables consistent read rollbacks, C-18

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

Unnecessary process cleanup for SCN batching, C-18

user calls, C-19

user commits, C-19

user rollbacks, C-19

write clones created in background, C-19

write clones created in foreground, C-19

STMT_AUDIT_OPTION_MAP table

auditing option type codes, 2-162

switch redo log file, 1-63

SYN synonym for USER_SYNONYMS, 2-162

SYNONYMS view, 2-162

SYS_OBJECTS view, 2-163

SYSCATALOG view, 2-162

SYSFILES view, 2-162

SYSSEGOBJ view, 2-162

system global area, 1-11

buffer areas, 1-24, 1-62

buffer cache, 1-24

maximum concurrent transactions, 1-119

rollback segment size, 1-67

size of, 1-24

system performance, 1-11

SYSTEM rollback segment, 1-105

SYSTEM_PRIVILEGE_MAP view, 2-162

TAB view, 2-163

TABLE_PRIVILEGE_MAP table

access privilege codes, 2-164

TABLE_PRIVILEGES view, 2-163

tables

data dictionary, 2-1

DML locks, 1-35

free lists, 1-28

locating free space, 1-47

row locking, 1-106

TABQUOTAS view, 2-164

TABS synonym for USER_TABLES, 2-164

tape archiving destination, 1-55

TAPE_ASYNCH_IO initialization parameter

initialization parameters

TAPE_ASYNCH_IO, 1-116

TEMPORARY_TABLE_LOCKS initialization parameter: obsolete

territory, 1-76, 1-79

TEXT_ENABLE initialization parameter: obsolete

THREAD initialization parameter, 1-116

TIMED_OS_STATISTICS initialization parameter, 1-117

TIMED_STATISTICS initialization parameter, 1-118

TIMED_STATISTICS parameter

file read/write statistics, 3-47, 3-116

TO_CHAR function, 1-75

TO_DATE function, 1-75

trace files

destination, 1-16, 1-120

location of, 1-16

maximum size, 1-66

TRANSACTION_AUDITING initialization parameter, 1-118

transactions

concurrent, 1-119

data locking, 1-35

rollback segments, 1-119

TRANSACTIONS initialization parameter, 1-105

DML locks, 1-35

TRANSACTIONS_PER_ROLLBACK_SEGMENT initialization parameter, 1-105, 1-119

TRUSTED_SERVERS view, 2-164

TS_PITR_CHECK view, 2-165

TS_PITR_OBJECTS TO_BE_DROPPED view, 2-166

U703040.SQL script, 5-7

UNI_PLUGGABLE_SET_CHECK view, 2-166

updates

locating free space, 1-47

transaction processing option, 1-106

uppercase characters, 1-3

USE_INDIRECT_DATA_BUFFERS initialization parameter, 1-120

USE_ISM initialization parameter: obsolete

user processes

trace files, 1-120

USER_ALL_TABLES view, 2-3, 2-167

USER_ARGUMENTS view, 2-5, 2-167

USER_ASSOCIATIONS view, 2-6

USER_AUDIT_OBJECT view, 2-167

USER_AUDIT_SESSION view, 2-167

USER_AUDIT_STATEMENT view, 2-168

USER_AUDIT_TRAIL view, 2-168

USER_CATALOG view, 2-168

CAT synonym, 2-93

USER_CLU_COLUMNS view, 2-168

USER_CLUSTER_HASH_EXPRESSIONS view, 2-168

USER_CLUSTERS view, 2-168

CLU synonym, 2-94

USER_COL_COMMENTS view, 2-168

USER_COL_PRIVS view, 2-169

USER_COL_PRIVS_MADE view, 2-169

USER_COL_PRIVS_RECD view, 2-169

USER_COLL_TYPES view, 2-169

USER_CONS_COLUMNS view, 2-169

USER_CONSTRAINTS view, 2-169

USER_DB_LINKS view, 2-170

USER_DEPENDENCIES view, 2-170

USER_DIM_ATTRIBUTES view, 2-170

USER_DIM_CHILD_OF view, 2-170

USER_DIM_HIERARCHIES view, 2-170

USER_DIM_JOIN_KEY view, 2-171

USER_DIM_LEVEL_KEY view, 2-171

USER_DIM_LEVELS view, 2-171

USER_DIMENSIONS view, 2-170

USER_DUMP_DEST initialization parameter, 1-120

USER_ERRORS view, 2-171

USER_EXTENTS view, 2-171

USER_FREE_SPACE view, 2-171

USER_IND_COLUMNS view, 2-172

USER_IND_EXPRESSIONS view, 2-172

USER_IND_PARTITIONS view, 2-172

USER_IND_SUBPARTITIONS view, 2-172

USER_INDEXES view, 2-172

IND synonym, 2-152

USER_INDEXTYPE_OPERATORS view, 2-173

USER_INDEXTYPES view, 2-172

USER_INTERNAL_TRIGGERS view, 2-173

USER_JOBS view, 2-173

USER_LIBRARIES view, 2-173

USER_LOB_PARTITIONS view, 2-173

USER_LOB_SUBPARTITIONS view, 2-174

USER_LOBS view, 2-173

USER_METHOD_PARAMS view, 2-174

USER_METHOD_RESULTS view, 2-174

USER_MVIEW_AGGREGATES view, 2-174

USER_MVIEW_ANALYSIS view, 2-174

USER_MVIEW_DETAIL_RELATIONS view, 2-175

USER_MVIEW_JOINS view, 2-175

USER_MVIEW_KEYS view, 2-175

USER_MVIEWS view, 2-43, 2-175

USER_NESTED_TABLES view, 2-175

USER_OBJ_AUDIT_OPTS view, 2-176

USER_OBJECT_SIZE view, 2-176

USER_OBJECT_TABLES view, 2-175

USER_OBJECTS view, 2-175

OBJ synonym, 2-154

USER_OPANCILLARY view, 2-176

USER_OPARGUMENTS view, 2-176

USER_OPBINDINGS view, 2-176

USER_OPERATORS view, 2-176

USER_OUTLINE_HINTS view, 2-176

USER_OUTLINES view, 2-177

USER_PART_COL_STATISTICS view, 2-177

USER_PART_HISTOGRAMS view, 2-177

USER_PART_INDEXES view, 2-177

USER_PART_KEY_COLUMNS view, 2-177

USER_PART_LOBS view, 2-177

USER_PART_TABLES view, 2-178

USER_PARTIAL_DROP_TABS view, 2-178

USER_PASSWORD_LIMITS view, 2-178

USER_POLICIES view, 2-178

USER_QUEUE_SCHEDULES view, 2-178

USER_QUEUE_TABLES view, 2-178

USER_QUEUES view, 2-179

USER_REFRESH view, 2-179

USER_REFRESH_CHILDREN view, 2-179

USER_REFS view, 2-179

USER_REGISTERED_SNAPSHOTS view, 2-179

USER_REPCATLOG view, 2-1

USER_REPCOLUMN view, 2-1

USER_REPCOLUMN_GROUP view, 2-1

USER_REPCONFLICT view, 2-1

USER_REPDDL view, 2-1

USER_REPGENERATED view, 2-1

USER_REPGENOBJECTS view, 2-1

USER_REPGROUP view, 2-1

USER_REPGROUPED_COLUMNS view, 2-1

USER_REPKEY_COLUMNS view, 2-1

USER_REPOBJECT view, 2-1

USER_REPPARAMETER_COLUMN view, 2-1

USER_REPPRIORITY view, 2-1

USER_REPPRIORITY_GROUP view, 2-1

USER_REPPROP view, 2-1

USER_REPRESOL_STATS_CONTROL view, 2-1

USER_REPRESOLUTION view, 2-1

USER_REPRESOLUTION_METHOD view, 2-1

USER_REPRESOLUTION_STATISTICS view, 2-1

USER_REPSITES view, 2-1

USER_RESOURCE_LIMITS view, 2-179

USER_ROLE_PRIVS view, 2-180

USER_RSRC_CONSUMER_GROUP_PRIVS view, 2-180

USER_RSRC_MANAGER_SYSTEM_PRIVS view, 2-180

USER_RULESETS view, 2-180

USER_SEGMENTS view, 2-181

USER_SEQUENCES view, 2-181

SEQ synonym, 2-161

USER_SNAPSHOT_LOGS view, 2-181

USER_SNAPSHOT_REFRESH_TIMES view, 2-181

USER_SNAPSHOTS view, 2-181

USER_SOURCE view, 2-181

USER_SUBPART_COL_STATISTICS view, 2-181

USER_SUBPART_HISTOGRAMS view, 2-182

USER_SUBPART_KEY_COLUMNS view, 2-182

USER_SYNONYMS view, 2-182

SYN synonym, 2-162

USER_SYS_PRIVS view, 2-182

USER_TAB_COL_STATISTICS view, 2-182

USER_TAB_COLUMNS

COLS synonym, 2-94

USER_TAB_COLUMNS view, 2-182

USER_TAB_COMMENTS view, 2-183

USER_TAB_HISTOGRAMS view, 2-183

USER_TAB_PARTITIONS view, 2-183

USER_TAB_PRIVS view, 2-183

USER_TAB_PRIVS_MADE view, 2-184

USER_TAB_PRIVS_RECD view, 2-184

USER_TAB_SUBPARTITIONS view, 2-184

USER_TABLES view, 2-184

USER_TABLESPACES view, 2-184

USER_TRIGGER_COLS view, 2-185

USER_TRIGGERS view, 2-184

USER_TS_QUOTAS view, 2-185

USER_TYPE_ATTRS view, 2-185

USER_TYPE_METHODS view, 2-185

USER_TYPES view, 2-185

USER_UPDATABLE_COLUMNS view, 2-185

USER_USERS view, 2-186

USER_USTATS view, 2-186

USER_VARRAYS view, 2-186

USER_VIEWS view, 2-186

USERLOCK.SQL script, 5-3

users

authenticating, 1-90

multiple, 1-35

UTL_FILE_DIR initialization parameter, 1-121

UTLBSTAT.SQL script, 5-3

UTLCHN1.SQL script, 5-4

UTLCONST.SQL script, 5-4

UTLDTREE.SQL script, 2-141, 2-152, 5-4

UTLESTAT.SQL script, 5-3

UTLEXPT1.SQL script, 5-4

UTLHTTP.SQL script, 5-4

UTLIP.SQL script, 5-4

UTLIRP.SQL script, 5-4

UTLJAVARM.SQL, 5-7

UTLJAVARM.SQL script, 5-7

UTLLOCKT.SQL script, 5-4

UTLPG.SQL script, 5-4

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

V$ACTIVE_INSTANCES view, 3-3

V$AQ view, 3-3

V$ARCHIVE view, 3-3

V$ARCHIVE_DEST, 3-4

V$ARCHIVE_DEST view, 3-4

V$ARCHIVE_PROCESSES view, 3-6

V$ARCHIVED_LOG view, 3-5

V$BACKUP view, 3-6

V$BACKUP_ASYNC_IO view, 3-7

V$BACKUP_CORRUPTION view, 3-8

V$BACKUP_DATAFILE view, 3-9

V$BACKUP_DEVICE view, 3-10

V$BACKUP_PIECE view, 3-10

V$BACKUP_REDOLOG view, 3-11

V$BACKUP_SET view, 3-12

V$BACKUP_SYNC_IO view, 3-12

V$BGPROCESS view, 3-13

V$BH view, 3-14

V$BSP view, 3-15

V$BUFFER_POOL view, 3-16, 3-17

V$CACHE view, 3-18

V$CACHE_LOCK view, 3-19

V$CIRCUIT view, 3-21

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

V$DATAFILE view, 3-25

V$DATAFILE_COPY view, 3-27

V$DATAFILE_HEADER view, 3-28

V$DB_OBJECT_CACHE view, 3-30

V$DB_PIPES view, 3-30

V$DBFILE view, 3-29

V$DBLINK view, 3-29

V$DELETED_OBJECT view, 3-31

V$DISPATCHER view, 3-31

V$DISPATCHER_RATE view, 3-32

V$DLM_ALL_LOCKS view, 3-37

V$DLM_CONVERT_LOCAL view, 3-38

V$DLM_CONVERT_REMOTE view, 3-38

V$DLM_LATCH view, 3-39

V$DLM_LOCKS view, 3-39

V$DLM_MISC view, 3-41

V$DLM_RESS view, 3-41

V$ENABLEDPRIVS view, 3-41

V$ENQUEUE_LOCK view, 3-42

V$EVENT_NAME view, 3-42

V$EXECUTION view, 3-43

V$FALSE_PING view, 3-43

V$FAST_START_SERVERS view, 3-44

V$FAST_START_TRANSACTIONS view, 3-45

V$FILE_PING view, 3-45

V$FILESTAT view, 3-47

V$FIXED_TABLE view, 3-47

V$FIXED_VIEW_DEFINITION view, 3-48

V$GLOBAL_BLOCKED_LOCKS view, 3-48

V$GLOBAL_TRANSACTION view, 3-48

V$HS_AGENT view, 3-49

V$HS_PARAMETER view, 3-49

V$HS_SESSION view, 3-50

V$INDEXED_FIXED_COLUMN view, 3-50

V$INSTANCE view, 3-51

V$INSTANCE_RECOVERY view, 3-51

V$LATCH view, 3-53

V$LATCH_CHILDREN view, 3-54

V$LATCH_MISSES view, 3-55

V$LATCH_PARENT view, 3-55

V$LATCHHOLDER view, 3-53

V$LATCHNAME view, 3-54

V$LIBRARYCACHE view, 3-55

V$LICENSE view, 3-56

V$LOADCSTAT view, 3-56

V$LOADTSTAT view, 3-56

V$LOCK view, 3-57

V$LOCK_ACTIVITY view, 3-59

V$LOCK_ELEMENT view, 3-59

V$LOCKED_OBJECT view, 3-60

V$LOCKS_WITH_COLLISIONS view, 3-60

V$LOG view, 3-61

V$LOG_HISTORY view, 3-65

V$LOGFILE view, 3-62

V$LOGHIST view, 3-62

V$LOGMNR_CONTENTS view, 3-62

V$LOGMNR_DICTIONARY view, 3-64

V$LOGMNR_LOGS view, 3-64

V$LOGMNR_PARAMETERS view, 3-65

V$MTS view, 3-66

V$MYSTAT view, 3-66

V$NLS_PARAMETERS view, 3-66

V$NLS_VALID_VALUES view, 3-67

V$OBJECT_DEPENDENCY view, 3-67

V$OFFLINE_RANGE view, 3-68

V$OPEN_CURSOR view, 3-68

V$OPTION view, 3-69

V$PARALLEL_DEGREE_LIMIT_MTH view, 3-69

V$PARAMETER view, 3-69

V$PING view, 3-70

V$PQ_SESSTAT view, 3-71

V$PQ_SLAVE view, 3-71

V$PQ_SYSSTAT view, 3-72

V$PQ_TQSTAT view, 3-73

V$PROCESS view, 3-74

V$PROXY_ARCHIVELOG view, 3-74

V$PROXY_DATAFILE view, 3-75

V$PWFILE_USERS view, 3-77

V$PX_PROCESS view, 3-77

V$PX_PROCESS_SYSSTAT view, 3-78

V$PX_SESSION view, 3-79

V$PX_SESSTAT view, 3-79

V$QUEUE view, 3-80

V$RECOVER_FILE view, 3-80

V$RECOVERY_FILE_STATUS view, 3-80

V$RECOVERY_LOG view, 3-81

V$RECOVERY_PROGRESS view, 3-81

V$RECOVERY_STATUS view, 3-82

V$REQDIST view, 3-82

V$RESERVED_WORDS view, 3-83

V$RESOURCE view, 3-83

V$RESOURCE_LIMIT view, 3-83

V$ROLLNAME view, 3-85

V$ROLLSTAT view, 3-85

V$ROWCACHE view, 3-86, 3-87

V$RSCRC_CONSUMER_GROUP view, 3-87

V$RSCRC_CONSUMER_GROUP_CPU_MTH view, 3-88

V$RSCRC_PLAN view, 3-89

V$RSCRC_PLAN_CPU_MTH view, 3-89

V$SESS_IO view, 3-99

V$SESSION view, 3-90

V$SESSION_CONNECT_INFO view, 3-93

V$SESSION_CURSOR_CACHE view, 3-94

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

V$SESSION_LONGOPS view, 3-95

V$SESSION_OBJECT_CACHE view, 3-96

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

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

V$SGA view, 3-99

V$SGASTAT view, 3-99

V$SHARED_POOL_RESERVED view, 3-100

V$SHARED_SERVER view, 3-101

V$SORT_SEGMENT view, 3-101

V$SORT_USAGE view, 3-102

V$SQL view, 3-103

V$SQL_BIND_DATA view, 3-104

V$SQL_BIND_METADATA view, 3-105

V$SQL_CURSOR view, 3-106

V$SQL_SHARED_MEMORY view, 3-106

V$SQLAREA view, 3-107

V$SQLTEXT view, 3-108

V$SQLTEXT_WITH_NEWLINES view, 3-109

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

V$SUBCACHE view, 3-110

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

V$SYSTEM_CURSOR_CACHE view, 3-111

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

V$SYSTEM_PARAMETER view, 3-112

V$TABLESPACE view, 3-113

V$TEMP_EXTENT_MAP view, 3-114

V$TEMP_EXTENT_POOL view, 3-114

V$TEMP_PING view, 3-115

V$TEMP_SPACE_HEADER view, 3-116

V$TEMPFILE view, 3-113

V$TEMPORARY_LOBS view, 3-113

V$TEMPSTAT view, 3-116

V$THREAD view, 3-117

V$TIMER view, 3-118

V$TRANSACTION view, 3-118

V$TRANSACTION_ENQUEUE view, 3-119

V$TYPE_SIZE view, 3-120

V$VERSION view, 3-121

V$WAITSTAT view, 3-121

views

data dictionary views, 2-1

data files, 1-39

virtual circuit status, A-47

wait events

alter system set mts_dispatchers, A-12

batched allocate scn lock request, A-12

BFILE check if exists, A-12

BFILE check if open, A-12

BFILE closure, A-13

BFILE get length, A-13

BFILE get name object, A-13

BFILE get path object, A-13

BFILE internal seek, A-14

BFILE open, A-14

BFILE read, A-14

buffer busy waits, A-15

buffer deadlock, A-15

buffer for checkpoint, A-15

buffer latch, A-16

buffer read retry, A-16

checkpoint completed, A-17

checkpoint range buffer not saved, A-17

controlfile parallel write, A-17

controlfile sequential read, A-18

controlfile single write, A-18

conversion file read, A-19

db file parallel read, A-19

db file parallel write, A-19

db file scattered read, A-20

db file sequential read, A-20

db file single write, A-20

DFS db file lock, A-21

DFS lock handle, A-21

direct path read, A-21, A-22

direct path write, A-22

dispatcher shutdown, A-23

dispatcher timer, A-23

duplicate cluster key, A-23

enqueue, A-23

file identify, A-24

file open, A-24

free buffer waits, A-24

free global transaction table entry, A-24

free process state object, A-25

global cache freelist wait, A-25

global cache lock busy, A-25

global cache lock cleanup, A-26

global cache lock null to s, A-26

global cache lock null to x, A-26

global cache lock open null, A-27

global cache lock open s, A-27

global cache lock open x, A-27

global cache locks s to x, A-28

inactive session, A-28

inactive transaction branch, A-28

index block split, A-29

instance recovery, A-29

instance state change, A-29

library cache load lock, A-31

library cache lock, A-32

library cache pin, A-32

lock manager wait for remote message, A-33

log file parallel write, A-33

log file sequential read, A-34

log file single write, A-34

log file switch (archiving needed), A-34

log file switch (checkpoint incomplete), A-35

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

log file switch completion, A-35

log file sync, A-35

log switch/archive, A-35

on-going SCN fetch to complete, A-36

parallel query create server, A-36

parallel query dequeue wait, A-36

parallel query qref latch, A-37

parallel query server shutdown, A-37

parallel query signal server, A-37

pending global transaction(s), A-38

pipe get, A-38

pipe put, A-38

PL/SQL lock timer, A-12, A-39

pmon rdomain attach, A-39

pmon timer, A-39

process startup, A-39

queue messages, A-40

rdbms ipc message, A-40

rdbms ipc message block, A-40

rdbms ipc reply, A-40

redo, A-41

row cache lock, A-41

scginq AST call, A-41

single-task message, A-41

smon timer, A-42

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

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

SQL*Net message from client, A-43

SQL*Net message from dblink, A-43

SQL*Net message to client, A-43

SQL*Net message to dblink, A-43

SQL*Net more data from client, A-44

SQL*Net more data from dblink, A-44

SQL*Net more data to client, A-44

SQL*Net more data to dblink, A-45

switch logfile command, A-45

timer in sksawat, A-45

transaction, A-45

unbound tx, A-46

undo segment extension, A-46

undo segment recovery, A-46

undo segment tx slot, A-46

wait events

log buffer space, A-33

WMON goes to sleep, A-12, A-47

write complete, A-47

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