Oracle8 Reference
Release 8.0
A58242-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

abbreviations
AM/PM, 4-22
BC/AD, 4-22
acquiring rollback segments
distributed locks, 1-47
ALERT file, 1-17
ALL_ALL_TABLES view, 2-2
ALL_ARGUMENTS view, 2-3
ALL_CATALOG view, 2-4
ALL_CLUSTERS view, 2-4
ALL_COL_COMMENTS view, 2-5
ALL_COL_PRIVS view, 2-6
ALL_COL_PRIVS_MADE view, 2-6
ALL_COL_PRIVS_RECD view, 2-7
ALL_COLL_TYPES view, 2-7
ALL_CONS_COLUMNS view, 2-8
ALL_CONSTRAINTS view, 2-8
ALL_DB_LINKS view, 2-9
ALL_DEF_AUDIT_OPTS view, 2-9
ALL_DEPENDENCIES view, 2-10
ALL_DIRECTORIES view, 2-10
ALL_ERRORS view, 2-10
ALL_IND_COLUMNS view, 2-11
ALL_IND_PARTITIONS view, 2-11
ALL_INDEXES view, 2-12
ALL_LABELS view, 2-14
ALL_LIBRARIES view, 2-14
ALL_LOBS view, 2-15
ALL_METHOD_PARAMS view, 2-15
ALL_METHOD_RESULTS view, 2-16
ALL_NESTED_TABLES view, 2-16
ALL_OBJECT_TABLES view, 2-16
ALL_OBJECTS view, 2-18
ALL_PART_COL_STATISTICS view, 2-19
ALL_PART_HISTOGRAMS view, 2-19
ALL_PART_INDEXES view, 2-19
ALL_PART_KEY_COLUMNS view, 2-21
ALL_PART_TABLES view, 2-21
ALL_REFRESH view, 2-23
ALL_REFRESH_CHILDREN view, 2-23
ALL_REFRESHS view, 2-22
ALL_REFS view, 2-23
ALL_REGISTERED_SNAPSHOTS view, 2-24
ALL_REPCATLOG view, 2-24
ALL_REPCOLUMN view, 2-24
ALL_REPCOLUMN_GROUP view, 2-25
ALL_REPCONFLICT view, 2-25
ALL_REPDDL view, 2-25
ALL_REPGENERATED view, 2-25
ALL_REPGROUP view, 2-25
ALL_REPGROUPED_COLUMN view, 2-25
ALL_REPKEY_COLUMNS view, 2-25
ALL_REPOBJECT view, 2-25
ALL_REPPARAMETER_COLUMN view, 2-25
ALL_REPPRIORITY view, 2-26
ALL_REPPRIORITY_GROUP view, 2-26
ALL_REPPROP view, 2-26
ALL_REPRESOL_STATS_CONTROL view, 2-26
ALL_REPRESOLUTION view, 2-26
ALL_REPRESOLUTION_METHOD view, 2-26
ALL_REPRESOLUTION_STATISTICS view, 2-26
ALL_REPSITES view, 2-26
ALL_SEQUENCES view, 2-26
ALL_SNAPSHOT_LOGS view, 2-27
ALL_SNAPSHOT_REFRESH_TIMES view, 2-28
ALL_SNAPSHOTS view, 2-28
ALL_SOURCE view, 2-29
ALL_SYNONYMS view, 2-30
ALL_TAB_COL_STATISTICS view, 2-30
ALL_TAB_COLUMNS view, 2-30
ALL_TAB_COMMENTS view, 2-31
ALL_TAB_HISTOGRAMS view, 2-32
ALL_TAB_PARTITIONS view, 2-32
ALL_TAB_PRIVS view, 2-33
ALL_TAB_PRIVS_MADE view, 2-34
ALL_TAB_PRIVS_RECD view, 2-34
ALL_TABLES view, 2-34
ALL_TRIGGER_COLS view, 2-37
ALL_TRIGGERS view, 2-36
ALL_TYPE_ATTRS view, 2-37
ALL_TYPE_METHODS view, 2-38
ALL_TYPES view, 2-38
ALL_UPDATABLE_COLUMNS view, 2-39
ALL_USERS view, 2-39
ALL_VIEWS view, 2-39
ALLOCATE EXTENT option
instance number, 1-51
allocation
archival buffer, 1-60
PCM locks, 1-44
rollback segments, 1-106
ALLOW_PARTIAL_SN_RESULTS parameter, 1-13
ALTER DATABASE command
ADD LOGFILE, 1-121
database name, 1-34
ENABLE THREAD, 1-121
THREAD, 1-121
ALTER SESSION command
SET HASH_AREA_SIZE option, 1-48
SET HASH_JOIN_ENABLED option, 1-48
SET NLS_* options, 4-9
SET NLS_CURRENCY option, 4-20, 4-23
SET NLS_DATE_FORMAT option, 4-21
SET NLS_LANGUAGE option, 4-12
SET NLS_NUMERIC_CHARACTERS option, 4-24
SET NLS_TERRITORY option, 4-12
ALTER SYSTEM command
SET NLS_LANGUAGE option, 4-12
alter system set mts_dispatchers wait event, A-16
ALTER TABLE statement
allocating extents, 1-51
alternate character mappings, 4-5
ALWAYS_ANTI_JOIN parameter, 1-13
ALWAYS_SEMI_JOIN parameter, 1-14
AM/PM abbreviation
language of, 4-22
ANALYZE command, 2-12, 2-30, 2-34, 2-60, 2-89, 2-92, 2-137, 2-161, 2-164
applications
language behavior for, 4-12
NLS support, 4-2
AQ_TM_PROCESSES parameter, 1-14
Arabic character set, 4-6
ARCH_IO_SLAVES parameter, 1-14
ARCHIVE LOG command
destination file, 1-60
START and STOP, 1-63
archived redo log
automatic versus manual, 1-63
buffer, 1-59, 1-60
storage device, 1-60, 1-62
tuning, 1-59, 1-60
ARCHIVELOG mode
archiving destination, 1-60, 1-61
automatic archiving, 1-63
ASCII character set
sorting order, 4-13
AUDIT_ACTIONS table, 2-40
AUDIT_FILE_DEST parameter, 1-15
AUDIT_TRAIL parameter, 1-15
authenticating remote clients, 1-104
authenticating users, 1-91

B

B_TREE_BITMAP_PLANS parameter, 1-16
background checkpoints completed statistic, C-4
background checkpoints started statistic, C-4
background processes
SNP background process, 1-52
specifying trace files, 1-16
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-17
BC/AD abbreviation
language of, 4-22
being written redo log enqueue, B-2
binary sorting, 4-13
bind enqueue, B-1
BITMAP_MERGE_AREA_SIZE parameter, 1-18
BLANK_TRIMMING parameter, 1-18
block
PCM lock, 1-44
redo log, 1-59, 1-64
rollback segment, 1-47
size, 1-30
when written to disk, 1-47
block size, 5-3
buffer busy waits wait event, A-17
buffer cache
database, 1-26
buffer cache management enqueue, B-1
buffer deadlock wait event, A-17
buffer for checkpoint wait event, A-18
buffer latch wait event, A-18
buffer read retry wait event, A-19
BUFFER_POOL_KEEP parameter, 1-19
BUFFER_POOL_RECYCLE parameter, 1-19
buffers
archival, 1-59, 1-60
effect on performance, 1-28
number of, 1-26, 1-28
bytes received via SQL*Net from client statistic, C-4
bytes received via SQL*Net from dblink statistic, C-4
bytes sent via SQL*Net to client statistic, C-4
bytes sent via SQL*Net to dblink statistic, C-5

C

cache
database blocks, 1-26
dictionary, 3-77
row cache, 1-106
sequence cache, 1-107, 1-108
statistics, 1-64
CACHE_SIZE_THRESHOLD parameter, 1-19
calendar systems, 4-19
supported, 4-54
calendars, 4-54
calls to get snapshot scn
kcmgss statistic, C-5
CAT synonym for USER_CATALOG view, 2-40
CAT8000.SQL script, 6-6
CATALOG view, 2-40
CATALOG.SQL
creating V$ views, 3-1
CATALOG.SQL script, 6-2
CATAUDIT.SQL script
audit trail records created by, 2-126
audit trails for connections and disconnections, 2-127
auditing options created by, 2-146
CATBLOCK.SQL script, 6-2
CATEXP7.SQL script, 6-2
CATHS.SQL script, 6-2
CATIO.SQL script, 6-3
CATNOADT.SQL script, 6-5
CATNOAUD.SQL script, 6-5
CATNOHS.SQL script, 6-5
CATNOPRT.SQL script, 6-5
CATNOQUEUE.SQL script, 6-5
CATNORMN.SQL script, 6-5
CATNOSNMP.SQL script, 6-5
CATNOSVM.SQL script, 6-5
CATOCTK.SQL script, 6-3
CATPARR.SQL script, 6-3
CATPROC.SQL script, 6-2
CATREP8M.SQL script, 6-6
CATREP.SQL script, 6-3
CATRMAN.SQL script, 6-3
CHAINED_ROWS view, 2-40
change write time statistic, C-5
CHAR datatype
multi-byte character sets and, 4-27
character data
binary sorts, 4-14
linguistic sorts, 4-14
special cases, 4-14
sorting, 4-13
character encoding schemes, 4-3
character sets
8-bit versus 7-bit, 4-34
conversion, 4-26
CONVERT function, 4-34
converting, 4-34
encoding schemes, 4-3
fixed-width multi-byte encoding schemes, 4-5
loadable character sets, 4-27
multi-byte, 4-27
pattern matching characters, 4-5
single-byte 7-bit ASCII, 4-4
single-byte 8-bit ASCII, 4-4
sorting data, 4-13
specifying, 4-25
supported, 4-26
varying-width multi-byte encoding schemes, 4-4
character string functionality and character sets
supported, 4-26
characters
numeric group separators, 1-81
checkpoint completed wait event, A-19
checkpoint range buffer not saved wait event, A-19
checkpoints
checkpoint interval, 1-64
statistics, 1-64
choosing character sets
guidelines, 4-7
CHR(n USING NCHAR_CS) function, 4-7
CLEANUP_ROLLBACK_ENTRIES parameter, 1-20
client/server architecture considerations, 4-12
CLOSE_CACHED_OPEN_CURSORS parameter, 1-20
CLU synonym for USER_CLUSTERS, 2-40
cluster key scan block gets statistic, C-5
cluster key scans statistic, C-5
CODE_PIECES view, 2-41
CODE_SIZE view, 2-41
COL view, 2-41
COLS synonym for USER_TAB_COLUMNS, 2-41
COLUMN_PRIVILEGES view, 2-41
commit cleanout failures
block lost statistic, C-5
buffer being written statistic, C-5
callback failure statistic, C-5
cannot pin statistic, C-5
hot backup in progress statistic, C-5
write disabled statistic, C-6
commit cleanouts statistic, C-6
commit cleanouts successfully completed statistic, C-6
COMMIT_POINT_STRENGTH parameter, 1-21
COMPATIBLE parameter, 1-21
COMPATIBLE_NO_RECOVERY parameter, 1-22
COMPLEX_VIEW_MERGING parameter, 1-22
concatenation operator, 4-27
concurrency
ROW_LOCKING parameter, 1-107
sequences, 1-107, 1-108
transactions and, 1-123
transactions per rollback segment, 1-123
connecting, 1-78
consistency
multiversion read, 1-47
rollback information, 1-47
consistent changes statistic, C-6
consistent gets statistic, C-6
contention
block-level, 3-113
context areas
sort spacemap, 1-116
control file parallel write wait event, A-20
control file sequential read wait event, A-20
control file single write wait event, A-21
control files
names, 1-24
specifying, 1-24
CONTROL_FILE_RECORD_KEEP_TIME parameter, 1-23
CONTROL_FILES parameter, 1-24
controlfile transaction enqueue, B-1
conversion file read wait event, A-21
conversions
between character set ID number and character set name, 4-36
CONVERT function, 4-34
converting character sets, 4-34
CORE_DUMP_DEST parameter, 1-24
cost-based optimizer, 1-87, 1-88
CPU used by this session statistic, C-1
CPU_COUNT parameter, 1-24
CR blocks created statistic, C-2
CREATE DATABASE command
database name, 1-34
MAXLOGFILES option, 1-66
setting the block size, 1-30
setting the log mode, 1-63
CREATE TABLE statement
FREELIST GROUPS option, 1-51
CREATE_BITMAP_AREA_SIZE parameter, 1-25
creating
databases
setting block size, 1-29, 1-30
cross instance CR read statistic, C-6
cross-instance call invocation enqueue, B-1
currency, 1-79
international currency symbol, 1-80
monetary units characters, 4-31
currency symbol
default, 4-16
local currency symbol, 4-19
Current blocks converted for CR statistic, C-2
CURSOR_SPACE_FOR_TIME parameter, 1-25
cursors
OPEN_CURSORS parameter, 1-84
row cache, 1-106
shared pool, 1-49, 1-111, 1-113

D

data
conversion, 4-34
CONVERT function, 4-34
data blocks
reading multiple, 1-32
size of, 1-29, 1-30
data dictionary, 2-1
cache, 3-77
datafiles, 1-45
DICTIONARY view, 2-114
rollback segments, 1-106
row cache, 1-106
scripts, 6-2
sequence cache, 1-107, 1-108
SQL scripts, 6-1
tables, 2-1
views, 1-45
overview, 2-1
user views, 2-1
database block size, 5-3
database character sets, 4-5
choosing, 4-6
uses for, 4-6
database mount enqueue, B-1
database writer process (DBWR)
checkpoint, 1-64
databases
database limits, 5-1
default language, 1-81
name, 1-34, 1-35
number of redo log files, 1-66
resource limits, 1-105
valid characters for database name, 1-34
datafile enqueue, B-1
datafiles
mapping blocks to PCM locks, 1-44
maximum number, 1-31
parameter, 1-31, 1-32
unspecified for PCM locks, 1-45
Date formats, 4-20
and partition bound expressions, 4-21
dates
ISO standard, 4-28
language used for, 1-80
NLS_DATE_LANGUAGE parameter, 4-22
NLS_TERRITORY parameter, 4-16
setting SYSDATE, 1-42
TO_CHAR and TO_DATE functions, 1-79
day
format element, 4-22
language of names, 4-22
db block changes statistic, C-6
db block gets statistic, C-7
db file parallel write wait event, A-22
db file scattered read wait event, A-22
db file sequential read wait event, A-23
db file single write wait event, A-23
DB_BLOCK_BUFFERS parameter, 1-26
DB_BLOCK_CHECKPOINT_BATCH parameter, 1-26
DB_BLOCK_CHECKSUM parameter, 1-27
DB_BLOCK_LRU_EXTENDED_STATISTICS parameter, 1-27
DB_BLOCK_LRU_LATCHES parameter, 1-28
DB_BLOCK_LRU_STATISTICS parameter, 1-28
DB_BLOCK_MAX_DIRTY_TARGET parameter, 1-29
DB_BLOCK_SIZE parameter, 1-30
DB_DOMAIN parameter, 1-30
DB_FILE_DIRECT_IO_COUNT parameter, 1-32
DB_FILE_MULTIBLOCK_READ_COUNT parameter, 1-32
DB_FILE_NAME_CONVERT parameter, 1-33
DB_FILE_SIMULTANEOUS_WRITES parameter, 1-33
DB_FILES parameter, 1-31
DB_NAME parameter, 1-34
DB_WRITER_PROCESSES parameter, 1-35
DBA_2PC_NEIGHBORS view, 2-42
DBA_2PC_PENDING view, 2-42
DBA_ALL_TABLES view, 2-43
DBA_AUDIT_EXISTS view, 2-44
DBA_AUDIT_OBJECT view, 2-45
DBA_AUDIT_SESSION view, 2-47
DBA_AUDIT_STATEMENT view, 2-47
DBA_AUDIT_TRAIL view, 2-49
DBA_BLOCKERS view, 2-50
DBA_CATALOG view, 2-51
DBA_CLU_COLUMNS view, 2-51
DBA_CLUSTERS view, 2-51
DBA_COL_COMMENTS view, 2-52
DBA_COL_PRIVS view, 2-52
DBA_COLL_TYPES view, 2-53
DBA_CONS_COLUMNS view, 2-54
DBA_CONSTRAINTS view, 2-53
DBA_DATA_FILES view, 1-45, 2-55, 2-104
DBA_DB_LINKS view, 2-55
DBA_DDL_LOCKS view, 2-55
DBA_DEPENDENCIES view, 2-56
DBA_DIRECTORIES view, 2-56
DBA_DML_LOCKS view, 2-57
DBA_ERRORS view, 2-57
DBA_EXP_FILES view, 2-58
DBA_EXP_OBJECTS view, 2-58
DBA_EXP_VERSION view, 2-59
DBA_EXTENTS view, 2-59
DBA_FREE_SPACE view, 2-59
DBA_FREE_SPACE_COALESCED view, 2-60
DBA_IND_COLUMNS view, 2-62
DBA_IND_PARTITIONS view, 2-62
DBA_INDEXES view, 2-60
DBA_JOBS view, 2-63
DBA_JOBS_RUNNING view, 2-65
DBA_LIBRARIES view, 2-65
DBA_LOBS view, 2-65
DBA_LOCKS view, 2-66
DBA_METHOD_PARAMS view, 2-66
DBA_METHOD_RESULTS view, 2-67
DBA_NESTED_TABLES view, 2-67
DBA_OBJ_AUDIT_OPTS view, 2-70
DBA_OBJECT_SIZE view, 2-68
DBA_OBJECT_TABLES view, 2-68
DBA_OBJECTS view, 2-70
DBA_PART_COL_STATISTICS view, 2-71
DBA_PART_HISTOGRAMS view, 2-72
DBA_PART_INDEXES view, 2-72
DBA_PART_KEY_COLUMNS view, 2-73
DBA_PART_TABLES view, 2-73
DBA_PRIV_AUDIT_OPTS view, 2-74
DBA_PROFILES view, 2-75
DBA_QUEUE_SCHEDULES view, 2-75
DBA_QUEUE_TABLES view, 2-75
DBA_QUEUES view, 2-76
DBA_RCHILD view, 2-77
DBA_REFRESH view, 2-77
DBA_REFRESH_CHILDREN view, 2-78
DBA_REFS view, 2-78
DBA_REGISTERED_SNAPSHOT_GROUPS view, 2-79
DBA_REGISTERED_SNAPSHOTS view, 2-79
DBA_REPCATLOG view, 2-80
DBA_REPCOLUMN view, 2-80
DBA_REPCOLUMN_GROUP view, 2-80
DBA_REPCONFLICT view, 2-80
DBA_REPDDL view, 2-80
DBA_REPGENERATED view, 2-80
DBA_REPGROUP view, 2-80
DBA_REPGROUPED_COLUMN view, 2-80
DBA_REPKEY_COLUMNS view, 2-81
DBA_REPOBJECT view, 2-81
DBA_REPPARAMETER_COLUMN view, 2-81
DBA_REPPRIORITY view, 2-81
DBA_REPPRIORITY_GROUP view, 2-81
DBA_REPPROP view, 2-81
DBA_REPRESOL_STATS_CONTROL view, 2-81
DBA_REPRESOLUTION view, 2-81
DBA_REPRESOLUTION_METHOD view, 2-81
DBA_REPSITES view, 2-82
DBA_RGROUP view, 2-82
DBA_ROLE_PRIVS view, 2-83
DBA_ROLES view, 2-82
DBA_ROLLBACK_SEGS view, 2-83
DBA_SEGMENTS view, 2-84
DBA_SEQUENCES view, 2-84
DBA_SNAPSHOT_LOGS view, 2-85
DBA_SNAPSHOT_REFRESH_TIMES view, 2-85
DBA_SNAPSHOTS view, 2-86
DBA_SOURCE view, 2-87
DBA_STMT_AUDIT_OPTS view, 2-87
DBA_SYNONYMS view, 2-88
DBA_SYS_PRIVS view, 2-88
DBA_TAB_COL_STATISTICS view, 2-88
DBA_TAB_COLUMNS view, 2-89
DBA_TAB_COMMENTS view, 2-90
DBA_TAB_HISTOGRAMS view, 2-90
DBA_TAB_PARTITIONS view, 2-90
DBA_TAB_PRIVS view, 2-91
DBA_TABLES view, 2-92
DBA_TABLESPACES view, 2-94
DBA_TRIGGER_COLS view, 2-95
DBA_TRIGGERS view, 2-94
DBA_TS_QUOTAS view, 2-95
DBA_TYPE_ATTRS view, 2-95
DBA_TYPE_METHODS view, 2-96
DBA_TYPES view, 2-96
DBA_UPDATABLE_COLUMNS view, 2-97
DBA_USERS view, 2-97
DBA_VIEWS view, 2-98
DBLINK_ENCRYPT_LOGIN parameter, 1-35
DBMS_ALERT_INFO view, 2-98
DBMS_LOCK_ALLOCATED view, 2-99
DBMSIOTC.SQL script, 6-3
DBMSOTRC.SQL script, 6-3
DBMSPOOL.SQL script, 6-3
DBWR buffers scanned statistic, C-2
DBWR checkpoints statistic, C-2
DBWR cross instance writes statistic, C-2
DBWR Flush object call found no dirty buffers statistic, C-2
DBWR Flush object cross instance calls statistic, C-2
DBWR free buffers found statistic, C-2
DBWR lru scans statistic, C-3
DBWR make free requests statistic, C-3
DBWR summed scan depth statistic, C-3
DBWR timeouts statistic, C-3
DBWR_IO_SLAVES parameter, 1-36
DDL statements parallelized statistic, C-3
debit symbol, 4-30
decimal character
default, 4-16
NLS_NUMERIC_CHARACTERS parameter, 4-23
when not a period (.), 4-24
DEFCALL view, 2-99
DEFCALLDEST view, 2-99
DEFDEFAULTDEST view, 2-99
DEFERRCOUNT view, 2-99
DEFERROR view, 2-99
DEFLOB view, 2-99
DEFPROPAGATOR view, 2-100
DEFSCHEDULE view, 2-100
DEFTRAN view, 2-100
DEFTRANDEST view, 2-100
DELAYED_LOGGING_BLOCK_CLEANOUTS parameter, 1-36
DEPTREE view, 2-100
derived parameters, 1-9
destination
archiving redo log files, 1-60
overriding default, 1-60
USER_DUMP_DEST, 1-124
devices
storage, 1-116
DFS db file lock wait event, A-10
DFS lock handle wait event, A-10
DICT synonym for DICTIONARY, 2-100
DICT_COLUMNS view, 2-101
DICTIONARY view, 2-101
DICT synonym, 2-100
direct loader index creation enqueue, B-1
direct path read wait event, A-23
direct path write wait event, A-24
dirty buffers inspected statistic, C-7
DISCRETE_TRANSACTIONS_ENABLED parameter, 1-37
disk drives
archiving destination, 1-60
writing blocks, 1-47
DISK_ASYNCH_IO parameter, 1-38
dispatcher processes
configuration, 1-70
maximum number, 1-74
dispatcher shutdown wait event, A-24
dispatcher timer wait event, A-25
distributed lock
exclusive, 1-46, 1-47
rollback segment, 1-47
distributed queries
disabling, 1-85
enabling, 1-85
links for, 1-85
distributed recovery enqueue, B-1
distributed transactions
limiting number of, 1-39
distributed TX enqueue, B-1
DISTRIBUTED_LOCK_TIMEOUT parameter, 1-38
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME parameter, 1-39
DISTRIBUTED_TRANSACTIONS parameter, 1-39
DML enqueue, B-2
DML statements parallelized statistic, C-3
DML_LOCKS parameter, 1-40
PDML restrictions, 1-40
DROPCAT5.SQL script, 6-6
DROPCAT6.SQL script, 6-6
dump files, 1-69
duplicate cluster key wait event, A-25
dynamic initialization parameters, 1-5
dynamic performance tables
CATALOG.SQL script, 3-1
public synonyms (V$), 3-1
views (V_$), 3-1

E

EBCDIC character set
sorting order, 4-13
embedded parameter files, 1-50
enqueue conversions statistic, C-7
enqueue deadlocks statistic, C-7
enqueue releases statistic, C-7
enqueue requests statistic, C-7
enqueue timeouts statistic, C-7
enqueue wait event, A-25
enqueue waits statistic, C-7
ENQUEUE_RESOURCES parameter, 1-41
enqueues
disabling, 1-40
ENQUEUE_RESOURCES parameter, 1-41
environment variables
client environment, 4-30
NLS parameters, 4-9, 4-29
NLS_LANG, 4-10
ERROR_SIZE view, 2-101
errors
archiving, 1-63
EVENT parameter, 1-42
EXCEPTIONS view, 2-101
exchange deadlocks statistic, C-7
exclusive distributed lock
rollback data, 1-47
exclusive mode
specifying instance number, 1-51
execute count statistic, C-7
extent
allocating to instance, 1-51

F

FAST_FULL_SCAN_ENABLED parameter, 1-42
file identify wait event, A-26
file open wait event, A-26
file set enqueue, B-1
FILE_LOCK view, 2-102
FILE_PING view, 2-102
filenames
case significance, 1-3
name and number, 1-44
FILEXT$ view, 2-104, 3-3
FIRST_ROWS, 1-88
FIXED_DATE parameter, 1-42
format elements, 4-28, 4-29
C, 4-29
D, 4-24, 4-29
day, 4-22
G, 4-24, 4-29
IW, 4-29
IY, 4-29
L, 4-19, 4-29
month, 4-22
RM, 4-20, 4-28
RN, 4-29
free buffer inspected statistic, C-8
free buffer requested statistic, C-8
free buffer waits wait event, A-26
free global transaction table entry wait event, A-26
free process state object wait event, A-27
free space list
locating space, 1-51
FREELIST GROUPS storage option, 1-51
FREELISTS storage option
maximum value, 1-30
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-46
GC_RELEASABLE_LOCKS parameter, 1-46
GC_ROLLBACK_LOCKS parameter, 1-47
global cache cleanup wait event, A-27
global cache control parameters, 1-9
global cache defers statistic, C-8
global cache freelist waits statistic, C-8
global cache hash latch waits statistic, C-8
global cache lock busy wait event, A-27
global cache lock cleanup wait event, A-27
global cache lock null to s wait event, A-28
global cache lock null to x wait event, A-28
global cache lock open null wait event, A-28
global cache lock open s wait event, A-29
global cache lock open ss wait event, A-29
global cache lock open x wait event, A-29
global cache locks s to x wait event, A-30
global constant parameter
rollback segments, 1-47
global lock convert time statistic, C-8
global lock converts (async) statistic, C-8
global lock converts (non async) statistic, C-8
global lock get time statistic, C-8
global lock gets (async) statistic, C-9
global lock gets (non async) statistic, C-9
global lock release time statistic, C-9
global lock releases statistic, C-9
GLOBAL_NAME view, 2-104
GLOBAL_NAMES parameter, 1-47
group separator, 4-23
default, 4-16
NLS_NUMERIC_CHARACTERS parameter, 4-23
GV$ views
for parallel servers, 3-2
restrictions on, 3-2

H

HASH_AREA_SIZE parameter, 1-48
HASH_JOIN_ENABLED parameter, 1-48
HASH_MULTIBLOCK_IO_COUNT parameter, 1-48
Hebrew character set, 4-6
Heterogeneous Services Parameters, 1-10
HI_SHARED_MEMORY_ADDRESS parameter, 1-49
hints
FIRST_ROWS, 1-88
RULE, 1-87, 1-88
HS_ALL_CAPS view, 2-104
HS_ALL_DD view, 2-105
HS_ALL_INITS view, 2-105
HS_BASE_CAPS view, 2-105
HS_BASE_DD view, 2-106
HS_CLASS_CAPS view, 2-106
HS_CLASS_DD view, 2-106
HS_CLASS_INIT view, 2-107
HS_EXTERNAL_OBJECT_PRIVILEGES view, 2-107
HS_EXTERNAL_OBJECTS view, 2-107
HS_EXTERNAL_USER_PRIVILEGES view, 2-108
HS_FDS_CLASS view, 2-108
HS_FDS_INST view, 2-108
HS_INST_CAPS view, 2-109
HS_INST_DD view, 2-109
HS_INST_INIT view, 2-110

I

I/O
reading multiple blocks, 1-32
redo log files, 1-64
reducing with buffer cache, 1-26
IDEPTREE view, 2-110
IFILE, 1-3
IFILE keyword
nested files, 1-50
IFILE parameter, 1-50
inactive session wait event, A-30
inactive transaction branch wait event, A-30
IND synonym for USER_INDEXES, 2-111
index block split wait event, A-31
INDEX_HISTOGRAM view, 2-111
INDEX_STATS view, 2-111
indexes
FREELISTS option, 1-30
partitioned, 4-37
sort spacemap, 1-116
INITDW.ORA file, 1-1
initialization parameters
ALLOW_PARTIAL_SN_RESULTS, 1-13
altering, 1-5
ALWAYS_ANTI_JOIN, 1-13
ALWAYS_SEMI_JOIN, 1-14
AQ_TM_PROCESSES, 1-14
ARCH_IO_SLAVES, 1-14
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-20
CLOSE_CACHED_OPEN_CURSORS, 1-20
COMMIT_POINT_STRENGTH, 1-21
COMPATIBLE, 1-21
COMPATIBLE_NO_RECOVERY, 1-22
COMPLEX_VIEW_MERGING, 1-22
CONTROL_FILE_RECORD_KEEP_TIME, 1-23
CONTROL_FILES, 1-24
controlling archiving, 1-59
CORE_DUMP_DEST, 1-24
CPU_COUNT, 1-24
CREATE_BITMAP_AREA_SIZE, 1-25
CURSOR_SPACE_FOR_TIME, 1-25
database creation, 1-34
DB_BLOCK_BUFFERS, 1-26
DB_BLOCK_CHECKPOINT_BATCH, 1-26
DB_BLOCK_CHECKSUM, 1-27
DB_BLOCK_LRU_EXTENDED_STATISTICS, 1-27
DB_BLOCK_LRU_LATCHES, 1-28
DB_BLOCK_LRU_STATISTICS, 1-28
DB_BLOCK_MAX_DIRTY_TARGET, 1-29
DB_BLOCK_SIZE, 1-30
DB_DOMAIN, 1-30
DB_FILE_DIRECT_IO_COUNT, 1-32
DB_FILE_MULTIBLOCK_READ_COUNT, 1-32
DB_FILE_NAME_CONVERT, 1-33
DB_FILE_SIMULTANEOUS_WRITES, 1-33
DB_FILES, 1-31
DB_NAME, 1-34
DB_WRITER_PROCESSES, 1-35
DBLINK_ENCRYPT_LOGIN, 1-35
DBWR_IO_SLAVES, 1-36
DELAYED_LOGGING_BLOCK_CLEANOUTS, 1-36
derived parameters, 1-9
DISCRETE_TRANSACTIONS_ENABLED, 1-37
DISK_ASYNCH_IO, 1-38
display current settings, 1-8
DISTRIBUTED_LOCK_TIMEOUT, 1-38
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME, 1-39
DISTRIBUTED_TRANSACTIONS, 1-39
DML_LOCKS, 1-40
dynamic, 1-5
ENQUEUE_RESOURCES, 1-41
EVENT, 1-42
FAST_FULL_SCAN_ENABLED, 1-42
FIXED_DATE, 1-42
FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY, 1-43
GC parameters, 1-9
GC_DEFER_TIME, 1-44
GC_FILES_TO_LOCKS, 1-44
GC_LATCHES, 1-45
GC_LCK_PROCS, 1-46
GC_RELEASABLE_LOCKS, 1-46
GC_ROLLBACK_LOCKS, 1-47
global cache, 1-9
global constant parameters, 1-9
GLOBAL_NAMES, 1-47
HASH_AREA_SIZE, 1-48
HASH_JOIN_ENABLED, 1-48
HASH_MULTIBLOCK_IO_COUNT, 1-48
HI_SHARED_MEMORY_ADDRESS, 1-49
IFILE, 1-50
INSTANCE_GROUPS, 1-50
INSTANCE_NUMBER, 1-51
JOB_QUEUE_INTERVAL, 1-51
JOB_QUEUE_PROCESSES, 1-52
language-dependent NLS, 4-8
LARGE_POOL_MIN_ALLOC, 1-52
LARGE_POOL_SIZE, 1-53
LICENSE_MAX_SESSIONS, 1-54
LICENSE_MAX_USERS, 1-54
LICENSE_SESSIONS_WARNING, 1-55
LM_LOCKS, 1-55
LM_PROCS, 1-56
LM_RESS, 1-57
LOCAL_LISTENER, 1-57
LOCK_NAME_SPACE, 1-58
LOCK_SGA, 1-58
LOCK_SGA_AREAS, 1-59
LOG_ARCHIVE_BUFFER_SIZE, 1-59
LOG_ARCHIVE_BUFFERS, 1-60
LOG_ARCHIVE_DEST, 1-60
LOG_ARCHIVE_DUPLEX_DEST, 1-61
LOG_ARCHIVE_FORMAT, 1-61
LOG_ARCHIVE_MIN_SUCCEED_DEST, 1-62
LOG_ARCHIVE_START, 1-62
LOG_BLOCK_CHECKSUM, 1-63
LOG_BUFFER, 1-63
LOG_CHECKPOINT_INTERVAL, 1-64
LOG_CHECKPOINT_TIMEOUT, 1-65
LOG_CHECKPOINTS_TO_ALERT, 1-65
LOG_FILE_NAME_CONVERT, 1-66
LOG_FILES, 1-66
LOG_SIMULTANEOUS_COPIES, 1-67
LOG_SMALL_ENTRY_MAX_SIZE, 1-67
MAX_COMMIT_PROPAGATION_DELAY, 1-68
MAX_DUMP_FILE_SIZE, 1-68
MAX_ENABLED_ROLES, 1-69
MAX_PARALLEL_SERVER parameter, 3-2
MAX_ROLLBACK_SEGMENTS, 1-69
MAX_TRANSACTION_BRANCHES, 1-70
MTS_DISPATCHERS, 1-70
MTS_LISTENER_ADDRESS, 1-73
MTS_MAX_DISPATCHERS, 1-74
MTS_MAX_SERVERS, 1-74
MTS_MULTIPLE_LISTENERS, 1-75
MTS_RATE_LOG_SIZE, 1-75
MTS_RATE_SCALE, 1-76
MTS_SERVERS, 1-77
MTS_SERVICE, 1-78
NLS_CALENDAR, 1-78
NLS_CALENDAR parameter, 4-19
NLS_CURRENCY, 1-79
NLS_DATE_FORMAT, 1-79
NLS_DATE_LANGUAGE, 1-80
NLS_DEBIT parameter, 4-30
NLS_ISO_CURRENCY, 1-80
NLS_LANGUAGE, 1-81
NLS_LIST_SEPARATOR parameter, 4-30, 4-31
NLS_MONETARY_CHARACTERS parameter, 4-31
NLS_NCHAR parameter, 4-31
NLS_NUMERIC_CHARACTERS, 1-81
NLS_SORT, 1-82
NLS_TERRITORY, 1-83
O7_DICTIONARY_ACCESSIBILITY, 1-12
OBJECT_CACHE_MAX_SIZE_PERCENT, 1-83
OBJECT_CACHE_OPTIMAL_SIZE, 1-84
OGMS_HOME, 1-84
OPEN_CURSORS, 1-84
OPEN_LINKS, 1-85
OPEN_LINKS_PER_INSTANCE, 1-86
operating system dependent parameters, 1-10
OPS_ADMIN_GROUP, 1-86, 3-2
OPTIMIZER_FEATURES_ENABLED, 1-87
OPTIMIZER_MODE, 1-87
OPTIMIZER_PERCENT_PARALLEL, 1-88
OPTIMIZER_SEARCH_LIMIT, 1-88
ORACLE_TRACE_COLLECTION_NAME, 1-88
ORACLE_TRACE_COLLECTION_PATH, 1-89
ORACLE_TRACE_COLLECTION_SIZE, 1-89
ORACLE_TRACE_ENABLE, 1-89
ORACLE_TRACE_FACILITY_NAME, 1-90
ORACLE_TRACE_FACILITY_PATH, 1-90
OS_AUTHENT_PREFIX, 1-91
OS_ROLES, 1-91
overview, 1-1
PARALLEL_ADAPTIVE_MULTI_USER, 1-92
PARALLEL_BROADCAST_ENABLED, 1-92
PARALLEL_DEFAULT_MAX_INSTANCES, 1-93
PARALLEL_EXECUTION_MESSAGE_SIZE, 1-93
PARALLEL_INSTANCE_GROUP, 1-94
PARALLEL_MAX_SERVERS, 1-94
PARALLEL_MIN_MESSAGE_POOL, 1-95
PARALLEL_MIN_PERCENT, 1-96
PARALLEL_MIN_SERVERS, 1-96
PARALLEL_SERVER, 1-97
PARALLEL_SERVER_IDLE_TIME, 1-97
PARALLEL_TRANSACTION_RESOURCE_TIMEOUT, 1-97
PARTITION_VIEW_ENABLED, 1-98
performance tuning, 1-10
PLSQL_V2_COMPATIBILITY, 1-98
PRE_PAGE_SGA, 1-100
PROCESSES, 1-100
PUSH_JOIN_PREDICATE, 1-101
READ_ONLY_OPEN_DELAYED, 1-101
RECOVERY_PARALLELISM, 1-102
REDUCE_ALARM, 1-103
REMOTE_DEPENDENCIES_MODE, 1-103
REMOTE_LOGIN_PASSWORDFILE, 1-103
REMOTE_OS_AUTHENT, 1-104
REMOTE_OS_ROLES, 1-104
REPLICATION_DEPENDENCY_TRACKING, 1-105
RESOURCE_LIMIT, 1-105
rollback segments, 1-123
ROLLBACK_SEGMENTS, 1-105
ROW_CACHE_CURSORS, 1-106
ROW_LOCKING, 1-107
SEQUENCE_CACHE_ENTRIES, 1-107
SEQUENCE_CACHE_HASH_BUCKET, 1-108
SERIAL_REUSE, 1-108
SESSION_CACHED_CURSORS, 1-109
SESSION_MAX_OPEN_FILES, 1-109
SESSIONS, 1-110
SHADOW_CORE_DUMP, 1-110
SHARED_MEMORY_ADDRESS, 1-111
SHARED_POOL_RESERVED_MIN_ALLOC, 1-111
SHARED_POOL_RESERVED_SIZE, 1-112, 3-91
SHARED_POOL_SIZE, 1-113
SORT_AREA_RETAINED_SIZE, 1-113
SORT_AREA_SIZE, 1-114
SORT_DIRECT_WRITES, 1-115
SORT_READ_FAC, 1-115
SORT_SPACEMAP_SIZE, 1-116
SORT_WRITE_BUFFER_SIZE, 1-116
SORT_WRITE_BUFFERS, 1-117
specifying in parameter files, 1-2
SPIN_COUNT, 1-117
SQL_TRACE, 1-118
SQL92_SECURITY, 1-118
STAR_TRANSFORMATION_ENABLED, 1-119
TEMPORARY_TABLE_LOCKS, 1-120
TEXT_ENABLE, 1-119
THREAD, 1-120
TIMED_OS_STATISTICS, 1-121
TIMED_STATISTICS, 1-122
TRANSACTION_AUDITING, 1-122
TRANSACTIONS, 1-122
TRANSACTIONS_PER_ROLLBACK_SEGMENT, 1-123
USE_INDIRECT_DATA_BUFFERS, 1-123
USE_ISM, 1-124
USER_DUMP_DEST, 1-124
UTL_FILE_DIR, 1-125
variable, 1-10
INIT.ORA
parameter files, 1-1
INIT.ORA file, 1-1
inserts
locating free space, 1-51
INST_ID column, 3-2
instance attribute lock enqueue, B-2
instance number enqueue, B-1
INSTANCE option
allocating extents, 1-51
Instance recovery, 1-43
instance recovery enqueue, B-1
instance recovery wait event, A-31
instance registration lock enqueue, B-2
instance state change wait event, A-31
instance state enqueue, B-1
INSTANCE_GROUPS parameter, 1-50
INSTANCE_NUMBER parameter, 1-51
exclusive or parallel mode, 1-51
instances
checkpoint, 1-64
startup order, 1-51
io done wait event, A-32
ISO standard
date format, 4-28
ISO week number, 4-28
IW format element, 4-29
IY format element, 4-29

J

job queue enqueue, B-1
JOB_QUEUE_INTERVAL parameter, 1-51
JOB_QUEUE_PROCESSES parameter, 1-52

K

kcl bg acks wait event, A-32
kcmccs called get current scn statistic, C-9
kcmccs read scn without going to DLM statistic, C-9
kcmggs waited for batching statistic, C-9
KOLF
Register LFI close wait event, A-10
Register LFI exists wait event, A-11
Register LFI isopen wait event, A-11
Register LFI length wait event, A-11
Register LFI lfimkpth wait event, A-12
Register LFI read wait event, A-12
Register LFI seek wait event, A-13

L

L format element, 4-19
language
database default language, 1-81
language-dependent application behavior, 4-12
language and territory specifications
overriding, 4-12
LARGE_POOL_MIN_ALLOC parameter, 1-52
LARGE_POOL_SIZE parameter, 1-53
latch activity wait event, A-32
latch free wait event, A-33
least recently used (LRU) list
sequence numbers, 1-107, 1-108
LGWR_IO_SLAVES parameter
initialization parameters
LGWR_IO_SLAVES, 1-53
library cache invalidation enqueue, B-1
library cache load lock wait event, A-33
library cache lock enqueue, B-1
library cache lock wait event, A-34
library cache pin enqueue, B-1
library cache pin wait event, A-34
LICENSE_MAX_SESSIONS parameter, 1-54
LICENSE_MAX_USERS parameter, 1-54
LICENSE_SESSIONS_WARNING parameter, 1-55
licenses
maximum sessions, 1-54
maximum users, 1-54
warning for concurrent user sessions, 1-55
LIKE operator, 4-5
limits on the database, 5-1
linguistic definitions
supported, 4-52
linguistic definitions, NLS, 4-52
linguistic sorts, 1-82, 4-14
controling, 4-37
list separator, 4-30, 4-31
listener process, 1-73
LM_LOCKS parameter, 1-55
LM_PROCS parameter, 1-56
LM_RESS parameter, 1-57
loadable character sets, 4-27
LOADER_CONSTRAINT_INFO view, 2-112
LOADER_FILE_TS view, 2-112
LOADER_PARAM_INFO view, 2-112
LOADER_PART_INFO view, 2-112
LOADER_TAB_INFO view, 2-112
LOADER_TRIGGER_INFO view, 2-113
local currency, 1-79
local currency symbol, 4-19
LOCAL_LISTENER parameter, 1-57
lock
names, A-9
lock conversion, 3-12, 3-14, 3-16, 3-40, 3-64
lock element
fixed, 1-47
non-fixed, 1-47
lock element waits statistic, C-9
lock manager wait for remote message wait event, A-35
LOCK_NAME_SPACE parameter, 1-58
LOCK_SGA parameter, 1-58
LOCK_SGA_AREAS parameter, 1-59
locks
table lock, 1-107
temporary tables, 1-119, 1-120
log buffer space wait event, A-35
log file parallel write wait event, A-35
log file sequential read wait event, A-36
log file single write wait event, A-36
log file switch (archiving needed) wait event, A-36
log file switch (checkpoint incomplete) wait event, A-37
log file switch (clearing log file) wait event, A-37
log file switch completion wait event, A-37
log file sync wait event, A-37
log switch/archive wait event, A-37
LOG_ARCHIVE_BUFFER_SIZE parameter, 1-59, 1-60
LOG_ARCHIVE_BUFFERS parameter, 1-60
LOG_ARCHIVE_DEST parameter, 1-60
LOG_ARCHIVE_DUPLEX_DEST parameter, 1-61
LOG_ARCHIVE_FORMAT parameter, 1-61
LOG_ARCHIVE_MIN_SUCCEED_DEST parameter, 1-62
LOG_ARCHIVE_START parameter, 1-62
LOG_BLOCK_CHECKSUM parameter, 1-63
LOG_BUFFER parameter, 1-63
LOG_CHECKPOINT_INTERVAL parameter, 1-64
LOG_CHECKPOINT_TIMEOUT parameter, 1-65
LOG_CHECKPOINTS_TO_ALERT parameter, 1-65
LOG_FILE_NAME_CONVERT parameter, 1-66
LOG_FILES parameter, 1-66
LOG_SIMULTANEOUS_COPIES parameter, 1-67
LOG_SMALL_ENTRY_MAX_SIZE parameter, 1-67
logons cumulative statistic, C-9
logons current statistic, C-9
lowercase significance, 1-3
LRU, 1-107, 1-108

M

manual archiving, 1-63
MAX_COMMIT_PROPAGATION_DELAY parameter, 1-68
MAX_DUMP_FILE_SIZE parameter, 1-68
MAX_ENABLED_ROLES parameter, 1-69
MAX_ROLLBACK_SEGMENTS parameter, 1-69
MAX_TRANSACTION_BRANCHES parameter, 1-70
MAXLOGFILES option, 1-66
MAXLOGMEMBERS option, 1-66
media recovery enqueue, B-1
memory
amount used for sorting, 1-114
virtual, 1-10
migration scripts, 6-6
modes
archiving, 1-63
monetary units characters, 4-31
monitor
performance, 1-65
month
format element, 4-22
language of names, 4-22
MTS dispatcher request statistics, 3-73
MTS_DISPATCHERS parameter, 1-70
MTS_LISTENER_ADDRESS parameter, 1-73
MTS_MAX_DISPATCHERS parameter, 1-74
MTS_MAX_SERVERS parameter, 1-74
MTS_MULTIPLE_LISTENERS parameter, 1-75
MTS_RATE_LOG_SIZE parameter, 1-75
MTS_RATE_SCALE parameter, 1-76
MTS_SERVERS parameter, 1-77
MTS_SERVICE parameter, 1-78
multi-byte character sets, 4-27
storing data, 4-27
multi-byte encoding schemes, 4-4
multiple-process systems
number of processes, 1-100
multi-threaded server (MTS)
HASH_MULTIBLOCK_IO_COUNT, 1-49
SESSIONS parameter, 1-110

N

national character set
parameter, 4-31
national character sets, 4-5
choosing, 4-6
uses for, 4-6
National Language Support (NLS)
architecture, 4-2
calendars, 4-54
goals, 4-2
language-dependent behavior, 4-8
linguistic definitions, 4-52
loadable character sets, 4-27
NLS_LANGUAGE parameter, 4-15, 4-34
nested files, 1-50
next scns gotten without going to DLM statistic, C-10
NLS, 4-1
number formats, 4-13
NLS data
obsolete, 4-37
supported calendar systems, 4-54
supported linguistic definitions, 4-52
supported storage character sets, 4-44
supported territories, 4-41
NLS parameters
using in SQL functions, 4-31
NLS_CALENDAR parameter, 1-78, 4-19
NLS_CHARSET_DECL_LEN function, 4-37
NLS_CHARSET_ID function, 4-36
NLS_CHARSET_NAME function, 4-36
NLS_CREDIT environment variable, 4-30
NLS_CURRENCY parameter, 1-79, 4-19
defined by NLS_TERRITORY, 1-83
NLS_DATABASE_PARAMETERS view, 2-113
NLS_DATE_FORMAT parameter, 1-79, 4-20
defined by NLS_NUMERIC_CHARACTERS, 1-83
defined by NLS_TERRITORY, 1-83
NLS_DATE_LANGUAGE parameter, 1-80, 4-21, 4-22
NLS_DEBIT parameter, 4-30
NLS_INSTANCE_PARAMETERS view, 2-113
NLS_ISO_CURRENCY parameter, 1-80, 4-23
defined by NLS_TERRITORY, 1-83
NLS_LANG environment variable, 4-10, 4-11, 4-26
NLS_LANGUAGE parameter, 1-81, 4-15, 4-34
NLS_LIST_SEPARATOR parameter, 4-30, 4-31
NLS_MONETARY_CHARACTERS parameter, 4-31
NLS_NCHAR environment variable, 4-26
NLS_NCHAR parameter, 4-31
NLS_NUMERIC_ CHARACTERS parameter, 4-23
NLS_NUMERIC_CHARACTERS parameter, 1-81, 4-24
NLS_SESSION_PARAMETERS view, 2-113
NLS_SORT parameter, 1-82, 4-24
NLS_TERRITORY parameter, 1-83, 4-16
NLSDATA (language independent data)
loading, 4-17
utilities for loading, 4-18
NLSRTL, 4-27
NLSSORT Function, 4-35
NOARCHIVELOG mode
creating a database, 1-63
NOCACHE option, 1-107, 1-108
Null Event wait event, A-13
numeric group separators, 1-81

O

O7_DICTIONARY_ACCESSIBILITY parameter, 1-12
OBJ synonym for USER_OBJECTS, 2-113
OBJECT_CACHE_MAX_SIZE_PERCENT parameter, 1-83
OBJECT_CACHE_OPTIMAL_SIZE parameter, 1-84
objects
data dictionary, 2-1
OGMS_HOME parameter, 1-84
OLF
Register LFI lfimkm wait event, A-12
Register LFI open wait event, A-12
on-going reading of SCN to complete wait event, A-38
online redo log
archiving, 1-63
archiving mode, 1-60
block, 1-64
block size, 1-59
file size, 1-64
number of files, 1-63, 1-66
setting checkpoint interval, 1-64
OPEN_CURSORS parameter, 1-84
OPEN_LINKS parameter, 1-85
OPEN_LINKS_PER_INSTANCE parameter, 1-86
opened cursors cumulative statistic, C-10
opened cursors current statistic, C-10
opens of replaced files statistic, C-10
opens requiring cache replacement statistic, C-10
operating system
authenticating remote clients, 1-104
authenticating users and passwords, 1-91
operating system dependent parameters, 1-10
redo log blocks, 1-59, 1-64
roles for remote clients, 1-104
OPS_ADMIN_GROUP parameter, 1-86, 3-2
optimization
trading cursor space for time, 1-25
optimizer mode
FIRST_ROWS, 1-88
RULE, 1-88
OPTIMIZER_FEATURES_ENABLED parameter, 1-87
OPTIMIZER_MODE parameter, 1-87
OPTIMIZER_PERCENT_PARALLEL parameter, 1-88
OPTIMIZER_SEARCH_LIMIT parameter, 1-88
ORACLE_TRACE_COLLECTION_NAME parameter, 1-88
ORACLE_TRACE_COLLECTION_PATH parameter, 1-89
ORACLE_TRACE_COLLECTION_SIZE parameter, 1-89
ORACLE_TRACE_ENABLE parameter, 1-89
ORACLE_TRACE_FACILITY_NAME parameter, 1-90
ORACLE_TRACE_FACILITY_PATH parameter, 1-90
ORDER BY clause, 4-37
sorting character data, 4-14
OS_AUTHENT_PREFIX parameter, 1-91
OS_ROLES parameter, 1-91

P

pad character
alternate mappings, 4-5
parallel mode
instance number, 1-51
parallel query
idle time, 1-97
maximum number of instances, 1-92, 1-93
maximum number of servers, 1-94
minimum number of queries, 1-95, 1-96
OPTIMIZER_PERCENT_PARALLEL, 1-88
parallel query create server wait event, A-38
parallel query dequeue wait wait event, A-38
parallel query qref latch wait event, A-39
parallel query server shutdown wait event, A-39
parallel query signal server wait event, A-39
parallel server parameters
LM_LOCKS, 1-55
LM_PROCS, 1-56
LM_RESS, 1-57
MTS_DISPATCHERS, 1-70
MTS_LISTENER_ADDRESS, 1-73
OPS_ADMIN_GROUP, 1-86
PARALLEL_ADAPTIVE_MULTI_USER, 1-92
PARALLEL_BROADCAST_ENABLE, 1-92
PARALLEL_DEFAULT_MAX_INSTANCES, 1-93
PARALLEL_EXECUTION_MESSAGE_SIZE, 1-93
PARALLEL_INSTANCE_GROUP, 1-94
PARALLEL_MAX_SERVERS, 1-94
PARALLEL_MIN_PERCENT, 1-96
PARALLEL_MIN_SERVERS, 1-96
PARALLEL_SERVER, 1-97
PARALLEL_SERVER_IDLE_TIME, 1-97
PARALLEL_TRANSACTION_RESOURCE_TIMEOUT, 1-97
parallel server views, 3-2
parallel slave synchronization enqueue, B-2
parallel slaves enqueue, B-1
PARALLEL_ADAPTIVE_MULTI_USER parameter, 1-92
PARALLEL_BROADCAST_ENABLE parameter, 1-92
PARALLEL_BROADCAST_ENABLED parameter, 1-92
PARALLEL_DEFAULT_MAX_INSTANCES parameter, 1-93
PARALLEL_EXECUTION_MESSAGE_SIZE parameter, 1-93
PARALLEL_INSTANCE_GROUP parameter, 1-94
PARALLEL_MAX_SERVERS parameter, 1-94, 3-2
PARALLEL_MIN_MESSAGE_POOL parameter, 1-95
PARALLEL_MIN_PERCENT parameter, 1-96
PARALLEL_MIN_SERVERS parameter, 1-96
PARALLEL_SERVER parameter, 1-97
PARALLEL_SERVER_IDLE_TIME parameter, 1-97
PARALLEL_TRANSACTION_RESOURCE_TIMEOUT parameter, 1-97
parallelism
OPTIMIZER_PERCENT_PARALLEL, 1-88
parameter files
common file, 1-50
embedded files, 1-3
embedded parameter files, 1-50
line continuation character (), 1-3
parse count (hard) statistic, C-10
parse count (total) statistic, C-10
parse time cpu statistic, C-10
parse time elapsed statistic, C-11
PARSED_PIECES view, 2-113
PARSED_SIZE view, 2-114
partition
raw partition, 1-60
PARTITION_VIEW_ENABLED parameter, 1-98
partitioned indexes, 4-37
partitioned tables, 4-37
password file enqueue, B-1
passwords
authenticating, 1-91, 1-104
REMOTE_LOGIN_PASSWORDFILE parameter, 1-103
PCM lock
mapping blocks to, 1-44
PDML Restrictions
for DML_LOCKS parameter, 1-40
pending ast wait event, A-40
pending global transaction(s) wait event, A-40
percent sign
alternate mappings, 4-5
performance, 1-10
archiving, 1-59
effect of SGA size, 1-28
number of database buffers, 1-28
rule-based optimizer, 1-87
shared pool, 1-49, 1-111, 1-113
sort performance, 1-115
sort spacemap, 1-116
tuning archiving, 1-60
physical reads statistic, C-11
physical writes statistic, C-11
pipe get wait event, A-40
pipe put wait event, A-40
PL/SQL lock timer wait event, A-13
PLAN_TABLE execution plan table, 2-114
PLSQL_V2_COMPATIBILITY parameter, 1-98
pmon timer wait event, A-41
PRE_PAGE_SGA parameter, 1-100
precision
NUMBER and FLOAT, 2-161
preface
Send Us Your Comments, xxxvii
private rollback segments
specifying, 1-106
privileges
remote login, 1-103
RESTRICTED_SESSION privilege, 1-54, 1-55
table-level select privileges, 1-118, 1-119
procedures
shared pool, 1-49, 1-111, 1-113
process startup enqueue, B-1
process startup wait event, A-41
processes
derived parameter values, 1-123
dispatcher process configuration, 1-70
dispatcher process maximum number, 1-74
listener process address, 1-73
maximum shared server processes, 1-74
number of server processes, 1-77
recovery, 1-102
trace files, 1-124
user processes, 1-100
PROCESSES parameter, 1-100
PRODUCT_COMPONENT_VERSION view, 2-115
profiles
resource limits, 1-105
PSTUBTBL view, 2-116
PUBLIC option
thread of redo, 1-121
public rollback segments, 1-106
using by default, 1-105
PUBLIC_DEPENDENCY view, 2-116
PUBLICSYN view, 2-116
PUSH_JOIN_PREDICATE parameter, 1-101
PX local messages recv'd statistic, C-3
PX local messages sent statistic, C-3
PX remote messages recv'd statistic, C-3
PX remote messages sent statistic, C-4

Q

queries
dictionary views, 1-45
hints, 1-87
ordering output, 4-14
queries parallelized statistic, C-11
queue messages wait event, A-41
queue wait wait event, A-42

R

raw partition
LOG_ARCHIVE_DEST parameter, 1-60
rdbms ipc message block wait event, A-42
rdbms ipc message wait event, A-42
rdbms ipc reply wait event, A-42
read consistency
rollback information, 1-47
READ_ONLY_OPEN_DELAYED parameter, 1-101
recovery
number of required processes, 1-102
recovery array read time statistic, C-11
recovery array reads statistic, C-11
recovery blocks read statistic, C-11
RECOVERY_PARALLELISM parameter, 1-102
recursive calls statistic, C-11
recursive cpu usage statistic, C-12
redo entries linearized statistic, C-12
redo entries statistic, C-12
redo log "kick" enqueue, B-1
redo log buffers
size, 1-64
redo log space requests statistic, C-12
redo log space wait time statistic, C-12
redo log switch interrupts statistic, C-12
redo ordering marks statistic, C-12
redo size statistic, C-13
redo sync writes statistic, C-13
redo synch time statistic, C-13
redo thread, 1-120
redo thread enqueue, B-2
redo wait event, A-43
redo wastage statistic, C-13
redo write time statistic, C-13
redo writer latching time statistic, C-13
redo writes statistic, C-13
REDUCE_ALARM parameter, 1-103
remote clients
authenticating, 1-104
remote instance undo block writes statistic, C-13
remote instance undo header writes statistic, C-14
remote instance undo requests statistic, C-14
remote logins, 1-103
REMOTE_DEPENDENCIES_MODE parameter, 1-103
REMOTE_LOGIN_PASSWORDFILE parameter, 1-103
REMOTE_OS_AUTHENT parameter, 1-104
REMOTE_OS_ROLES parameter, 1-104
replacement characters, 4-34
REPLICATION_DEPENDENCY_TRACKING parameter, 1-105
resource limits for profiles, 1-105
RESOURCE_COST view, 2-117
RESOURCE_LIMIT parameter, 1-105
RESOURCE_MAP view, 2-117
RM format element, 4-20
ROLE_ROLE_PRIVS view, 2-117
ROLE_SYS_PRIVS view, 2-117
ROLE_TAB_PRIVS view, 2-118
roles, 1-91
remote clients, 1-104
rollback segments
acquiring, 1-106, 1-123
distributed locks, 1-47
global constant parameters, 1-47
initialization parameters, 1-47
maximum size, 1-70
number of concurrent transactions, 1-123
private rollback segments, 1-106
public rollback segments, 1-106
specifying, 1-106
SYSTEM, 1-106
ROLLBACK_SEGMENTS parameter, 1-105
unique values, 1-106
Roman numerals
format mask for, 4-20
row cache cursor, 1-106
row cache enqueue, B-2
row cache lock wait event, A-43
ROW_CACHE_CURSORS parameter, 1-106
ROW_LOCKING parameter, 1-107
RULE, 1-87, 1-88
rule-based optimizer, 1-87

S

scginq AST call wait event, A-43
scripts
data dictionary, 6-2
migration, 6-5, 6-6
SQL scripts, 6-1
Send Us Your Comments
boilerplate, xxxvii
SEQ synonym for USER_SEQUENCES, 2-118
sequence number enqueue, B-2
sequence number value enqueue, B-2
SEQUENCE_CACHE_ENTRIES parameter, 1-107
SEQUENCE_CACHE_HASH_BUCKET parameter, 1-108
sequences
data dictionary cache, 1-107, 1-108
not cached, 1-107, 1-108
SERIAL_REUSE parameter, 1-108
serializable aborts statistic, C-14
server processes
number, 1-77
session connect time statistic, C-14
session cursor cache count statistic, C-14
session cursor cache hits statistic, C-14
session logical reads statistic, C-14
session pga memory max statistic, C-15
session pga memory statistic, C-14
session stored procedure space statistic, C-15
session uga memory max statistic, C-15
session uga memory statistic, C-15
SESSION_CACHED_CURSORS parameter, 1-109
SESSION_MAX_OPEN_FILES parameter, 1-109
SESSION_PRIVS view, 2-118
SESSION_ROLES view, 2-118
SESSIONS parameter, 1-110
SGA, 1-10
SHADOW_CORE_DUMP parameter, 1-110
shared server processes
maximum number, 1-74
SHARED_MEMORY_ADDRESS parameter, 1-111
SHARED_POOL_RESERVED_MIN_ALLOC parameter, 1-111
SHARED_POOL_RESERVED_SIZE parameter, 1-112
V$SHARED_POOL_RESERVED, 3-91
SHARED_POOL_SIZE parameter, 1-113
SHOW command
PARAMETERS option, 1-8
single-task message wait event, A-43
SMON enqueue, B-2
smon timer wait event, A-44
SNP background processes, 1-52
sort segment enqueue, B-2
SORT_AREA_RETAINED_SIZE parameter, 1-113
SORT_AREA_SIZE parameter, 1-114
SORT_DIRECT_WRITES parameter, 1-115
SORT_READ_FAC parameter, 1-115
SORT_SPACEMAP_SIZE parameter, 1-116
SORT_WRITE_BUFFER_SIZE parameter, 1-116
SORT_WRITE_BUFFERS parameter, 1-117
sorting
character data, 4-13
double characters, 4-14
following language conventions, 4-14
maximum memory, 1-114
order, 4-13
ORDER BY queries, 1-82
specifying non-default, 4-24
sorts (disk) statistic, C-15
sorts (memory) statistic, C-15
sorts (rows) statistic, C-15
SOURCE_SIZE view, 2-118
space
SGA, 1-67
space management transaction enqueue, B-2
SPIN_COUNT parameter, 1-117
SQL scripts
creating the data dictionary, 6-1
optional, 6-2
required, 6-2
SQL*Net break/reset to client wait event, A-13
SQL*Net break/reset to dblink wait event, A-13
SQL*Net message from client wait event, A-14
SQL*Net message from dblink wait event, A-14
SQL*Net message to client wait event, A-14
SQL*Net message to dblink wait event, A-15
SQL*Net more data from client wait event, A-15
SQL*Net more data from dblink wait event, A-15
SQL*Net more data to client wait event, A-16
SQL*Net more data to dblink wait event, A-16
SQL*Net roundtrips to/from client statistic, C-4
SQL*Net roundtrips to/from dblink statistic, C-4
SQL_TRACE parameter, 1-118
SQL92_SECURITY parameter, 1-118
STAR_TRANSFORMATION_ENABLED parameter, 1-119
START option
automatic archiving, 1-60
starting up
database name, 1-34
instance number, 1-51
startup order, 1-51
STARTUP command
database name, 1-34
statistics
dbwr checkpoints, 1-64
effect of cache size, 1-28, 1-29
timed, 1-122
STMT_AUDIT_OPTION_MAP table
auditing option type codes, 2-119
storage character sets
supported, 4-44
storing data
in multi-byte character sets, 4-27
string comparisons
and WHERE clause, 4-35
summed dirty queue length statistic, C-16
supported character sets, 4-26
supported character string functionality and character sets, 4-26
switch logfile command wait event, A-44
switch redo log file, 1-64
SYN synonym for USER_SYNONYMS, 2-119
synchronized replication enqueue, B-2
SYNONYMS view, 2-119
SYS_OBJECTS view, 2-120
SYSCATALOG view, 2-119
SYSFILES view, 2-119
SYSSEGOBJ view, 2-119
system commit number enqueue, B-2
System Global Area (SGA)
buffer areas, 1-26, 1-64
buffer cache, 1-26
maximum concurrent transactions, 1-123
rollback segment size, 1-70
sequence cache, 1-107, 1-108
size of, 1-26, 1-67
tuning, 1-28
system performance, 1-10
SYSTEM rollback segment, 1-106
SYSTEM_PRIVILEGE_MAP view, 2-119

T

TAB view, 2-120
table fetch by rowid statistic, C-16
table fetch continued row statistic, C-16
table scan blocks gotten statistic, C-16
table scan rows gotten statistic, C-16
table scans (cache partitions) statistic, C-17
table scans (direct read) statistic, C-17
table scans (long tables) statistic, C-17
table scans (rowid ranges) statistic, C-17
TABLE_PRIVILEGE_MAP table
access privilege codes, 2-121
TABLE_PRIVILEGES view, 2-120
tables
data dictionary, 2-1
DML locks, 1-40
free lists, 1-30
locating free space, 1-51
partitioned, 4-37
row locking, 1-107
temporary tables, 1-119, 1-120
TABQUOTAS view, 2-121
TABS synonym for USER_TABLES, 2-121
tape archiving destination, 1-60
TAPE_ASYNCH_IO parameter
initialization parameters
TAPE_ASYNCH_IO, 1-119
temporary segment enqueue, B-2
temporary table enqueue, B-2
TEMPORARY_TABLE_LOCKS parameter, 1-120
territories
supported, 4-41
territory, 1-83, 4-16
TEXT_ENABLE parameter, 1-119
THREAD parameter, 1-120
TIMED_OS_STATISTICS parameter, 1-121
TIMED_STATISTICS parameter, 1-122
file read/write statistics, 3-43
timer in sksawat wait event, A-44
TO_CHAR function, 1-80
default date format, 4-20
format masks, 4-28
group separator, 4-24
language for dates, 4-21
spelling of days and months, 4-22
TO_DATE function, 1-80
default date format, 4-20
format masks, 4-28
language for dates, 4-21
spelling of days and months, 4-22
TO_NUMBER function
format masks, 4-28
group separator, 4-24
total file opens statistic, C-17
trace files
destination, 1-16, 1-124
location of, 1-16
maximum size, 1-69
transaction enqueue, B-2
transaction recovery enqueue, B-2
transaction wait event, A-44
TRANSACTION_AUDITING parameter, 1-122
transactions
concurrent, 1-123
data locking, 1-40
rollback segments, 1-123
TRANSACTIONS parameter, 1-106, 1-122
DML locks, 1-40
TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter, 1-106, 1-123
Trusted ORACLE
ALL_LABELS view, 2-14
data dictionary, 2-1
TRUSTED_SERVERS view, 2-121
TS_PITR_CHECK view, 2-122
TS_PITR_OBJECTS TO_BE_DROPPED view, 2-123

U

unbound tx wait event, A-45
underscore
alternate mappings, 4-5
undo segment extension wait event, A-45
undo segment recovery wait event, A-45
undo segment tx slot wait event, A-45
undo segment, serialization enqueue, B-2
UNICODE, 4-6, 4-38
Unnecesary process cleanup for SCN batching statistic, C-4
updates
locating free space, 1-51
transaction processing option, 1-107
uppercase characters, 1-3
USE_INDIRECT_DATA_BUFFERS parameter, 1-123
USE_ISM parameter, 1-124
user calls statistic, C-17
user commits statistic, C-17
user name enqueue, B-2
user processes
trace files, 1-124
user rollbacks statistic, C-18
USER_ALL_TABLES view, 2-123
USER_ARGUMENTS view, 2-125
USER_AUDIT_OBJECT view, 2-126
USER_AUDIT_SESSION view, 2-127
USER_AUDIT_STATEMENT view, 2-127
USER_AUDIT_TRAIL view, 2-129
USER_CATALOG view, 2-130
CAT synonym, 2-40
USER_CLU_COLUMNS view, 2-131
USER_CLUSTERS view, 2-130
CLU synonym, 2-40
USER_COL_COMMENTS view, 2-132
USER_COL_PRIVS view, 2-132
USER_COL_PRIVS_MADE view, 2-132
USER_COL_PRIVS_RECD view, 2-133
USER_COLL_TYPES view, 2-133
USER_CONS_COLUMNS view, 2-134
USER_CONSTRAINTS view, 2-133
USER_DB_LINKS view, 2-135
USER_DEPENDENCIES view, 2-135
USER_DUMP_DEST parameter, 1-124
USER_ERRORS view, 2-136
USER_EXTENTS view, 2-136
USER_FREE_SPACE view, 2-136
USER_IND_COLUMNS view, 2-139
USER_IND_PARTITIONS view, 2-139
USER_INDEXES view, 2-137
IND synonym, 2-111
USER_JOBS view, 2-140
USER_LIBRARIES view, 2-141
USER_LOBS view, 2-142
USER_METHOD_PARAMS view, 2-142
USER_METHOD_RESULTS view, 2-143
USER_NESTED_TABLES view, 2-143
USER_OBJ_AUDIT_OPTS view, 2-146
USER_OBJECT_SIZE view, 2-146
USER_OBJECT_TABLES view, 2-143
USER_OBJECTS view, 2-145
OBJ syonym, 2-113
USER_PART_COL_STATISTICS view, 2-147
USER_PART_HISTOGRAMS view, 2-147
USER_PART_INDEXES view, 2-148
USER_PART_KEY_COLUMNS view, 2-148
USER_PART_TABLES view, 2-149
USER_PASSWORD_LIMITS view, 2-150
USER_QUEUE_TABLES view, 2-150
USER_QUEUES view, 2-151
USER_REFRESH view, 2-151
USER_REFRESH_CHILDREN view, 2-152
USER_REFS view, 2-153
USER_REPCATLOG view, 2-153
USER_REPCOLUMN view, 2-153
USER_REPCOLUMN_GROUP view, 2-153
USER_REPCONFLICT view, 2-153
USER_REPDDL view, 2-154
USER_REPGENERATED view, 2-154
USER_REPGROUP view, 2-154
USER_REPGROUPED_COLUMNS view, 2-154
USER_REPKEY_COLUMNS view, 2-154
USER_REPOBJECT view, 2-154
USER_REPPARAMETER_COLUMN view, 2-154
USER_REPPRIORITY view, 2-154
USER_REPPRIORITY_GROUP view, 2-154
USER_REPPROP view, 2-155
USER_REPRESOL_STATS_CONTROL view, 2-155
USER_REPRESOLUTION view, 2-155
USER_REPRESOLUTION_METHOD view, 2-155
USER_REPRESOLUTION_STATISTICS view, 2-155
USER_REPSITES view, 2-155
USER_RESOURCE_LIMITS view, 2-155
USER_ROLE_PRIVS view, 2-156
USER_SEGMENTS view, 2-156
USER_SEQUENCES view, 2-157
SEQ synonym, 2-118
USER_SNAPSHOT_LOGS view, 2-158
USER_SNAPSHOT_REFRESH_TIMES view, 2-159
USER_SNAPSHOTS view, 2-157
USER_SOURCE view, 2-159
USER_SYNONYMS view, 2-159
SYN synonym, 2-119
USER_SYS_PRIVS view, 2-160
USER_TAB_COL_STATISTICS view, 2-160
USER_TAB_COLUMNS
COLS synonym, 2-41
USER_TAB_COLUMNS view, 2-161
USER_TAB_COMMENTS view, 2-162
USER_TAB_HISTOGRAMS view, 2-162
USER_TAB_PARTITIONS view, 2-162
USER_TAB_PRIVS view, 2-163
USER_TAB_PRIVS_MADE view, 2-164
USER_TAB_PRIVS_RECD view, 2-164
USER_TABLES view, 2-164
USER_TABLESPACES view, 2-166
USER_TRIGGER_COLS view, 2-167
USER_TRIGGERS view, 2-166
USER_TS_QUOTAS view, 2-167
USER_TYPE_ATTRS view, 2-168
USER_TYPE_METHODS view, 2-169
USER_TYPES view, 2-168
USER_UPDATABLE_COLUMNS view, 2-169
USER_USERS view, 2-169
USER_VIEWS view, 2-170
user-defined locks enqueue, B-2
USERLOCK.SQL script, 6-3
users
authenticating, 1-91
multiple, 1-40
UTF2 encoding, 4-6, 4-38
UTF8 encoding, 4-6, 4-38
UTL_FILE_DIR parameter, 1-125
UTLBSTAT.SQL script, 6-3
UTLCHAIN.SQL script, 6-3
UTLCONST.SQL script, 6-4
UTLDTREE.SQL script, 2-100, 2-110, 6-4
UTLESTAT.SQL script, 6-3
UTLEXCPT.SQL script, 6-4
UTLHTTP.SQL script, 6-4
UTLLOCKT.SQL script, 6-4
UTLPG.SQL script, 6-4
UTLPWDMG.SQL script, 6-4
UTLSAMPL.SQL script, 6-4
UTLSCLN.SQL script, 6-4
UTLTKPROF.SQL script, 6-4
UTLVALID.SQL script, 6-4
UTLXPLAN.SQL script, 6-4

V

V$ACCESS view, 3-3
V$ACTIVE_INSTANCES view, 3-3
V$AQ view, 3-4
V$ARCHIVE view, 3-4
V$ARCHIVE_DEST, 3-4
V$ARCHIVED_LOG view, 3-5
V$BACKUP view, 3-6
V$BACKUP_CORRUPTION view, 3-6
V$BACKUP_DATAFILE view, 3-7
V$BACKUP_DEVICE view, 3-8
V$BACKUP_PIECE view, 3-8
V$BACKUP_REDOLOG view, 3-9
V$BACKUP_SET view, 3-10
V$BGPROCESS view, 3-12
V$BH view, 3-12
V$BUFFER_POOL view, 3-13
V$CACHE view, 3-14
V$CACHE_LOCK view, 3-16
V$CIRCUIT view, 3-17
V$CLASS_PING view, 3-18
V$COMPATIBILITY view, 3-19
V$COMPATSEG view, 3-19
V$CONTROLFILE view, 3-20
V$CONTROLFILE_RECORD_SECTION view, 3-20
V$COPY_CORRUPTION view, 3-21
V$CURRENT_BUCKET view, 3-21
V$DATABASE view, 3-21
V$DATAFILE view, 3-22
V$DATAFILE_COPY view, 3-24
V$DATAFILE_HEADER view, 3-26
V$DB_OBJECT_CACHE view, 3-28
V$DB_PIPES view, 3-29
V$DBFILE view, 3-27
V$DBLINK view, 3-27
V$DELETED_OBJECT view, 3-29
V$DISPATCHER view, 3-29
V$DISPATCHER_RATE view, 3-30
V$DLM_CONVERT_LOCAL view, 3-33
V$DLM_CONVERT_REMOTE view, 3-33
V$DLM_LATCH view, 3-34
V$DLM_LOCKS view, 3-35
V$DLM_MISC view, 3-35, 3-37
V$ENABLEDPRIVS view, 3-37
V$ENQUEUE_LOCK view, 3-37
V$EVENT_NAME view, 3-38
V$EXECUTION view, 3-38, 3-39
V$EXECUTION_LOCATION view, 3-39
V$FALSE_PING view, 3-39
V$FILE_PING view, 3-41
V$FILESTAT view, 3-42
V$FIXED_TABLE view, 3-43
V$FIXED_VIEW_DEFINITION view, 3-44
V$GLOBAL_TRANSACTION view, 3-44
V$INDEXED_FIXED_COLUMN view, 3-45
V$INSTANCE view, 3-45
V$LATCH view, 3-46
V$LATCH_CHILDREN view, 3-48
V$LATCH_MISSES view, 3-48
V$LATCH_PARENT view, 3-49
V$LATCHHOLDER view, 3-47
V$LATCHNAME view, 3-47
V$LIBRARYCACHE view, 3-49
V$LICENSE view, 3-50
V$LOADCSTAT view, 3-50
V$LOADTSTAT view, 3-51
V$LOCK view, 3-51
V$LOCK_ACTIVITY view, 3-54
V$LOCK_ELEMENT view, 3-55
V$LOCKED_OBJECT view, 3-56
V$LOCKS_WITH_COLLISIONS view, 3-56
V$LOG view, 3-57
V$LOG_HISTORY view, 3-58
V$LOGFILE view, 3-58
V$LOGHIST view, 3-58
V$MLS_PARAMETERS view, 3-59
V$MTS view, 3-59
V$MYSTAT view, 3-60
V$NLS_PARAMETERS view, 3-60
V$NLS_VALID_VALUES view, 3-60
V$OBJECT_DEPENDENCY view, 3-61
V$OFFLINE_RANGE view, 3-61
V$OPEN_CURSOR view, 3-62
V$OPTION view, 3-62
V$PARAMETER view, 3-62
V$PING view, 3-63
V$PQ_SESSTAT view, 3-65
V$PQ_SLAVE view, 3-66
V$PQ_SYSSTAT view, 3-66
V$PQ_TQSTAT view, 3-68
V$PROCESS view, 3-68
V$PWFILE_USERS view, 3-69
V$QUEUE view, 3-69
V$RECENT_BUCKET view, 3-70
V$RECOVER_FILE view, 3-70
V$RECOVERY_FILE_STATUS view, 3-70
V$RECOVERY_LOG view, 3-71
V$RECOVERY_PROGRESS view, 3-71
V$RECOVERY_STATUS view, 3-72
V$REQDIST view, 3-73
V$RESOURCE view, 3-73
V$RESOURCE_LIMIT view, 3-74
V$ROLLNAME view, 3-76
V$ROLLSTAT view, 3-76
V$ROWCACHE view, 3-77
V$SESS_IO view, 3-90
V$SESSION view, 3-77
V$SESSION_CONNECT_INFO view, 3-84
V$SESSION_CURSOR_CACHE view, 3-84
V$SESSION_EVENT view, 3-85, A-1
V$SESSION_LONGOPS view, 3-86
V$SESSION_OBJECT_CACHE view, 3-87
V$SESSION_WAIT view, 3-88, A-1
V$SESSTAT view, 3-89, C-1
V$SGA view, 3-90
V$SGASTAT view, 3-90
V$SHARED_POOL_RESERVED view, 3-91
V$SHARED_SERVER view, 3-92
V$SORT_SEGMENT view, 3-93
V$SORT_USAGE view, 3-94
V$SQL view, 3-95
V$SQL_BIND_DATA view, 3-97
V$SQL_BIND_METADATA view, 3-98
V$SQL_CURSOR view, 3-98
V$SQL_SHARED_MEMORY view, 3-99
V$SQLAREA view, 3-100
V$SQLTEXT view, 3-102
V$SQLTEXT_WITH_NEWLINES view, 3-102
V$STATNAME view, 3-103, C-1
V$SUBCACHE view, 3-106
V$SYSSTAT view, 3-107, C-1
V$SYSTEM_CURSOR_CACHE view, 3-107
V$SYSTEM_EVENT view, 3-107, A-1
V$SYSTEM_PARAMETER view, 3-108
V$TABLESPACE view, 3-109
V$THREAD view, 3-109
V$TIMER view, 3-110
V$TRANSACTION view, 3-110
V$TRANSACTION_ENQUEUE view, 3-111
V$TYPE_SIZE view, 3-112
V$VERSION view, 3-113
V$WAITSTAT view, 3-113
VARCHAR2 datatype
multi-byte character sets and, 4-27
variable parameters, 1-10
views
data dictionary views, 2-1
data files, 1-45
virtual circuit status wait event, A-46

W

wait event
parameter descriptions, A-6
week numbers, 4-28
WHERE clause
and string comparisons, 4-35
WMON goes to sleep wait event, A-16
write complete wait event, A-46
write requests statistic, C-18
writes stopped by instance recovery wait event, A-46

Prev
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library
Product
Contents