Oracle7 Parallel Server Concepts and Administrator's Guide
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
@
acquiring rollback segments
distributed locks
[
2
]
initialization parameters
acquisition AST
[
2
]
ADD LOGFILE clause
THREAD clause
thread number
thread required
ADDED_EXTENTS
adding a file
[
2
] [
3
]
ALERT file
[
2
]
ALL option
ALL_TABLES table
ALLOCATE EXTENT option, DATAFILE option
[
2
]
in exclusive mode
instance number
[
2
] [
3
]
INSTANCE option
[
2
]
not available
pre-allocating extents
SIZE option
[
2
]
allocation, automatic
[
2
] [
3
]
extents
[
2
] [
3
]
free space
[
2
]
PCM locks
[
2
] [
3
] [
4
] [
5
] [
6
]
rollback segments
[
2
]
sequence numbers
ALTER CLUSTER statement
ALLOCATE EXTENT option
allocating extents
ALTER DATABASE statement
ADD LOGFILE
[
2
]
adding or dropping log file
[
2
] [
3
]
CLOSE option
DATAFILE OFFLINE and ONLINE options
[
2
]
DATFILE RESIZE
DISABLE
ENABLE THREAD
[
2
]
MOUNT option
OPEN option
RECOVER option
renaming a file
setting the log mode
[
2
] [
3
]
specifying a database
[
2
]
THREAD
[
2
]
thread of redo
[
2
]
ALTER INDEX statement, DEALLOCATE UNUSED option
ALTER ROLLBACK SEGMENT command
ALTER SESSION statement, SET INSTANCE option
[
2
]
ALTER SYSTEM ARCHIVE LOG statement
[
2
]
CURRENT option
[
2
] [
3
]
global log switch
[
2
] [
3
]
THREAD option
[
2
]
ALTER SYSTEM CHECK DATAFILES statement
instance recovery
ALTER SYSTEM CHECKPOINT statement
[
2
]
global versus local
specifying an instance
ALTER SYSTEM command, limiting instances for parallel query
ALTER SYSTEM privilege
[
2
]
ALTER SYSTEM SWITCH LOGFILE statement
[
2
] [
3
]
checkpoint
DBA privilege
[
2
] [
3
]
ALTER TABLE statement
ALLOCATE EXTENT option
allocating extents
[
2
] [
3
] [
4
]
DISABLE TABLE LOCK option
[
2
] [
3
] [
4
]
ENABLE TABLE LOCK option
[
2
] [
3
]
MAXEXTENTS option
ALTER TABLESPACE statement
ADD DATAFILE
ADD DATAFILE option
BACKUP option
OFFLINE and ONLINE options
[
2
]
READ ONLY option
renaming a data file
application
analysis
availability
business functions
compute-intensive
converting to multi-instance
departmentalized
designing
disjoint data
[
2
]
DSS
[
2
] [
3
] [
4
]
insert-intensive
node
OLTP
[
2
] [
3
]
performance
portability
profile
profiles
query-intensive
[
2
]
random access
redesigning for parallel processing
scalability
[
2
]
tuning
tuning performance
[
2
]
ARCH process
[
2
]
architecture
hardware
multi-instance
Oracle database
[
2
]
Oracle instance
ARCHIVE LOG clause
ALTER SYSTEM ARCHIVE LOG statement
CURRENT option
[
2
] [
3
] [
4
]
global log switch
[
2
]
specifying an instance
THREAD option
Archive Log dialog box
ARCHIVELOG mode
automatic archiving
[
2
]
changing mode
[
2
] [
3
]
creating a database
online and offline backups
[
2
]
archiving redo log files
automatic versus manual
conversion to multi-instance
creating a database
forcing a log switch
history
identified in control file
log sequence number
online archiving
[
2
] [
3
]
AST
asymmetrical multiprocessing
asynchronous trap
[
2
] [
3
]
authentication, password file
AUTOEXTEND
automatic archiving
automatic recovery
availability
and interconnect
benefit of parallel database
data files
[
2
]
multiple databases
phases of recovery
recovery time
shared disk systems
single node failure
single-node failure
background process
ARCH
DBWR
holding instance lock
[
2
]
instance
LCKn
[
2
]
LGWR
optional
parallel cache management
[
2
]
SMON
[
2
]
specifying number
backup
checkpoint
conversion to multi-instance
export
files used in recovery
offline
[
2
]
online
[
2
] [
3
] [
4
] [
5
]
parallel
bandwidth
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
] [
8
]
batch applications
[
2
]
batched allocate SCN lock request
BEGIN BACKUP option
BL, Buffer Cache Management lock
block
allocating dynamically
associated with instance
[
2
]
class
[
2
] [
3
]
cleanout
content
contention
[
2
] [
3
] [
4
] [
5
]
deferred rollback
[
2
] [
3
]
distributed lock
[
2
]
free space
blocking AST
[
2
]
block, multiple copies
[
2
] [
3
]
PCM lock
[
2
]
per PCM lock
redo log
rollback segment
[
2
]
segment header
[
2
] [
3
]
when written to disk
[
2
] [
3
] [
4
] [
5
]
buffer busy waits
buffer cache
checkpoint
coherency
distributed locks
instance recovery
minimizing I/O
[
2
]
written to disk
buffer state
[
2
]
buffer, redo log
CACHE keyword
CACHE option
[
2
]
CACHE_SIZE_THRESHOLD parameter
[
2
] [
3
] [
4
]
cache, buffer cache
[
2
]
coherency
[
2
] [
3
] [
4
]
consistency, on MPPs
dictionary cache
[
2
] [
3
]
flushing dictionary
management issues, non-PCM
parallel cache management
[
2
]
recovery
row cache
sequence cache
[
2
]
capacity planning
CATALOG.SQL script
CATPARR.SQL script
[
2
]
CF, Controlfile Transaction
CHANGE option
CHECK DATAFILES clause
instance recovery
CHECKPOINT_PROCESS parameter
checkpoint
datafile
DBWR process
definition
forcing
[
2
]
global
instance
log switch
CI, Cross-instance Call Invocation
CKPT process
classes of blocks
[
2
] [
3
]
CLEANUP_ROLLBACK_ENTRIES parameter
[
2
]
client-server configuration
description
SQL*Net
closed thread
[
2
]
cluster
allocating extents
free list groups
free lists
[
2
]
hash cluster
[
2
] [
3
]
implementations
performance
COMMIT WORK
committed data
checkpoint
fast commits and group commits
instance failure
sequence numbers
common pool
compatibility, shared and exclusive modes
[
2
]
concurrency, inserts and updates
[
2
]
maximum number of instances
[
2
]
multiversion read
SEQUENCE_CACHE_ENTRIES
sequences
shared mode
transactions
[
2
]
user processes
concurrent read mode
concurrent write mode
configurations
change in redo log
client-server
distributed database system
guidelines for parallel server
multi-instance database system
Oracle alternatives
overview of Oracle
single instance database system
CONNECT command
[
2
]
forcing a checkpoint
INTERNAL option
[
2
] [
3
]
querying performance views
SQL*Net
[
2
]
connect string
[
2
] [
3
] [
4
]
consistency, multiversion read
[
2
] [
3
]
rollback information
[
2
] [
3
]
content of block
contention, block
[
2
] [
3
] [
4
] [
5
]
disk
[
2
]
distributed lock
for rollback segments
free list
free space
[
2
] [
3
]
index
monitoring
on single block or row
rollback segment
[
2
] [
3
]
segment header
[
2
]
sequence number
[
2
] [
3
]
SYSTEM tablespace
table data
[
2
] [
3
]
control file
accessibility
backing up
conversion to multi-instance
creating
data files
log history
[
2
]
MAXLOGHISTORY
parameter values
shared
[
2
]
CONTROL_FILES parameter
same for all instances
[
2
]
conversion
application
database
database, to multi-instance
ramifications
convert queue
[
2
]
COUNTER column
CPU usage
CPU_COUNT parameter
CREATE CLUSTER statement
[
2
]
FREELIST GROUPS option
FREELISTS option
CREATE CONTROLFILE statement
changing database options
conversion to multi-instance
exclusive mode
MAXLOGHISTORY
CREATE DATABASE statement
exclusive mode
MAXINSTANCES
[
2
]
MAXLOGFILES
MAXLOGHISTORY
[
2
] [
3
]
MAXLOGMEMBERS
setting the log mode
[
2
]
thread number 1
CREATE INDEX statement, FREELISTS option
CREATE ROLLBACK SEGMENT command
CREATE ROLLBACK SEGMENT statement
[
2
]
CREATE SEQUENCE statement, CACHE option
[
2
]
CYCLE option
description
NOORDER option
ORDER option
[
2
]
CREATE TABLE statement
clustered tables
examples
[
2
]
FREELIST GROUPS option
[
2
]
FREELISTS option
[
2
] [
3
]
initial storage
[
2
] [
3
]
CREATE TABLESPACE statement
creating a database
creating a rollback segment
[
2
] [
3
]
creating a tablespace, exclusive mode
cross-instance CR read
CU, Bind Enqueue
current instance
checkpoint
log switch
rollback segments
specifying
CURRENT option
checkpoints
[
2
]
forcing a global log switch
[
2
]
global log switch
new in Oracle7
CYCLE option
data block
data dependent routing
data dictionary views
defined
for parallel server
querying
data dictionary, data files
[
2
]
datafiles
objects
rollback
rollback segments
row cache
sequence cache
views
[
2
] [
3
] [
4
]
data file radio button, media recovery
data warehousing
data-dependent routing
[
2
]
database administrator (DBA)
distributed database
system privileges
database radio button, media recovery
database, archiving mode
[
2
]
backup
[
2
]
closing
conversion to multi-instance
[
2
]
creating
designing
[
2
]
dismounting
[
2
]
export and import
logical
migrating to multi-instance
mounted but not open
number of archived log files
[
2
]
number of instances
[
2
]
rollback segments
[
2
]
scalability
DATAFILE option
table
tablespace
datafile
accessiblity
adding
[
2
] [
3
] [
4
]
allocating extents
backing up
[
2
]
checkpoint
[
2
]
disk contention
dropping
file ID
instance recovery
[
2
]
mapping PCM locks to data blocks
[
2
]
maximum number
multiple files per table
[
2
] [
3
]
number of blocks
parallel recovery
recovery
[
2
]
renaming
shared
[
2
]
tablespace
[
2
]
tablespace name
taking offline or online
unspecified for PCM locks
[
2
]
validity
DB_BLOCK_BUFFERS parameter
[
2
] [
3
] [
4
]
ensuring DLM lock capacity
DB_BLOCK_SIZE parameter
[
2
]
same for all instances
DB_FILES parameter
[
2
]
calculating non-PCM locks
calculating non-PCM resources
ensuring DLM lock capacity
same for all instances
DB_NAME parameter
[
2
]
conversion to multi-instance
same for all instances
DBA lock
DBA_DATA_FILES view
[
2
]
DBA_ROLLBACK_SEGS view
[
2
]
online rollback segments
public rollback segments
DBA_SEGMENTS view
[
2
]
DBA_TABLES table
DBMS_SPACE package
DBWR cross-instance writes
DBWR process
checkpoint
in parallel server
DDL commands
DDL lock
[
2
]
deadlock detection
[
2
]
deallocating unused space
default instance
[
2
]
deferred rollback segment
[
2
]
DELAYED_LOGGING_BLOCK_CLEANOUTS parameter
[
2
] [
3
] [
4
]
departmentalized applications
DESCRIPTION_LIST feature
DF, Datafile
DFS db file lock
DFS enqueue lock acquisition
DFS enqueue lock handle
DFS enqueue request cancellation
DFS lock acquisition
DFS lock convert
DFS lock handle
DFS lock release
DFS lock request cancellation
dialog box, Archive Log
DIASBLE THREAD clause
dictionary cache
[
2
] [
3
] [
4
]
dictionary cache lock
dictionary, data dictionary
DISABLE TABLE LOCK option
disabling the archive history
disaster recovery
DISCONNECT command
disconnecting from an instance
[
2
]
before SET INSTANCE
multiple sessions
user process
disjoint data, applications with
[
2
]
data files
disk I/O
statistics
disk, access
[
2
]
contention
[
2
]
media failure
reading blocks
rollback segments
striping
writing blocks
[
2
] [
3
] [
4
] [
5
]
distributed database system
distributed DLM
distributed lock
distributed lock manager, at instance startup
[
2
]
capacity for locks and resources
configuring
conversion to multi-instance
deadlock detection
definition
[
2
] [
3
]
effect on performance
evaluating
failover requirements
fault tolerant
features
[
2
] [
3
]
group-based locking
handling lock requests
initialization parameters
kernalized
LCKn process
lock mastering
[
2
]
lock modes
memory requirements
minimizing use
[
2
]
non-PCM lock capacity
number of locks supported
Oracle interface
per instance configuration
queues
recovery phases
scalability
system-wide configuration
user-level
distributed lock
acquiring
disowning
exclusive
[
2
] [
3
]
memory area
null
read
rollback segment
[
2
] [
3
]
row cache
sequence
[
2
]
total number
[
2
]
DL, Direct Loader Index Creation
DLM
DLM parameter
number of locks
number of processes
number of resources
DM, Database Mount
[
2
]
DML lock
[
2
]
DML_LOCKS parameter
[
2
] [
3
] [
4
] [
5
]
and performance
calculating non-PCM locks
calculating non-PCM resources
ensuring DLM lock capacity
DROP TABLE command
DROP TABLESPACE statement
dropping a database object, tablespace
[
2
]
dropping a redo log file
log switch
manual archiving
restrictions
DSS applications
[
2
] [
3
] [
4
] [
5
] [
6
]
dual ported controllers
DX, Distributed TX Recovery
dynamic performance view
creating
granting PUBLIC access
list of
null values
querying
XNC column
dynamically allocating blocks
ENABLE TABLE LOCK option
END BACKUP option
enqueue
enqueue locks
calculating non-PCM locks
calculating non-PCM resources
ENQUEUE_DEBUG_MULTI_INSTANCE parameter (Oracle Version 6)
ENQUEUE_RESOURCES parameter
calculating non-PCM locks
calculating non-PCM resources
enqueue
definitions
global
local
names
OPS context
error message
parameter values
rollback segment
storage options
exclusive distributed lock
rollback data
[
2
]
exclusive mode
[
2
] [
3
]
compatibility
creating a database
database access
[
2
]
free list
free lists
[
2
]
free space lists
instance recovery
MAXLOGHISTORY
media recovery
required for file operations
[
2
]
specifying instance number
[
2
]
specifying thread number
startup
[
2
] [
3
]
switching archive log mode
taking tablespace offline
EXCLUSIVE option
Export utility, and free lists
[
2
] [
3
]
backing up data
compatibility
extent, allocating PCM locks
[
2
]
allocating to instance
[
2
] [
3
] [
4
]
definition
initial allocation
not allocated to instance
[
2
] [
3
]
rollback segment
[
2
]
size
[
2
] [
3
]
specifying a file
failover
[
2
]
failure
access to files
ALERT file
instance
[
2
]
instance recovery
media
[
2
] [
3
]
MPP node
node
[
2
] [
3
]
false pinging
[
2
]
fault tolerance
FILE_LOCK view
[
2
]
description
FILE_PING view
description
file, adding
[
2
] [
3
]
ALERT
[
2
]
allocating extents
archiving redo log
[
2
] [
3
] [
4
]
common parameter file
control file
[
2
] [
3
]
datafile
dropping
[
2
] [
3
] [
4
] [
5
]
exported
maximum number
multiplexed
name and number
[
2
]
parameter
[
2
] [
3
]
PFILE
[
2
]
redo log
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
] [
8
]
renaming
[
2
] [
3
]
restricted operations
[
2
]
size
[
2
]
used in recovery
fine grain lock
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
]
creation
DBA lock
group factor
fine grain locking
[
2
]
disabled by default
platform-dependent
release 7.3
fine grain lock
introduction
one lock element to one block
specifying
fixed mode, lock element
flexibility of parallel database
Force Checkpoint dialog box
[
2
]
foreground process, instance shutdown
format, lock name
free list group, assigned to instance
[
2
]
assigning to session
definition
enhanced for release 7.3
example
high performance feature
setting !blocks
unused space
used space
free list, and Export utility
[
2
]
assigned to instance
cluster
concurrent inserts
[
2
]
contention
definition
hash cluster
in exclusive mode
[
2
]
index
locating space
number of lists
partitioning
partitioning data
[
2
]
unused space
[
2
]
free space list
cluster
extent
in exclusive mode
list groups
PCM locks
[
2
]
FREE_LIST_INST parameter (Oracle Version 6)
[
2
]
FREE_LIST_PROC parameter (Oracle Version 6)
[
2
]
FREED_EXTENTS
FREELIST GROUPS storage option
[
2
] [
3
] [
4
]
clustered tables
instance number
FREELISTS parameter
FREELISTS storage option
[
2
]
clustered tables
indexes
maximum value
FS, File Set
GC_DB_LOCKS parameter
[
2
] [
3
] [
4
]
adjusting after file operations
number of distributed locks
[
2
] [
3
]
room for growth
unassigned locks
[
2
]
GC_FILES_TO_LOCKS parameter
[
2
] [
3
] [
4
] [
5
] [
6
]
adding datafiles
adjusting after file operations
[
2
]
associating PCM locks with extents
[
2
]
evaluating
fine grain examples
guidelines
hashed examples
index data
number of blocks per lock
reducing false pings
room for growth
setting
syntax
GC_FILES_TO_LOCKS, parameter
GC_FREELIST_GROUPS parameter
[
2
] [
3
] [
4
] [
5
]
setting
GC_LCK_PROCS parameter
[
2
] [
3
]
ensuring DLM lock capacity
same for all instances
GC_RELEASABLE_LOCKS parameter
[
2
] [
3
] [
4
] [
5
]
GC_ROLLBACK_LOCKS parameter
[
2
] [
3
] [
4
] [
5
] [
6
]
setting
GC_ROLLBACK_SEGMENTS parameter
[
2
] [
3
] [
4
] [
5
] [
6
]
number of distributed locks
setting
GC_SAVE_ROLLBACK_LOCKS parameter
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
]
setting
GC_SEGMENTS parameter
[
2
] [
3
] [
4
]
number of locks reserved
setting
GC_SORT_LOCKS parameter
GC_TABLESPACES parameter
[
2
] [
3
] [
4
]
setting
global checkpoint
global constant parameter
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
] [
8
] [
9
] [
10
] [
11
] [
12
] [
13
] [
14
] [
15
] [
16
] [
17
] [
18
] [
19
] [
20
] [
21
] [
22
]
and non-PCM locks
control file
description
list of
rollback segments
[
2
] [
3
] [
4
]
same for all instances
[
2
]
setting
global lock converts
GLOBAL option, forcing a checkpoint
[
2
]
verifying access to files
granted queue
[
2
] [
3
]
GROUP option
group-based locking
group
free space list
MAXLOGFILES
redo log files
[
2
] [
3
]
unique numbers
V$LOGFILE
hardware, architecture
[
2
] [
3
]
requirements
scalability
supported Oracle options
hash cluster
free lists
[
2
]
hash latch wait gets
hashed PCM lock
[
2
] [
3
] [
4
] [
5
] [
6
]
creation
introduction
specifying
header, rollback segment
[
2
]
segment
[
2
]
high speed interconnect
high water mark
definition
[
2
]
moving
[
2
]
high-speed bus
[
2
]
history, archive
[
2
]
horizontal partitioning
HOST command
host, distributed lock manager
hypercube
I/O
and scalability
disk contention
interrupts
minimizing
[
2
] [
3
] [
4
]
identifier, lock
IFILE parameter
multiple files
overriding values
specifying identical parameters
Import utility
Compatibility
free lists
restoring data
IN, Instance Number
incomplete recovery
incremental growth
index
contention
creating
data partitioning
[
2
]
FREELISTS option
PCM locks
INIT_SQL_FILES parameter
INITIAL storage parameter
minimum value
rollback segments
initialization parameter
archiving
CACHE_SIZE_THRESHOLD
[
2
] [
3
]
control of blocks
control of PCM locks
displaying values
[
2
]
distributed lock manager
duplicate values
for parallel server
format
global constant
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
]
guidelines
identical for all instances
MAX_DEFAULT_PROPAGATION_DELAY
[
2
] [
3
]
obsolete
PARALLEL_DEFAULT_MAX_INSTANCES
PARALLEL_DEFAULT_MAXSCANS
PARALLEL_DEFAULT_SCANSIZE parameter
PARALLEL_MAX_SERVERS
[
2
]
PARALLEL_MIN_PERCENT
[
2
]
planning DLM capacity
[
2
]
PROCESSES parameter
using default value
input/output, I/O
inserts, concurrent
[
2
] [
3
]
free list
free space lists
[
2
]
free space unavailable
locating free space
performance
instance lock
acquired by background process
acquired by foreground process
definition
[
2
]
rollback segment
[
2
]
segment
space management
total number
[
2
]
types
INSTANCE option
allocating
allocating extents
SET INSTANCE command
[
2
]
SHOW INSTANCE command
instance recovery
abnormal shutdown
access to files
[
2
]
global checkpoint
multiple failures
recovery time
rollback segments
starting another instance
instance registration
INSTANCE_NUMBER parameter
[
2
] [
3
]
and SQL options
assigning free lists to instances
conversion to multi-instance
exclusive mode
exclusive or shared mode
[
2
]
individual parameter files
setting
unique values
unique values for instances
unspecified
instance, adding instances
[
2
] [
3
]
associated with data block
associated with data file
associated with extent
background processes
[
2
] [
3
]
changing current
[
2
]
changing default
checkpoint
[
2
]
creating a database
current
[
2
] [
3
]
failure
[
2
] [
3
]
free list
[
2
]
instance number
[
2
]
maximum number
[
2
] [
3
] [
4
]
number
ownership of PCM locks
parallel server characteristics
recovery
[
2
] [
3
] [
4
]
remote
[
2
] [
3
] [
4
]
rollback segment required
INSTANCES keyword
INSTANCES parameter (Oracle Version 6)
instance
specifying a database
startup order
[
2
] [
3
]
thread number
[
2
] [
3
]
integrated operations
inter-node communication
interconnect
and scalability
communications protocol
high-speed
INTERNAL option
instance shutdown
internal parallelism
iostat UNIX utility
IR, Instance Recovery
IS, Instance State
IV, Library Cache Invalidation
kcmgss reads scn without going to DLM
kcmgss waited for batching
kernalized DLM
[
2
]
KK, Redo Log Kick"
L[A-P], Library Cache Lock
LANGUAGE parameter (Oracle Version 6)
latch
[
2
]
latency
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
]
LCKn process
[
2
]
definition
description
on multi-instance database
role in recovery
specifying number
LGWR process
log history
log switch
library cache lock
links
list, free space
load balancing
[
2
]
local I/O
[
2
]
local instance, node
local lock
LOCAL option, forcing a checkpoint
[
2
]
verifying access to files
lock activity
monitoring and tuning
lock contention
detecting
pinpointing
lock conversion
detecting
excessive rate
maximum rate
lock element cleanup
lock element waits
lock element
correspondence to locks
creation
fixed
free
LRU list
mode
name
non-fixed
non-fixed mode
number
valid bit
lock process
lock value block
[
2
] [
3
]
lock
boundary
conversion
[
2
]
cost of
dictionary cache
DML
[
2
]
enqueue
fine grain
global
group-based
hashed
identifier
implementations, PCM
locking, session-based
lock, instance
[
2
]
latch
LCKn process
library cache
local
mastering
[
2
] [
3
] [
4
]
mode compatibility
mode, and buffer state
modes, DLM
mount lock
[
2
]
name format
names
non-PCM
[
2
]
OPS exclusive mode
OPS shared mode
overview of locking mechanisms
ownership by DLM
PCM lock
[
2
] [
3
] [
4
]
process-owned
request, handling by DLM
rollback segment
[
2
]
row
[
2
]
row cache
segment
system change number
table
[
2
] [
3
] [
4
]
transaction
[
2
] [
3
]
types of
[
2
]
log file
accessibility
redo log file
log history
[
2
] [
3
]
log sequence number
[
2
]
manual archiving
log switch
adding or dropping files
checkpoint
[
2
]
closed thread
forced
forcing
[
2
] [
3
] [
4
] [
5
]
global
log history
LOG_ALLOCATION parameter (Oracle Version 6)
[
2
]
LOG_ARCHIVE_DEST parameter, specifying for recovery
LOG_ARCHIVE_FORMAT parameter
[
2
]
same for all instances
used in recovery
LOG_ARCHIVE_START parameter, automatic archiving
[
2
]
creating a database
LOG_CHECKPOINT_INTERVAL parameter
[
2
] [
3
] [
4
]
LOG_CHECKPOINT_TIMEOUT parameter
[
2
] [
3
]
inactive instance
[
2
]
LOG_DEBUG_MULTI_INSTANCE parameter (Oracle Version 6)
LOG_FILES parameter, same for all instances
LOGFILE option
logical database
loosely coupled system
cache consistency
characteristics
disk access
hardware architecture
[
2
]
shared memory access
tightly coupled nodes
LRU list, lock elements
manual archiving
[
2
]
dropping a redo log file
massively parallel processing
massively parallel system
application profile
disk access
hardware architecture
implementations
master free list, definition
master node
mastering, lock
[
2
] [
3
]
MAX_COMMIT_PROPAGATION_DELAY parameter
[
2
]
MAX_COMMIT_PROPAGATION_DELAY parameter
[
2
]
MAX_SORT_SIZE
MAXDATAFILES option
MAXEXTENTS storage parameter, automatic allocations
[
2
]
preallocating extents
MAXINSTANCES option
[
2
]
changing
MAXINSTANCES parameter, assigning free lists to instances
[
2
]
calculating non-PCM locks
calculating non-PCM resources
conversion to multi-instance
[
2
]
MAXLOGFILES option
[
2
]
MAXLOGHISTORY option
[
2
]
changing
CREATE CONTROLFILE
exceeding
log history
MAXLOGMEMBERS option
[
2
]
media failure
[
2
] [
3
]
access to files
automatic recovery
recovery
media recovery
incomplete
log history
[
2
] [
3
]
member, MAXLOGMEMBERS
memory access
memory
cache
cached data
distributed locks
[
2
]
DLM requirements
SGA
message, access to files
[
2
]
ALERT file
[
2
]
distributed lock manager
instance shutdown
parameter values
messaging, in parallel processing
migration
data migration
planning for future
returning to exclusive mode
MINEXTENTS storage parameter, automatic allocations
[
2
] [
3
]
common free space
default
mode, archiving
[
2
] [
3
] [
4
] [
5
]
database access
[
2
] [
3
] [
4
]
distributed lock
[
2
]
exclusive mode
incompatible
lock compatibility
lock element
modified data
instance recovery
updates
modulo
[
2
] [
3
] [
4
] [
5
]
MONITOR command
default instance in display screen
ROLLBACK option
specifying an instance
MONITOR STATISTICS CACHE display
MONITOR.SQL script
mount lock
[
2
]
MOUNT option
MPP systems
MR, Media Recovery
multi-instance database
converting application
definition
reasons not to convert to
reasons to convert to
requirements
multi-threaded server (MTS)
multiple shared mode
[
2
]
multiple-process systems, number of processes
multiplexed redo log files
example
log history
total number of files
multiversion read consistency
N[A-Z], Library Cache Pin
network usage
next scns gotten without going to DLM
NEXT storage parameter
[
2
]
NFS
[
2
] [
3
]
NLS_* parameters
NOARCHIVELOG mode
changing mode
[
2
] [
3
]
creating a database
[
2
]
offline backups
requiring offline backups
node, adding
[
2
]
cache coherency
definition
failure
[
2
] [
3
] [
4
]
independent operation
local
[
2
]
parallel backup
parallel shutdown
recovery time
remote
[
2
] [
3
]
single to cluster
NOMOUNT option
non-fixed mode, lock element
non-PCM lock
dictionary cache lock
DLM capacity
DML lock
enqueue
enqueue definitions
library cache lock
mount lock
relative number
non-PCM locks
calculating
overview
non-PCM lock
system change number
table lock
transaction lock
types
user control
non-PCM resources, calculating
non-uniform memory access
[
2
]
NOORDER option
null lock mode
[
2
]
NUMA
number generator
obsolete parameters
[
2
]
offline backup
[
2
]
parallel
redo log files
offline datafile
offline tablespace, deferred rollback segments
[
2
]
restrictions
[
2
] [
3
]
OLTP applications
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
] [
8
] [
9
]
on-going reading of SCN to complete
online backup
[
2
]
archiving log files
checkpoint
parallel
procedure
redo log files
online datafile, supported operations
online recovery
[
2
] [
3
] [
4
] [
5
]
online redo log file
archive log mode
archiving
[
2
]
checkpoint interval
log switch
[
2
] [
3
]
thread
thread of redo
[
2
]
online transaction processing
OPEN option
[
2
]
opening a database
operating system
distributed lock manager
exported files
privileges
scalability
OPS_FAILOVER clause
Oracle executable
ORACLE*Case Matrix Diagrammer
oracle_pid
Oracle
background processes
backing up
[
2
]
compatibility
[
2
]
configurations
data dictionary
datafile compatibility
exclusive mode
[
2
] [
3
]
free space unavailable
instance recovery
instances on MPP nodes
migration
multi-instance
obsolete parameters
performance features
restrictions
[
2
] [
3
]
shared mode
single-instance
version on all nodes
ORDER option
[
2
]
overhead
calculating non-PCM locks
calculating non-PCM resources
P[A-Z], Library Cache Pin
parallel backup
parallel cache management lock
conversion
definition
[
2
]
example
how they work
implementations
minimizing number of
number of blocks per lock
owned by instance LCK processes
owned by multiple instances
periodicity
relative number
releasing
user control
parallel cache management
broad view
narrow view
parallel database
and parallel query
availability
benefits
definition
parallel mode
file operation restrictions
[
2
] [
3
]
recovery restrictions
sequence restrictions
[
2
]
shutdown
startup
PARALLEL option
parallel processing
benefits
characteristics
definition
elements of
for integrated operations
for MPPs
for SMPs
hardware architecture
[
2
]
implementations
messaging
misconceptions about
Oracle configurations
types of workload
when advantageous
when not advantageous
parallel query option
availability
calculating overhead
[
2
]
limiting instances
processor affinity
query processing
[
2
] [
3
]
scalability
speedup and scaleup
table scan size
under Oracle Parallel Server
parallel recovery
[
2
] [
3
]
Parallel Server, Oracle, startup and shutdown
Parallel Server, startup and shutdown
[
2
]
PARALLEL_DEFAULT_MAX_INSTANCES parameter
[
2
]
PARALLEL_DEFAULT_MAXSCANS parameter
PARALLEL_DEFAULT_SCANSIZE parameter
PARALLEL_MAX_SERVERS parameter
[
2
] [
3
] [
4
]
calculating non-PCM locks
calculating non-PCM resources
ensuring DLM lock capacity
PARALLEL_MIN_PERCENT parameter
[
2
]
parallelism, internal
parameter file
backing up
common file
[
2
] [
3
]
conversion to multi-instance
duplicate values
identical parameters
PFILE
[
2
] [
3
]
remote instance
[
2
] [
3
]
parameter
controlling PCM locks
database creation
[
2
] [
3
] [
4
] [
5
]
obsolete
protecting classes of blocks
storage
[
2
] [
3
] [
4
] [
5
]
partitioning data
data files
[
2
]
free list
free space lists
[
2
] [
3
]
index data
multiple databases
PCM locks
[
2
] [
3
] [
4
]
rollback segments
[
2
]
table data
[
2
] [
3
] [
4
]
partitioning
application
data
elements
guidelines
horizontal
of OLTP applications
vertical
PCM lock
adding datafiles
allocating
checking for valid number
contention
[
2
] [
3
] [
4
]
conversion
conversion time
estimating number needed
exclusive
index data
mapping blocks to
[
2
] [
3
] [
4
] [
5
]
mapping data blocks to
planning
sessions waiting
set of files
shared
[
2
]
specifying total number
[
2
] [
3
] [
4
]
total needed
total used
types of conversion
valid lock assignments
worksheets
PCTFREE
[
2
] [
3
]
PCTINCREASE parameter, table extents
PCTUSED
[
2
]
performance
and lock mastering
application
application tuning
benefits of parallel database
caching sequences
fine grain locking
inserts and updates
monitoring
Oracle7 features
rollback segments
[
2
]
sequence numbers
shared resource system
tuning
persistent resource
[
2
]
PF, Password File
PFILE option
[
2
]
conversion to multi-instance
PI, Parallel Slaves
ping count
ping rate
ping/write ratio
pinging
[
2
]
definition
detecting
false
[
2
] [
3
]
FILE_PING view
reduced by free list groups
true
tuning
PL/SQL, shared memory areas
PR, Process Startup
pre-allocating extent
prime number
private rollback segment
acquisition
creating
individual parameter file
specifying
[
2
]
private thread
privilege, ALTER SYSTEM
[
2
]
process free list
definition
pinging of segment header
PROCESSES parameter
[
2
] [
3
]
calculating non-PCM locks
calculating non-PCM resources
ensuring DLM lock capacity
increasing for LCK0
processor affinity, parallel query
protected read mode
protected write mode
PS, Parallel Slave Synchronization
PUBLIC option, thread of redo
[
2
]
public rollback segment
bringing online
common parameter file
creating
owner
specifying
[
2
]
using by default
[
2
]
Q[A-Z], Row Cache
[
2
]
query, dictionary views
[
2
] [
3
]
performance
specifying an instance
random access
raw device
read consistency
multiversion
rollback information
[
2
] [
3
]
read lock mode
read-only access
[
2
]
applications
index data
read distributed lock
read-only tables
RECO process
[
2
]
RECOVER command
[
2
]
recover dialog box
[
2
]
recovery
RECOVERY_PARALLELISM parameter
[
2
]
recovery, access to files
[
2
] [
3
]
after SHUTDOWN ABORT
archive history
automatic
conversion to multi-instance
deferred transaction
[
2
]
definition
detection of error
disaster
[
2
]
DLM recovery time
from an offline backup
from an online backup
from multiple node failure
from single-node failure
global checkpoint
incomplete
instance
[
2
] [
3
]
instance failure
instance recovery
LCKn process
log history
[
2
]
media failure
[
2
] [
3
] [
4
] [
5
]
online
parallel
PARALLEL_MAX_SERVERS parameter
phases
recovery time
[
2
]
restrictions
rolling back
setting parallelism
starting another instance
UNTIL options
using redo log
redo log file
accessibility
adding
archiving
[
2
] [
3
] [
4
] [
5
]
backup
[
2
]
dropping
[
2
]
identified in control file
log history
log sequence number
multiplexed
overwriting
[
2
]
renaming
[
2
]
size
thread
thread of redo
[
2
] [
3
]
redo log
archiving mode
block
instance
instance recovery
log history
reconfiguring
redo log buffer
shared
redo thread
thread
remote databases
remote I/O
[
2
]
remote instance
[
2
] [
3
] [
4
]
remote instance undo requests
remote instance undo writes
REMOTE_LOGIN_PASSWORDFILE parameter
renaming a file
log switch
redo log file
RENAME FILE option
replicated systems
resource sharing system, distributed lock manager
resource
database
operating system
persistent
releasing
response time
restrictions
cached sequence
changing the redo log
deferred rollback segments
file operations
[
2
] [
3
]
offline tablespace
[
2
]
recovery
RETRY option
Start Up Instance diaglog box
STARTUP PARALLEL command
rollback segment
rollback segment tablespace, loss of
rollback segment
acquiring
contention
[
2
] [
3
]
deferred
[
2
] [
3
]
description
displaying information about
distributed locks
[
2
] [
3
] [
4
]
global constant parameters
[
2
] [
3
]
header block
ID number
[
2
]
information in data dictionary
initialization parameters
[
2
]
instance locks
monitoring contention for
multiple
[
2
] [
3
] [
4
]
name
[
2
]
online
[
2
]
onlining
private
private vs. public
public
[
2
]
public vs. private
[
2
]
specifying
[
2
]
SYSTEM
[
2
] [
3
]
tablespace
[
2
] [
3
] [
4
]
total number
[
2
]
ROLLBACK_SEGMENTS parameter
[
2
] [
3
] [
4
] [
5
] [
6
]
conversion to multi-instance
private and public segments
[
2
]
unique values
rolling back
instance recovery
rollback segments
row locks
routing, data dependent
routing, data-dependent
row cache, data dictionary
row level locking
independent of PCM locks
[
2
]
resource sharing system
[
2
]
row lock
ROW_CACHE_MULTI_INSTANCE parameter (Oracle Version 6)
ROW_LOCKING parameter, same for all instances
RT, Redo Thread
SC, System Change Number
[
2
] [
3
]
scalability, application
[
2
] [
3
]
database
definition
determinants
disk input and output
distributed lock manager
enhancement for release 7.3
four levels of
hardware
network
operating system
potential
relative
shared memory system
scginq AST call
SCN
SCSI
segment header, block class
[
2
]
contention
[
2
] [
3
]
segment
definition
header block
[
2
] [
3
]
ID number
[
2
]
name
[
2
]
rollback segment
simultaneous space management
size
SEQ option
SEQUENCE number
[
2
]
sequence number generation
[
2
]
sequence number generator, distributed locks
[
2
]
on parallel server
restriction
[
2
]
skipping sequence numbers
sequence# cache entry
sequence# lock op
SEQUENCE_CACHE_ENTRIES parameter
[
2
] [
3
]
sequence, data dictionary cache
[
2
]
log sequence number
[
2
] [
3
]
not cached
[
2
]
timestamp
sequential processing
[
2
]
SERIALIZABLE parameter, same for all instances
Server Manager, privileged commands
server, client-server configuration
session wait events
[
2
]
session-based locking
session, multiple
[
2
]
SESSIONS parameter, ensuring DLM lock capacity
sessions, multiple
session, waiting for PCM lock conversion
SET INSTANCE command
[
2
]
instance startup
[
2
]
requires SQL*Net
shared disk system
advantages
application profiles
disadvantages
implementations
[
2
]
parallel query support
scalability
with shared nothing system
shared exclusive mode
shared memory system
advantages
application profiles
disadvantages
implementations
loosely coupled
parallel query support
scalability
tightly coupled
shared mode
database access
datafiles
[
2
]
file operation restrictions
instance number
[
2
]
instance recovery
recovery restrictions
startup
shared nothing system
advantages
application profiles
disadvantages
disk access
implementations
massively parallel systems
overview
parallel query support
scalability
with shared disk system
SHARED option
shared mode
shared PL/SQL area
shared resource system, incremental growth
shared SQL area
[
2
] [
3
]
SHOW INSTANCE command
[
2
]
SHOW PARAMETERS command
[
2
]
instance number
SHOW SGA command
[
2
]
SHUTDOWN command
ABORT option
[
2
]
checkpoint
database creation
IMMEDIATE option
[
2
]
specifying an instance
shutdown menu
shutting down an instance
abnormal shutdown
archiving redo log files
changing startup order
checkpoint
forcing a log switch
lost sequence numbers
unarchived log files
single instance database
single shared mode
[
2
]
SIZE option, allocating extents
SM, SMON
SMON process, instance recovery
[
2
]
recovery after SHUTDOWN ABORT
transaction recovery
SMP
SN, Sequence Number
sort enhancements
SORT MERGE JOIN
sort space
SORT_DIRECT_WRITES parameter
space, allocating extents
[
2
]
deallocating unused
determining unused
free blocks
[
2
]
free space list
not allocated to instance
[
2
]
segment management
SGA
sources of free blocks
unavailable in exclusive mode
specialized servers
speed-down
[
2
]
speedup
attainability
definition
with batch processing
SQ, Sequence Number Enqueue
SQL area, shared
SQL statement
instance-specific
restrictions
SQL*DBA
ARCHIVE LOG command
CONNECT command
MONITOR
SHOW INSTANCE command
STARTUP command
SQL*Net
client-server configuration
connect string
[
2
]
distributed database system
for CONNECT
[
2
]
for SET INSTANCE
ST, Space Management Transaction
starting up, after file operations
[
2
]
creating a database
during instance recovery
exclusive mode
[
2
] [
3
]
global constant parameters
[
2
]
instance number
remote instance
[
2
] [
3
] [
4
]
rollback segments
[
2
]
shared mode
[
2
] [
3
] [
4
]
startup order
[
2
] [
3
]
verifying access to files
STARTUP command
EXCLUSIVE option
[
2
]
OPEN option
[
2
]
PARALLEL option
PFILE option
[
2
]
specifying a database
specifying an instance
startup dialog box
startup
LCKn process
order of instances
statistics
display system
frequency of PCM lock conversion
interpreting V$SESSTAT and V$SYSSTAT
lock conversions
tuning
V$FILESTAT view
storage options, clustered tables
[
2
]
extent size
[
2
] [
3
] [
4
] [
5
]
index
rollback segment
table
[
2
]
striping, disk
sub shared mode
sub-shared exclusive mode
SV, Sequence Number Value
switch archiving mode
[
2
] [
3
]
Switch Online Redo Log File dialog box, forcing a checkpoint
symmetric multiprocessor
[
2
] [
3
]
configuration
in loosely coupled system
parallel processing
synchronization, cost of
[
2
] [
3
] [
4
] [
5
]
definition
minimizing
non-PCM
overhead
SYSDBA
[
2
] [
3
] [
4
] [
5
]
SYSOPER
[
2
] [
3
] [
4
]
system change number (SCN)
[
2
]
archive file format
[
2
]
archiving redo log files
[
2
]
incrementation
non-PCM lock
redo log history
System Global Area (SGA)
in parallel server
instance
parameter file
PCM locks
row cache
sequence cache
SHOW SGA command
statistics
SYSTEM rollback segment
global constant
[
2
]
not specified in parameter file
SYSTEM tablespace
[
2
]
system-specific Oracle documentation
archived redo log name
client-server processing
connecting with SQL*Net
datafiles, maximum number
DLM persistent resources
fine grain locking
[
2
] [
3
]
free list overhead
instance number range
lock convert rate
MAXLOGHISTORY default
password file
password file name
privileged Server Manager commands
recovery process allocation
redo log archive destination
redo log archive format
session-based locking
SQL*Net connect string
[
2
]
supported Oracle configurations
system change number (SCN)
TA, Transaction Recovery
table lock
[
2
]
disabling
minimizing
TABLE_LOCK column
table
access pattern
allocating extents
[
2
] [
3
]
cluster
contention
[
2
]
free space unavailable
initial storage
[
2
]
locating free space
lock
[
2
]
multiple files
[
2
]
PCM locks
[
2
]
read-only
simultaneous space management
tablespace radio button, media recovery
tablespace
active rollback segments
backup
[
2
] [
3
]
creating
[
2
]
data files
datafiles
dropping
[
2
]
index data
offline
[
2
]
online rollback segments
[
2
]
parallel backup
parallel recovery
read-only
recovery
[
2
]
rollback segment
[
2
] [
3
] [
4
]
SYSTEM
tables
taking offline
[
2
] [
3
]
table, tablespace
thread
THREAD option
[
2
] [
3
] [
4
] [
5
]
creating private thread
creating public thread
disabling a thread
when required
THREAD parameter
[
2
] [
3
] [
4
]
assigning thread number
conversion to multi-instance
individual parameter files
instance acquiring thread
thread
archive file format
archiving redo log files
[
2
] [
3
]
associated with an instance
closed
definition
description
disabled
[
2
]
enabled
[
2
] [
3
]
example
exclusive mode
forced log switch
log history
number of groups
[
2
]
open
[
2
]
public
[
2
] [
3
]
single
tightly coupled system, hardware architecture
[
2
]
implementations
in loosely coupled cluster
performance
TM, DML Enqueue
[
2
]
TP monitor
trace file, conversion to multi-instance
transaction lock
[
2
]
transaction processing monitor
transaction
aborted
committed data
[
2
]
concurrent
[
2
] [
3
] [
4
]
inserts
[
2
]
instance failure
isolation
lock
[
2
] [
3
] [
4
]
offline tablespace
[
2
]
recovery
[
2
]
rollback segments
[
2
]
rolling back
[
2
]
row locking
[
2
]
TRANSACTIONS parameter
[
2
]
calculating non-PCM locks
calculating non-PCM resources
ensuring DLM lock capacity
TRANSACTIONS_PER_ROLLBACK parameter
TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter
transaction
sequence numbers
updates
[
2
]
waiting for recovery
TS, TableSpace
TS, Temporary Segment
TT, Temporary Table
tuning, general guidelines
two-phase commits
TX, Transaction
[
2
]
UL, User-defined Locks
UN, User Name
uniform memory access
updates
at different times
concurrent
[
2
]
distributed lock
[
2
]
free space lists
[
2
]
locating free space
performance
upgrade
Oracle
replicated systems
US, Undo segment, Serialization
user commits
user process
free list
free space lists
[
2
]
instance shutdown errors
manual archiving
maximum number
user-level DLM
[
2
]
USER_TABLES table
user
multiple
name and password
PUBLIC
[
2
]
users, benefits of parallel database
user, SYS
[
2
]
utilities, Oracle, Export, Import
V$ACTIVE_INSTANCES view
V$BH view
[
2
] [
3
] [
4
] [
5
] [
6
]
definition
V$CACHE view
[
2
] [
3
] [
4
]
definition
V$CACHE_LOCK view
definition
V$DATAFILE view, querying
V$FALSE_PING view
definition
V$FILESTAT view, querying
V$LE table
V$LOCK table
V$LOCK_ACTIVITY view
[
2
]
COUNTER column
definition
detecting lock conversion
querying
[
2
]
V$LOCK_ELEMENT view
[
2
]
definition
V$LOCKS_WITH_COLLISIONS
V$LOG_HISTORY view
V$LOGFILE view
V$PING view
[
2
] [
3
] [
4
] [
5
] [
6
] [
7
] [
8
]
definition
querying
[
2
]
V$RECOVERY_LOG view
V$SESSION_WAIT view
V$SESSTAT view, querying
V$SORT_SEGMENT view
[
2
] [
3
]
V$SYSSTAT view
detecting lock conversion
querying
V$SYSTEM_EVENT view
V$THREAD view, conversion to multi-instance
V$WAITSTAT view
querying
[
2
]
valid bit, lock element
versions, Oracle, compatibility
[
2
]
upgrading
vertical partitioning
view
data dictionary
data files
[
2
]
rollback segments
[
2
]
virtual memory usage
wait event
introduction
parameter descriptions
summary
wait time
[
2
]
wait, session
WL, Being written Redo Log
workload
and scaleup
balancing
mixed
partitioning
type of
[
2
]
X$ dynamic performance table
XA interface
performance enhancement
recovery enhancement
XA library
XA, Instance Atribute Lock
XA_RECOVER call
XI, Instance Registration
XNC column
