| < Day Day Up > |
|
Hardware resource usage tuning, 489–526
CPU usage, 489–99
high network activity, 498–99
poor index usage, 492
poorly tuned SQL code, 491–92
rollback and undo, 493–96
row locks and latch waits, 497–98
swapping and paging, 490–91
temporary sort space, 497
I/O usage, 520–26
efficiency and recoverability, 520–23
RAID arrays, 524–25
memory usage, 499–519
advice on buffers, 515–20
automated memory management, 511
database buffer cache, 502–3, 515–18
Java pool, 514, 520
large pool, 512–13
library cache, 504–7
manual memory management, 511–12
metadata or dictionary cache, 508–9
pinning objects in the shared pool, 509
redo log buffer, 513–14
session connection cache, 509–10
shared pool, 503–4, 518–20
shared servers and virtual circuits, 513
system global area, 499–501
Hardware upgrades, xv
History of data modelling, 89–96
evolution, 90, 94
Oracle database, 94–96
roots of SQL, 96
types of models, 90–93
hierarchical, 90–91
network, 90–91
object, 92–93
object-relational, 92–93
relational, 90–92
| < Day Day Up > |
|