rdf-syntax-grammar
mods:
  schema location: http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-2.xsd
  title info:
    title: Oracle performance tuning for 10gR2
  title info:
    title: Referex
  name:
    name part: Powell, Gavin.
    role:
      role term: creator
  name:
    name part: ScienceDirect (Online service)
  type of resource: text
  genre: Electronic books.
  origin info:
    place:
      place term: mau
    date issued: 2007
    edition: 2nd ed.
    issuance: monographic
  language:
    language term: eng
  physical description:
    form: electronic
    form: remote
    extent: xlix, 904 pages : illustrations ; 24 cm.
  abstract: 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.
  table of contents: 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).
  table of contents: 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.
  note: Gavin Powell.
  note: Previous edition published: New York : Digital Press, c2004, under title: Oracle high performance tuning for 9i and 10g.
  note: Includes index.
  note: Electronic resource.
  note: Electronic reproduction. Amsterdam : Elsevier Science & Technology, 2007. Mode of access: World Wide Web. System requirements: Web browser. Title from title screen (viewed on Aug. 2, 2007). Access may be restricted to users at subscribing institutions.
  subject:
    topic: Relational databases
  subject:
    title info:
      title: Oracle (Computer file)
  classification: QA76.9.D3 P686 2007eb
  classification: 005.75/85
  related item:
    title info:
      title: Oracle high performance tuning for 9i and 10g
    name:
      name part: Powell, Gavin.
  related item:
    identifier: (DLC) 2007270274
    identifier: (OCoLC)72763046
  identifier: 9781555583453
  identifier: 1555583458
  identifier: 132716:132837 Elsevier Science & Technology
  identifier: http://proxy.library.tamu.edu/login
  identifier: http://www.loc.gov/catdir/enhancements/fy0707/2007270274-d.html
  related item:
    location:
      url: http://www.loc.gov/catdir/enhancements/fy0707/2007270274-d.html
  record info:
    record content source: OPELS
    record creation date: 070806
    record change date: 20260609193423.3
    record identifier: in00002429689