Oracle8 Server Reference
Release 8.0
A54645_01

Library
Product
Contents

Prev

A

abbreviations
AM/PM, 4-23
BC/AD, 4-23
acquiring rollback segments
distributed locks, 1-46
ALERT file, 1-16
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-6
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-11
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-17
ALL_OBJECTS view, 2-19
ALL_PART_COL_STATISTICS view, 2-20
ALL_PART_HISTOGRAMS view, 2-20
ALL_PART_INDEXES view, 2-20
ALL_PART_KEY_COLUMNS view, 2-21
ALL_PART_TABLES view, 2-22
ALL_REFRESH view, 2-23
ALL_REFRESH_CHILDREN view, 2-23
ALL_REFS view, 2-24
ALL_REGISTERED_SNAPSHOTS view, 2-25
ALL_REPCATLOG view, 2-25
ALL_REPCOLUMN view, 2-25
ALL_REPCOLUMN_GROUP view, 2-26
ALL_REPCONFLICT view, 2-26
ALL_REPDDL view, 2-26
ALL_REPGENERATED view, 2-26
ALL_REPGROUP view, 2-26
ALL_REPGROUPED_COLUMN view, 2-26
ALL_REPKEY_COLUMNS view, 2-26
ALL_REPOBJECT view, 2-26
ALL_REPPARAMETER_COLUMN view, 2-27
ALL_REPPRIORITY view, 2-27
ALL_REPPRIORITY_GROUP view, 2-27
ALL_REPPROP view, 2-27
ALL_REPRESOL_STATS_CONTROL view, 2-27
ALL_REPRESOLUTION view, 2-27
ALL_REPRESOLUTION_METHOD view, 2-27
ALL_REPRESOLUTION_STATISTICS view, 2-27
ALL_REPSITES view, 2-28
ALL_SEQUENCES view, 2-28
ALL_SNAPSHOT_LOGS view, 2-28
ALL_SNAPSHOTS view, 2-29
ALL_SOURCE view, 2-30
ALL_SYNONYMS view, 2-30
ALL_TAB_COL_STATISTICS view, 2-31
ALL_TAB_COLUMNS view, 2-31
ALL_TAB_COMMENTS view, 2-32
ALL_TAB_HISTOGRAMS view, 2-32
ALL_TAB_PARTITIONS view, 2-33
ALL_TAB_PRIVS view, 2-34
ALL_TAB_PRIVS_MADE view, 2-34
ALL_TAB_PRIVS_RECD view, 2-34
ALL_TABLES view, 2-35
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-49
allocation
archival buffer, 1-57
PCM locks, 1-44
rollback segments, 1-99
ALLOW_PARTIAL_SN_RESULTS parameter, 1-13
ALTER DATABASE command
ADD LOGFILE, 1-112
database name, 1-34
ENABLE THREAD, 1-112
THREAD, 1-112
ALTER SESSION command
SET HASH_AREA_SIZE option, 1-47
SET NLS_* options, 4-9
SET NLS_CURRENCY option, 4-20, 4-24
SET NLS_DATE_FORMAT option, 4-21
SET NLS_LANGUAGE option, 4-12
SET NLS_NUMERIC_CHARACTERS option, 4-25
SET NLS_TERRITORY option, 4-12
ALTER SYSTEM command
SET NLS_LANGUAGE option, 4-12
ALTER TABLE statement
allocating extents, 1-49
alternate character mappings, 4-6
ALWAYS_ANTI_JOIN parameter, 1-13
AM/PM abbreviation
language of, 4-23
ANALYZE command, 2-12, 2-31, 2-35, 2-60, 2-87, 2-90, 2-135, 2-157, 2-161
applications
language behavior for, 4-13
NLS support, 4-2
AQ_TM_PROCESSES parameter, 1-14
Arabic character set, 4-6, 4-50
Arabic/Hebrew character sets
supported, 4-50
ARCH_IO_SLAVES parameter, 1-14
ARCHIVE LOG command
destination file, 1-58
START and STOP, 1-60
archived redo log
automatic versus manual, 1-60
buffer, 1-57
storage device, 1-58-1-59
tuning, 1-57
ARCHIVELOG mode
archiving destination, 1-58-1-59
automatic archiving, 1-60
ASCII character set
sorting order, 4-14
AUDIT_ACTIONS table, 2-40
AUDIT_FILE_DEST parameter, 1-14
AUDIT_TRAIL parameter, 1-15
authenticating remote clients, 1-97
authenticating users, 1-87

B

B_TREE_BITMAP_PLANS parameter, 1-15
background checkpoints completed statistic, C-4
background checkpoints started statistic, C-5
background processes
SNP background process, 1-50
specifying trace files, 1-16
BACKGROUND_CORE_DUMP parameter, 1-16
BACKGROUND_DISK_IO_SLAVES parameter, 1-17
BACKGROUND_DUMP_DEST parameter, 1-16
ALERT file, 1-16
BACKUP_TAPE_IO_SLAVES parameter, 1-17
batched allocate scn lock request wait event, A-17
BC/AD abbreviation
language of, 4-23
being written redo log enqueue, B-2
binary sorting, 4-14
bind enqueue, B-2
BITMAP_MERGE_AREA_SIZE parameter, 1-18
BLANK_TRIMMING parameter, 1-18
block
PCM lock, 1-44
redo log, 1-57, 1-62
rollback segment, 1-46
size, 1-30
when written to disk, 1-46
block size, 5-3
buffer busy waits wait event, A-17
buffer cache
database, 1-25
buffer cache management enqueue, B-2
buffer deadlock wait event, A-18
buffer for checkpoint wait event, A-18
buffer is not pinned count statistic, C-5
buffer latch wait event, A-18
buffer read retry wait event, A-19
buffers
archival, 1-57
effect on performance, 1-27
number of, 1-25, 1-27
bytes received via SQL*Net from client statistic, C-5
bytes received via SQL*Net from dblink statistic, C-5
bytes sent via SQL*Net to client statistic, C-5
bytes sent via SQL*Net to dblink statistic, C-5

C

cache
database blocks, 1-25
dictionary, 3-77
row cache, 1-99
sequence cache, 1-100-1-101
statistics, 1-62
CACHE_SIZE_THRESHOLD parameter, 1-19
calendar systems, 4-19
supported, 4-53
calendars, 4-53
calls to get snapshot scn
kcmgss statistic, C-5
CAT synonym for USER_CATALOG view, 2-40
CAT8000.SQL script, 6-5
CATALOG view, 2-40
CATALOG.SQL
creating V$ views, 3-2
CATALOG.SQL script, 6-2
CATAUDIT.SQL script
audit trail records created by, 2-124
audit trails for connections and disconnections, 2-125
auditing options created by, 2-144
CATBLOCK.SQL script, 6-2
CATEXP7.SQL script, 6-2
CATHS.SQL script, 6-2
CATIO.SQL script, 6-3
CATNOADT.SQL script, 6-4
CATNOAUD.SQL script, 6-4
CATNOHS.SQL script, 6-4
CATNOPRT.SQL script, 6-4
CATNOQUEUE.SQL script, 6-4
CATNORMN.SQL script, 6-4
CATNOSNMP.SQL script, 6-4
CATNOSVM.SQL script, 6-4
CATOCTK.SQL script, 6-3
CATPARR.SQL script, 6-3
CATPROC.SQL script, 6-2
CATREP.SQL script, 6-3
CATREP8M.SQL script, 6-5
CATRMAN.SQL script, 6-3
CHAINED_ROWS view, 2-40
change write time statistic, C-5
CHAR datatype
multi-byte character sets and, 4-28
character data
binary sorts, 4-14
linguistic sorts, 4-14
special cases, 4-15
sorting, 4-14
character encoding schemes, 4-3
character sets
8-bit versus 7-bit, 4-36
conversion, 4-27
CONVERT function, 4-36
converting, 4-36
encoding schemes, 4-3
fixed-width multi-byte encoding schemes, 4-5
loadable character sets, 4-28
multi-byte, 4-28
pattern matching characters, 4-6
single-byte 7-bit ASCII, 4-4
single-byte 8-bit ASCII, 4-5
sorting data, 4-14
specifying, 4-26
supported, 4-27
varying-width multi-byte encoding schemes, 4-5
character string functionality and character sets
supported, 4-27
characters
numeric group separators, 1-78
checkpoint completed wait event, A-19
checkpoint range buffer not saved wait event, A-20
checkpoints
checkpoint interval, 1-62
statistics, 1-62
choosing character sets
guidelines, 4-7
CHR(n USING NCHAR_CS) function, 4-8
CLEANUP_ROLLBACK_ENTRIES parameter, 1-19
client/server architecture considerations, 4-12
CLOSE_CACHED_OPEN_CURSORS parameter, 1-20
CLU synonym for USER_CLUSTERS, 2-41
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-6
buffer being written statistic, C-6
callback failure statistic, C-6
cannot pin statistic, C-6
hot backup in progress statistic, C-6
write disabled statistic, C-6
commit cleanouts statistic, C-6
commit cleanouts successfully completed statistic, C-6
COMMIT_POINT_STRENGTH parameter, 1-20
COMPATIBLE parameter, 1-21
COMPATIBLE_NO_RECOVERY parameter, 1-22
concatenation operator, 4-28
concurrency
ROW_LOCKING parameter, 1-100
sequences, 1-100-1-101
transactions and, 1-114
transactions per rollback segment, 1-115
connecting, 1-75
consistency
multiversion read, 1-46
rollback information, 1-46
consistent changes statistic, C-6
consistent gets statistic, C-7
contention
block-level, 3-115
context areas
sort spacemap, 1-108
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-23
specifying, 1-23
CONTROL_FILE_RECORD_KEEP_TIME parameter, 1-22
CONTROL_FILES parameter, 1-23
controlfile transaction enqueue, B-2
conversion file read wait event, A-21
conversions
between character set ID number and character set name, 4-38
CONVERT function, 4-36
converting character sets, 4-36
CORE_DUMP_DEST parameter, 1-23
cost-based optimizer, 1-83-1-84
CPU used by this session statistic, C-2
CPU_COUNT parameter, 1-24
CR blocks created statistic, C-2
CREATE DATABASE command
database name, 1-34
MAXLOGFILES option, 1-64
setting the block size, 1-30
setting the log mode, 1-61
CREATE TABLE statement
FREELIST GROUPS option, 1-49
CREATE_BITMAP_AREA_SIZE parameter, 1-24
creating
databases
setting block size, 1-29-1-30
cross instance CR read statistic, C-7
cross-instance call invocation enqueue, B-2
currency, 1-76
international currency symbol, 1-77
monetary units characters, 4-33
currency symbol
default, 4-17
local currency symbol, 4-20
Current blocks converted for CR statistic, C-2
CURSOR_SPACE_FOR_TIME parameter, 1-25
cursors
OPEN_CURSORS parameter, 1-81
row cache, 1-99
shared pool, 1-105

D

data
conversion, 4-36
CONVERT function, 4-36
data blocks
reading multiple, 1-32
size of, 1-29-1-30
data dictionary, 2-2
cache, 3-77
datafiles, 1-45
DICTIONARY view, 2-112
rollback segments, 1-99
row cache, 1-99
scripts, 6-2
sequence cache, 1-100-1-101
SQL scripts, 6-1
tables, 2-1
views, 1-45
overview, 2-1-2-2
user views, 2-2
database block size, 5-3
database character sets, 4-5
choosing, 4-7
uses for, 4-7
database mount enqueue, B-2
database writer process (DBWR)
checkpoint, 1-62
databases
database limits, 5-1
default language, 1-78
name, 1-34
number of redo log files, 1-64
resource limits, 1-98
valid characters for database name, 1-34
datafile enqueue, B-2
datafiles
mapping blocks to PCM locks, 1-44
maximum number, 1-31
parameter, 1-31-1-32
unspecified for PCM locks, 1-44
Date formats, 4-21
and partition bound expressions, 4-22
dates
ISO standard, 4-29
language used for, 1-77
NLS_DATE_LANGUAGE parameter, 4-22
NLS_TERRITORY parameter, 4-17
setting SYSDATE, 1-42
TO_CHAR and TO_DATE functions, 1-76
day
format element, 4-23
language of names, 4-23
db block changes statistic, C-7
db block gets statistic, C-7
db file parallel write wait event, A-22
db file scattered read wait event, A-23
db file sequential read wait event, A-23
db file single write wait event, A-23
DB_BLOCK_BUFFERS parameter, 1-25
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-25, 1-29-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-1-32
DB_NAME parameter, 1-34
DBA_2PC_NEIGHBORS view, 2-42
DBA_2PC_PENDING view, 2-42
DBA_ALL_TABLES view, 2-43
DBA_ANALYZE_OBJECTS view, 2-45
DBA_AUDIT_EXISTS view, 2-45
DBA_AUDIT_OBJECT view, 2-46
DBA_AUDIT_SESSION view, 2-47
DBA_AUDIT_STATEMENT view, 2-48
DBA_AUDIT_TRAIL view, 2-49
DBA_BLOCKERS view, 2-51
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-53
DBA_COLL_TYPES view, 2-53
DBA_CONS_COLUMNS view, 2-55
DBA_CONSTRAINTS view, 2-54
DBA_DATA_FILES view, 1-45, 2-55, 2-102
DBA_DB_LINKS view, 2-55
DBA_DDL_LOCKS view, 2-56
DBA_DEPENDENCIES view, 2-56
DBA_DIRECTORIES view, 2-57
DBA_DML_LOCKS view, 2-57
DBA_ERRORS view, 2-58
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-64
DBA_LIBRARIES view, 2-65
DBA_LOBS view, 2-65
DBA_LOCKS view, 2-65
DBA_METHOD_PARAMS view, 2-66
DBA_METHOD_RESULTS view, 2-66
DBA_OBJ_AUDIT_OPTS view, 2-70
DBA_OBJECT_SIZE view, 2-67
DBA_OBJECT_TABLES view, 2-68
DBA_OBJECTS view, 2-69
DBA_PART_COL_STATISTICS view, 2-71
DBA_PART_HISTOGRAMS view, 2-71
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-74
DBA_QUEUE_TABLES view, 2-74
DBA_QUEUES view, 2-75
DBA_RCHILD view, 2-75
DBA_REFRESH view, 2-76
DBA_REFRESH_CHILDREN view, 2-77
DBA_REFRESH_TIMES view, 2-77
DBA_REFS view, 2-78
DBA_REGISTERED_SNAPSHOT_GROUPS view, 2-78
DBA_REGISTERED_SNAPSHOTS view, 2-78
DBA_REPCATLOG view, 2-79
DBA_REPCOLUMN view, 2-79
DBA_REPCOLUMN_GROUP view, 2-79
DBA_REPCONFLICT view, 2-79
DBA_REPDDL view, 2-79
DBA_REPGENERATED view, 2-79
DBA_REPGROUP view, 2-79
DBA_REPGROUPED_COLUMN view, 2-80
DBA_REPKEY_COLUMNS view, 2-80
DBA_REPOBJECT view, 2-80
DBA_REPPARAMETER_COLUMN view, 2-80
DBA_REPPRIORITY view, 2-80
DBA_REPPRIORITY_GROUP view, 2-80
DBA_REPPROP view, 2-80
DBA_REPRESOL_STATS_CONTROL view, 2-81
DBA_REPRESOLUTION view, 2-80
DBA_REPRESOLUTION_METHOD view, 2-81
DBA_REPSITES view, 2-81
DBA_RGROUP view, 2-81
DBA_ROLE_PRIVS view, 2-82
DBA_ROLES view, 2-82
DBA_ROLLBACK_SEGS view, 2-82
DBA_SEGMENTS view, 2-83
DBA_SEQUENCES view, 2-84
DBA_SNAPSHOT_LOGS view, 2-84
DBA_SNAPSHOTS view, 2-85
DBA_SOURCE view, 2-86
DBA_STMT_AUDIT_OPTS view, 2-86
DBA_SYNONYMS view, 2-86
DBA_SYS_PRIVS view, 2-87
DBA_TAB_COL_STATISTICS view, 2-87
DBA_TAB_COLUMNS view, 2-87
DBA_TAB_COMMENTS view, 2-88
DBA_TAB_HISTOGRAMS view, 2-88
DBA_TAB_PARTITIONS view, 2-89
DBA_TAB_PRIVS view, 2-90
DBA_TABLES view, 2-90
DBA_TABLESPACES view, 2-92
DBA_TRIGGER_COLS view, 2-93
DBA_TRIGGERS view, 2-92
DBA_TS_QUOTAS view, 2-93
DBA_TYPE_ATTRS view, 2-93
DBA_TYPE_METHODS view, 2-94
DBA_TYPES view, 2-94
DBA_UPDATABLE_COLUMNS view, 2-95
DBA_USERS view, 2-95
DBA_VIEWS view, 2-96
DBLINK_ENCRYPT_LOGIN parameter, 1-35
DBMS_ALERT_INFO view, 2-96
DBMS_LOCK_ALLOCATED view, 2-96
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-3
DBWR cross instance writes statistic, C-3
DBWR free buffers found statistic, C-3
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-35
debit symbol, 4-31
decimal character
default, 4-17
NLS_NUMERIC_CHARACTERS parameter, 4-24
when not a period (.), 4-25
DEFCALL view, 2-97
DEFCALLDEST view, 2-97
DEFDEFAULTDEST view, 2-97
DEFERRCOUNT view, 2-97
deferred pings statistic, C-7
DEFERROR view, 2-97
DEFLOB view, 2-97
DEFPROPAGATOR view, 2-97
DEFSCHEDULE view, 2-97
DEFTRAN view, 2-98
DEFTRANDEST view, 2-98
DELAYED_LOGGING_BLOCK
_CLEANOUTS parameter, 1-36
DEPTREE view, 2-98
derived parameters, 1-9
destination
archiving redo log files, 1-58
BACKGROUND_DUMP_DEST parameter, 1-16
overriding default, 1-58
USER_DUMP_DEST, 1-116
devices
storage, 1-108
DFS db file lock wait event, A-9
DFS lock handle wait event, A-10
DICT synonym for DICTIONARY, 2-98
DICT_COLUMNS view, 2-99
DICTIONARY view, 2-98
DICT synonym, 2-98
direct access I/O wait event, A-24
direct loader index creation enqueue, B-2
dirty buffers inspected statistic, C-7
DISCRETE_TRANSACTIONS_ENABLED parameter, 1-37
disk drives
archiving destination, 1-58
writing blocks, 1-46
DISK_ASYNCH_IO parameter, 1-37
dispatcher processes
configuration, 1-68
maximum number, 1-72
dispatcher shutdown wait event, A-25
dispatcher timer wait event, A-25
distributed lock
exclusive, 1-46
rollback segment, 1-46
distributed queries
disabling, 1-82
enabling, 1-82
links for, 1-82
distributed recovery enqueue, B-2
distributed transactions
limiting number of, 1-39
distributed TX enqueue, B-2
DISTRIBUTED_LOCK_TIMEOUT parameter, 1-38
DISTRIBUTED_RECOVERY
_CONNECTION_HOLD
_TIME parameter, 1-38
DISTRIBUTED_TRANSACTIONS parameter, 1-39
DML enqueue, B-2
DML_LOCKS parameter, 1-39
PDML restrictions, 1-40
DROPCAT5.SQL script, 6-5
DROPCAT6.SQL script, 6-5
dump files, 1-66
dupl. cluster key wait event, A-26
dynamic initialization parameters, 1-5
dynamic performance tables
CATALOG.SQL script, 3-2
public synonyms (V$), 3-2
views (V_$), 3-2

E

EBCDIC character set
sorting order, 4-14
embedded parameter files, 1-48
enqueue conversions statistic, C-7
enqueue deadlocks statistic, C-7
enqueue releases statistic, C-8
enqueue requests statistic, C-8
enqueue timeouts statistic, C-8
enqueue wait event, A-26
enqueue waits statistic, C-8
ENQUEUE_RESOURCES parameter, 1-41
enqueues
disabling, 1-40
ENQUEUE_RESOURCES parameter, 1-41
environment variables
client environment, 4-31
NLS parameters, 4-10, 4-30
NLS_LANG, 4-10
ERROR_SIZE view, 2-99
errors
archiving, 1-60
escalates saved statistic, C-8
EVENT parameter, 1-42
EXCEPTIONS view, 2-99
exchange deadlocks statistic, C-8
exclusive distributed lock
rollback data, 1-46
exclusive mode
specifying instance number, 1-49
execute count statistic, C-8
extent
allocating to instance, 1-49

F

file set enqueue, B-2
FILE_LOCK view, 2-99
FILE_PING view, 2-100
filenames
case significance, 1-3
name and number, 1-44
FILEXT$ view, 2-102, 3-3
FIRST_ROWS, 1-84
FIXED_DATE parameter, 1-42
format elements, 4-29-4-30
C, 4-30
D, 4-25, 4-30
day, 4-23
G, 4-25, 4-30
IW, 4-30
IY, 4-30
L, 4-20, 4-30
month, 4-23
RM, 4-21, 4-29
RN, 4-30
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-27
free process state object wait event, A-27
free space list
locating space, 1-49
FREELIST GROUPS storage option, 1-49
FREELISTS storage option
maximum value, 1-30
FREEZE_DB_FOR_FAST_INSTANCE
_RECOVERY parameter, 1-42

G

GC_DEFER_TIME parameter, 1-43
GC_FILES_TO_LOCKS parameter, 1-44
GC_LCK_PROCS parameter, 1-45
GC_RELEASABLE_LOCKS parameter, 1-46
GC_ROLLBACK_LOCKS parameter, 1-46
global cache cleanup wait event, A-28
global cache control parameters, 1-9
global cache lock escalate wait event, A-28
global cache lock quiesce wait event, A-28
global cache lock ss gets wait event, A-28
global constant parameter
rollback segments, 1-46
global lock convert time statistic, C-9
global lock converts (async) statistic, C-9
global lock converts (non async) statistic, C-9
global lock get time statistic, C-9
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-10
GLOBAL_NAME view, 2-102
GLOBAL_NAMES parameter, 1-47
group separator, 4-24
default, 4-17
NLS_NUMERIC_CHARACTERS parameter, 4-24
GV$ views
for parallel servers, 3-2
restrictions on, 3-3

H

HASH_AREA_SIZE parameter, 1-44-1-47
HASH_MULTIBLOCK_IO_COUNT parameter, 1-47
Hebrew character set, 4-6, 4-50
Heterogeneous Services Parameters, 1-10
hints
FIRST_ROWS, 1-84
RULE, 1-83-1-84
HS, 2-106
HS_ALL_CAPS view, 2-102
HS_ALL_DD view, 2-102
HS_ALL_INITS view, 2-103
HS_BASE_CAPS view, 2-103
HS_BASE_DD view, 2-103
HS_CLASS_CAPS view, 2-104
HS_CLASS_DD view, 2-104
HS_CLASS_INIT view, 2-104
HS_EXTERNAL_PROCEDURES view, 2-105
HS_FDS_CLASS view, 2-106
HS_FDS_INST view, 2-106
HS_INST_CAPS view, 2-107
HS_INST_DD view, 2-107
HS_INST_INIT view, 2-108

I

I/O
reading multiple blocks, 1-32
redo log files, 1-61
reducing with buffer cache, 1-25
IDEPTREE view, 2-108
IFILE, 1-3
IFILE keyword
nested files, 1-48
IFILE parameter, 1-48
inactive session wait event, A-31
inactive transaction branch wait event, A-31
IND synonym for USER_INDEXES, 2-108
index block split wait event, A-32
INDEX_HISTOGRAM view, 2-109
INDEX_STATS view, 2-109
indexes
FREELISTS option, 1-30
partitioned, 4-38
sort spacemap, 1-108
INIT.ORA
parameter files, 1-1
INIT.ORA file, 1-2
INITDW.ORA file, 1-2
initialization parameters
ALLOW_PARTIAL_SN_RESULTS, 1-13
altering, 1-5
ALWAYS_ANTI_JOIN, 1-13
AQ_TM_PROCESSES, 1-14
ARCH_IO_SLAVES, 1-14
AUDIT_FILE_DEST, 1-14
AUDIT_TRAIL, 1-15
B_TREE_BITMAP_PLANS, 1-15
BACKGROUND_CORE_DUMP, 1-16
BACKGROUND_DISK_IO_SLAVES, 1-17
BACKGROUND_DUMP_DEST, 1-16
BACKUP_TAPE_IO_SLAVES, 1-17
BITMAP_MERGE_AREA_SIZE, 1-18
BLANK_TRIMMING, 1-18
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-21
COMPATIBLE_NO_RECOVERY, 1-22
CONTROL_FILE_RECORD_KEEP
_TIME, 1-22
CONTROL_FILES, 1-23
controlling archiving, 1-57
CORE_DUMP_DEST, 1-23
CPU_COUNT, 1-24
CREATE_BITMAP_AREA_SIZE, 1-24
CURSOR_SPACE_FOR_TIME, 1-25
database creation, 1-34
DB_BLOCK_BUFFERS, 1-25
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-29-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-1-32
DB_NAME, 1-34
DBLINK_ENCRYPT_LOGIN, 1-35
DBWR_IO_SLAVES, 1-35
DELAYED_LOGGING_BLOCK
_CLEANOUTS, 1-36
derived parameters, 1-9
DISCRETE_TRANSACTIONS
_ENABLED, 1-37
DISK_ASYNCH_IO, 1-37
display current settings, 1-8
DISTRIBUTED_LOCK_TIMEOUT, 1-38
DISTRIBUTED_RECOVERY
_CONNECTION_HOLD
_TIME, 1-38
DISTRIBUTED_TRANSACTIONS, 1-39
DML_LOCKS, 1-39
dynamic, 1-5
ENQUEUE_RESOURCES, 1-41
EVENT, 1-42
FIXED_DATE, 1-42
FREEZE_DB_FOR_FAST_INSTANCE
_RECOVERY, 1-42
GC parameters, 1-9
GC_DEFER_TIME, 1-43
GC_FILES_TO_LOCKS, 1-44
GC_LCK_PROCS, 1-45
GC_RELEASABLE_LOCKS, 1-46
GC_ROLLBACK_LOCKS, 1-46
global cache, 1-9
global constant parameters, 1-9
GLOBAL_NAMES, 1-47
HASH_AREA_SIZE, 1-44-1-47
HASH_MULTIBLOCK_IO_COUNT, 1-47
IFILE, 1-48
INSTANCE_GROUPS, 1-49
INSTANCE_NUMBER, 1-49
JOB_QUEUE_INTERVAL, 1-50
JOB_QUEUE_PROCESSES, 1-50
language-dependent NLS, 4-9
LARGE_POOL_MIN_ALLOC, 1-51
LARGE_POOL_SIZE, 1-51
LICENSE_MAX_SESSIONS, 1-52
LICENSE_MAX_USERS, 1-53
LICENSE_SESSIONS_WARNING, 1-53
LM_LOCKS, 1-54
LM_PROCS, 1-55
LM_RESS, 1-55
LOCAL_LISTENER, 1-56
LOCK_NAME_SPACE, 1-56
LOG_ARCHIVE_BUFFER_SIZE, 1-57
LOG_ARCHIVE_BUFFERS, 1-57
LOG_ARCHIVE_DEST, 1-58
LOG_ARCHIVE_DUPLEX_DEST, 1-58
LOG_ARCHIVE_FORMAT, 1-59
LOG_ARCHIVE_MIN_SUCCEED
_DEST, 1-60
LOG_ARCHIVE_START, 1-60
LOG_BLOCK_CHECKSUM, 1-61
LOG_BUFFER, 1-61
LOG_CHECKPOINT_INTERVAL, 1-62
LOG_CHECKPOINT_TIMEOUT, 1-63
LOG_CHECKPOINTS_TO_ALERT, 1-63
LOG_FILE_NAME_CONVERT, 1-64
LOG_FILES, 1-64
LOG_SIMULTANEOUS_COPIES, 1-65
LOG_SMALL_ENTRY_MAX_SIZE, 1-65
MAX_DEFAULT_PROPAGATION
_DELAY, 1-66
MAX_DUMP_FILE_SIZE, 1-66
MAX_ENABLED_ROLES, 1-67
MAX_PARALLEL_SERVER parameter, 3-3
MAX_ROLLBACK_SEGMENTS, 1-67
MAX_TRANSACTION_BRANCHES, 1-68
MTS_DISPATCHERS, 1-68
MTS_LISTENER_ADDRESS, 1-71
MTS_MAX_DISPATCHERS, 1-72
MTS_MAX_SERVERS, 1-72
MTS_MULTIPLE_LISTENERS, 1-72
MTS_RATE_LOG_SIZE, 1-73
MTS_RATE_SCALE, 1-74
MTS_SERVERS, 1-75
MTS_SERVICE, 1-75
NLS_CALENDAR parameter, 4-19
NLS_CURRENCY, 1-76
NLS_DATE_FORMAT, 1-76
NLS_DATE_LANGUAGE, 1-77
NLS_DEBIT parameter, 4-31
NLS_DISPLAY parameter, 4-32
NLS_ISO_CURRENCY, 1-77
NLS_LANGUAGE, 1-78
NLS_LIST_SEPARATOR parameter, 4-32
NLS_MONETARY_CHARACTERS parameter, 4-33
NLS_NCHAR parameter, 4-33
NLS_NUMERIC_CHARACTERS, 1-78
NLS_SORT, 1-79
NLS_TERRITORY, 1-80
O7_DICTIONARY_ACCESSIBILITY, 1-12
OBJECT_CACHE_MAX_SIZE
_PERCENT, 1-80
OBJECT_CACHE_OPTIMAL_SIZE, 1-81
OPEN_CURSORS, 1-81
OPEN_LINKS, 1-82
OPEN_LINKS_PER_INSTANCE, 1-82
operating system dependent parameters, 1-10
OPS_ADMIN_GROUP, 1-83, 3-2-3-3
OPTIMIZER_MODE, 1-83
OPTIMIZER_PERCENT_PARALLEL, 1-84
OPTIMIZER_SEARCH_LIMIT, 1-84
ORACLE_TRACE_COLLECTION
_NAME, 1-85
ORACLE_TRACE_COLLECTION
_PATH, 1-85
ORACLE_TRACE_COLLECTION
_SIZE, 1-85
ORACLE_TRACE_ENABLE, 1-86
ORACLE_TRACE_FACILITY_NAME, 1-86
ORACLE_TRACE_FACILITY_PATH, 1-87
OS_AUTHENT_PREFIX, 1-87
OS_ROLES, 1-88
overview, 1-1
PARALLEL_DEFAULT_MAX
_INSTANCES, 1-88
PARALLEL_INSTANCE_GROUP, 1-89
PARALLEL_MAX_SERVERS, 1-89
PARALLEL_MIN_MESSAGE_POOL, 1-90
PARALLEL_MIN_PERCENT, 1-90
PARALLEL_MIN_SERVERS, 1-90-1-91
PARALLEL_SERVER, 1-91
PARALLEL_SERVER_IDLE_TIME, 1-92
PARALLEL_TRANSACTION
_RESOURCE_TIMEOUT, 1-92
PARTITION_VIEW_ENABLED, 1-93
performance tuning, 1-10
PLSQL_V2_COMPATIBILITY, 1-93
PRE_PAGE_SGA, 1-94
PROCESSES, 1-95
RECOVERY_PARALLELISM, 1-95
REDUCE_ALARM, 1-96
REMOTE_DEPENDENCIES_MODE, 1-96
REMOTE_LOGIN_PASSWORDFILE, 1-96
REMOTE_OS_AUTHENT, 1-97
REMOTE_OS_ROLES, 1-97
REPLICATION_DEPENDENCY
_TRACKING, 1-98
RESOURCE_LIMIT, 1-98
rollback segments, 1-115
ROLLBACK_CACHE_CURSORS, 1-99
ROLLBACK_SEGMENTS, 1-98
ROW_CACHE_CURSORS, 1-99
ROW_LOCKING, 1-100
SEQUENCE_CACHE_ENTRIES, 1-100
SEQUENCE_CACHE_HASH_BUCKET, 1-101
SEQUENCE_CACHED_CURSORS, 1-100-1-101
SERIAL_REUSE, 1-101
SESSION_CACHED_CURSORS, 1-102
SESSION_MAX_OPEN_FILES, 1-102
SESSIONS, 1-103
SHADOW_CORE_DUMP, 1-103
SHARED_POOL_RESERVED_MIN
_ALLOC, 1-104
SHARED_POOL_RESERVED_SIZE, 1-104, 3-93
SHARED_POOL_SIZE, 1-105
SORT_AREA_RETAINED_SIZE, 1-106
SORT_AREA_SIZE, 1-106
SORT_DIRECT_WRITES, 1-107
SORT_READ_FAC, 1-108
SORT_SPACEMAP_SIZE, 1-108
SORT_WRITE_BUFFER_SIZE, 1-109
SORT_WRITE_BUFFERS, 1-109
specifying in parameter files, 1-2
SPIN_COUNT, 1-109
SQL_TRACE, 1-110
SQL92_SECURITY, 1-111
STAR_TRANSFORMATION
_ENABLED, 1-111
TEMPORARY_TABLE_LOCKS, 1-112
THREAD, 1-112
TIMED_OS_STATISTICS, 1-113
TIMED_STATISTICS, 1-113
TRANSACTION_AUDITING, 1-114
TRANSACTIONS, 1-114
TRANSACTIONS_PER_ROLLBACK
_SEGMENT, 1-115
USE_ISM, 1-115
USER_DUMP_DEST, 1-116
UTL_FILE_DIR, 1-116
variable, 1-10
inserts
locating free space, 1-49
INST_ID column, 3-2
instance attribute lock enqueue, B-2
instance number enqueue, B-2
INSTANCE option
allocating extents, 1-49
Instance recovery, 1-43
instance recovery enqueue, B-2
instance recovery wait event, A-32
instance registration lock enqueue, B-2
instance state change wait event, A-32
instance state enqueue, B-2
INSTANCE_GROUPS parameter, 1-49
INSTANCE_NUMBER parameter, 1-49
exclusive or parallel mode, 1-49
instances
checkpoint, 1-62
startup order, 1-49
io done wait event, A-33
ISO standard
date format, 4-29
ISO week number, 4-29
IW format element, 4-30
IY format element, 4-30

J

job queue enqueue, B-2
JOB_QUEUE_INTERVAL parameter, 1-50
JOB_QUEUE_PROCESSES parameter, 1-50

K

kcl bg acks wait event, A-33
KOLF
Register LFI close wait event, A-10
Register LFI exists wait event, A-10
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-12

L

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

M

manual archiving, 1-60
MAX_COMMIT_PROPAGATION_DELAY parameter, 1-66
MAX_DUMP_FILE_SIZE parameter, 1-66
MAX_ENABLED_ROLES parameter, 1-67
MAX_ROLLBACK_SEGMENTS parameter, 1-67
MAX_TRANSACTION_BRANCHES parameter, 1-68
MAXLOGFILES option, 1-64
MAXLOGMEMBERS option, 1-64
media recovery enqueue, B-2
memory
amount used for sorting, 1-106
virtual, 1-10
migration scripts, 6-5
modes
archiving, 1-60
monetary units characters, 4-33
monitor
performance, 1-62
month
format element, 4-23
language of names, 4-23
MTS dispatcher request statistics, 3-74
MTS_DISPATCHERS parameter, 1-68
MTS_LISTENER_ADDRESS parameter, 1-71
MTS_MAX_DISPATCHERS parameter, 1-72
MTS_MAX_SERVERS parameter, 1-72
MTS_MULTIPLE_LISTENERS parameter, 1-72
MTS_RATE_LOG_SIZE parameter, 1-73
MTS_RATE_SCALE parameter, 1-74
MTS_SERVERS parameter, 1-75
MTS_SERVICE parameter, 1-75
multi-byte character sets, 4-28
storing data, 4-28
multi-byte encoding schemes, 4-5
multiple-process systems
number of processes, 1-95
multi-threaded server (MTS)
HASH_MULTIBLOCK_IO_COUNT, 1-47
SESSIONS parameter, 1-103

N

national character set
parameter, 4-33
national character sets, 4-5
choosing, 4-7
uses for, 4-7
National Language Support (NLS)
architecture, 4-2
calendars, 4-53
goals, 4-2
language-dependent behavior, 4-9
linguistic definitions, 4-51
loadable character sets, 4-28
NLS_LANGUAGE parameter, 4-15, 4-36
nested files, 1-48
next scns gotten without going to DLM statistic, C-10
NLS, 4-1
number formats, 4-13
NLS data
obsolete, 4-39
supported Arabic/Hebrew character sets, 4-50
supported calendar systems, 4-53
supported languages, 4-41
supported linguistic definitions, 4-51
supported storage character sets, 4-45
supported territories, 4-42
NLS parameters
using in SQL functions, 4-33
NLS_CALENDAR parameter, 4-19
NLS_CHARSET_DECL_LEN function, 4-38
NLS_CHARSET_ID function, 4-38
NLS_CHARSET_NAME function, 4-38
NLS_CREDIT environment variable, 4-31
NLS_CURRENCY parameter, 1-76, 4-20
defined by NLS_TERRITORY, 1-80
NLS_DATABASE_PARAMETERS view, 2-111
NLS_DATE_FORMAT parameter, 1-76, 4-21
defined by NLS_NUMERIC
_CHARACTERS, 1-80
defined by NLS_TERRITORY, 1-80
NLS_DATE_LANGUAGE parameter, 1-77, 4-22
NLS_DEBIT parameter, 4-31
NLS_DISPLAY environment variable, 4-6
NLS_DISPLAY parameter, 4-32
NLS_INSTANCE_PARAMETERS view, 2-111
NLS_ISO_CURRENCY parameter, 1-77, 4-23
defined by NLS_TERRITORY, 1-80
NLS_LANG environment variable, 4-6, 4-10-4-11, 4-27
NLS_LANGUAGE parameter, 1-78, 4-15, 4-36
NLS_LIST_SEPARATOR parameter, 4-32
NLS_MONETARY_CHARACTERS parameter, 4-33
NLS_NCHAR environment variable, 4-27
NLS_NCHAR parameter, 4-33
NLS_NUMERIC_ CHARACTERS parameter, 4-24
NLS_NUMERIC_CHARACTERS parameter, 1-78, 4-25
NLS_SESSION_PARAMETERS view, 2-111
NLS_SORT parameter, 1-79, 4-25
NLS_TERRITORY parameter, 1-80, 4-17
NLSDATA (language independent data)
loading, 4-18
utilities for loading, 4-18
NLSRTL, 4-28
NLSSORT Function, 4-37
NOARCHIVELOG mode
creating a database, 1-61
NOCACHE option, 1-100-1-101
Null Event wait event, A-13
numeric group separators, 1-78

O

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

P

pad character
alternate mappings, 4-6
parallel mode
instance number, 1-49
parallel query
idle time, 1-92
maximum number of instances, 1-88
maximum number of servers, 1-89
minimum number of queries, 1-90-1-91
OPTIMIZER_PERCENT_PARALLEL, 1-84
parallel query create server wait event, A-39
parallel query dequeue wait wait event, A-39
parallel query qref latch wait event, A-40
parallel query server shutdown wait event, A-40
parallel query signal server wait event, A-40
parallel server parameters
LM_LOCKS, 1-54
LM_PROCS, 1-55
LM_RESS, 1-55
MTS_DISPATCHERS, 1-68
MTS_LISTENER_ADDRESS, 1-71
OPS_ADMIN_GROUP, 1-83
PARALLEL_DEFAULT_MAX
_INSTANCES, 1-88
PARALLEL_INSTANCE_GROUP, 1-89
PARALLEL_MAX_SERVERS, 1-89
PARALLEL_MIN_PERCENT, 1-90
PARALLEL_MIN_SERVERS, 1-90-1-91
PARALLEL_SERVER, 1-91
PARALLEL_SERVER_IDLE_TIME, 1-92
PARALLEL_TRANSACTION
_RESOURCE_TIMEOUT, 1-92
parallel server views, 3-2
parallel slave synchronization enqueue, B-2
parallel slaves enqueue, B-2
PARALLEL_DEFAULT_MAX_INSTANCES parameter, 1-88
PARALLEL_INSTANCE_GROUP parameter, 1-89
PARALLEL_MAX_SERVERS parameter, 1-89, 3-3
PARALLEL_MIN_MESSAGE_POOL parameter, 1-90
PARALLEL_MIN_PERCENT parameter, 1-90
PARALLEL_MIN_SERVERS parameter, 1-90-1-91
PARALLEL_SERVER parameter, 1-91
PARALLEL_SERVER_IDLE_TIME parameter, 1-92
PARALLEL_TRANSACTION_RESOURCE
_TIMEOUT parameter, 1-92
parallelism
OPTIMIZER_PERCENT_PARALLEL, 1-84
parameter files
common file, 1-48
embedded files, 1-3
embedded parameter files, 1-48
line continuation character (), 1-3
parse count (hard) statistic, C-11
parse count (total) statistic, C-11
parse time cpu statistic, C-11
parse time elapsed statistic, C-11
PARSED_PIECES view, 2-111
PARSED_SIZE view, 2-111
partition
raw partition, 1-58
PARTITION_VIEW_ENABLED parameter, 1-93
partitioned indexes, 4-38
partitioned tables, 4-38
password file enqueue, B-2
passwords
authenticating, 1-87, 1-97
REMOTE_LOGIN_PASSWORDFILE parameter, 1-96
PCM lock
mapping blocks to, 1-44
PDML Restrictions
for DML_LOCKS parameter, 1-40
pending ast wait event, A-41
pending global transaction(s) wait event, A-41
percent sign
alternate mappings, 4-6
performance, 1-10
archiving, 1-57
effect of SGA size, 1-27
number of database buffers, 1-27
rule-based optimizer, 1-83
shared pool, 1-105
sort performance, 1-107
sort spacemap, 1-108
tuning archiving, 1-57
physical reads statistic, C-11
physical writes statistic, C-12
pipe get wait event, A-41
pipe put wait event, A-42
PL/SQL lock timer wait event, A-13
PLAN_TABLE execution plan table, 2-112
PLSQL_V2_COMPATIBILITY parameter, 1-93
pmon timer wait event, A-42
PRE_PAGE_SGA parameter, 1-94
precision
NUMBER and FLOAT, 2-157
private rollback segments
specifying, 1-99
privileges
remote login, 1-96
RESTRICTED_SESSION privilege, 1-52-1-53
table-level select privileges, 1-111
procedures
shared pool, 1-105
process startup enqueue, B-2
process startup wait event, A-42
processes
derived parameter values, 1-114
dispatcher process configuration, 1-68
dispatcher process maximum number, 1-72
listener process address, 1-71
maximum shared server processes, 1-72
number of server processes, 1-75
recovery, 1-95
trace files, 1-116
user processes, 1-95
PROCESSES parameter, 1-95
PRODUCT_COMPONENT_VERSION view, 2-113
profiles
resource limits, 1-98
PSTUBTBL view, 2-114
PUBLIC option
thread of redo, 1-112
public rollback segments, 1-99
using by default, 1-98
PUBLIC_DEPENDENCY view, 2-114
PUBLICSYN view, 2-114

Q

queries
dictionary views, 1-45
hints, 1-83
ordering output, 4-14
queue messages wait event, A-43
queue wait wait event, A-43
quotation marks, 1-4

R

raw partition
LOG_ARCHIVE_DEST parameter, 1-58
rdbms ipc message block wait event, A-44
rdbms ipc message wait event, A-43
rdbms ipc reply wait event, A-44
read consistency
rollback information, 1-46
recovery
number of required processes, 1-95
recovery array read time statistic, C-12
recovery array reads statistic, C-12
recovery blocks read statistic, C-12
RECOVERY_PARALLELISM parameter, 1-95
recursive calls statistic, C-12
recursive cpu usage statistic, C-12
redo entries linearized statistic, C-13
redo entries statistic, C-12
redo log "kick" enqueue, B-2
redo log buffers
size, 1-61
redo log space requests statistic, C-13
redo log space wait time statistic, C-13
redo log switch interrupts statistic, C-13
redo ordering marks statistic, C-13
redo size statistic, C-13
redo sync writes statistic, C-14
redo synch time statistic, C-13
redo thread, 1-112
redo thread enqueue, B-2
redo wastage statistic, C-14
redo write time statistic, C-14
redo writer latching time statistic, C-14
redo writes statistic, C-14
REDUCE_ALARM parameter, 1-96
remote clients
authenticating, 1-97
remote instance undo block writes statistic, C-14
remote instance undo header writes statistic, C-14
remote instance undo requests statistic, C-14
remote logins, 1-96
REMOTE_DEPENDENCIES_MODE parameter, 1-96
REMOTE_LOGIN_PASSWORDFILE parameter, 1-96
REMOTE_OS_AUTHENT parameter, 1-97
REMOTE_OS_ROLES parameter, 1-97
replacement characters, 4-36
REPLICATION_DEPENDENCY
_TRACKING parameter, 1-98
resource limits for profiles, 1-98
RESOURCE_COST view, 2-115
RESOURCE_LIMIT parameter, 1-98
RESOURCE_MAP view, 2-115
RM format element, 4-21
ROLE_ROLE_PRIVS view, 2-115
ROLE_SYS_PRIVS view, 2-115
ROLE_TAB_PRIVS view, 2-116
roles, 1-88
remote clients, 1-97
rollback segments
acquiring, 1-99, 1-115
distributed locks, 1-46
global constant parameters, 1-46
initialization parameters, 1-46
maximum size, 1-67
number of concurrent transactions, 1-115
private rollback segments, 1-99
public rollback segments, 1-99
specifying, 1-99
SYSTEM, 1-99
ROLLBACK_SEGMENTS parameter, 1-98
unique values, 1-99
Roman numerals
format mask for, 4-21
row cache cursor, 1-99
row cache enqueue, B-2
row cache lock wait event, A-44
ROW_CACHE_CURSORS parameter, 1-99
ROW_LOCKING parameter, 1-100
RULE, 1-83-1-84
rule-based optimizer, 1-83

S

scginq AST call wait event, A-44
scripts
data dictionary, 6-2
migration, 6-4-6-5
SQL scripts, 6-1
SEQ synonym for USER_SEQUENCES, 2-116
sequence number enqueue, B-2
sequence number value enqueue, B-2
SEQUENCE_CACHE_ENTRIES parameter, 1-100-1-101
SEQUENCE_CACHE_HASH_BUCKET parameter, 1-101
sequences
data dictionary cache, 1-100-1-101
not cached, 1-100-1-101
SERIAL_REUSE parameter, 1-101
serializable aborts statistic, C-15
server processes
number, 1-75
session connect time statistic, C-15
session cursor cache count statistic, C-15
session cursor cache hits statistic, C-15
session logical reads statistic, C-15
session pga memory max statistic, C-15
session pga memory statistic, C-15
session stored procedure space statistic, C-16
session uga memory max statistic, C-16
session uga memory statistic, C-16
SESSION_CACHED_CURSORS parameter, 1-102
SESSION_MAX_OPEN_FILES parameter, 1-102
SESSION_PRIVS view, 2-116
SESSION_ROLES view, 2-116
SESSIONS parameter, 1-103
SGA, 1-10
SHADOW_CORE_DUMP parameter, 1-103
shared server processes
maximum number, 1-72
SHARED_POOL_RESERVED_MIN_ALLOC parameter, 1-104
SHARED_POOL_RESERVED_SIZE parameter, 1-104
V$SHARED_POOL_RESERVED, 3-93
SHARED_POOL_SIZE parameter, 1-105
SHOW command
PARAMETERS option, 1-8
single-task message wait event, A-45
slave exit wait event, A-45
SMON enqueue, B-2
smon timer wait event, A-45
SNP background processes, 1-50
sort segment enqueue, B-2
SORT_AREA_RETAINED_SIZE parameter, 1-106
SORT_AREA_SIZE parameter, 1-106
SORT_DIRECT_WRITES parameter, 1-107
SORT_READ_FAC parameter, 1-108
SORT_SPACEMAP_SIZE parameter, 1-108
SORT_WRITE_BUFFER_SIZE parameter, 1-109
SORT_WRITE_BUFFERS parameter, 1-109
sorting
character data, 4-14
double characters, 4-15
following language conventions, 4-14
maximum memory, 1-106
order, 4-14
ORDER BY queries, 1-79
specifying non-default, 4-25
sorts (disk) statistic, C-16
sorts (memory) statistic, C-16
sorts (rows) statistic, C-16
SOURCE_SIZE view, 2-116
space
SGA, 1-64
space management transaction enqueue, B-2
SPIN_COUNT parameter, 1-109
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-14
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-15
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-110
SQL92_SECURITY parameter, 1-111
STAR_TRANSFORMATION_ENABLED parameter, 1-111
START option
automatic archiving, 1-58
starting up
database name, 1-34
instance number, 1-49
startup order, 1-49
STARTUP command
database name, 1-34
statistics
dbwr checkpoints, 1-62
effect of cache size, 1-27-1-28
timed, 1-113
STMT_AUDIT_OPTION_MAP table
auditing option type codes, 2-117
storage character sets
supported, 4-45
storing data
in multi-byte character sets, 4-28
string comparisons
and WHERE clause, 4-37
summed dirty queue length statistic, C-16
supported character sets, 4-27
supported character string functionality and character sets, 4-27
switch logfile command wait event, A-45
switch redo log file, 1-62
SYN synonym for USER_SYNONYMS, 2-117
synchronized replication enqueue, B-2
SYNONYMS view, 2-117
SYS_OBJECTS view, 2-118
SYSCATALOG view, 2-117
SYSFILES view, 2-117
SYSSEGOBJ view, 2-117
system commit number enqueue, B-2
System Global Area (SGA)
buffer areas, 1-25, 1-61
buffer cache, 1-25
maximum concurrent transactions, 1-114
rollback segment size, 1-67
sequence cache, 1-100-1-101
size of, 1-25, 1-64
tuning, 1-27-1-28
system performance, 1-10
SYSTEM rollback segment, 1-99
SYSTEM_PRIVILEGE_MAP view, 2-117

T

TAB view, 2-118
table fetch by rowid statistic, C-17
table fetch continued row statistic, C-17
table scan blocks gotten statistic, C-17
table scan rows gotten statistic, C-17
table scans (cache partitions) statistic, C-17
table scans (direct read) statistic, C-18
table scans (long tables) statistic, C-18
table scans (rowid ranges) statistic, C-18
TABLE_PRIVILEGE_MAP table
access privilege codes, 2-119
TABLE_PRIVILEGES view, 2-118
tables
data dictionary, 2-1
DML locks, 1-39
free lists, 1-30
locating free space, 1-49
partitioned, 4-38
row locking, 1-100
temporary tables, 1-112
TABQUOTAS view, 2-119
TABS synonym for USER_TABLES, 2-119
tape archiving destination, 1-58
TAPE_ASYNCH_IO parameter
initialization parameters
TAPE_ASYNCH_IO, 1-111
temporary segment enqueue, B-2
temporary table enqueue, B-2
TEMPORARY_TABLE_LOCKS parameter, 1-112
territories
supported, 4-42
territory, 1-80, 4-17
THREAD parameter, 1-112
TIMED_OS_STATISTICS parameter, 1-113
TIMED_STATISTICS parameter, 1-113
file read/write statistics, 3-43
timer in sksawat wait event, A-45
TO_CHAR function, 1-76
default date format, 4-21
format masks, 4-29
group separator, 4-25
language for dates, 4-22
spelling of days and months, 4-22
TO_DATE function, 1-76
default date format, 4-21
format masks, 4-29
language for dates, 4-22
spelling of days and months, 4-22
TO_NUMBER function
format masks, 4-29
group separator, 4-25
total file opens statistic, C-18
trace files
ALERT file, 1-16
destination, 1-16, 1-116
location of, 1-16
maximum size, 1-66
transaction enqueue, B-2
transaction recovery enqueue, B-2
transaction wait event, A-46
TRANSACTION_AUDITING parameter, 1-114
transactions
concurrent, 1-114
data locking, 1-39
rollback segments, 1-115
TRANSACTIONS parameter, 1-99, 1-114
DML locks, 1-39
TRANSACTIONS_PER_ROLLBACK
_SEGMENT parameter, 1-99, 1-115
Trusted ORACLE
ALL_LABELS view, 2-14
data dictionary, 2-1
TRUSTED_SERVERS view, 2-119
TS_PITR_CHECK view, 2-120
TS_PITR_OBJECTS TO_BE_DROPPED view, 2-121

U

unbound tx wait event, A-46
underscore
alternate mappings, 4-6
undo segment extension wait event, A-46
undo segment recovery wait event, A-46
undo segment tx slot wait event, A-47
undo segment, serialization enqueue, B-2
UNICODE, 4-6, 4-40
Unnecesary process cleanup for SCN batching statistic, C-4
updates
locating free space, 1-49
transaction processing option, 1-100
uppercase characters, 1-3
USE_ISM parameter, 1-115
user calls statistic, C-18
user commits statistic, C-18
user name enqueue, B-2
user processes
trace files, 1-116
user rollbacks statistic, C-19
USER_ALL_TABLES view, 2-121
USER_ARGUMENTS view, 2-123
USER_AUDIT_OBJECT view, 2-124
USER_AUDIT_SESSION view, 2-125
USER_AUDIT_STATEMENT view, 2-126
USER_AUDIT_TRAIL view, 2-127
USER_CATALOG view, 2-128
CAT synonym, 2-40
USER_CLU_COLUMNS view, 2-129
USER_CLUSTERS view, 2-128
CLU synonym, 2-41
USER_COL_COMMENTS view, 2-130
USER_COL_PRIVS view, 2-130
USER_COL_PRIVS_MADE view, 2-130
USER_COL_PRIVS_RECD view, 2-131
USER_COLL_TYPES view, 2-131
USER_CONS_COLUMNS view, 2-132
USER_CONSTRAINTS view, 2-131
USER_DB_LINKS view, 2-133
USER_DEPENDENCIES view, 2-133
USER_DUMP_DEST parameter, 1-116
USER_ERRORS view, 2-134
USER_EXTENTS view, 2-134
USER_FREE_SPACE view, 2-134
USER_IND_COLUMNS view, 2-136
USER_IND_PARTITIONS view, 2-137
USER_INDEXES view, 2-135
IND synonym, 2-108
USER_JOBS view, 2-138
USER_LIBRARIES view, 2-139
USER_LOBS view, 2-139
USER_METHOD_PARAMS view, 2-139
USER_METHOD_RESULTS view, 2-140
USER_NESTED_TABLES view, 2-140
USER_OBJ_AUDIT_OPTS view, 2-144
USER_OBJECT_SIZE view, 2-143
USER_OBJECT_TABLES view, 2-141
USER_OBJECTS view, 2-142
OBJ syonym, 2-111
USER_PART_COL_STATISTICS view, 2-144
USER_PART_HISTOGRAMS view, 2-145
USER_PART_INDEXES view, 2-145
USER_PART_KEY_COLUMNS view, 2-145
USER_PART_TABLES view, 2-146
USER_PASSWORD_LIMITS view, 2-147
USER_QUEUE_TABLES view, 2-147
USER_QUEUES view, 2-148
USER_REFRESH view, 2-148
USER_REFRESH_CHILDREN view, 2-149
USER_REFS view, 2-150
USER_REPCATLOG view, 2-150
USER_REPCOLUMN view, 2-150
USER_REPCOLUMN_GROUP view, 2-150
USER_REPCONFLICT view, 2-151
USER_REPDDL view, 2-151
USER_REPGENERATED view, 2-151
USER_REPGROUP view, 2-151
USER_REPGROUPED_COLUMNS view, 2-151
USER_REPKEY_COLUMNS view, 2-151
USER_REPOBJECT view, 2-151
USER_REPPARAMETER_COLUMN view, 2-151
USER_REPPRIORITY view, 2-152
USER_REPPRIORITY_GROUP view, 2-152
USER_REPPROP view, 2-152
USER_REPRESOL_STATS_CONTROL view, 2-152
USER_REPRESOLUTION view, 2-152
USER_REPRESOLUTION_METHOD view, 2-152
USER_REPRESOLUTION_STATISTICS view, 2-152
USER_REPSITES view, 2-152
USER_RESOURCE_LIMITS view, 2-153
USER_ROLE_PRIVS view, 2-153
USER_SEGMENTS view, 2-153
USER_SEQUENCES view, 2-154
SEQ synonym, 2-116
USER_SNAPSHOT_LOGS view, 2-155
USER_SNAPSHOTS view, 2-154
USER_SOURCE view, 2-156
USER_SYNONYMS view, 2-156
SYN synonym, 2-117
USER_SYS_PRIVS view, 2-156
USER_TAB_COL_STATISTICS view, 2-157
USER_TAB_COLUMNS
COLS synonym, 2-41
USER_TAB_COLUMNS view, 2-157
USER_TAB_COMMENTS view, 2-158
USER_TAB_HISTOGRAMS view, 2-158
USER_TAB_PARTITIONS view, 2-159
USER_TAB_PRIVS view, 2-160
USER_TAB_PRIVS_MADE view, 2-160
USER_TAB_PRIVS_RECD view, 2-160
USER_TABLES view, 2-161
USER_TABLESPACES view, 2-162
USER_TRIGGER_COLS view, 2-163
USER_TRIGGERS view, 2-163
USER_TS_QUOTAS view, 2-164
USER_TYPE_ATTRS view, 2-164
USER_TYPE_METHODS view, 2-165
USER_TYPES view, 2-164
USER_UPDATABLE_COLUMNS view, 2-165
USER_USERS view, 2-165
USER_VIEWS view, 2-166
user-defined locks enqueue, B-2
USERLOCK.SQL script, 6-3
users
authenticating, 1-87
multiple, 1-40
UTF2 encoding, 4-6, 4-40
UTF8 encoding, 4-6, 4-40
UTL_FILE_DIR parameter, 1-116
UTLBSTAT.SQL script, 6-3
UTLCHAIN.SQL script, 6-3
UTLCONST.SQL script, 6-3
UTLDTREE.SQL script, 2-98, 2-108, 6-3
UTLESTAT.SQL script, 6-3
UTLEXCPT.SQL script, 6-3
UTLHTTP.SQL script, 6-3
UTLLOCKT.SQL script, 6-3
UTLPG.SQL script, 6-3
UTLPWDMG.SQL script, 6-3
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-4
V$ACTIVE_INSTANCES view, 3-4
V$ARCHIVE view, 3-4
V$ARCHIVE_DEST, 3-5
V$ARCHIVED_LOG view, 3-5
V$BACKUP view, 3-6
V$BACKUP_CORRUPTION view, 3-7
V$BACKUP_DATAFILE view, 3-7
V$BACKUP_DEVICE view, 3-8
V$BACKUP_PIECE view, 3-9
V$BACKUP_REDOLOG view, 3-10
V$BACKUP_SET view, 3-11
V$BGPROCESS view, 3-12
V$BH view, 3-12
V$BUFFER_POOL view, 3-14
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-20
V$CONTROLFILE view, 3-20
V$CONTROLFILE_RECORD_SECTION view, 3-21
V$COPY_CORRUPTION view, 3-21
V$DATABASE view, 3-22
V$DATAFILE view, 3-23
V$DATAFILE_COPY view, 3-25
V$DATAFILE_HEADER view, 3-26
V$DB_OBJECT_CACHE view, 3-29
V$DB_PIPES view, 3-30
V$DBFILE view, 3-28
V$DBLINK view, 3-28
V$DELETED_OBJECT view, 3-30
V$DISPATCHER view, 3-31
V$DISPATCHER_RATE view, 3-31
V$DLM_CONVERT_LOCAL view, 3-34
V$DLM_CONVERT_REMOTE view, 3-35
V$DLM_LATCH view, 3-36
V$DLM_MISC view, 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-43
V$GLOBAL_TRANSACTION view, 3-44
V$INDEXED_FIXED_COLUMN view, 3-44
V$INSTANCE view, 3-45
V$LATCH view, 3-46
V$LATCH_CHILDREN view, 3-48
V$LATCH_MISSES view, 3-49
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-57
V$LOG view, 3-57
V$LOG_HISTORY view, 3-59
V$LOGFILE view, 3-58
V$LOGHIST view, 3-58
V$MLS_PARAMETERS view, 3-59
V$MTS view, 3-60
V$MYSTAT view, 3-60
V$NLS_PARAMETERS view, 3-61
V$NLS_VALID_VALUES view, 3-61
V$OBJECT_DEPENDENCY view, 3-61
V$OFFLINE_RANGE view, 3-62
V$OPEN_CURSOR view, 3-63
V$OPTION view, 3-63
V$PARAMETER view, 3-63
V$PING view, 3-64
V$PQ_SESSTAT view, 3-66
V$PQ_SLAVE view, 3-67
V$PQ_SYSSTAT view, 3-68
V$PQ_TQSTAT view, 3-69
V$PROCESS view, 3-70
V$PWFILE_USERS view, 3-70
V$QUEUE view, 3-71
V$RECOVER_FILE view, 3-71
V$RECOVERY_FILE_STATUS view, 3-71
V$RECOVERY_LOG view, 3-72
V$RECOVERY_STATUS view, 3-73
V$REQDIST view, 3-74
V$RESOURCE view, 3-74
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-92
V$SESSION view, 3-78
V$SESSION_CONNECT_INFO view, 3-85
V$SESSION_CURSOR_CACHE view, 3-86
V$SESSION_EVENT view, 3-86, A-1
V$SESSION_LONGOPS view, 3-87
V$SESSION_OBJECT_CACHE view, 3-89
V$SESSION_WAIT view, 3-89, A-1
V$SESSTAT view, 3-91, C-1
V$SGA view, 3-92
V$SGASTAT view, 3-92
V$SHARED_POOL_RESERVED view, 3-93
V$SHARED_SERVER view, 3-94
V$SORT_SEGMENT view, 3-95
V$SORT_USAGE view, 3-96
V$SQL view, 3-96
V$SQL_BIND_DATA view, 3-99
V$SQL_BIND_METADATA view, 3-100
V$SQL_CURSOR view, 3-100
V$SQL_SHARED_MEMORY view, 3-101
V$SQLAREA view, 3-102
V$SQLTEXT view, 3-104
V$SQLTEXT_WITH_NEWLINES view, 3-104
V$STATNAME view, 3-105, C-1
V$SUBCACHE view, 3-108
V$SYSSTAT view, 3-108, C-1
V$SYSTEM_CURSOR_CACHE view, 3-109
V$SYSTEM_EVENT view, 3-109, A-1
V$SYSTEM_PARAMETER view, 3-110
V$TABLESPACE view, 3-111
V$THREAD view, 3-111
V$TIMER view, 3-112
V$TRANSACTION view, 3-112
V$TRANSACTION_ENQUEUE view, 3-114
V$TYPE_SIZE view, 3-115
V$VERSION view, 3-115
V$WAITSTAT view, 3-115
VARCHAR2 datatype
multi-byte character sets and, 4-28
variable parameters, 1-10
views
data dictionary views, 2-2
data files, 1-45
virtual circuit status wait event, A-47

W

wait event
parameter descriptions, A-6
week numbers, 4-29
WHERE clause
and string comparisons, 4-37
WMON goes to sleep wait event, A-16
write requests statistic, C-19
writes stopped by instance recovery wait event, A-48

X

X$KCBCBH table, 1-28

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

Library
Product
Contents