F
FAIRNESS_DOWN_CONVERTS, 221 ‚ 222
_FAIRNESS_THRESHOLD parameter, 221, 223
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
file headers dumps, 308 ‚ 309
file# parameter
buffer busy waits, 184
free buffer waits, 206
write complete waits, 210
FILESYSTEMIO_OPTIONS, 134
flush_level parameter, 249
FORCE LOGGING mode, 136, 206
foreground events, 42 ‚ 43
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