| Tag |
In 1 |
In 2 |
Data |
| 001 | | | vtls000010934 |
| 003 | | | IISER-K |
| 005 | | | 20140514144300.0 |
| 006 | | | m d |
| 007 | | | cr cn||||||||| |
| 008 | | | 090617s2007 maua s 001 0 eng d |
| 020 | | | \a 9781555583453 |
| 020 | | | \a 1555583458 |
| 037 | | | \a 132716:132837 \b Elsevier Science & Technology \n http://www.sciencedirect.com |
| 039 | | 9 | \a 201405141443 \b VLOAD \y 200906171841 \z VLOAD |
| 049 | | | \a TEFA |
| 082 | 0 | 4 | \a 005.75/85 \2 22 |
| 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 xlix, 904 p. : \b ill. ; \c 24 cm. |
| 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 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. |
| 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. |
| 533 | | | \a Electronic reproduction. \b Amsterdam : \c Elsevier Science & Technology, \d 2007. \n Mode of access: World Wide Web. \n System requirements: Web browser. \n Title from title screen (viewed on Aug. 2, 2007). \n Access may be restricted to users at subscribing institutions. |
| 630 | 0 | 0 | \a Oracle (Computer file) |
| 650 | | 0 | \a Relational databases. |
| 655 | | 7 | \a Electronic books. \2 local |
| 700 | 1 | | \a Powell, Gavin. |
| 710 | 2 | | \a ScienceDirect (Online service) |
| 776 | 1 | | \c Original \z 1555583458 \z 9781555583453 \w (DLC) 2007270274 \w (OCoLC)72763046 |
| 856 | 4 | 0 | \3 ScienceDirect \u http://www.sciencedirect.com/science/book/9781555583453 \z An electronic book accessible through the World Wide Web; click for information \y An electronic book accessible through the World Wide Web; click for information \y ScienceDirect |
| 856 | 4 | 2 | \3 Publisher description \u http://www.loc.gov/catdir/enhancements/fy0707/2007270274-d.html \y Publisher description |
|
|
