Oracle High Performance Tuning for 9i and 10g

F

File structure layers, 427–52

file system layer, 430–37

control files, 434

tuning datafiles, 432–34

tuning redo logs and archive logs, 434–37

types of files, 431–32

logical layer, 438–52

auto extend, 442

automatic undo, 449–50

avoiding datafile header contention, 446

BIGFILE tablespaces, 445–46

block size, 442–43

dictionary managed tablespaces, 439–41

extent management, 443–44

locally managed tablespaces, 441–42

logging, 443

manual rollback, 450–52

segment space management, 444–45

temporary sort space, 446–49

networking layer, 437

Oracle Instance, 427–30

memory cache buffers, 428

processes, 428–30