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
BEFORE LOGOFF database trigger, 82 ‚ 86
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
buffers, cloning, 132, 219
bugs
OWI, 46 ‚ 47
trace event 10046 as data collector, 81
_BUMP_HIGHWATER_MARK_COUNT parameter, 234