Index_L

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