책 이미지
책 정보
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9781555583453
· 쪽수 : 960쪽
목차
Part I. Data Model Tuning; The Relational Database Model; Tuning the Relational Database Model; A Brief History of Data Modeling;
Part II. SQL Code Tuning; Concepts of Efficient SQL; Common Sense Indexing; Oracle SQL Optimization and Statistics; How Oracle SQL Optimization Works;
How to Find Problem Queries; Automated SQL Tuning;
Part III. Physical and Configuration Tuning; Installing Oracle and Creating a Database; Tuning Oracle Database File Structures;
Low Level Physical Tuning; Hardware Resource Usage Tuning; Tuning Network Usage; Oracle Partitioning and Parallelism; Ratios: Possible Symptoms of Problems; Tools and Utilities; Part IV. Tuning Everything at Once; The Wait Event Interface; The Database Control; Tuning With STATSPACK; Appendices
Appendix A. Sample Databases
Appendix B. Sample Scripts (script changes)
Appendix C. Sources of Information (accreditations)Appendix D. SQL Tuning in Oracle Enterprise Manager
(might delete this one, depending on how much I remove from part III, which is 9i)