Index_H

 < Day Day Up > 



H

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 > 



Oracle High Performance Tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
Year: 2003
Pages: 164

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