Oracle performance tuning for 10gR2
Title:
Oracle performance tuning for 10gR2
Author:
Powell, Gavin.
ISBN:
9780080492025
Personal Author:
Edition:
2nd ed.
Publication Information:
Burlington, MA : Digital Press, c2007.
Physical Description:
1 online resource (xlix, 904 p.) : ill.
General Note:
Previous ed. published: New York : Digital Press, c2004, under title: Oracle high performance tuning for 9i and 10g.
Includes index.
Contents:
pt. 1. Data model turning -- The relational database model -- Turning the relational database model -- Different forms of the relational database model -- A brief history of data modeling -- pt. 2 SQL code tuning -- What is SQL? -- The basics of efficient SQL -- Advanced concepts of efficient SQL -- Common-sense indexing -- Oracle SQL optimization and statistics -- How Oracle SQL optimization works -- Overriding optimizer behavior using hints -- How to find problem queries -- 10g automated SQL tuning -- pt. 3. Physical and configuration tuning -- Tuning Oracle database file structures -- Object tuning -- Low-level physical tuning -- Hardware resource usage tuning -- Tuning network usage -- Oracle partitioning and parallelism -- pt. 4. Tuning everything at once -- Ratios: possible symptoms of problems -- Wait events -- Latches -- Tools and utilities -- The wait event interface -- 9i tuning with STATSPACK.
Title Subject:
Genre:
Electronic Access:
EBSCOhost http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=195157