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 Info | Hoboken, N.J. : John Wiley, 2011. |
| Description | pages ; cm. |
| Supplemental Content | An 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 note | Electronic 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 form | Print version: Liu, Henry H. Oracle database performance and scalability. Hoboken, N.J. : John Wiley, 2011 9781118056998 |
| Genre/form | Electronic books. |
| ISBN | 9781118135532 (electronic bk.) |
| ISBN | 1118135539 (electronic bk.) |
| Stock number | 10.1002/9781118135532 Wiley InterScience http://www3.interscience.wiley.com |
Availability
| Library | Location | Call Number | Status | Item Actions |
|---|---|---|---|---|
| Electronic Resources | Access Content Online | ✔ Available |