Index

ALTER DATABASE ADD LOGFILE command, 4-7

ALTER DATABASE DISABLE THREAD statement, 3-8

ALTER DATABASE OPEN RESETLOGS statement, 14-13

ALTER DATABASE statement

setting the log mode, 3-2, 3-8

THREAD, 3-8

thread of redo, 3-8

ALTER INDEX statement

DEALLOCATE UNUSED option, 8-14

ALTER ROLLBACK SEGMENT statement, 3-4

ALTER SESSION SET INSTANCE statement, 8-8

ALTER SESSION statement

SET INSTANCE option, 8-8

ALTER SYSTEM ARCHIVE LOG CURRENT statement, 4-7

ALTER SYSTEM ARCHIVE LOG statement, 4-7, 13-21

CURRENT clause, 13-15

global log switch, 13-15, 13-21

THREAD clause, 4-7, 13-5

ALTER SYSTEM CHECK DATAFILES statement

ALTER SYSTEM CHECKPOINT LOCAL statement, 4-7

ALTER SYSTEM CHECKPOINT statement, 13-14

global versus local, 4-7

specifying an instance, 4-7

ALTER SYSTEM privilege, 13-14, 13-15

ALTER SYSTEM SWITCH LOGFILE statement, 4-7, 13-15

DBA privilege, 13-15

ALTER TABLE statement

ALLOCATE EXTENT, 8-9

allocating extents, 8-12, 8-13

DISABLE TABLE LOCK clause, 7-17, 10-4

ENABLE TABLE LOCK clause, 7-17, 10-4

MAXEXTENTS option, 8-13

ALTER TABLESPACE statement

ADD DATAFILE, 9-5

BACKUP option, 13-20

READ ONLY option, 5-3

analysis

of applications for Oracle Parallel Server, 5-3

applications

analysis for Oracle Parallel Server, 5-3

availability, 14-3

designing, A-2

development for Oracle Parallel Server, 5-2

for Oracle Parallel Server, determining suitability, 5-2

partitioning, methodology, 5-8

table access patterns, 5-3

archive log

ARCHIVE LOG clause

CURRENT option, 13-15, 13-21

global log switch, 13-15, 13-21

manual archiving, 13-5

THREAD option, 13-1, 13-5

ARCHIVE LOG statement, 13-4

archive logs

backing up with RMAN, 13-8

archive mode

switch, 3-8

ARCHIVELOG mode, 3-2, 3-8

automatic archiving, 13-3

changing mode, 3-2, 3-8

creating a database, 3-2

online and offline backups, 13-3

archiving redo log files, 13-1

automatic versus manual, 13-4

creating a database, 3-2

forcing a log switch, 13-15

history, 13-7

log sequence number, 13-6

online archiving, 13-3

asynchronous lock operations

analyzing, 12-17

AUTOEXTEND, 9-5

AUTOLOCATE

RMAN option, 13-11

automatic archiving, 13-4

automatic recovery, 13-8

availability

data files, 14-4

single-node failure, 14-2

steps of recovery, 14-5

background processes

ARCH, 13-4

LGWR, 13-7

SMON, 4-5, 14-2

backups

archive log, 13-8

files used in recovery, 14-7

offline, 13-16

online, 13-16, 13-21

parallel, 13-16

batch processing

and partitioning, 5-17

BEGIN BACKUP option, 13-20

Block Server Process

and consistent-read blocks, 12-2

blocks

allocating dynamically, 8-13

associated with instance, 14-3

classes and synchronization, 6-9

contention, 7-14

on indexes, 5-5

contention for, 8-9, 8-11

branch blocks

minimizing contention for, 6-11

buffer cache

CATPARR.SQL script, 9-8, 12-9

cache

Cache Fusion

CHECK DATAFILES clause

closed thread, 13-4, 13-21

checkpoints

forcing, 13-14

Cluster Manager software, 4-2

clusters

recommended locations for, 1-2

free list groups, 8-9

free lists, 8-5

hash cluster, 8-5

committed data

checkpoint, 13-14

instance failure, 14-3

common parameter files

using multiple, 1-3

compatibility

shared and exclusive modes, 8-9

composite partitioning, 5-15

concurrency

inserts and updates, 8-4

maximum number of instances, 3-3

configurations

change in redo log, 3-8

CONNECT @instance-path command, 3-6

CONNECT command, 4-4, 4-6

forcing a checkpoint, 13-14

CONNECT INTERNAL

example of, 1-5

connect strings, 4-4

connecting

to instances, 4-3

to remote instances, 4-4

consistent-read blocks, 12-2

contention

block, 7-14, 8-9, 8-11

distributed lock, 7-14

SYSTEM tablespace, 3-4

table data, 8-11

context switches

reduced with Cache Fusion, 12-4

control files

backing up, 13-1

creating, 3-9

data files, 8-10

log history, 3-3, 13-7

parameter values, 1-9

CONTROL_FILES parameter, 1-8, 14-11

reduced with Cache Fusion, 12-4

CPU service time required

calculating, 11-8

CPU utilization

CREAT DATABASE

MAXLOGHISTORY clause, 3-3

CREATE CLUSTER statement, 8-5

FREELIST GROUPS option, 8-4

FREELISTS option, 8-4

CREATE CONTROLFILE statement, 3-9

changing database options, 3-9

MAXLOGHISTORY, 13-7

CREATE DATABASE

creating threads, 3-7

MAXDATAFILES clause, 3-3

MAXINSTANCES clause, 3-3

MAXLOGFILES clause, 3-3

MAXLOGMEMBERS clause, 3-3

CREATE DATABASE statement, 3-2

MAXINSTANCES, 3-3

MAXLOGFILES, 3-3

MAXLOGHISTORY, 3-3, 13-7

MAXLOGMEMBERS, 3-3

setting the log mode, 3-2, 3-8

CREATE INDEX statement

FREELISTS option, 8-6

CREATE PUBLIC ROLLBACK SEGMENT statement, 3-5

CREATE ROLLBACK SEGMENT statement, 3-4, 3-5

CREATE statement

setting FREELISTS and FREELIST GROUPS, 8-4

CREATE TABLE statement

clustered tables, 8-5

examples, 8-12

FREELISTS option, 8-4

initial storage, 8-11, 8-12

creating a rollback segment, 3-4, 3-5

creating threads, 3-7

current instance

CURRENT option

forcing a global log switch, 13-15

global log switch, 13-21

data block addresses

translating to lock name, 8-13

data blocks, 7-5

types accessed by transactions, 6-3

data dictionary

querying views, 12-9

views, 3-5

data dictionary cache locks, 7-19

data files

adding, 9-2, 9-5, 9-8

allocating extents, 8-10

backing up, 13-1

file ID, 7-3

multiple files per table, 8-9, 8-11

number of blocks, 7-3

parallel recovery, 14-7

recovery, 14-7

tablespace name, 7-3

validity, 9-7

data files and data blocks

examining, 7-3

database

archiving mode, 3-2, 3-8

design techniques for Oracle Parallel Server, 6-2

designing, A-2

mounted but not open, 3-8

number of archived log files, 13-7

number of instances, 3-3

rollback segments, 3-4

standby, 14-17

starting NOMOUNT, 14-11

Database Configuration Assistant

and object creation for Oracle Parallel Server, 3-1

and the IFILE parameter, 1-3

placement of IFILE parameter, 1-3

database mount locks, 7-19

data-dependent routing, 5-16

DATAFILE option

table, 8-12

DB_BLOCK_BUFFERS parameter

DB_BLOCK_SIZE parameter, 1-8

GC_RELEASABLE_LOCKS, 9-8

DB_DOMAIN parameter, 1-8

DB_FILES parameter, 1-8

DB_NAME parameter, 1-8, 1-9

DBA_ROLLBACK_SEGS view, 3-6

public rollback segments, 3-5

DBA_SEGMENTS view, 3-6

DBA_TABLES table, 10-4

DBMS_JOB

using, 5-17

DBMS_SPACE package, 8-14

DBMSUTIL.SQL script, 8-14

DDL

commands, 10-3

deallocating unused space, 8-14

degree of parallelism

adaptive multi-user feature, 2-6

setting, 2-2

DELETE

block access during, 6-9

departmental partitioning method, 5-13

deployment

techniques for application development, 5-2

designing

databases for Oracle Parallel Server, 6-2

diagnosing

performance problems, 11-18

dictionary cache

lock, 7-19

DISABLE TABLE LOCK clause, 10-4

DISABLE THREAD clause, 3-8

disabling the archive history, 3-3

disabling threads, 3-8

disaster recovery, 14-10, 14-13

DISCONNECT command, 4-5

disconnecting from an instance, 4-5

multiple sessions, 4-6

user process, 4-5

disk

affinity, 2-3, 2-7

contention, avoiding, 2-6

DLM

lock statistics, analyzing, 12-18

message statistics, analyzing, 12-20

parameters, 1-14

recovery steps, 14-5

resources, analyzing, 12-18

statistics, for monitoring contention, 11-18

workloads, affect on performance, 12-18

DM, Database Mount, 7-19

DML_LOCKS parameter, 1-8, 1-10, 7-17

and performance, 10-4

ensuring IDLM lock capacity, 10-3

dropping a redo log file

log switch, 13-15

manual archiving, 3-8

restrictions, 3-8

dropping database objects

tablespace, 9-2

dynamic allocation, 6-6

dynamic performance view

creating, 12-9

ENABLE TABLE LOCK clause, 10-4

END BACKUP clause, 13-20

enqueues

in V$LOCK, 9-13

error messages

parameter values, 1-6

rollback segment, 3-5

specifying instance number, 8-11

specifying thread number, 1-7

startup, 8-11

switching archive log mode, 3-8

EXCLUSIVE option, 4-2

EXT_TO_OBJ table, 9-8, 12-9

extents

allocating PCM locks, 8-9

allocating to instance, 1-6, 8-8, 8-12

initial allocation, 8-11

not allocated to instance, 8-10

rollback segment, 3-6

size, 3-6, 8-9

specifying a file, 8-10

external sequence generators, 6-14

failure

access to files, 14-4

parallel rollback, Fast-Start, 14-16

media, 14-7

node, 14-2

false pings, 9-11

Fast-Start Parallel Rollback

features

new, xvii

file

dropping, 3-8

file to lock mapping, 7-4

FILE_LOCK view, 7-4, 9-7

files

fixed locking, 7-12

fixed PCM locks

specifying, 9-4

foreground processes

instance shutdown, 4-5

free list groups

and cache coherency, 6-10

assigning to session, 8-8

setting !blocks, 9-4

unused space, 8-14

used space, 8-14

using to partition data, 8-1

free lists

cluster, 8-5

creating for clustered tables, 8-5

creating for indexes, 8-6

hash cluster, 8-5

implementing, 8-2

in exclusive mode, 8-4, 8-9

index, 8-6

need for, 8-2 to 8-3

number of lists, 8-4

partitioning data, 1-6

PCM locks, 8-9

unused space, 8-14

FREELIST GROUPS

storage option, 1-6

FREELIST GROUPS clause, 1-7, 8-4, 8-12

FREELISTS

creating for clustered tables, 8-5

creating for indexes, 8-6

storage option, 8-4

FREELISTS clause, 8-4

indexes, 8-6

maximum value, 8-4

GC_DEFER_TIME parameter, 1-10

GC_FILES_TO_LOCKS parameter, 1-8, 1-10, 3-9, 7-7, 7-10

1 to 1 examples, 9-4

adding data files, 9-8

adjusting after file operations, 9-2

associating PCM locks with extents, 8-9

reducing false pings, 9-12

room for growth, 9-6

setting, 9-2

syntax, 9-2

GC_RELEASABLE_LOCKS parameter, 1-10

default, 9-8

GC_ROLLBACK_LOCKS parameter, 1-8, 1-10, 9-3, 9-9

default setting for, 9-9

geographic

partitioning method, 5-13

global cache

coherence, measuring, 11-9

lock allocation, 6-16

synchronization and block classes, 6-9

global cache cr block log flush time, 12-15

global cache cr block log flushes, 12-14

global cache cr block receive time, 12-14

global cache cr block send time, 12-14

global cache cr block serve time, 12-14

global cache cr blocks received, 12-14

global cache cr blocks served, 12-14

global cache cr timeouts, 12-14

global cache freelist waits, 9-8

global cache parameters, 1-9

global cache statistics

analyzing, 12-11

GLOBAL clause

forcing a checkpoint, 13-14

global constant parameter

same for all instances, 1-8, 1-10

global constant parameters

list of, 1-9

GLOBAL hint, 12-10

global lock statistics

analyzing, 12-15

GLOBAL option

forcing a checkpoint, 4-7

global work ratios

measuring, 11-11

group

MAXLOGFILES, 3-3

redo log files, 3-3, 3-8

GROUP clause, 13-5

growth

accommodating with more instances, 5-17

room for, 9-6

GV$CACHE view, 12-9

GV$CLASS_PING view, 12-9

GV$FILE_PING view, 12-9

GV$LIBRARYCACHE view, 12-9

GV$PARAMETER view, 2-5

GV$PING view, 12-9

GV$PX_PROCESS view, 2-6

GV$PX_PROCESS_SYSSTAT view, 2-6

GV$PX_SESSION view, 2-6

GV$PX_SESSSTAT view, 2-6

GV$ROWCACHE view, 12-9

hash clusters, 8-5

hash partitioning, 5-15

header

blocks, user undo segments, 7-6

rollback segment, 3-6

segment, 3-6

high speed interconnect, 5-3

history

hot blocks

identifiers

IDLM parameters, 1-14

IFILE

parameter, 1-3

IFILE parameter, 1-4

multiple files, 1-4

overriding values, 1-3

specifying identical parameters, 1-5

include file parameter, 1-4

incremental growth, 8-11

indexes

block contention, 5-5

creating, 8-6

data partitioning, 7-14

FREELISTS option, 8-6

issues for inter-instance contention, 6-10

locking policy for, 6-13

PCM locks, 7-14

reverse-key, for minimizing contention, 6-11

INITIAL storage parameter

minimum value, 8-11

initialization files

location, 1-4

initialization parameter files

recommended locations for, 1-4

initialization parameters

archiving, 13-4

displaying values, 1-6

duplicate values, 1-3

global constant, 1-9

identical, 3-2

identical for all instances, 1-8

multiple instance issues regarding, 1-10

planning LM capacity, 10-3

setting for multiple instances, 1-7

that must be identical on all instances, 1-8

that must be unique on all instances, 1-8

using default value, 1-9

INSERT

processing within Oracle, 6-4

INSERTS

concurrent, 8-4

free lists, 1-6

free space unavailable, 8-9

INSTANCE option

allocating, 8-12

SET INSTANCE command, 8-8

SHOW INSTANCE command, 4-4

INSTANCE_GROUPS parameter, 2-3

INSTANCE_ID column, 12-9

INSTANCE_NUMBER

as determined by startup order, 1-6

INSTANCE_NUMBER parameter, 1-8, 8-8

exclusive mode, 1-6

exclusive or shared mode, 1-6

recommended settings for, 1-6

setting, 8-11

setting for freelist groups, 6-6

unique values for instances, 1-6, 1-10

unspecified, 1-6

instances

instance-specific parameter files, 1-2

conditions requiring, 1-3

interconnect, 5-3

protocols for OPS, 12-5

INTERNAL option

instance shutdown, 4-5

I/O

minimizing, 7-14

statistics, analyzing, 12-23

IPCs

and Cache Fusion, 12-5

jobs

and instance affinity, 5-17

latches, 7-19

analyzing statistics for, 12-28

LCKn process

role in recovery, 14-5

leaf blocks

minimizing contention for, 6-11

LGWR process

parameter for the multi-threaded server, 1-13

library cache locks, 7-19

LISTENER

LM_LOCKS parameter, 1-8, 1-14

LM_RESS parameter, 1-14

load balancing

in parallel execution, 2-5

LOCAL clause

forcing a checkpoint, 4-7, 13-14

local instances

nodes, 4-4

local work ratios

measuring, 11-11

lock

elements, number, 7-6

locking policy

for indexes, 6-13

locks

log files

redo log file, 13-1

log history, 3-3, 13-7, 14-9

log sequence numbers, 13-6, 13-7

log switches

adding or dropping files, 3-8

closed thread, 13-15

forcing, 13-15, 13-21

global, 13-21

LOG_ARCHIVE_DEST parameter, 1-8, 14-8, 14-9

specifying for recovery, 14-9

LOG_ARCHIVE_FORMAT parameter, 1-11, 13-6, 14-9

same for all instances, 14-9

used in recovery, 14-9

LOG_ARCHIVE_START parameter, 13-4

automatic archiving, 1-4, 13-4

creating a database, 3-2

LOG_CHECKPOINT_TIMEOUT parameter

inactive instance, 13-15

manual archiving, 13-4

dropping a redo log file, 3-8

mapping blocks to PCM locks, 7-7

MAX_COMMIT_PROPAGATION_DELAY parameter, 1-8, 1-11, 7-18

MAXDATAFILES clause, 3-3, 3-9

MAXDATAFILES parameter, 3-9

MAXEXTENTS storage parameter

automatic allocations, 8-11

preallocating extents, 8-13

MAXINSTANCES clause, 3-3

changing, 3-9

MAXINSTANCES parameter, 3-9

MAXLOGFILES clause, 3-3, 3-9

MAXLOGFILES parameter, 3-9

MAXLOGHISTORY clause, 3-3, 13-7

changing, 3-9

CREATE CONTROLFILE, 13-7

MAXLOGHISTORY parameter, 3-9

MAXLOGMEMBERS

clause, 3-3, 3-9

MAXLOGMEMBERS clause, 3-3

MAXLOGMEMBERS parameter, 3-9

media failure, 14-7

automatic recovery, 13-8

media recovery, 14-7

incomplete, 14-8

log history, 3-3, 13-8, 14-8

O/S utilities, 14-8

member

MAXLOGMEMBERS, 3-3

messages

access to files, 14-4

ALERT file, 14-4

instance shutdown, 4-5

migration

returning to exclusive mode, 8-9

MINEXTENTS storage parameter

automatic allocations, 8-11, 8-12

default, 8-11

mode

archiving, 3-2, 3-8, 13-3

modified data

parameter for the multi-threaded server, 1-13

MONITOR command, 3-6

monitoring

statistics for, 11-2

mount locks, 7-19

MTS_DISPATCHERS

MTS_DISPATCHERS parameter, 1-13

multiple nodes

starting from one node, 1-5

multiple shared mode, 7-19

multiplexed redo log files

log history, 13-8

total number of files, 3-3

multi-threaded server

parameters for, 1-13

new features, xvii

NEXT storage parameter, 13-5

NLS_* parameters, 1-11

NOARCHIVELOG mode, 3-8

changing mode, 3-2, 3-8

creating a database, 3-2, 3-8

requiring offline backups, 13-3

nodes

adding, 8-11

affinity awareness, 13-19

failure of, 14-2

local, 1-4, 1-5

parallel backup, 13-16

remote, 4-4

NOMOUNT option, 14-11

non-default parameter files, 1-2

non-PCM locks, 7-16

dictionary cache lock, 7-19

DML lock, 7-17

library cache lock, 7-19

mount lock, 7-19

overview, 7-16

system change number, 7-18

table lock, 7-17

transaction lock, 7-17

NSTANCE_GROUPS parameter, 2-5

offline backups

parallel, 13-16

redo log files, 13-16

online backups

archiving log files, 13-21

parallel, 13-16

procedure, 13-21

redo log files, 13-16

online recovery, 14-2, 14-4, 14-7

online redo log file

archive log mode, 3-8

log switch, 13-15

thread of redo, 1-7

online redo log files

archiving, 13-1, 13-7

log switch, 13-7

operating system

privileges, 4-7

operating system-specific Oracle documentation

archived redo log name, 13-6

instance number range, 8-10

Oracle

compatibility, 8-9

overlaps, 5-9

packaged applications

scalability for, 12-4

parallel automatic tuning, 2-6

parallel backups, 13-16

Parallel Cache Management

locks, minimizing number of, 5-3

parallel cache management locks

releasable, 9-3, 9-5

parallel execution

and scalability, 5-3

limiting instances for, 2-2

load balancing, 2-5

using performance views to examine, 2-6

parallel mode

startup, 1-9

PARALLEL option, 4-2

parallel recovery, 14-7, 14-14, 14-16

PARALLEL_ADAPTIVE_MULTIUSER parameter, 2-6

PARALLEL_INSTANCE_GROUP parameter, 2-4

PARALLEL_MAX_SERVERS parameter, 14-14, 14-16

PARALLEL_SERVER parameter, 1-11, 4-2

PARALLEL_SERVER_ INSTANCES parameter, 1-12

PARALLEL_SERVER_INSTANCES parameter, 1-8

parameter

database creation, 3-3

parameter files

backing up, 13-1

common file, 1-5

duplicate values, 1-3

identical parameters, 1-9

IFILE parameter, 1-4

include file parameter, 1-4

initialization, 1-2

instance specific, 1-2

instance specific, conditions requiring, 1-3

instance-specific, 1-3 to 1-4

location, 1-3

naming conventions for, 1-2

non-default, 1-2

PFILE, 1-4, 1-5

remote instance, 1-4, 1-5

remote instances, 4-4

parameters

database creation, 3-3

initialization, 1-1

setting for multiple instances, 1-7

storage, 8-4, 8-6, 8-9

that must be identical on all instances, 1-8

that must be unique on all instances, 1-8

partitioning

partitioning data

table data, 7-14, 8-9

PCM locks, 7-14

PCTINCREASE parameter

table extents, 8-9

performance

problems, diagnosing, 11-18

problems, identifying, 12-31

views, using to examine parallel execution, 2-6

PFILE option, 1-4, 1-5

physical layouts

design of, 6-15

suggestions for, 6-15

physical partitioning strategy

considerations for, 6-15

physical table partitioning, 5-15

pinging, 9-10, 9-12

identifying by block class, 12-26

rate, 9-11

private rollback segments, 1-9, 3-5

creating, 3-4

private thread, 3-7

privileges

ALTER SYSTEM, 13-14, 13-15

PROCESSES parameter, 1-12

parameter for the multi-threaded server, 1-13

PROTOCOL

public rollback segments, 3-5

bringing online, 3-5

creating, 3-5

owner, 3-5

specifying, 3-5

using by default, 3-5

PUBLIC thread, 3-7

reader/writer conflicts

and Cache Fusion, 12-1

read-only access

index data, 7-14

read-only tables, 5-3

recording statistics

for tuning, 11-5

RECOVER command, 4-6, 14-7, 14-13, 14-16

RECOVER DATABASE statement, 14-7

RECOVER DATAFILE statement, 14-7

RECOVER TABLESPACE statement, 14-7

recovery, 14-1

Recovery Manager, 14-6

archive log backup, 13-8

disaster recovery, 14-10

incomplete media recovery, 14-8

RECOVERY_PARALLELISM parameter, 1-12, 14-14, 14-15

redo log files

archiving, 3-8, 13-1, 13-3, 13-15

archiving mode, 13-3

backup, 13-16

dropping, 13-15

releasable PCM locks, 9-3, 9-5

log sequence number, 13-6

redo threads, 13-1, 13-5

releasable locking, 7-12

remote instance, 1-4, 1-5

remote instances, 4-4

renaming a file

log switch, 13-15

resources

and locks, avoiding dynamic allocation, 10-2

operating system, 1-9

releasing, 14-3

restrictions

changing the redo log, 3-8

RETRY option

STARTUP PARALLEL command, 4-3

reverse-key indexes

creating, 5-5

for minimizing contention, 6-11

RMAN

AUTOLOCATE option, 13-11

restoring archive logs with, 13-11

using to back up archive logs, 13-8

rollback segment, 3-4

rollback segments

public vs. private, 3-5

setting parameters for, 1-8

specifying, 3-4

tablespace, 3-4, 3-6

ROLLBACK_SEGMENTS parameter, 1-9, 1-13

private and public segments, 3-4, 3-5

rolling back

routing, data-dependent, 5-16

row level locking

DML locks, 7-17

ROW_LOCKING parameter, 1-8

scalability

and partitioning, 5-16

with Cache Fusion, 12-4

SCN

System Change Number, 7-18

segment header

processing during inserts, 6-4

segments

name, 3-6

SELECT

block access during, 6-9

sequence generators

external, 6-14

sequence number cache size, 6-13

sequence number generator

and block contention, 5-5

sequence numbers

using, 6-13

sequences

global conflict detection for, 6-14

log sequence number, 13-6, 13-7

SERIALIZABLE parameter, 1-8

SERVICE_NAMES parameter, 1-8

sessions

multiple, 4-5, 4-6

waiting for PCM lock conversion, 9-12

SESSIONS parameter

SET INSTANCE command, 1-5, 4-4

example of, 1-5

instance startup, 1-5, 4-4

SET UNTIL command, 14-10

setting instances, 4-3

shared mode

instance number, 1-6

instance recovery, 14-2

recovery restrictions, 14-7

shared resource system, 8-11

shared SQL area, 5-8

SHARED_POOL_SIZE

setting, 10-3

SHOW INSTANCE command, 4-4, 4-6

SHOW PARAMETER command

example of, 1-6

SHOW PARAMETERS command, 4-6

instance number, 1-6

SHOW SGA command, 4-6

SHUTDOWN ABORT command, 4-5

SHUTDOWN command

ABORT option, 4-5, 4-6

IMMEDIATE option, 4-6

specifying an instance, 4-4

shutting down an instance, 4-5

abnormal shutdown, 4-5

archiving redo log files, 13-15

changing startup order, 1-6

forcing a log switch, 13-15

unarchived log files, 13-4

single shared mode, 7-19

SIZE option

instance recovery, 14-2, 14-3

SMON process

recovery after SHUTDOWN ABORT, 4-5

space

allocating extents, 8-11

deallocating unused, 8-14

determining unused, 8-14

not allocated to instance, 8-10

unavailable in exclusive mode, 8-9

SQL area

shared, 5-8

SQL statements

instance-specific, 4-7

SQL*Plus sessions

multiple, 4-6

standby databases, 14-17

starting an instance using SQL*Plus, 4-2

starting up

after file operations, 9-2

during instance recovery, 3-3

exclusive mode, 8-11

global constant parameters, 1-9

remote instance, 1-4, 1-5, 4-4

rollback segments, 3-5

startup order, 1-6

STARTUP command, 1-5

MOUNT option, 14-13

PFILE option, 1-4, 1-5

specifying an instance, 4-4

static allocation, 6-6

statistics

DLM, for monitoring contention, 11-18

global cache, analyzing, 12-11

recording for tuning, 11-5

views containing, 11-5

where maintained, 11-2

storage options

clustered tables, 8-4

extent size, 8-9, 8-11, 8-12

index, 8-6

table, 8-4

switch archiving mode, 3-2, 3-8

synchronization

determining the costs of, 11-7

synchronous lock gets

analyzing, 12-17

SYSDBA, 13-16

privilege for connecting, 4-5

SYSOPER, 13-16

privilege for connecting, 4-5

System Change Number, 7-18

system change numbers, 7-18

archive file format, 13-6

archiving redo log files, 13-5

redo log history, 13-7

SYSTEM tablespace, 3-4

system undo blocks, 7-5

system-specific Oracle documentation

MAXLOGHISTORY default, 13-7

redo log archive destination, 13-7

redo log archive format, 13-7

table locks, 7-17

TABLE_LOCK column, 10-4

tables

free space unavailable, 8-9

cluster, 8-5

contention, 8-11

DELETE, 5-4

initial storage, 8-11

INSERT, 5-4

locks, 7-17

locks, disabling, 10-4

tablespaces

design, for access distribution, 6-16

dropping, 9-2

index data, 7-14

online rollback segments, 3-4, 3-6

parallel backup, 13-16

parallel recovery, 14-7

read-only, 9-7

recovery, 14-7

rollback segment, 3-4, 3-6

SYSTEM, 3-4

THREAD clause, 4-7, 13-1, 13-5, 13-15

disabling a thread, 3-8

when required, 3-7

THREAD parameter, 1-8, 1-13, 3-7

threads

archive file format, 13-6

archiving redo log files, 13-1, 13-5, 13-15

associated with an instance, 3-7

changing from public to private, 3-8

enabled, 13-8, 13-21, 14-9

exclusive mode, 1-7

forced log switch, 13-15

log history, 13-8

open, 13-8, 13-21

public, 3-7

throughput

with Cache Fusion, 12-4

TM, DML Enqueue, 7-17

transaction processing monitor, 5-6, 5-15

transactions

committed data, 13-14

instance failure, 14-3

locks for, 7-17

partitioning, 5-15

rolling back, 14-3

table access patterns, 5-3

types of DML involved, 6-3

waiting for recovery, 14-3

TRANSACTIONS parameter