Index_T

---

T

TKPROF, 340–49, 723–25

Tools and utilities, 625–46

Enterprise Manager Diagnostics Pack, 625–33 (see also Enterprise Manager Tuning Pack)

event monitoring, 626

latch get/miss rates, 630, 632, 633

lock monitoring, 626, 628

performance manager, 628–30, 632

reorg wizard, 631–34, 635, 636

tablespace map, 631–34

TopSessions, 626–27, 629

TopSQL, 627, 630

Export utility, 639

Recovery Manager (RMAN), 642

Spotlight on Oracle, 634–36, 637, 638, 639

Shared Global Area, 635, 638

SQL*Loader, 639–41

STATSPACK (see STATSPACK)

Unix utilities, 638

Windows Performance Monitor, 636–37, 640

Tools to detect problem queries, 327–64

autotrace, 349–50

EXPLAIN PLAN, 328–35

command syntax, 331–35

operations, 329–30

PLAN_TABLE, 335

producing the best plan, 331

search for problems, 330

what is not provided, 335–36

performance views, 350–64

examining cached query plans, 362–63

examining SQL code, 352–53

finding cached SQL code, 351–52

using V$SQL, 359–62

using V$SQLAREA, 354–59

SQL Trace, 336–40

finding trace files, 338

session level tracing, 338

setting up, 337–38

using, 339–40

TKPROF, 340–49, 723–25

interpretation of output, 342–49

interpretation script, 724–25

perl wrapper script, 723–24

syntax, 340–41

using, 341–42

TRCSESS, 349

Tuning the data model, xii–xiii, 1–88 see also Denormalization; Normalization; Referential integrity; SQL

from development to production, 11–17

configuration tuning, 16–17

data model tuning, 12–14

physical tuning, 17

query plan from EXPLAIN PLAN, 16

SQL code tuning, 14–16

steps in tuning, 11–12

using static generic entities, 14, 45–46

environment, 1–11

bottlenecks, 7

configuration, 7

data model tuning, 9–11

duplicating production databases, 3–4

personnel, 2

physical space usage, 7–8

SQL code tuning, 8–9

staging and testing, 2–3

tools, 2

what is required, 1

what to tune in production, 5–6

when to stop tuning in production, 6–7

when to tune, 4–5

optimizing with alternate indexes, 59–61

relational database model, 43–80

tuning pack (see Enterprise Manager Tuning Pack)

---