Index_O

---

O

OcfsUtil command, 714–15

OCOPY utility, 462

Online block recovery, 146–47

Online log switching algorithm, 477

Online redo log files, 509

Online transaction processing system

(OLTP), 52, 247

Open Source Initiative (OSI) networking

model, 40

Operating system tuning, 615–26

CPU (Oracle perspective), 617–19

CPU utilization, 615–17

disk I/O analysis, 619–26

See also Performance tuning

Optimal Flexible Architecture (OFA), 284–87

defined, 284

illustrated, 285

parameter file, 286

recommendation, 285

Optimizer, 107–8

cost-based (CBO), 107–8, 597

mode evaluation, 452

rule-based (RBO), 107

OPTIMIZER_DYNAMIC_SAMPLING

parameter, 381

OPTIMIZER_INDEX_CACHING parameter, 381, 597–98

OPTIMIZER_INDEX_COST_ADJ parameter, 381, 596

OPTIMIZER_MAX_PERMUTATIONS

parameter, 381

OPTIMIZER_MODE parameter, 381–82

Oracle 9i

bitmap join index, 250

block size specification, 107

cache fusion, 112, 165

Flash Freeze, 669–71

GCS, 127

global enqueue service monitor, 127

GRD, 132

installing, 454

interconnect size limitation, 638

LCK process, 128

lock remastering, 142

MONITORING clause, 108

multithreaded server (MTS) option, 67

RAC Guard feature, 142

resumable space allocation, 198

SGA dynamic management, 75

SQL work area size, 66

subpartitions, 266

transaction naming, 174

undo management, 8, 151

undo tablespace, 101

watchdog daemon process, 687

write/write behavior, 190–93

Oracle 10g

archive log-naming format, 467

BIGFILE tablespace, 96

CFS, 331

flashback queries, 507

RBO, 108

rollback segment method, 154

Shared Servers, 67

sorted hash cluster, 254

Oracle Advanced Replication (OAR), 94, 393, 451

Oracle Clustered File System (OCFS), 681–85

defined, 681

installing, 681–85

interface, 684

latest version, 681–82

operational overhead, 683–84

package files, 682

partition creation, 683

partition mounting, 684–85

starting, 683

Oracle Cluster Management Software

(OCMS), 685

installation, 687–90

node fencing support, 697

starting, 690–97

Oracle Cluster Setup Wizard, 700

Oracle databases

background processes, 82–91

components, 64–91

configuration, 109–10

files, 75–82

instances, 64–75

PGA, 64, 65–67

SGA, 64, 67–68

shared pool, 68–69

Oracle Data Guard (ODG), 233, 393, 451

Oracle Designer

defined, 234

illustrated, 235

Oracle Enterprise Manager (OEM), 81, 466, 534–46

agent configuration, 538–43

architecture, 535

components, 535

configuration prerequisite, 538

configuring, for RAC, 537–46

console tier, 536

defined, 534

disk utilization chart, 631

enhancement, 569

file I/O rate chart, 631

installation, 534, 536–37

installation product selection, 536

installation type selection, 537

intelligent agent, 538

management server configuration, 538

Node Discovery Wizard, 543

performance manager, 543–46

three-tier configuration, 534

troubleshooting opportunities, 535–36

Oracle Net

Configuration Assistant, 304, 305

files, 737–38

load-balancing feature, 423

tracing, 665–67

Oracle Parallel Fail Safe (OPFS), 115

Oracle Parallel Server Management (OPSM), 115

Oracle Parallel Server (OPS), 10, 61

data dictionary changes, 117–18

parameter changes, 116

performance, 113

RAC vs., 114

scalability, 113

terminology changes, 115–16

Oracle RDBMS

operating system support, 6

RMAN, 7

ORACLE_TRACE_ENABLE parameter, 382

Oracle Universal Installer (OUI)

configuration tools screen, 305

custom software selection screen, 303, 304

defined, 298

file location screen, 301

first time run, 300

installation type screen, 302

introduction screen, 299

welcome screen, 300

See also Installation

Oracle wait interface (OWI), 559–68

defined, 560

GV$SESSION_EVENT, 566

GV$SESSION_WAIT, 566

GV$SESSTAT, 566–68

GV$SYSSTAT, 566

GV$SYSTEM_EVENT, 566

system level activity reports, 566

for visibility, 571

ORADEBUG utility, 668–71, 727–29

activity recording, 670

benefits, 668

command help, 668–69

defined, 668

Flash Freeze and, 669–71

invoking, 668

ORA errors, 671–78

ORA-600, 671–73

ORA-1041, 675

ORA-3113, 674–75

ORA-7445, 673–74

ORA-29740, 675–78

---