| < Day Day Up > |
|
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)
| < Day Day Up > |
|