Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

B

background events, 42 ‚ 43

background writes , LGWR, 198

BACKGROUND_DUMP_DEST parameter, 30, 35

base address, SGA, 323 ‚ 324

baseline snapshots, 244 ‚ 247

baseline_name parameter, 250 ‚ 251

batch process, log file sync events, 201

BCHR (buffer cache hit ratio), 4, 6

BD_BLOCK_SIZE, 119

BEFORE LOGOFF database trigger, 82 ‚ 86

binaries, Oracle, 226

bitmap index entries, 181 ‚ 182

block class# parameter, 184

Block Server Process (BSP), 221

block# parameter

buffer busy waits events, 184

free buffer waits events, 206

write complete waits events, 210

blocks

as buffers, 216 ‚ 217

delayed cleanouts, 209 ‚ 210

hot, 163 ‚ 166

bottlenecks. See wait events

BSP (Block Server Process), 221

buffer busy global cache events, 68

buffer busy global cr events, 68

buffer busy waits wait events

causes of, 185 ‚ 188

data block contention with reason code 130, 188 ‚ 189

data block contention with reason code 220, 189

data segment headers contention, 189 ‚ 191

interpreting, 184 ‚ 185

monitoring, 98 ‚ 99

overview of, 50 ‚ 51

in Real Application Clusters environment, 228 ‚ 229

system-level diagnosis of, 192 ‚ 194

undo blocks contention, 192

undo segment headers contention, 191 ‚ 192

buffer cache

in free buffer waits events, 210

global, 217 ‚ 223

in RAC environment, 216 ‚ 217

buffer cache hit ratio (BCHR), 4, 6

buffer dumps, 307 ‚ 308

buffer pins, 185

buffer# parameter, 198

buffers dump, 305 ‚ 306

buffers, cloning, 132, 219

bugs

OWI, 46 ‚ 47

trace event 10046 as data collector, 81

_BUMP_HIGHWATER_MARK_COUNT parameter, 234