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

T

tables

analyzing low ESTIMATE value, 110

analyzing with COMPUTE option, 116

db file sequential reads against, 117

scan operations, 116 ‚ 118

sequential reads against, 110

TCH (touch count) values, 164 ‚ 165

time model statistics, 238 ‚ 240

TIME_WAITED

db file parallel writes , 131, 133

db file scattered reads, 116

db file sequential reads, 104, 105, 110 ‚ 112

defined, 20 ‚ 21

latch contentions, 151

log file parallel writes, 135 ‚ 138

working with, 21 ‚ 23

TIME_WAITED_MICRO, 20 ‚ 21, 46 ‚ 47

TIMED_STATISTICS initialization parameter

setting to TRUE, 17

tracing own session, 31

tracing someone else ‚ s session, 32

timing, OWI and, 46 ‚ 47

tkprof (Transient Kernel Profiler), 4, 18

TM enqueue wait, 183 ‚ 184

TOTAL_TIMEOUTS, V$SYSTEM_EVENT view, 20 ‚ 21

TOTAL_WAITS, V$SYSTEM_EVENT view

defined, 20 ‚ 21

latch free wait events, 148 ‚ 149

working with, 21 ‚ 23

trace event 10046, 30 ‚ 36

analyzing trace files, 35 ‚ 36

database logoff trigger vs., 86

diagnosing direct path writes, 129 ‚ 130

discovering direct read I/O with, 127

finding trace files, 35

overview of, 30

setting, 279

tracing own session, 31 ‚ 32

tracing someone else ‚ s session, 32 ‚ 35

as unsuitable data collector, 80 ‚ 81

working with, 30 ‚ 31

trace event 10053, 279

trace event 10357, 127, 129 ‚ 130

trace files, 201, 304

trace keyword, 283

TRACE supported parameters, 284

TRACEFILE_IDENTIFIER parameter, 35

traces. See dumps and traces

transactions

commit frequency, 201 ‚ 202

TX enqueue used during, 235 ‚ 236

Transient Kernel Profiler (tkprof), 4, 18

TX enqueue

overview of, 235 ‚ 236

wait in mode 4 ‚ bitmap index entry, 181 ‚ 182

wait in mode 4 ‚ ITL, 179 ‚ 181

wait in mode 4 ‚ unique key enforcement, 181

wait in mode 6, 177 ‚ 179