Oracle8i Reference
Release 8.1.5

A67790-01

Library

Product

Contents

Prev

Index

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


A

acquiring rollback segments
distributed locks, 1-46
ALERT file, 1-17
ALL_ALL_TABLES view, 2-2
ALL_ARGUMENTS view, 2-4
ALL_ASSOCIATIONS view, 2-5
ALL_CATALOG view, 2-5
ALL_CLUSTER_HASH_EXPRESSIONS view, 2-7
ALL_CLUSTERS view, 2-6
ALL_COL_COMMENTS view, 2-7
ALL_COL_PRIVS view, 2-7
ALL_COL_PRIVS_MADE view, 2-8
ALL_COL_PRIVS_RECD view, 2-8
ALL_COLL_TYPES view, 2-8
ALL_CONS_COLUMNS view, 2-9
ALL_CONSTRAINTS view, 2-10
ALL_CONTEXT view, 2-11
ALL_DB_LINKS view, 2-11
ALL_DEF_AUDIT_OPTS view, 2-11
ALL_DEPENDENCIES view, 2-12
ALL_DIM_ATTRIBUTES view, 2-13
ALL_DIM_CHILD_OF view, 2-13
ALL_DIM_HIERARCHIES view, 2-14
ALL_DIM_JOIN_KEY view, 2-14
ALL_DIM_LEVEL_KEY view, 2-15
ALL_DIM_LEVELS view, 2-14
ALL_DIMENSIONS view, 2-12
ALL_DIRECTORIES view, 2-15
ALL_ERRORS view, 2-15
ALL_IND_COLUMNS view, 2-16
ALL_IND_PARTITIONS view, 2-16
ALL_IND_SUBPARTITIONS view, 2-18
ALL_INDEXES view, 2-19
ALL_INDEXTYPE_OPERATORS view, 2-22
ALL_INDEXTYPES view, 2-22
ALL_JOBS view, 2-22
ALL_LABELS view, 2-23
ALL_LIBRARIES view, 2-23
ALL_LOB_PARTITIONS view, 2-24
ALL_LOB_SUBPARTITIONS view, 2-25
ALL_LOBS view, 2-24
ALL_METHOD_PARAMS view, 2-26
ALL_METHOD_RESULTS view, 2-27
ALL_MVIEW_AGGREGATES view, 2-27
ALL_MVIEW_ANALYSIS view, 2-28
ALL_MVIEW_DETAIL_RELATIONS view, 2-29
ALL_MVIEW_JOINS view, 2-29
ALL_MVIEW_KEYS view, 2-30
ALL_NESTED_TABLES view, 2-30
ALL_OBJECT_TABLES view, 2-31
ALL_OBJECTS view, 2-33
ALL_OPANCILLARY view, 2-34
ALL_OPARGUMENTS view, 2-34
ALL_OPBINDINGS view, 2-34
ALL_OPERATORS view, 2-35
ALL_OUTLINE_HINTS view, 2-35
ALL_OUTLINES view, 2-35
ALL_PART_COL_STATISTICS view, 2-36
ALL_PART_HISTOGRAMS view, 2-37
ALL_PART_INDEXES view, 2-37
ALL_PART_KEY_COLUMNS view, 2-38
ALL_PART_LOBS view, 2-39
ALL_PART_TABLES view, 2-40
ALL_PARTIAL_DROP_TABS view, 2-41
ALL_POLICIES view, 2-41
ALL_QUEUES view, 2-42
ALL_REFRESH_CHILDREN view, 2-43
ALL_REFRESH_DEPENDENCIES view, 2-44
ALL_REFRESHS view, 2-42
ALL_REGISTERED_SNAPSHOTS view, 2-45
ALL_REPCATLOG view, 2-46
ALL_REPCOLUMN view, 2-46
ALL_REPCOLUMN_GROUP view, 2-46
ALL_REPCONFLICT view, 2-46
ALL_REPDDL view, 2-46
ALL_REPGENERATED view, 2-46
ALL_REPGENOBJECTS view, 2-46
ALL_REPGROUP view, 2-46
ALL_REPGROUPED_COLUMN view, 2-47
ALL_REPKEY_COLUMNS view, 2-47
ALL_REPOBJECT view, 2-47
ALL_REPPARAMETER_COLUMN view, 2-47
ALL_REPPRIORITY view, 2-47
ALL_REPPRIORITY_GROUP view, 2-47
ALL_REPPROP view, 2-47
ALL_REPRESOL_STATS_CONTROL view, 2-48
ALL_REPRESOLUTION view, 2-47
ALL_REPRESOLUTION_METHOD view, 2-48
ALL_REPRESOLUTION_STATISTICS view, 2-48
ALL_REPSITES view, 2-48
ALL_SEQUENCES view, 2-48
ALL_SNAPSHOT_LOGS view, 2-49
ALL_SNAPSHOT_REFRESH_TIMES view, 2-49
ALL_SNAPSHOTS view, 2-49
ALL_SOURCE view, 2-51
ALL_SUBPART_COL_STATISTICS view, 2-51
ALL_SUBPART_HISTOGRAMS view, 2-52
ALL_SUBPART_KEY_COLUMNS view, 2-52
ALL_SUMDELTA view, 2-53
ALL_SUMMARIES view, 2-53
ALL_SYNONYMS view, 2-54
ALL_TAB_COL_STATISTICS view, 2-54
ALL_TAB_COLUMNS view, 2-55
ALL_TAB_COMMENTS view, 2-56
ALL_TAB_HISTOGRAMS view, 2-56
ALL_TAB_PARTITIONS view, 2-57
ALL_TAB_PRIVS view, 2-58
ALL_TAB_PRIVS_MADE view, 2-58
ALL_TAB_PRIVS_RECD view, 2-59
ALL_TAB_SUBPARTITIONS view, 2-59
ALL_TABLES view, 2-60
ALL_TRIGGER_COLS view, 2-64
ALL_TRIGGERS view, 2-63
ALL_TYPE_ATTRS view, 2-64
ALL_TYPE_METHODS view, 2-65
ALL_TYPES view, 2-65
ALL_UPDATABLE_COLUMNS view, 2-65, 2-66, 2-156, 2-260
ALL_USERS view, 2-66
ALL_USTATS view, 2-66
ALL_VARRAYS view, 2-67
ALL_VIEWS view, 2-67
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
ADD LOGFILE, 1-123
database name, 1-33
ENABLE THREAD, 1-123
THREAD, 1-123
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

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

C

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

D

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
scripts, 5-3
SQL scripts, 5-2
tables, 2-1
views, 1-45
overview, 2-1, 2-2
user views, 2-2
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

E

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

F

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

G

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

H

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

I

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
LM_LOCKS, 1-56
LM_PROCS, 1-57
LM_RESS, 1-57
LOCAL_LISTENER, 1-58
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
UTL_FILE_DIR, 1-127
variable, 1-11
INIT.ORA
parameter files, 1-2
INIT.ORA file, 1-2
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

J

JAVA_POOL_SIZE parameter, 1-52
job queue enqueue, B-2
JOB_QUEUE_INTERVAL parameter, 1-52
JOB_QUEUE_PROCESSES parameter, 1-53

K

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

L

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

M

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

N

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

O

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
archiving, 1-66
archiving mode, 1-60
block, 1-67
file size, 1-67
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

P

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

Q

queries
dictionary views, 1-45
hints, 1-88
queries parallelized statistic, C-14
queue messages wait event, A-45
QUEUE_PRIVILEGES view, 2-179

R

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

S

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

T

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

U

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

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

W

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


Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents