This book focuses on tuning of Oracle data warehouse databases
. My
previous tuning book,
Oracle High Performance Tuning
for 9
i
and 10
g
(ISBN: 1555583059) focused on tuning of OLTP databases. OLTP data-
bases require fine-tuning of small transactions for very high concurrency
both in reading and changing of an OLTP database.
Tuning a data warehouse database is somewhat different to tuning of
OLTP databases. Why? A data warehouse database concentrates on large
transactions and mostly requires what is termed throughput. What is
throughput? Throughput is the term applied to the passing of large
amounts of information through a server
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.