Index_R

R

RAC (Real Application Clusters) wait events, 66 ‚ 72, 215 ‚ 236

buffer busy global cache, 68

buffer busy global cr, 68

buffer caches, 216 ‚ 217

Cache Fusion, 221 ‚ 222

CR processing, 219

enqueue waits, 231 ‚ 236

global buffer cache, 217 ‚ 223

global cache busy, 69, 228 ‚ 229

global cache cr request, 66 ‚ 67, 223 ‚ 228

global cache null to s, 70

global cache null to x, 69 ‚ 70

global cache open s, 71

global cache open x, 71

global cache s to x, 70

light work rule, 222 ‚ 223

LMS background process in, 200, 216

lock mastering and resource affinity, 218

network protocols, 225

new buffer cache management, 219 ‚ 220

Oracle Database 10 g enhancements, 230 ‚ 231

Parallel Cache Management, 217 ‚ 219

pings and false pings , 220 ‚ 221

references, 336

row cache lock, 71 ‚ 72

tracking CPU and other statistics, 72 ‚ 74

ratio numbers , cache-hit ratios, 3 ‚ 4

Raw devices, 216

read events

attaching SGA to C program, 327

backward naming of, 55

db file parallel read, 53

db file scattered read, 54 ‚ 55

db file sequential read, 55

direct path read, 56 ‚ 57

log file sequential read, 63

Real Application Clusters. See RAC (Real Application Clusters) wait events

reason codes

causing buffer busy waits, 185 ‚ 186, 188 ‚ 189

table of, 52

records, X$KSUSECST, 324 ‚ 325

Recovery Manager (RMAN), 52

redo buffer allocation retries statistic, 205

redo log dumps, 315 ‚ 316

references

for appendixes, 337

attaching SGA to C program, 328

for chapters in book, 334 ‚ 336

latch miss locations, 149

naming Oracle read events, 55

Statspack as data collector, 81

reports

ADDM, 265 ‚ 267, 270 ‚ 273

AWR, 251

repositories

AWR. See AWR (Automatic Workload Repository)

database logoff trigger and, 82 ‚ 85

root cause analysis of historical, 80

sampling with PL/SQL, 90 ‚ 92

resource mastering, 218

response times

ADDM for individual user , 260

developing focus on, 11 ‚ 13

OWI ‚ s role in database, 8 ‚ 11

retention parameter values, snapshots, 248

RMAN (Recovery Manager), 52

rollback segments

log file sync event caused by, 201

undo segment headers and, 192

X$ views Transaction layer and, 320

root cause analysis

with database logoff trigger, 82 ‚ 86

developing in PL/SQL. See PL/SQL code

overview of, 79 ‚ 80

row cache lock events, 71 ‚ 72

row cache objects latches, 169

ROWID, 166