Oracle7 Server Reference Manual
Library
Product
Contents
Index
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
@
# symbol
7-bit ASCII
8-bit ASCII
abbreviations
AM/PM
BC/AD
ACCESSIBLE_COLUMNS view
acquiring rollback segments, distributed locks
ALERT file
ALL_CATALOG view
[
2
]
ALL_COL_PRIVS view
ALL_COL_PRIVS_MADE view
ALL_COL_PRIVS_RECD view
ALL_COLUMN_COMMENTS view
ALL_CONS_COLUMNS view
ALL_CONSTRAINTS view
ALL_DB_LINKS view
ALL_DEF_AUDIT_OPTS view
ALL_DEPENDENCIES view
ALL_ERRORS view
ALL_HISTOGRAMS view
ALL_IND_COLUMNS view
ALL_INDEXES view
ALL_LABELS view
ALL_MOUNTED_DBS view
ALL_OBJECTS view
ALL_REFRESH view
ALL_REFRESH_CHILDREN view
ALL_SEQUENCES view
ALL_SNAPSHOTS view
ALL_SOURCE view
ALL_SYNONYMS view
ALL_TAB_COLUMNS view
ACCESSIBLE_COLUMNS synonym
ALL_TAB_COMMENTS view
ALL_TAB_PRIVS view
ALL_TAB_PRIVS_MADE view
ALL_TAB_PRIVS_RECD view
ALL_TABLES view
ALL_TRIGGER_COLS view
ALL_TRIGGERS view
ALL_UPDATABLE_COLUMNS view
ALL_USERS view
ALL_VIEWS view
ALLOCATE EXTENT option, instance number
allocation
archival buffer
PCM locks
rollback segments
ALTER DATABASE command
ADD LOGFILE
database name
ENABLE THREAD
THREAD
ALTER SESSION command
SET HASH_AREA_SIZE option
SET HASH_JOIN_ENABLED option
SET HASH_MULTIBLOCK_IO_COUNT option
SET LOG_SIMULTANEOUS_COPIES option
SET NLS_* options
SET NLS_CURRENCY option
[
2
]
SET NLS_DATE_FORMAT option
SET NLS_LANGUAGE option
SET NLS_NUMERIC_CHARACTERS option
SET NLS_TERRITORY option
SET OPTIMIZER_MODE option
SET OPTIMIZER_PERCENT_PARALLEL option
SET PARTITION_VIEW_ENABLED option
SET SQL_TRACE option
ALTER SYSTEM command
SET HASH_MULTIBLOCK_IO_COUNT option
SET NLS_LANGUAGE option
ALTER TABLE statement, allocating extents
ALWAYS_ANTI_JOIN parameter
AM/PM abbreviation, language of
ANALYZE command
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
] [
8
] [
9
]
applications
language behavior for
NLS support
Arabic character set
[
2
]
ARCHIVE LOG command
destination file
START and STOP
archived redo log
automatic versus manual
buffer
[
2
]
storage device
[
2
]
tuning
[
2
]
ARCHIVELOG mode, archiving destination
[
2
]
automatic archiving
ASCII character set, sorting order
AUDIT_ACTIONS table
AUDIT_TRAIL parameter
authenticating remote clients
authenticating users
AUTO_MOUNTING parameter
background processes
enabling the checkpoint process (CKPT)
LCKn
SNP background process
specifying number
specifying trace files
tuning the log writer process (LGWR)
BACKGROUND_DUMP_DEST parameter
ALERT file
backslash (\) character
BC/AD abbreviation, language of
binary sorting
BLANK_TRIMMING parameter
block
deferred rollback
PCM lock
[
2
]
redo log
[
2
]
rollback segment
size
when written to disk
buffer cache, database
buffers, archival
[
2
]
effect on performance
number of
[
2
]
CACHE_SIZE_THRESHOLD parameter
cache
database blocks
dictionary
row cache
sequence cache
statistics
calendar systems
calendars
CAT synonym for USER_CATALOG
CATALOG
CATALOG.SQL scripts
CATALOG.SQL, creating V$ views
CATALOG6.SQL script
CATAUDIT.SQL script
audit trail records created by
audit trails for connections and disconnections
auditing options created by
CATAUDIT.SQL scripts
CATBLOCK.SQL script
CATDBSYN.SQL script
CATEXP.SQL scripts
CATEXP6.SQL script
CATLDR.SQL scripts
CATNOAUD.SQL script
CATNOPRC.SQL script
CATNOREP.SQL script
CATNOSVM.SQL script
CATPARR.SQL script
CATPRC.SQL script
CATPROC.SQL script
CATREPAD.SQL script
CATRPC.SQL script
CATSNAP.SQL script
CATSVRMG.SQL script
CATTRUST.SQL script
CHAINED_ROWS view
CHAR datatype, multi-byte character sets and
character encoding schemes
character sets
7-bit ASCII
8-bit versus 7-bit
CONVERT function
converting
[
2
]
encoding schemes
loadable character sets
multi-byte
sorting data
characters, numeric group separators
checkpoint process (CKPT)
CHECKPOINT_PROCESS parameter
checkpoints
checkpoint interval
CKPT process
statistics
CKPT
CLEANUP_ROLLBACK_ENTRIES parameter
CLOSE_CACHED_OPEN_CURSORS parameter
CLU synonym for USER_CLUSTERS
code pages
CODE_PIECES view
CODE_SIZE view
COL view
COLS synonym for USER_TAB_COLUMNS
COLUMN_PRIVILEGES view
comments, in parameter files
COMMIT_POINT_STRENGTH parameter
COMPATIBLE parameter
COMPATIBLE_NO_RECOVERY parameter
concatenation operator
concurrency
ROW_LOCKING parameter
sequences
SERIALIZABLE parameter
transactions and
transactions per rollback segment
user processes
connecting
consistency
multiversion read
rollback information
SERIALIZABLE parameter
contention, block-level
context areas, sort spacemap
control files
names
specifying
CONTROL_FILES parameter
CONVERT function
converting character sets
cost-based optimizer
[
2
]
CPU_COUNT parameter
CREATE DATABASE command
database name
MAXDATAFILES option
MAXLOGFILES option
setting the block size
setting the log mode
CREATE INDEX command, performance
CREATE TABLE statement, FREELIST GROUPS option
creating
databases
setting block size
currency
currency symbol
default
local currency symbol
currency
international currency symbol
monetary units characters
CURSOR_SPACE_FOR_TIME parameter
cursors
OPEN_CURSORS parameter
row cache
shared pool
data blocks
reading multiple
size of
data dictionary
base tables
cache
datafiles
[
2
]
DICTIONARY view
dynamic performance tables
location
rollback segments
row cache
scripts
sequence cache
SQL scripts
tables
views
DBA views
overview
[
2
]
user views
database administrator, data dictionary views
database writer process (DBWR), batch writes
[
2
]
checkpoint
databases
database limits
default language
full database import
name
number of redo log files
resource limits
valid characters for database name
data
conversion
CONVERT function
datafiles
batch writes
mapping blocks to PCM locks
maximum number
[
2
]
parameter
unspecified for PCM locks
dates
ISO standard
language used for
NLS_DATE_LANGUAGE parameter
NLS_TERRITORY parameter
setting SYSDATE
TO_CHAR and TO_DATE functions
day
format element
language of names
DB_BLOCK_BUFFERS parameter
DB_BLOCK_CHECKPOINT_BATCH parameter
DB_BLOCK_CHECKSUM parameter
DB_BLOCK_LRU_EXTENDED_STATISTICS parameter
DB_BLOCK_LRU_LATCHES parameter
DB_BLOCK_LRU_STATISTICS parameter
DB_BLOCK_SIZE parameter
[
2
]
DB_DOMAIN parameter
DB_FILE_MULTIBLOCK_READ_COUNT parameter
DB_FILE_SIMULTANEOUS_WRITES parameter
DB_FILE_STANDBY_NAME_CONVERT parameter
DB_FILES parameter
DB_MOUNT_MODE, Trusted ORACLE parameter
DB_NAME parameter
DBA_2PC_NEIGHBORS view
DBA_2PC_PENDING view
DBA_ANALYZE_OBJECTS view
DBA_AUDIT_EXISTS view
DBA_AUDIT_OBJECT view
DBA_AUDIT_SESSION view
DBA_AUDIT_STATEMENT view
DBA_AUDIT_TRAIL view
DBA_BLOCKERS view
DBA_CATALOG view
DBA_CLU_COLUMNS view
DBA_CLUSTERS view
DBA_COL_COMMENTS view
DBA_COL_PRIVS view
DBA_CONS_COLUMNS view
DBA_CONSTRAINTS view
DBA_DATA_FILES view
[
2
]
DBA_DB_LINKS view
DBA_DDL_LOCKS view
DBA_DEPENDENCIES view
DBA_DML_LOCKS view
DBA_ERRORS view
DBA_EXP_FILES view
DBA_EXP_OBJECTS view
DBA_EXP_VERSION view
DBA_EXTENTS view
DBA_FREE_SPACE view
DBA_FREE_SPACE_COALESCED view
DBA_HISTOGRAMS view
DBA_IND_COLUMNS view
DBA_INDEXES view
DBA_JOBS view
DBA_JOBS_RUNNING view
DBA_LOCKS view
DBA_OBJ_AUDIT_OPTS view
DBA_OBJECT_SIZE view
DBA_OBJECTS view
DBA_PRIV_AUDIT_OPTS view
DBA_PROFILES view
DBA_RCHILD view
DBA_REFRESH view
DBA_REFRESH_CHILDREN view
DBA_RGROUP view
DBA_ROLE_PRIVS view
DBA_ROLES view
DBA_ROLLBACK_SEGS view
DBA_SEGMENTS view
DBA_SEQUENCES view
DBA_SNAPSHOT_LOGS view
DBA_SNAPSHOTS view
DBA_SOURCE view
DBA_STMT_AUDIT_OPTS view
DBA_SYNONYMS view
DBA_SYS_PRIVS view
DBA_TAB_COLUMNS view
DBA_TAB_COMMENTS view
DBA_TAB_PRIVS view
DBA_TABLES view
DBA_TABLESPACES view
DBA_TRIGGER_COLS view
DBA_TRIGGERS view
DBA_TS_QUOTAS view
DBA_UPDATABLE_COLUMNS view
DBA_USERS view
DBA_VIEWS view
DBLINK_ENCRYPT_LOGIN parameter
DBMS_ALERT_INFO view
DBMS_LOCK_ALLOCATED table
DBMSALRT.SQL script
DBMSDESC.SQL script
DBMSLOCK.SQL script
DBMSMAIL.SQL script
DBMSOTPT.SQL script
DBMSPIPE.SQL script
DBMSSNAP.SQL script
DBMSSTDX.SQL script
DBMSUTIL.SQL script
DBWR
debit symbol
decimal character
default
NLS_NUMERIC_CHARACTERS parameter
when not a period (.)
DEFCALL view
deferred rollback segment
DELAYED_LOGGING_BLOCK_CLEANOUTS parameter
DEPTREE view
derived parameters
destination
archiving redo log files
BACKGROUND_DUMP_DEST parameter
overriding default
USER_DUMP_DEST
devices, storage
DICT synonym for DICTIONARY
DICT_COLUMNS view
DICTIONARY view
DICT synonym
DISCRETE_TRANSACTIONS_ENABLED parameter
disk drives
archiving destination
writing blocks
dispatcher processes
configuration
maximum number
distributed lock
exclusive
rollback segment
[
2
] [
3
]
segment
space management
total number
[
2
] [
3
]
distributed queries
disabling
enabling
links for
distributed transactions, limiting number of
DISTRIBUTED_LOCK_TIMEOUT parameter
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME parameter
DISTRIBUTED_TRANSACTIONS parameter
DIUTIL.SQL script
DML_LOCKS parameter
DROPCAT6.SQL script
dump files
dynamic initialization parameters
dynamic performance tables
CATALOG.SQL script
granting selective access
performance
public synonyms (V$)
views (V_$)
EBCDIC character set, sorting order
embedded parameter files
ENQUEUE_RESOURCES parameter
enqueues
disabling
ENQUEUE_RESOURCES parameter
environment variables
client environment
NLS parameters
[
2
]
NLS_LANG
ERROR_SIZE view
errors, archiving
EVENT parameter
EXCEPTIONS table
exclusive distributed lock, rollback data
exclusive mode, specifying instance number
extent, allocating to instance
FILE_LOCK view
FILE_PING view
filenames
case significance
name and number
FILEXT$ view
FIRST_ROWS
[
2
]
FIXED_DATE parameter
format elements
[
2
]
C
D
[
2
]
day
G
[
2
]
IW
IY
L
[
2
]
month
RM
[
2
]
RN
free space list, locating space
FREELIST GROUPS storage option
FREELISTS storage option, maximum value
GC_DB_LOCKS parameter
unassigned locks
GC_DEFAULT_LOCKS parameter
GC_FILES_TO_LOCKS parameter
GC_LCK_PROCS parameter
GC_RELEASABLE_LOCKS parameter
GC_ROLLBACK_LOCKS parameter
GC_ROLLBACK_SEGMENTS parameter
GC_SAVE_ROLLBACK_LOCKS parameter
GC_SEGMENTS parameter
GC_TABLESPACES parameter
global cache control parameters
[
2
] [
3
]
global constant parameter, rollback segments
[
2
]
GLOBAL_NAME view
GLOBAL_NAMES parameter
group separator
default
NLS_NUMERIC_CHARACTERS parameter
HASH_AREA_SIZE parameter
HASH_JOIN_ENABLED parameter
HASH_MULTIBLOCK_IO_COUNT parameter
Hebrew character set
[
2
]
hints
FIRST_ROWS
RULE
[
2
]
HISTOGRAMS view
I/O
reading multiple blocks
redo log files
reducing with buffer cache
IDEPTREE view
IFILE
IFILE keyword
nested files
importing, performance
IND synonym for USER_INDEXES
INDEX_HISTOGRAM view
INDEX_STATS view
indexes
FREELISTS option
maximum PGA memory
sort spacemap
INIT.ORA, parameter files
INIT_SQL_FILES parameter
data dictionary creation
initialization parameters
altering
ALWAYS_ANTI_JOIN parameter
AUDIT_TRAIL parameter
AUTO_MOUNTING parameter
BACKGROUND_DUMP_DEST parameter
BLANK_TRIMMING parameter
CACHE_SIZE_THRESHOLD parameter
case significance in filenames
CHECKPOINT_PROCESS parameter
CLEANUP_ROLLBACK_ENTRIES parameter
CLOSE_CACHED_OPEN_CURSORS parameter
COMMIT_POINT_STRENGTH parameter
COMPATIBLE parameter
COMPATIBLE_NO_RECOVERY parameter
CONTROL_FILES parameter
controling archiving
CPU_COUNT parameter
CURSOR_SPACE_FOR_TIME parameter
database creation
DB_BLOCK_BUFFERS parameter
DB_BLOCK_CHECKPOINT_BATCH parameter
DB_BLOCK_CHECKSUM parameter
DB_BLOCK_LRU_EXTENDED_STATISTIC parameter
DB_BLOCK_LRU_LATCHES parameter
DB_BLOCK_LRU_STATISTICS parameter
DB_BLOCK_SIZE parameter
DB_DOMAIN parameter
DB_FILE_MULTIBLOCK_READ_COUNT parameter
DB_FILE_SIMULTANEOUS_WRITES parameter
DB_FILE_STANDBY_NAME_CONVERT parameter
DB_FILES parameter
DB_MOUNT_MODE parameter
DB_NAME parameter
DBLINK_ENCRYPT_LOGIN parameter
DELAYED_LOGGING_BLOCK_CLEANOUTS parameter
derived parameters
DISCRETE_TRANSACTIONS_ENABLED parameter
display current settings
DISTRIBUTED_LOCK_TIMEOUT parameter
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME parameter
DISTRIBUTED_TRANSACTIONS parameter
DML_LOCKS parameter
dynamic
ENQUEUE_RESOURCES parameter
EVENT parameter
FIXED_DATE parameter
GC parameters
GC_DB_LOCKS parameter
GC_DEFAULT_LOCKS parameter
GC_FILES_TO_LOCKS parameter
GC_LCK_PROCS parameter
GC_RELEASABLE_LOCKS parameter
GC_ROLLBACK_LOCKS parameter
GC_ROLLBACK_SEGMENT parameter
GC_SAVE_ROLLACK_LOCKS parameter
GC_SEGMENTS parameter
GC_TABLESPACES parameter
global cache
global constant parameters
GLOBAL_NAMES parameter
HASH_AREA_SIZE parameter
HASH_JOIN_ENABLED parameter
HASH_MULTIBLOCK_IO_COUNT parameter
INIT_SQL_FILES
INIT_SQL_FILES parameter
INSTANCE_NUMBER parameter
JOB_QUEUE_INTERVAL parameter
JOB_QUEUE_PROCESSES parameter
LABEL_CACHE_SIZE parameter
language-dependent NLS
LICENSE_MAX_SESSIONS parameter
LICENSE_MAX_USERS parameter
LICENSE_SESSIONS_WARNING parameter
LOG_ARCHIVE_BUFFER_SIZE parameter
LOG_ARCHIVE_BUFFERS parameter
LOG_ARCHIVE_DEST parameter
LOG_ARCHIVE_FORMAT parameter
LOG_ARCHIVE_START parameter
LOG_BLOCK_CHECKSUM parameter
LOG_BUFFER parameter
LOG_CHECKPOINT_INTERVAL parameter
LOG_CHECKPOINT_TIMEOUT parameter
LOG_CHECKPOINTS_TO_ALERT parameter
LOG_ENTRY_PREBUILD_THRESHOLD
LOG_FILE_STANDBY_NAME_CONVERT parameter
LOG_FILES parameter
LOG_SIMULTANEOUS_COPIES parameter
LOG_SMALL_ENTRY_MAX_SIZE parameter
MAX_DEFAULT_PROPAGATION_DELAY parameter
MAX_DUMP_FILE_SIZE parameter
MAX_ENABLED_ROLES parameter
MAX_ROLLBACK_SEGMRNTS parameter
MAX_TRANSACTION_BRANCHES parameter
MLS_LABEL_FORMAT parameter
MTS_DISPATCHERS parameter
MTS_LISTENER_ADDRESS parameter
MTS_MAX_DISPATCHERS parameter
MTS_MAX_SERVERS parameter
MTS_MULTIPLE_LISTENERS parameter
MTS_SERVERS parameter
MTS_SERVICE parameter
NLS_CALENDAR parameter
NLS_CURRENCY parameter
NLS_DATE parameter
NLS_DATE_LANGUAGE parameter
NLS_DEBIT parameter
NLS_DISPLAY parameter
NLS_ISO_CURRENCY parameter
NLS_LANGUAGE parameter
NLS_LIST_SEPARATOR parameter
NLS_MONETARY_CHARACTERS parameter
NLS_NUMERIC_CHARACTERS parameter
NLS_SORT parameter
NLS_TERRITORY parameter
OPEN_CURSORS parameter
OPEN_LINKS parameter
OPEN_MOUNTS parameter
operating system dependent parameters
OPTIMIZER_MODE parameter
OPTIMIZER_PERCENT_PARALLEL parameter
ORACLE_TRACE_COLLECTION_NAME parameter
ORACLE_TRACE_COLLECTION_PATH parameter
ORACLE_TRACE_COLLECTION_SIZE parameter
ORACLE_TRACE_ENABLE parameter
ORACLE_TRACE_FACILITY_NAME parameter
ORACLE_TRACE_FACILITY_PATH parameter
OS_AUTHENT_PREFIX parameter
OS_ROLES parameter
overview
PARALLEL_DEFAULT_MAX_INSTANCES parameter
PARALLEL_DEFAULT_MAX_SCANS parameter
PARALLEL_DEFAULT_SCANSIZE parameter
PARALLEL_MAX_SERVERS parameter
PARALLEL_MIN_PERCENT parameter
PARALLEL_MIN_SERVERS parameter
PARALLEL_SERVER_IDLE_TIME parameter
PARTITION_VIEW_ENABLED parameter
performance tuning
PRE_PAGE_SGA parameter
PROCESSES parameter
RECOVERY_PARALLELISM parameter
REMOTE_DEPENDENCIES_MODE parameter
REMOTE_LOGIN_PASSWORDFILE parameter
REMOTE_OS_AUTHENT parameter
REMOTE_OS_ROLES parameter
RESOURCE_LIMIT parameter
rollback segments
ROLLBACK_CACHE_CURSORS parameter
ROLLBACK_SEGMENTS parameter
ROW_LOCKING parameter
SEQUENCE_CACHED_CURSORS parameter
SEQUENCE_CACHED_HASH_BUCKETS parameter
SEREIALIZABLE parameter
SESSION_CACHED_CURSORS parameter
SESSIONS parameter
SHARED_POOL_RESERVED_MIN_ALLOC parameter
SHARED_POOL_RESERVED_SIZE
SHARED_POOL_RESERVED_SIZE parameter
SHARED_POOL_SIZE parameter
SNAPSHOT_REFRESH_INTERVAL parameter
SNAPSHOT_REFRESH_PROCESS parameter
SORT_AREA_RETAINED_SIZE parameter
SORT_AREA_SIZE parameter
SORT_DIRECT_WRITES parameter
SORT_READ_FAC parameter
SORT_SPACEMAP_SIZE parameter
SORT_WRITE_BUFFER_SIZE parameter
SORT_WRITE_BUFFERS parameter
specifying in parameter files
SQL92_SECURITY parameter
SQL_TRACE parameter
TEMPORARY_TABLE_LOCKS parameter
THREAD parameter
TIMED_STATISTICS parameter
TRANSACTIONS parameter
TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter
USER_DUMP_DEST parameter
UTL_FILE_DIR parameter
variable
inserts, locating free space
INSTANCE option, allocating extents
INSTANCE_NUMBER parameter
exclusive or parallel mode
instances
checkpoint
startup order
ISO standard, date format
[
2
]
ISO week number
IW format element
IY format element
JOB_QUEUE_INTERVAL parameter
JOB_QUEUE_PROCESSES parameter
L format element
LABEL_CACHE_SIZE parameter
language
database default language
language-dependent application behavior
LCKn process
least recently used (LRU) list, sequence numbers
LICENSE_MAX_SESSIONS parameter
LICENSE_MAX_USERS parameter
LICENSE_SESSIONS_WARNING parameter
licenses
maximum sessions
maximum users
warning for concurrent user sessions
limits on the database
linguistic definitions, NLS
linguistic sorts
[
2
]
list separator
listener process
loadable character sets
LOADER_COL_INFO view
LOADER_CONSTRAINT_INFO view
LOADER_FILE_TS view
LOADER_IND_INFO view
LOADER_INDCOL_INFO view
LOADER_PARAM_INFO view
LOADER_TAB_INFO view
LOADER_TRIGGER_INFO view
local currency
local currency symbol
lock conversion
[
2
] [
3
] [
4
] [
5
]
lock process (LCKn), specifying number
locks
PCM lock
rollback segment
segment
table lock
[
2
]
temporary tables
LOG_ARCHIVE_BUFFER_SIZE parameter
[
2
]
LOG_ARCHIVE_BUFFERS parameter
[
2
]
LOG_ARCHIVE_DEST parameter
LOG_ARCHIVE_FORMAT parameter
LOG_ARCHIVE_START parameter
LOG_BLOCK_CHECKSUM parameter
LOG_BUFFER parameter
LOG_CHECKPOINT_INTERVAL parameter
LOG_CHECKPOINT_TIMEOUT parameter
LOG_CHECKPOINTS_TO_ALERT parameter
LOG_ENTRY_PREBUILD_THRESHOLD parameter
LOG_FILE_STANDBY_NAME_CONVERT parameter
LOG_FILES parameter
LOG_SIMULTANEOUS_COPIES parameter
LOG_SMALL_ENTRY_MAX_SIZE parameter
lowercase significance
LRU
manual archiving
MAX_COMMIT_PROPAGATION_DELAY parameter
MAX_DUMP_FILE_SIZE parameter
MAX_ENABLED_ROLES parameter
MAX_ROLLBACK_SEGMENTS parameter
MAX_TRANSACTION_BRANCHES parameter
MAXDATAFILES option
MAXLOGFILES option
MAXLOGMEMBERS option
memory
amount used for sorting
distributed locks
minimum session memory
virtual
migration scripts
MLS_LABEL_FORMAT, Trusted ORACLE parameter
modes, archiving
monetary units characters
MONITOR command, dynamic performance tables
monitor, system statistics
month
format element
language of names
MTS dispatcher request statistics
MTS_DISPATCHERS parameter
MTS_LISTENER_ADDRESS parameter
MTS_MAX_DISPATCHERS parameter
MTS_MAX_SERVERS parameter
MTS_MULTIPLE_LISTENERS parameter
MTS_SERVERS parameter
MTS_SERVICE parameter
multi-byte character sets
multi-byte encoding schemes
multi-threaded server (MTS)
HASH_MULTIBLOCK_IO_COUNT
SESSIONS parameter
multiple-process systems, number of processes
National Language Support (NLS)
architecture
calendars
enhancements
goals
language-dependent behavior
linguistic definitions
loadable character sets
NLS_LANGUAGE parameter
[
2
]
nested files
NLS
NLS_CALENDAR parameter
NLS_CREDIT environment variable
NLS_CURRENCY parameter
[
2
]
defined by NLS_TERRITORY
NLS_DATABASE_PARAMETERS view
NLS_DATE_FORMAT parameter
[
2
]
defined by NLS_NUMERIC_CHARACTERS
defined by NLS_TERRITORY
NLS_DATE_LANGUAGE parameter
[
2
]
NLS_DEBIT parameter
NLS_DISPLAY environment variable
[
2
] [
3
]
NLS_DISPLAY parameter
NLS_INSTANCE_PARAMETERS view
NLS_ISO_CURRENCY parameter
defined by NLS_TERRITORY
NLS_LANG environment variable
[
2
] [
3
] [
4
] [
5
] [
6
]
NLS_LANGUAGE parameter
[
2
] [
3
]
NLS_LIST_SEPARATOR parameter
NLS_MONETARY_CHARACTERS parameter
NLS_NUMERIC_CHARACTERS parameter
[
2
]
NLS_SESSION_PARAMETERS view
NLS_SORT parameter
[
2
]
NLS_TERRITORY parameter
[
2
]
NLSRTL
NOARCHIVELOG mode, creating a database
NOCACHE option
numeric group separators
OBJ synonym for USER_OBJECTS
objects
data dictionary
DBA
offline tablespace
deferred rollback segments
restrictions
online redo log
archiving
archiving mode
block
block size
file size
number of files
[
2
]
setting checkpoint interval
OPEN_CURSORS parameter
OPEN_LINKS parameter
OPEN_MOUNTS parameter, Trusted ORACLE parameter
operating system
authenticating remote clients
authenticating users and passwords
operating system dependent parameters
redo log blocks
[
2
]
roles for remote clients
optimization, trading cursor space for time
optimizer mode
FIRST_ROWS
RULE
OPTIMIZER_MODE parameter
OPTIMIZER_PERCENT_PARALLEL parameter
ORACLE_TRACE_COLLECTION_NAME parameter
ORACLE_TRACE_COLLECTION_PATH parameter
ORACLE_TRACE_COLLECTION_SIZE parameter
ORACLE_TRACE_ENABLE parameter
ORACLE_TRACE_FACILITY_NAME parameter
ORACLE_TRACE_FACILITY_PATH parameter
ORDER BY clause, sorting character data
OS_AUTHENT_PREFIX parameter
OS_ROLES parameter
parallel mode, instance number
parallel query
idle time
maximum number of instances
maximum number of servers
minimum number of queries
OPTIMIZER_PERCENT_PARALLEL
PARALLEL_DEFAULT_MAX_INSTANCES parameter
PARALLEL_DEFAULT_MAX_SCANS parameter
PARALLEL_DEFAULT_SCANSIZE parameter
PARALLEL_MAX_SERVERS parameter
PARALLEL_MIN_PERCENT parameter
PARALLEL_MIN_SERVERS parameter
PARALLEL_SERVER_IDLE_TIME parameter
parallelism, OPTIMIZER_PERCENT_PARALLEL
parameter files
common file
embedded files
embedded parameter files
line continuation character (\)
PARSED_PIECES view
PARSED_SIZE view
PARTITION_VIEW_ENABLED parameter
partition, raw partition
passwords, authenticating
[
2
]
REMOTE_LOGIN_PASSWORDFILE parameter
PCM lock
mapping blocks to
specifying total number
performance
archiving
dynamic performance tables
effect of SGA size
full database import
maximum PGA memory
number of database buffers
rule-based optimizer
shared pool
sort performance
sort spacemap
tuning archiving
PGA
PIDIAN.SQL script
pinging
PIPIDL.SQL script
PISTUB.SQL script
PLAN_TABLE execution plan table
PRE_PAGE_SGA parameter
precision, NUMBER and FLOAT
[
2
]
private rollback segments, specifying
privileges
remote login
RESTRICTED_SESSION privilege
[
2
]
table-level select privileges
procedures, shared pool
PROCESSES parameter
increasing for CKPT
increasing for LCK0
processes
derived parameter values
dispatcher process configuration
dispatcher process maximum number
listener process address
maximum shared server processes
number of server processes
recovery
snapshot refresh intervals
snapshot refreshes
trace files
user processes
PRODUCT_COMPONENT_VERSION view
profiles, resource limits
Program Global Area (PGA), maximum for sorts
PSTUBTBL view
PUBLIC option, thread of redo
public rollback segments
using by default
PUBLIC user group, dynamic performance table access
PUBLIC_DEPENDENCY view
PUBLICSYN view
queries
dictionary views
hints
ordering output
table-level read locks
quotation marks
raw partition, LOG_ARCHIVE_DEST parameter
read consistency, rollback information
RECOVERY_PARALLELISM parameter
recovery, number of required processes
redo log buffers, size
redo thread
remarks, in parameter files
remote clients, authenticating
remote logins
REMOTE_DEPENDENCIES_MODE parameter
REMOTE_LOGIN_PASSWORDFILE parameter
REMOTE_OS_AUTHENT parameter
REMOTE_OS_ROLES parameter
REPCAT$_REPOBJECT view
replacement characters
resource limits for profiles
RESOURCE_COST view
RESOURCE_LIMIT parameter
RESOURCE_MAP view
restrictions, number of files
RM format element
ROLE_ROLE_PRIVS view
ROLE_SYS_PRIVS view
ROLE_TAB_PRIVS view
roles
remotes clients
rollback segments, acquiring
[
2
]
deferred
distributed locks
[
2
] [
3
]
global constant parameters
initialization parameters
maximum size
multiple
number of concurrent transactions
private rollback segments
public rollback segments
specifying
SYSTEM
[
2
]
total number
ROLLBACK_SEGMENTS parameter
unique values
Roman numerals, format mask for
row cache cursor
ROW_CACHE_CURSORS parameter
ROW_LOCKING parameter
RULE
[
2
]
rule-based optimizer
scripts
data dictionary
migration
SQL scripts
segment, simultaneous space management
SEQ synonym for USER_SEQUENCES
SEQUENCE_CACHE_ENTRIES parameter
SEQUENCE_CACHE_HASH_BUCKETS parameter
sequences
data dictionary cache
not cached
SERIALIZABLE parameter
Server Manager, statistics
server processes, number
session memory, minimum
SESSION_CACHED_CURSORS parameter
SESSION_PRIVS view
SESSION_ROLES view
SESSIONS parameter
SGA
shared server processes, maximum number
SHARED_POOL_RESERVED_MIN_ALLOC parameter
SHARED_POOL_RESERVED_SIZE parameter
V$SHARED_POOL_RESERVED
SHARED_POOL_SIZE parameter
SHOW command, PARAMETERS option
SNAPSHOT_REFRESH_INTERVAL parameter
SNAPSHOT_REFRESH_PROCESS parameter
snapshots
refresh interval
refresh processes per instance
SNP background processes
SORT_AREA_RETAINED_SIZE parameter
SORT_AREA_SIZE parameter
SORT_DIRECT_WRITES parameter
SORT_READ_FAC parameter
SORT_SPACEMAP_SIZE parameter
SORT_WRITE_BUFFER_SIZE parameter
SORT_WRITE_BUFFERS parameter
sorting
character data
double characters
following language conventions
maximum memory
maximum PGA memory
minimum session memory
order
ORDER BY queries
specifying non-default
SOURCE_SIZE view
space
allocating extents
segment management
SGA
[
2
]
SQL scripts
creating the data dictionary
optional
required
SQL.BSQ scripts
SQL92_SECURITY parameter
SQL_TRACE parameter
STANDARD.SQL script
START option, automatic archiving
starting up
database name
instance number
startup order
STARTUP command, database name
statistics
dbwr checkpoints
effect of cache size
[
2
]
timed
STMT_AUDIT_OPTION_MAP table, auditing option type codes
switch redo log file
SYN synonym for USER_SYNONYMS
SYNONYMS view
SYS username, dynamic performance tables
SYS_OBJECTS view
SYSCATALOG view
SYSFILES view
SYSSEGOBJ view
System Global Area (SGA), buffer areas
[
2
]
buffer cache
maximum concurrent transactions
page size
PCM locks
rollback segment size
sequence cache
size of
[
2
] [
3
]
tuning
[
2
]
system performance
SYSTEM rollback segment
defining
global constant
SYSTEM_PRIVILEGE_MAP view
SYSTEM, tablespace
TAB view
TABLE_PRIVILEGE_MAP table, access privilege codes
TABLE_PRIVILEGES view
tables
allocating extents
data dictionary
DML locks
free lists
locating free space
tablespace, offline
tables
row locking
simultaneous space management
temporary tables
TABQUOTAS view
TABS synonym for USER_TABLES
tape archiving destination
TEMPORARY_TABLE_LOCKS parameter
territory
[
2
]
THREAD parameter
TIMED_STATISTICS parameter
file read/write statistics
TO_CHAR function
default date format
format masks
group separator
language for dates
spelling of days and months
TO_DATE function
default date format
format masks
language for dates
spelling of days and months
TO_NUMBER function
format masks
group separator
trace files
ALERT file
destination
[
2
]
location of
maximum size
TRANSACTIONS parameter
[
2
]
DML locks
TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter
[
2
]
transactions
concurrent
data locking
[
2
]
rollback segments
updates
Trusted ORACLE
ALL_LABELS view
ALL_MOUNTED view
data dictionary
UNICODE
[
2
] [
3
]
updates
locating free space
serializable
transaction processing option
uppercase characters
user processes, trace files
USER_AUDIT_OBJECT view
USER_AUDIT_SESSION view
USER_AUDIT_STATEMENT view
USER_AUDIT_TRAIL view
USER_CATALOG view
CAT synonym
USER_CLU_COLUMNS view
USER_CLUSTERS view
CLU synonym
USER_COL_COMMENTS view, comments, on columns of user's tables and views
USER_COL_PRIVS view
USER_COL_PRIVS_MADE view
USER_COL_PRIVS_RECD view
USER_CONS_COLUMNS view
USER_CONSTRAINTS view
USER_DB_LINKS view
USER_DEPENDENCIES view
USER_DUMP_DEST parameter
USER_ERRORS view
USER_EXTENTS view
USER_FREE_SPACE view
USER_IND_COLUMNS view
USER_INDEXES view
IND synonym
USER_JOBS view
USER_OBJ_AUDIT_OPTS view
USER_OBJECT_SIZE view
USER_OBJECTS view
OBJ syonym
USER_REFRESH view
USER_REFRESH_CHILDREN view
USER_RESOURCE_LIMITS view
USER_ROLE_PRIVS view
USER_SEGMENTS view
USER_SEQUENCES view
SEQ synonym
USER_SNAPSHOT_LOGS view
[
2
]
USER_SNAPSHOTS view
USER_SOURCE view
USER_SYNONYMS view
SYN synonym
USER_SYS_PRIVS view
USER_TAB_COLUMNS view
USER_TAB_COLUMNS, COLS synonym
USER_TAB_COMMENTS view
USER_TAB_PRIVS view
USER_TAB_PRIVS_MADE view
USER_TAB_PRIVS_RECD view
USER_TABLES view
USER_TABLESPACES view
USER_TRIGGER_COLS view
USER_TRIGGERS view
USER_TS_QUOTAS view
USER_UPDATABLE_COLUMNS view
USER_USERS view
USER_VIEWS view
users
authenticating
multiple
UTF2 encoding
[
2
] [
3
]
UTL_FILE_DIR parameter
UTLBSTAT.SQL script
UTLCHAIN.SQL script
UTLDIDXS.SQL script
UTLDTREE.SQL script
UTLESTAT.SQL script
UTLEXCPT.SQL script
UTLEXP6.SQL script
UTLLOCKT.SQL script
UTLMAIL.SQL script
UTLMONTR.SQL script
[
2
]
UTLOIDXS.SQL script
UTLSAMPL.SQL script
UTLSIDXS.SQL script
UTLXPLAN.SQL script
V$ACCESS view
V$ACTIVE_INSTANCES view
V$ARCHIVE view
V$BACKUP view
V$BGPROCESS view
V$BH view
V$CACHE view
V$CACHE_LOCK view
V$CIRCUIT view
V$COMPATIBILITY view
V$COMPATSEG view
V$CONTROLFILE view
V$DATABASE view
V$DATAFILE view
V$DB_OBJECT_CACHE view
V$DB_PIPES view
V$DBFILE view
V$DBLINK view
V$DISPATCHER view
V$ENABLEDPRIVS view
V$EVENT_NAME view
V$FALSE_PING view
V$FILESTAT view
V$FIXED_TABLE view
V$FIXED_VIEW_DEFINITION view
V$INDEXED_FIXED_COLUMN view
V$INSTANCE view
V$LATCH view
V$LATCH_CHILDREN view
V$LATCH_MISSES view
V$LATCH_PARENT view
V$LATCHHOLDER view
V$LATCHNAME view
V$LIBRARYCACHE view
V$LICENSE view
V$LOADCSTAT view
V$LOADTSTAT view
V$LOCK view
V$LOCK_ACTIVITY view
V$LOCK_ELEMENT view
V$LOCKED_OBJECT view
V$LOCKS_WITH_COLLISIONS view
V$LOG view
V$LOG_HISTORY view
V$LOGFILE view
V$LOGHIST view
V$MLS_PARAMETERS view
V$MTS view
V$MYSTAT view
V$NLS_PARAMETERS view
V$NLS_VALID_VALUES view
V$OBJECT_DEPENDENCY view
V$OPEN_CURSOR view
V$OPTION view
V$PARAMETER view
V$PING view
[
2
]
V$PQ_SESSTAT view
V$PQ_SLAVE view
V$PQ_SYSSTAT view
V$PQ_TQSTAT view
V$PROCESS view
V$PWFILE_USERS view
V$QUEUE view
V$RECOVER_FILE view
V$RECOVERY_FILE_STATUS view
V$RECOVERY_LOG view
V$RECOVERY_STATUS view
V$REQDIST view
V$RESOURCE view
V$ROLLNAME view
V$ROLLSTAT view
V$ROWCACHE view
V$SECONDARY view
V$SESS_IO view
V$SESSION view
V$SESSION_CONNECT_INFO view
V$SESSION_CURSOR_CACHE view
V$SESSION_EVENT view
V$SESSION_WAIT view
V$SESSTAT view
V$SGA view
V$SGASTAT view
V$SHARED_POOL_RESERVED view
V$SHARED_SERVER view
V$SORT_SEGMENT view
V$SQL view
V$SQLAREA view
V$SQLTEXT view
V$SQLTEXT_WITH_NEWLINES view
V$STATNAME view
V$SYSLABEL view
V$SYSSTAT view
V$SYSTEM_CURSOR_CACHE view
V$SYSTEM_EVENT view
V$SYSTEM_PARAMETER view
V$THREAD view
V$TIMER view
V$TRANSACTION view
V$TYPE_SIZE view
V$VERSION view
V$WAITSTAT view
VARCHAR2 datatype, multi-byte character sets and
variable parameters
views
data dictionary views
data files
DBA views
week numbers
X$KCBCBH table
X$KCBRBH table