Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
L
LAST_DDL_TIME column, 115
latch address parameter, 142
latch free wait events, 142 ‚ 169
cache buffers chains latches, 159 ‚ 167
cache buffers lru chains latches, 167 ‚ 169
common causes, diagnosis and actions, 150 ‚ 151
defining latches, 142 ‚ 143
information in, 148 ‚ 149
latch acquisition, 145 ‚ 146
latch classification, 146 ‚ 148
latch miss locations, 149
latch types, 144
latches in Oracle Database 10 g , 149 ‚ 150
list of, 60
locks vs. latches, 143 ‚ 144
monitoring, 95
overview of, 59 ‚ 60, 142
row cache objects latches, 169
shared pool and library cache latches, 151 ‚ 159
latch number parameter, 142
latch wait posting, 146
latches
acquisition, 145 ‚ 146
classification of, 146 ‚ 148
defining, 142 ‚ 143
miss locations, 149
short- and long-wait, 146
types of, 144
wait events for common, 29
latency- related wait events, 197 ‚ 214
free buffer waits, 206 ‚ 210
log buffer space, 204 ‚ 206
log file switch, 212 ‚ 213
log file sync, 198 ‚ 204
references for, 336
write complete waits, 210 ‚ 212
level keyword, 279, 283 ‚ 284
levels
controlling buffers dump, 306
controlling control file dumps, 310
controlling file headers dumps, 308 ‚ 309
controlling heap dumps, 311 ‚ 312
controlling library cache dumps, 312 ‚ 313
controlling shared server state dumps, 314
LGWR process
control file parallel writes and, 138
discovering wait time, 202
log buffer size and, 203 ‚ 204
log file parallel write events belonging to, 135 ‚ 138
performing background writes, 198 ‚ 199
library cache
dumps, 312 ‚ 313
lock events, 61 ‚ 62
pin events, 60 ‚ 61, 100
serializing cursor binding in, 232
library cache latches
defining, 58
high version count contention , 158 ‚ 159
overview of, 152 ‚ 153
parsing contention, 153 ‚ 156
light work rule, 222 ‚ 223
line continuation character (\), 279
Linux operating system, 225
_LM_DYNAMIC_REMASTERING parameter, 218
LMS (Lock Manager Service) background process
buffer cache in RAC environment, 216
global cache wait events and, 226 ‚ 227
log file sync wait events and, 200
LOBs, 128
Lock Manager Service. See LMS (Lock Manager Service) background process
locks
enqueue, 171 ‚ 174, 176
latches vs., 143 ‚ 144
lock mastering operations, 218
PCM, 217
pings and false pings , 220 ‚ 221
locks-related wait events, 141 ‚ 196
buffer busy waits. See buffer busy waits wait events
enqueue waits. See enqueue wait events
latch free waits. See latch free wait events
references for, 335
log buffer size, 203 ‚ 204, 205
log buffer space wait event
causes of, 204 ‚ 205
log file switch completion event and, 212
overview of, 62
slow I/O subsystem causing , 205 ‚ 206
undersized log buffer causing, 205
log file parallel write events
diagnosis and actions, 135 ‚ 138
improving average wait time in, 202
overview of, 62 ‚ 63
log file sequential read wait event, 63
log file switch (archiving needed) wait event, 63
log file switch (checkpoint incomplete) wait event, 212 ‚ 213
log file switch completion wait event, 64, 211 ‚ 212
log file sync wait event, 198 ‚ 204
causes of, 198 ‚ 200
high commit frequency causing, 201 ‚ 202
oversized log buffer causing, 203 ‚ 204
overview of, 64 ‚ 65
slow I/O subsystem causing, 202 ‚ 203
slow LGWR process magnifying, 135
Log Miner, 201
LOG_CHECKPOINT_INTERVAL parameter, 212
LOG_CHECKPOINT_TIMEOUT parameter, 212
LOG_IO_SIZE parameter, 137
_LOG_IO_SIZE parameter, 203 ‚ 204
logging, physiological, 198
LOGOFF trigger, 9
LOGON_TIME, 113
long-wait latches, 146
low_snap_id parameter, 249
LRU lists, 167 ‚ 169, 206 ‚ 208
LRU/MRU (least recently used/most recently used) buffer algorithm, 219
LRUW lists, 167 ‚ 169