High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability
"Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues."\ -Aki Ratner, President, Precise Software Solutions Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"— that is, how to fine-tune the Oracle database for its...
Search in google:
"Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues."-Aki Ratner, President, Precise Software SolutionsEnsuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"— that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system—not just the database.High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system.The book provides practical solutions for:* Choosing physical layout for ease of administration and efficient use of space* Managing indexes, including detecting unused indexes and automating rebuilds* SQL and system tuning using the powerful new features in Oracle9i Release 2* Improving SQL performance without modifying code* Running Oracle Real Application Clusters (RAC) for performance and availability* Protecting data using Recover Manager (RMAN), and physical and logical standby databasesThe companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.
http://catalogimages.wiley.com/images/db/pdf/U0471224367.06.pdf
IntroductionPt. 1Fundamentals of an Oracle Configuration1Ch. 1Installing Oracle3Ch. 2Database Creation23Ch. 3Configuring Oracle Networking53Ch. 4Environment Standards and Tools85Ch. 5Securing Your Database105Pt. 2Designing Fast and Supportable Applications135Ch. 6Designing Supportable Applications137Ch. 7Choosing Third-Party Software153Pt. 3Performance Management and Tuning Techniques165Ch. 8End-to-End Performance Management167Ch. 9Fundamentals of SQL Tuning181Ch. 10Collecting and Using Optimizer Statistics241Ch. 11Partitioning259Ch. 12Managing Indexes279Ch. 13Managing Space Growth303Ch. 14Stress Testing and Benchmarks327Ch. 15Server Consolidation and Resource Management343Ch. 16Selecting and Using Performance Management Tools357Pt. 4Backup, Restore, and Recovery381Ch. 17Fundamentals of Oracle Recovery383Ch. 18Backup and Recovery Using Recovery Manager (RMAN)403Ch. 19Backup and Restore Using Export and Import445Pt. 5High Availability (HA) Solutions471Ch. 20VERITAS High Availability (HA) for Oracle473Ch. 21Oracle Replication485Ch. 22Oracle Real Application Clusters505Ch. 23Protecting Data Using Standby Databases525Pt. 6Maintaining the Oracle System561Ch. 24Guidelines for Health Checks and Monitoring563Ch. 25Auditing Techniques599Ch. 26Migration and Upgrade619Ch. 27Working Effectively with Oracle Support629Ch. 28Troubleshooting Oracle DBMS Problems641Index665
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
