Oracle performance tuning for 10gR2
Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improve...
| Κύριος συγγραφέας: | Powell, Gavin. |
|---|---|
| Μορφή: | Ηλεκτρονική πηγή |
| Γλώσσα: | English |
| Στοιχεία έκδοσης: |
Burlington, MA :
Digital Press,
c2007.
|
| Έκδοση: | 2nd ed. |
| Θέματα: | |
| Διαθέσιμο Online: |
http://www.sciencedirect.com/science/book/9781555583453 |
| Ετικέτες: |
Προσθήκη ετικέτας
Δεν υπάρχουν, Καταχωρήστε ετικέτα πρώτοι!
|
| LEADER | 05233nam a2200373 a 4500 | ||
|---|---|---|---|
| 001 | 1/45134 | ||
| 008 | 140709s2007 us 001 0 eng | ||
| 020 | |a 9781555583453 | ||
| 020 | |a 1555583458 | ||
| 020 | |a 9780080492025 (electronic bk.) | ||
| 020 | |a 0080492029 (electronic bk.) | ||
| 035 | |l 48092 | ||
| 040 | |a OPELS |b eng |c OPELS |d OCLCQ |d OCLCO |d OCLCQ |d N$T |d YDXCP |d IDEBK |d DKDLA |d ZCU |d E7B |d UMI |d OCLCO |d DEBSZ |d OCLCQ |d GR-PeUP | ||
| 100 | 1 | |a Powell, Gavin. | |
| 245 | 1 | 0 | |a Oracle performance tuning for 10gR2 |h [electronic resource] / |c Gavin Powell. |
| 250 | |a 2nd ed. | ||
| 260 | |a Burlington, MA : |b Digital Press, |c c2007. | ||
| 300 | |a 1 online resource (xlix, 904 p.) : |b ill. | ||
| 520 | |a Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase. Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results. * Fully updated for version 10gR2 and provides all necessary transition material from version 9i * Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning * Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective. | ||
| 505 | 0 | |a Preface -- Introduction -- Part I. Data Model Tuning -- Chapter 1. The Relational Database Model -- Chapter 2. Tuning the Relational Database Model -- Chapter 3. Different Forms of the Relational Database Model -- Chapter 4. A Brief History of Data Modeling -- Part II. SQL Code Tuning -- Chapter 5. What is SQL? -- Chapter 6. Basic Concepts of Efficient SQL -- Chapter 7. Advanced Concepts of Efficient SQL -- Chapter 8. Common Sense Indexing -- Chapter 9. Oracle SQL Optimization and Statistics -- Chapter 10. How Oracle SQL Optimization Works -- Chapter 11. Overriding Optimizer Behavior Using Hints -- Chapter 12. How to Find Problem Queries -- Chapter 13. Automated SQL Tuning -- Part III. Physical and Configuration Tuning -- Chapter 14. Installing Oracle and Creating a Database -- Chapter 15. Tuning Oracle Database File Structures -- Chapter 16. Object Tuning -- Chapter 17. Low Level Physical Tuning -- Chapter 18. Hardware Resource Usage Tuning -- Chapter 19. Tuning Network Usage -- Chapter 20. Oracle Partitioning and Parallelism -- Chapter 21. Ratios: Possible Symptoms of Problems -- Chapter 22. Wait Events -- Chapter 23. Latches -- Chapter 24. Tools and Utilities -- Part IV. Tuning Everything at Once -- Chapter 25. The Wait Event Interface -- Chapter 26. The Database Control -- Chapter 27. 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). | |
| 500 | |a Previous ed. published: New York : Digital Press, c2004, under title: Oracle high performance tuning for 9i and 10g. | ||
| 500 | |a Includes index. | ||
| 505 | 0 | |a 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. | |
| 506 | |a License restrictions may limit access. | ||
| 650 | 4 | |a Relational databases. | |
| 630 | 0 | 0 | |a Oracle (Computer file) |
| 655 | 4 | |a Electronic books. | |
| 700 | 1 | |a Powell, Gavin. |t Oracle high performance tuning for 9i and 10g. | |
| 852 | |a INST |b UNIPILB |c EBOOKS |e 20140729 |p 00b48092 |q 00b48092 |t ONLINE |y 0 | ||
| 856 | 4 | 0 | |3 ScienceDirect |u http://www.sciencedirect.com/science/book/9781555583453 |
| 856 | 4 | |d /webopac/covers/03/48092_9781555583453.jpg | |
| 856 | 4 | |d /webopac/covers/03/48092_1555583458.jpg | |
| 856 | 4 | |d /webopac/covers/03/48092_9780080492025.jpg |z (electronic bk.) | |
| 856 | 4 | |d /webopac/covers/03/48092_0080492029.jpg |z (electronic bk.) | |