Index_M

M

Manageability Monitor (MMON), 242, 243

Manageability Monitor-Lightweight (MMNL), 242

MAX_DUMP_FILE_SIZE parameter, 30 ‚ 32

MAX_WAIT column, 24, 25 ‚ 26

MAXIORTM columns , 26

MAXIOWTM columns, 26

MBRC (DB_FILE_MULTIBLOCK_READ_COUNT)

diagnosing db file scattered reads, 115

full scan operations requesting fewer blocks than, 118

setting, 118 ‚ 119

mean time to recovery (MTTR), 208 ‚ 209, 211

metric views, 241

MFU (most frequently used) buffer algorithm, 220

microsecond timing, 46 ‚ 47

middle- tier layer, 201

MISSES routine, latch, 145

MMNL (Manageability Monitor-Lightweight), 242

MMON (Manageability Monitor), 242, 243

monitoring/collection methods , 77 ‚ 102

with database logoff trigger, 82 ‚ 86

historical data and, 78 ‚ 79

references for, 335

root cause analysis and, 79 ‚ 80

sampling with PL/SQL. See PL/SQL code

sampling with SGA Direct Access, 101

with Statspack, 81

with trace event 10046, 80 ‚ 81

most frequently used (MFU) buffer algorithm, 220

MTS (multithreaded server), 35

MTTR (mean time to recovery), 208 ‚ 209, 211

multiple actions, setting for single events, 284 ‚ 285

multithreaded server (MTS), 35