Oracle database performance and scalability : a quantitative approach / Henry H. Liu.

Author/creator Liu, Henry H.
Other author Wiley InterScience (Online service)
Format Electronic
Publication InfoHoboken, N.J. : John Wiley, 2011.
Descriptionpages ; cm.
Supplemental ContentAn electronic book accessible through the World Wide Web; click for information
Subjects

Contents Frontmatter -- Introduction -- Getting Started With Oracle. Part Introduction -- Basic Concepts -- Installing Oracle Software -- Options for Accessing an Oracle Server -- A Quick Tour of an Oracle Server -- Oracle Architecture from Performance and Scalability Perspectives. Part Introduction -- Understanding Oracle Architecture -- Oracle 10g Memory Management -- Oracle 11g Memory Management -- Oracle Storage Structure -- Oracle Wait Interface (OWI) -- Oracle Data Consistency and Concurrency -- Anatomy of an Oracle Automatic Workload Repository (AWR) Report -- Oracle Advanced Features and Options -- Top 10 Oracle Performance and Scalability Features -- Oracle-Based Application Performance and Scalability by Design -- Project: Soba₇A Secure Online Banking Application on Oracle -- Optimizing Oracle Performance and Scalability. Part Introduction -- Logistics of the Oracle Cost-Based Optimizer (CBO) -- Oracle SQL Tuning -- Oracle Indexing -- Auto_Tune Features -- Case Studies: Oracle Meeting Real World Performance and Scalability Challenges. Part Introduction -- Case Study: Achieving High Throughput with Array Processing -- Case Study: Performance Comparison of Heap-Organized Versus Index-Organized Tables -- Case Study: SQL Tuning: ₃IN₄ Versus ₃OR₄ Versus Global Temporary Table -- Case Study: Data Access Paths (Double Buffering) -- Case Study: Covering Index -- Case Study: CURSOR_SHARING -- Case Study: Bulk Transactions -- Case Study: Missing Statistics -- Case Study: Misconfigured SAN Storage -- Appendix A: Oracle Product Documentations -- Appendix B: Using SQL*Plus with Oracle -- Appendix C: A Complete List of All Wait Events in Oracle 11g -- Appendix D: A Complete List of All Metrics with the V$STATNAME View -- Appendix E: A Complete List of All Statistics with the V$SYSSTAT View -- Index.
Reproduction noteElectronic reproduction. Hoboken, N.J. : Wiley InterScience, 2011. Mode of access: World Wide Web. System requirements: Web browser. Title from title screen (viewed on Nov. 2, 2011). Access may be restricted to users at subscribing institutions.
Issued in other formPrint version: Liu, Henry H. Oracle database performance and scalability. Hoboken, N.J. : John Wiley, 2011 9781118056998
Genre/formElectronic books.
ISBN9781118135532 (electronic bk.)
ISBN1118135539 (electronic bk.)
Stock number10.1002/9781118135532 Wiley InterScience http://www3.interscience.wiley.com

Availability

Library Location Call Number Status Item Actions
Electronic Resources Access Content Online ✔ Available