Index_P

---

P

Packs

components, 424

defined, 424

functions, 426

See also Real Application Cluster Guard (RACG)

Parallel DDL, 221–22

Parallel DML, 222–23, 272

Parallelism

degree of (DOP), 219, 220–21

inter-operation, 213

intra-operation, 212, 213

Parallel load operations, 223–26

conventional path, 223–24

direct path, 224–26

SQL *Loader, 224, 225

Parallel operators, 585–86

Parallel processing, 205–31

advantages, 208

architecture, 212

defined, 206–7

drawbacks, 210

example, 207

goal, 206

introduction, 205–6

load operations, 223–26

Oracle and, 209–10

performance improvement, 209–10

query architecture, 210–19

in RAC, 219–23

recovery, 226–27

troubleshooting, 227–29

Parallel query

architecture, 210–19

execution time and, 229

full table scan (FTS), 230

hints, 217–19

index lookups and, 229

initialization parameters, 214–17

PQS, 210, 211

QC, 210

statistics, 228–29

TQ, 211

troubleshooting, 227–29

tuning, 229–30

Parallel query initialization parameters, 214–17

PARALLEL_ADAPTIVE_MULTI_USER,215–16

PARALLEL_AUTOMATIC_TUNING, 216

PARALLEL_EXECUTION_MESSAGE_SIZE, 217

PARALLEL_MAX_SERVERS, 214–15

PARALLEL_MIN_PERCENT, 215

PARALLEL_MIN_SERVERS, 214

PARALLEL_THREADS_PER_CPU, 217

Parallel query slave (PQS), 210, 211

Parallel recovery, 226–27

Parameter files, 81

binary server, 324–25

configuration, 324–26

defined, 147

definition syntax, 147

initialization, 734–37

Parameters, 377–85

ACTIVE_INSTANCE_COUNT, 377

CLUSTER_DATABASE, 377

CLUSTER_DATABASE_INSTANCE, 377

CLUSTER_INTERCONNECTS, 377

CREATE_STORED_OUTLINES, 384

CURSOR_SHARING, 377, 584

CURSOR_SPACE_FOR_TIME, 377

DBA_UNDO_EXTENTS, 603–4

DB_BLOCK_SIZE, 378, 607–8

DB_CACHE_ADVICE, 378, 592

DB_CACHE_SIZE, 378, 591–92

DB_FLASHBACK_RETENTION_TARGET, 384

DB_KEEP_CACHE_SIZE, 378, 593

DB_MULTIBLOCK_READ_COUNT, 378

DB_NAME, 378

DB_nK_CACHE_SIZE, 377–78

DB_RECOVERY_FILE_DEST, 384–85

DB_RECOVERY_FILE_DEST_SIZE, 385

DB_RECYCLE_CACHE_SIZE, 379, 594

DB_WAIT_FOR_LOCKS, 385

DB_WRITER_PROCESSES, 379

DBWR_TO_SLAVES, 379

definitions, 358

DML_LOCKS, 611–12

ENQUEUE_RESOURCES, 379, 612

FAST_START_MTTR_TARGET, 379, 599–600

GC_FILES_TO_LOCKS, 379

HASH_AREA_SIZE, 379–80

HASH_JOIN_ENABLED, 379

INSTANCE_GROUPS, 380

INSTANCE_NAME, 380

INSTANCE_NUMBER, 380

results description, 203

rows, fetching, 203–4

statement execution, 203

statement parallelization, 203

statement parsing, 200–203

variable binding, 203

Parses, 201–2

hard, 201–2, 581–85

soft, 202

time savings, 375

types, 201

Partitioned indexes, 268

Partitioning, 254–75

application, 254–55

benefits of, 269–72

composite, 264–68

with cost-based optimizer, 270

data, 257–58

database, 255–68

defined, 254

hash, 260–62

list, 263–64

Oracle methods, 258

range, 258–60

strategy evaluation, 452

See also Database design

Partition(s)

composite, 264, 268

creating, 701–5

drop, 274–75

exchange, 274–75

hash, 265, 268

independence, 269–70

maintenance, 272–75

merge, 274

move, 275

pruning, 262, 270

size definition, 708

split, 273–74

subpartitions, 266

truncate, 274–75

INSTANCE_TYPE, 385

LOCAL_LISTENER, 541

LOCK_CHECKPOINTS_TO_ALERT, 380

LOG_BUFFER, 380

LOG_CHECKPOINT_INTERVAL, 380

LOG_CHECKPOINT_TIMEOUT, 380

LOG_PARALLELISM, 381

MAX_COMMIT_PROPAGATION_DELAY, 381

OPTIMIZER_DYNAMIC_SAMPLING, 381

OPTIMIZER_INDEX_CACHING, 381, 597–98

OPTIMIZER_INDEX_COST_ADJ, 381, 596

OPTIMIZER_MAX_PERMUTATIONS, 381

OPTIMIZER_MODE, 381–82

ORACLE_TRACE_ENABLE, 382

PGA_AGGREGATE_TARGET, 382, 595

REMOTE_LISTENER, 541

SERVICE_NAMES, 382

SESSION_CACHED_CURSORS, 382, 585

SGA_MAX_SIZE, 383, 596

SHARED_POOL, 587

STATISTICS_LEVEL, 383, 578

STREAMS_POOL_SIZE, 385

THREAD, 383

TIMED_OS_STATISTICS, 383, 577

TIMED_STATISTICS, 383, 577

TRACE_ENABLED, 383

TRANSACTION_AUDITING, 383

TRANSACTIONS, 383

UNDO_MANAGEMENT, 383–84

UNDO_RETENTION, 384

UNDO_TABLESPACE, 384

values, adjusting, 454–55

WORKAREA_SIZE_POLICY, 384

Parse operation, 198–204

cursor, closing, 204

cursor, creating, 200

flow diagram, 199

query output definition, 203

Partition-wise joins, 270–72

defined, 271

join operation, 271

performance enhancement, 270–71

regular full partition join vs., 271

uses, 272

Password files, 81–82

configuration, 326

creating, 326

Performance

B-tree index, 244

capacity planning and, 447

compressed index, 248

enqueue, 611

Gigabit Ethernet, 43, 44

library cache, 590–91

OPS, 113

parallel processing and, 209–10

partition-wise join, 270–71

reverse key index, 246–47

storage subsystem and, 630

tradeoffs, 60

Performance manager, 543–46

CPU utilization chart, 544–45

database health screen, 543–46

file I/O rate chart, 545

global cache CR request chart, 545–46

See also Oracle Enterprise Manager (OEM)

Performance tuning, 455, 515–69

application, 576–86

CFS, 716–17

cluster instance, 639–44

clusters, 629–59

database, 606–15

importance, 515

instance, 586–606

introduction, 515–16

methodology, 572–76

operating system, 615–26

parallel operators, 585–86

query, 581

single instance, 571–627

STATSPACK, 517–34

tools and utilities, 515–69

UTLBSTAT/UTLESTAT, 516–17

PERFSTAT, 517

PGA_AGGREGATE_TARGET parameter, 382, 595

Physical I/O (PIO), 581

Physical logging, 472

Physiological logging, 472

Polling

defined, 47

LAN, 48

Portability

example, 6

requirement, 5–6

Pre-establishing connections, 408–9

Preinstallation, 288–98

CFS, 293–94

device configuration, 290–92

hangcheck-timer, 296–98

kernel configuration, 294–96

open file descriptors limit, 296

steps, 288–98

user creation, 292–93

See also Installation

Preparation phase (migration), 443–44

Problem diagnosis, 661–79

critical ORA errors, 671–78

introduction, 661

ORADEBUG utility, 668–71

RAC, 662–67

RDA, 678–79

Problem-solving tasks, 572–76

Process monitor (PMON), 82, 84

Program global area (PGA), 64, 65–67

creation, 65

defined, 65

impact statistics, 595–96

memory manager, 371

memory usage statistics, 371, 595

---