Cargando…
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Burlington, MA :
Digital Press,
�2007.
|
| Edición: | 2nd ed. |
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | SCIDIR_ocn162595444 | ||
| 003 | OCoLC | ||
| 005 | 20231117015024.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 070806s2007 maua o 001 0 eng d | ||
| 040 | |a OPELS |b eng |e pn |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 AU@ |d OCLCF |d OCLCQ |d COO |d OCLCQ |d AZK |d JBG |d LOA |d AGLDB |d MOR |d PIFAG |d OCLCQ |d OCLCO |d U3W |d COCUF |d STF |d WRM |d D6H |d OCLCQ |d VTS |d CEF |d INT |d VT2 |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d WYU |d TKN |d LEAUB |d HS0 |d OCLCQ |d OCLCO |d M8D |d OCLCQ |d OCLCO | ||
| 019 | |a 156908201 |a 488133436 |a 507420514 |a 648305378 |a 824973195 |a 856952088 |a 874199491 |a 961596480 |a 962701020 |a 966182207 |a 988534507 |a 991999681 |a 1037790324 |a 1038626824 |a 1055383956 |a 1063815362 |a 1109248195 | ||
| 020 | |a 9781555583453 | ||
| 020 | |a 1555583458 | ||
| 020 | |a 9780080492025 |q (electronic bk.) | ||
| 020 | |a 0080492029 |q (electronic bk.) | ||
| 020 | |a 1281007161 | ||
| 020 | |a 9781281007162 | ||
| 020 | |a 9786611007164 | ||
| 020 | |a 6611007164 | ||
| 035 | |a (OCoLC)162595444 |z (OCoLC)156908201 |z (OCoLC)488133436 |z (OCoLC)507420514 |z (OCoLC)648305378 |z (OCoLC)824973195 |z (OCoLC)856952088 |z (OCoLC)874199491 |z (OCoLC)961596480 |z (OCoLC)962701020 |z (OCoLC)966182207 |z (OCoLC)988534507 |z (OCoLC)991999681 |z (OCoLC)1037790324 |z (OCoLC)1038626824 |z (OCoLC)1055383956 |z (OCoLC)1063815362 |z (OCoLC)1109248195 | ||
| 050 | 4 | |a QA76.9.D3 |b P686 2007eb | |
| 072 | 7 | |a COM |x 018000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.75/85 |2 22 |
| 100 | 1 | |a Powell, Gavin. | |
| 245 | 1 | 0 | |a Oracle performance tuning for 10gR2 / |c Gavin Powell. |
| 250 | |a 2nd ed. | ||
| 260 | |a Burlington, MA : |b Digital Press, |c �2007. | ||
| 300 | |a 1 online resource (xlix, 904 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 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). | |
| 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. | |
| 588 | 0 | |a Print version record. | |
| 546 | |a English. | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |
| 650 | 0 | |a Relational databases. | |
| 650 | 6 | |a Bases de donn�ees relationnelles. |0 (CaQQLa)201-0158069 | |
| 650 | 7 | |a COMPUTERS |x Data Processing. |2 bisacsh | |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 blmlsh |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |0 (OCoLC)fst01363816 |
| 650 | 7 | |a Relational databases |2 fast |0 (OCoLC)fst01093575 | |
| 700 | 1 | |a Powell, Gavin. |t Oracle high performance tuning for 9i and 10g. | |
| 776 | 0 | 8 | |i Print version: |a Powell, Gavin. |t Oracle performance tuning for 10gR2. |b 2nd ed. |d Burlington, MA : Digital Press, �2007 |z 1555583458 |z 9781555583453 |w (DLC) 2007270274 |w (OCoLC)72763046 |
| 856 | 4 | 0 | |u https://sciencedirect.uam.elogim.com/science/book/9781555583453 |z Texto completo |