Oracle9i Real Application Clusters Deployment and Performance -- Index

Active/Active configurations

and Real Application Clusters, 1-3

adding nodes, 2-8

administration

aspects of scalability in Real Application Clusters, 2-8

advanced queuing

and queue table cache transfers, 3-6

and queue table instance affinity, 3-6

in Real Application Clusters, performance, 3-5

affinity

of data in Real Application Clusters, 2-4

tables and advanced queuing, 3-6

ALLOCATE EXTENT

DATAFILE clause, B-8

exclusive mode, B-8

in exclusive mode, B-8

INSTANCE clause, B-8

SIZE clause, B-8

allocation

automatic, B-9

Cache Fusion resources, A-7

extents, dynamic, A-10

of Cache Fusion resources, A-7

ALTER CLUSTER statement

ALLOCATE EXTENT clause, B-7

ALTER DATABASE statement

DATAFILE RESIZE, A-5

ALTER SEQUENCE statement

increasing cache size with, 4-11

ALTER SESSION statement

SET INSTANCE clause, B-6

ALTER TABLE statement

ALLOCATE EXTENT, B-7

application workloads

from Statspack statistics, 4-7

asynchronous I/O

for writing large amounts of data, 3-5

AUTOEXTEND clause, A-5

automatic segment-space management, 1-2, 3-2

automatic undo management, 1-2

bandwidth

interconnect, 4-3

block mode conversions

statistics for, 4-6

block size

increasing for query performance, 3-5

block transfers

analyzing, 4-8

buffer cache

adjusting size for Real Application Clusters, 4-3

as a statistics source, 4-6

buffer sizes

IPC, adjusting for Real Application Clusters, 4-3

cache

sequence numbers, 3-3

size and sequence number use, 3-3

size, default and sequence numbers, 3-3

sizing, 4-15

transfer of queue table blocks in AQ, 3-6

Cache Fusion

and e-commerce applications, 2-2

resources, exclusive, A-6

resources, shared, A-6

resources, specifying, A-5

sources of performance statistics for, 4-6

capacity limitations

identified through stress testing, 2-8

CATCLUST.SQL script

using to create views for Real Application Clusters, 4-5

charts

Performance Manager, 5-2

checkpoints, 4-3

infrequency, 4-15

cluster file systems

in Real Application Clusters, 1-2

CLUSTER_INTERCONNECTS

parameter, 4-4

clustered tables

with free lists and free list groups, B-5

clusters

free list groups, B-8

free lists, B-5

hash cluster, B-5

parallel execution tuning, A-10

communication protocols

verifying settings for, 4-3

compatibility

shared and exclusive modes, B-8

composite partitioned objects

for hot block performance issues, 3-3

concurrency

inserts and updates, B-4

configurations

full active, 1-3

connection load balancing, 1-5

control files

datafiles, B-8

cost-based optimizer, 2-5

CREATE CLUSTER statement, B-5

FREELIST GROUPS clause, B-4

FREELISTS clause, B-4

CREATE statement

setting FREELISTS and FREELIST GROUPS, B-3

CREATE TABLE statement

clustered tables, B-5

FREELISTS clause, B-4

initial storage, B-9

cyclic redundancy check (CRC) errors, 4-10

data affinity, 2-4

data blocks

cache transfers in advanced queuing, 3-6

data dictionary

querying views, 4-5

Data Guard, 1-4

data locality

in Real Application Clusters, 2-4

data warehouse

deploying applications for in Real Application Clusters, 2-3

Database Configuration Assistant (DBCA)

creating views for Real Application Clusters, 4-5

database resources

dynamic migration, 2-3

database writer processes

and checkpoints, 4-3

improving performance of, 3-5

datafiles

allocating extents, B-8

multiple files for each table, B-9

DB_BLOCK_SIZE

parameter, 3-5

DB_FILE_MULTIBLOCK_READ_COUNT

increasing for full table scans, 3-5

parameter, 3-5

DBA_QUEUE_TABLES

analyzing table and instance affinity in advanced queuing, 3-6

DBWRn processes

and checkpoints, 4-3

improving performance of, 3-5

DC_SEQUENCES

parameter, 3-3

dedicated server

and connection load balancing, 1-5

degree of parallelism (DOP), 2-4

disk affinities

and parallel query, 2-7

disk writes

reasons for, 4-14

dynamic performance views

creating, 4-5

for performance monitoring, 4-4

e-commerce

applications in Real Application Clusters, 2-2

enqueue

Global Enqueue Service (GES) statistics, 4-10

error messages

storage options, B-4

exclusive mode

free lists, B-4, B-8

extent management, 3-2

extents

allocating to instance, B-6

initial allocation, B-9

not allocated to instance, B-9

preallocating, B-7

preallocating to free list groups, B-9

size, B-8

specifying a file, B-8

failover

and Real Application Clusters, 1-3

false forced writes, A-14

false pings, A-3

FAST_START_MTTR_TARGET, 4-3

parameter, 4-3

features

taking advantage of, 1-2

File I/O Rate By Instance chart, 5-4

File I/O Rate By Object chart, 5-4

File I/O Rate chart, 5-4, 5-10

files

allocating extents, B-8

forced disk writes, A-15

false, A-14

reasons for, 4-14

free list groups

assigning to session, B-6

for concurrent inserts, B-2

setting !blocks, A-5

free lists

cluster, B-5

creating for clustered tables, B-5

creating for indexes, B-6

examples, B-5

hash cluster, B-5

in exclusive mode, B-3, B-8

number of lists, B-4

FREELIST GROUPS clause, B-4

determining reorganization needs, B-3

parameter, use, B-4

parameter, use with indexes, B-6

FREELISTS clause, B-4

creating for clustered tables, B-5

creating for indexes, B-6

examples of use, B-5

maximum value, B-4

parameter, use, B-4

parameter, use with indexes, B-6

STORAGE clause, B-4

full active configurations, 1-3

function shipping, 2-4

fusion write, 4-14

GC_FILES_TO_LOCKS parameter, A-6, A-10

examples, A-5

reducing false pings, A-15

setting, A-4

syntax, A-4

global cache blocks corrupt, 4-11

global cache blocks lost, 4-11

Global Cache Convert By Instance chart, 5-4

Global Cache Convert chart, 5-4, 5-8, 5-11

global cache cr request, 4-12

Global Cache CR Request By Instance chart, 5-4

Global Cache CR Request chart, 5-4, 5-7

Global Cache Current Block Request By Instance chart, 5-4

Global Cache Current Block Request chart, 5-4, 5-9, 5-11

global cache null to s, 4-12

global cache null to x, 4-12

global cache open s, 4-12

global cache open x, 4-12

Global Cache Service (GCS)

analyzing the interconnect, 4-10

and logical reads, 4-13

as a statistics source, 4-6

message traffic and interconnect, 4-3

resources, A-11

resources, acquisition, 3-6

statistics for, 4-9

global cache wait events, 4-9

global cache waits, 4-12

Global Enqueue Service (GES)

message traffic and interconnect, 4-3

statistics, 4-10

statistics for, 4-9

GLOBAL hint, 4-4

global V$ view tables, 5-2

hash clusters, B-5

hash partitioned objects

for hot block performance issues, 3-3

high availability

and Real Application Clusters, 1-3

full active configurations, 1-3

hot blocks

objects, 4-14

resolving performance issues for, 3-2

identifiers

for resources, A-16

incremental growth, B-9

index leaf blocks

performance of, 4-10

indexes

block splits, 3-3

using with free lists and free list groups, B-6

INITIAL storage parameter

minimum value, B-9

initialization parameters

CLUSTER_INTERCONNECTS, 4-4

DB_BLOCK_SIZE, 3-5

DB_FILE_MULTIBLOCK_READ_COUNT, 3-5

DC_SEQUENCES, 3-3

FAST_START_MTTR_TARGET, 4-3

INITRANS, 4-11

INSTANCE_GROUPS, 2-6

INSTANCE_ROLL, 1-5

LOG_CHECKPOINT_INTERVAL, 4-3

LOG_CHECKPOINT_TIMEOUT, 4-3

MAXTRANS, 4-11

PARALLEL_INSTANCE_GROUP, 2-6

PARALLEL_MAX_SERVERS, 4-4, 4-5

PCTINCREASE, B-8

STATISTICS_LEVEL, 4-6

TIMED_STATISTICS, 4-6

INITRANS

parameter, 4-11

INSERTS

concurrent, B-4

free space unavailable, B-8

inserts

space management, 3-2

INST_ID column, 4-4

INSTANCE clause

SET INSTANCE statement, B-6

INSTANCE_GROUPS

initialization parameter, 2-6

INSTANCE_NUMBER parameter

initialization parameters

INSTANCE_NUMBER, B-6

INSTANCE_ROLE

use of in secondary instance connections, 1-5

instances

adding instances, B-9

associated with datafile, B-9

associated with extent, B-6

associating with free list groups, B-6

free list, B-8

number, B-6

interconnect

and performance, 4-3

bandwidth, 4-3

identifying with SQL*Plus, 4-4

latency, analyzing Global Cache Service (GCS) timings, 4-10

protocols for Real Application Clusters, 4-3

verifying settings for, 4-3

intranode parallelism, 2-5

IPCs

and Cache Fusion, 4-2

buffer sizes, adjusting, 4-3

JDBC OCI, 1-5

leaf blocks

indexes, performance issues for, 4-10

Library Cache Lock By Instance chart, 5-4

Library Cache Lock chart, 5-4, 5-8, 5-11

load balancing, 2-5

load processing capabilities, 2-7

locally managed table spaces, 3-2

locks

deciding whether to use by setting GC_FILES_TO_LOCKS, A-2

setting with GC_FILES_TO_LOCKS, A-2

when to use locks, A-3

LOG_CHECKPOINT_INTERVAL, 4-3

parameter, 4-3

LOG_CHECKPOINT_TIMEOUT, 4-3

parameter, 4-3

logical reads

and the Global Cache Service (GCS), 4-13

mapping blocks to Cache Fusion resources, A-6

MAXEXTENTS storage parameter

automatic allocations, B-9

MAXTRANS

parameter, 4-11

memory-mapped IPCs

and Cache Fusion, 4-2

message request counters, 4-6

migration

returning to exclusive mode, B-8

MINEXTENTS storage parameter

automatic allocations, B-9

default, B-9

monitoring

procedures for, 4-8

statistics for Real Application Clusters, 4-5

nodes

adding, 2-8, B-9

objects

creation of and effect on performance, 3-2

hot blocks, 4-14

identifying performance issues for, 4-9

partitioning for hot blocks, 3-2

OCI library, 1-5

online transaction processing

in Real Application Clusters, 2-2

operating system

striping for performance, 3-5

Oracle

compatibility, B-8

Oracle Net

OCI libraries, 1-5

Oracle Performance Manager

displaying charts, 5-2

overview, 5-2

oradebug

ipc, 4-4

setmypid, 4-4

packets

dropped, 4-10

parallel execution

and load balancing, 2-5

clusters, A-10

processes, 4-5

server processes and data affinity, 2-4

parallel instance groups, 2-6

PARALLEL_INSTANCE_GROUP

parameter, 2-6

PARALLEL_MAX_SERVERS

parameter, 4-4, 4-5

parallelism

in Real Application Clusters, 2-4

parallel-aware query optimization, 2-5

Past Images (PI)

as used in recovery, 4-3

PCTINCREASE parameter

table extents, B-8

performance

issues in applications in Real Application Clusters, 3-4

maintaining history of, 4-6

primary components affecting, 4-3

testing, 2-7

using Statspack, 4-7

wait events, analyzing, 4-12

Performance Manager

charts, hierarchies, 5-4

PL/SQL

in Real Application Clusters, 1-6

packages and TAF, 1-5

preallocating

extents, B-7

extents to free list groups, B-9

Primary/Secondary Instance configurations

and Real Application Clusters, 1-3

and TAF, 1-5

processes

parallel execution, 4-5

protocols

interconnect, 4-2

queries

tuning tips, 3-4

raw devices, 1-2

Real Application Clusters

and e-commerce, 2-2

disk affinities, 2-7

parallel execution, A-10

tablespace use, 3-2

Real Application Clusters Database Health Overview chart, 5-4, 5-11, 5-12

Real Application Clusters Guard I, 1-4

Real Application Clusters Guard II, 1-3

Real Application Clusters Top Sessions chart, 5-4, 5-10

resources

acquisition and the GCS, 3-6

dynamic migration, 2-3

identifier, A-16

name format, A-16

response times

analyzing, 4-12

retransmits, 4-10

RMAN

in Real Application Clusters, 1-6

Row Cache Lock By Instance chart, 5-4

Row Cache Lock chart, 5-4, 5-9, 5-11

scalability tests, 2-7

segments

header, A-17

sequence numbers

and global conflicts, 3-3

caching, suppressing with ordering, 3-3

generation and tablespace use, 3-2

generation with database tables, 3-4

using, 3-3

server parameter file, 1-2

server processes

and parallel execution, 2-4

Sessions chart, 5-4, 5-10

setting locks, A-2

shared disk architectures

and data affinity, 2-4

shared nothing systems

and data affinity, 2-4

shared pool

adjusting size for Real Application Clusters, 4-3

shared resource system, B-9

shared server

and connection load balancing, 1-4

in Real Application Clusters, 1-4

space

allocating extents, B-9

not allocated to instance, B-9

unavailable in exclusive mode, B-8

SQ Enqueue

from V$ENQUEUE_STATS, 4-11

standby databases, 1-4

statistics

contents of, 4-6

maintaining records of, 4-6

monitoring for Real Application Clusters, 4-5

where maintained, 4-6

where Oracle collects from, 4-6

STATISTICS_LEVEL

parameter, 4-6

Statspack

using in Real Application Clusters, 4-7

storage, 1-2

options, clustered tables, B-4

options, extent size, B-8, B-9

options, table, B-4

striping

and disk affinity, 2-7

System Global Area (SGA)

for statistics maintenance, 4-6

tables

affinity and advanced queuing, 3-6

cluster, B-5

free space unavailable, B-8

initial storage, B-9

multiple files, B-9

with high insert rates, 3-3

tablespaces

locally managed for automatic segment-space management, 3-2

use in Real Application Clusters, 3-2

timed statistics, 4-6

TIMED_STATISTICS

parameter, 4-6

Total Transfer chart, 5-4, 5-6, 5-11

hierarchy for lower-level charts, 5-5

traffic generators, 2-7

transaction monitor, 1-4

Transfer By File chart, 5-4, 5-7

Transfer By File Per Instance chart, 5-4

Transfer By Instance chart, 5-4

Transfer By Instance Per File chart, 5-4

Transfer By Instance Per Object chart, 5-4

Transfer By Object Per File chart, 5-4

transparent application failover (TAF), 1-5

TX Enqueue

from V$ENQUEUE_STATS, 4-11

user sessions

associating with free list groups, B-6

USER_QUEUE_TABLES

analyzing table and instance affinity in advanced queuing, 3-6

user-mode IPCs

and Cache Fusion, 4-2

Users By Instance chart, 5-4

Users chart, 5-4, 5-10

V$BH

identifying contended objects with, 4-15

V$CACHE

identifying contended objects with, 4-15

V$CACHE_TRANSFER

identifying contended objects with, 4-15

versions, Oracle

compatibility, B-8

VIA

interconnect protocol, 4-2

views

creating for Real Application Clusters, 4-5

for performance monitoring, 4-4

wait events

analyzing, 4-12

workloads

distribution for data warehouse applications, 2-5

from Statspack statistics, 4-7