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

F

FAIRNESS_DOWN_CONVERTS, 221 ‚ 222

_FAIRNESS_THRESHOLD parameter, 221, 223

false pings , 220 ‚ 221

FAST_START_IO_TARGET parameter, 212

FAST_START_MTTR_TARGET parameter

free buffer waits and, 208 ‚ 209

log file switch completion and, 212

reducing PI buffers in buffer cache, 228

write complete waits and, 211

fastpath AIO, 133

file headers dumps, 308 ‚ 309

file# parameter

buffer busy waits, 184

free buffer waits, 206

write complete waits, 210

FILESYSTEMIO_OPTIONS, 134

fixup events, 230 ‚ 231

flush_level parameter, 249

FORCE LOGGING mode, 136, 206

foreground events, 42 ‚ 43

foreign keys, 183 ‚ 184

forever keyword, 277, 283

free buffer inspected statistic, 206 ‚ 207

free buffer requested statistic, 206 ‚ 207

free buffer waits event, 206 ‚ 210

causes of, 206 ‚ 207

delayed block cleanouts causing , 209 ‚ 210

diagnosing db file parallel writes , 131

inefficient SQL statements causing, 207

insufficient DBWR processes causing, 207 ‚ 209

monitoring, 99

overview of, 59, 206

slow I/O subsystem causing, 209

small buffer cache causing, 210

FREELIST GROUPS

causing buffer busy waits, 189

database logoff trigger method, 82

segment header contention , 190

FREELISTS

causing buffer busy waits, 189

database logoff trigger method, 82

segment header contention, 190

frequency, PL/SQL sampling, 88 ‚ 90