Index_F


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



Oracle Wait Interface
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
ISBN: 007222729X
EAN: 2147483647
Year: 2004
Pages: 114

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net