Troubleshooting Oracle Performance
Troubleshooting Oracle Performance, 2nd Edition is your systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. Christian Antognini brings a decade and a half experience to his topic. His first edition is one of the m...
| Main Author: | |
|---|---|
| Corporate Author: | |
| Format: | eBook |
| Language: | Inglés |
| Published: |
Berkeley, CA :
Apress
2014.
|
| Edition: | 2nd ed. 2014. |
| Series: | Expert's voice in Oracle.
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629540006719 |
Table of Contents:
- ""Contents at a Glance""; ""About IOUG Press""; ""Contents""; ""Foreword by Jonathan Lewis""; ""Foreword by Cary Millsap""; ""Foreword from the First Edition""; ""About the Author""; ""About the Technical Reviewers""; ""Acknowledgments""; ""Acknowledgments from the First Edition""; ""Introduction""; ""Part I: Foundations""; ""Chapter 1: Performance Problems""; ""Do You Need to Plan Performance?""; ""Requirements Analysis""; ""Analysis and Design""; ""Coding and Unit Testing""; ""Integration and Acceptance Testing""; ""Designing for Performance""; ""Lack of Logical Database Design""
- ""Implementing Generic Tables""""Not Using Constraints to Enforce Data Integrity""; ""Lack of Physical Database Design""; ""Not Choosing the Right Data Type""; ""Not Using Bind Variables Correctly""; ""Not Using Advanced Database Features""; ""Not Using PL/SQL for Data-Centric Processing""; ""Performing Unnecessary Commits""; ""Steadily Opening and Closing Database Connections""; ""Do You Have Performance Problems?""; ""System Monitoring""; ""Response-Time Monitoring""; ""Compulsive Tuning Disorder""; ""How Do You Approach Performance Problems?""
- ""Business Perspective vs. System Perspective""""Cataloging the Problems""; ""Working the Problems""; ""On to Chapter 2""; ""Chapter 2: Key Concepts""; ""Selectivity and Cardinality""; ""What Is a Cursor?""; ""Life Cycle of a Cursor""; ""How Parsing Works""; ""Shareable Cursors""; ""Bind Variables""; ""Advantage""; ""Disadvantage""; ""Best Practices""; ""Reading and Writing Blocks""; ""Instrumentation""; ""Application Code""; ""Database Calls""; ""PL/SQL""; ""OCI""; ""JDBC""; ""The Legacy Way""; ""The Contemporary Way""; ""ODP.NET""; ""PHP""; ""On to Part 2""; ""Part II : Identification""
- ""Chapter 3: Analysis of Reproducible Problems""""Tracing Database Calls""; ""SQL Trace""; ""Enabling SQL Trace with ALTER SESSION""; ""Enabling SQL Trace with DBMS_MONITOR""; ""Session Level""; ""Client Level""; ""Component Level""; ""Database Level""; ""Enabling SQL Trace with DBMS_SESSION""; ""Triggering SQL Trace""; ""Timing Information in Trace Files""; ""Limiting the Size of Trace Files""; ""Finding Trace Files""; ""Structure of the Trace Files""; ""Using TRCSESS""; ""Profilers""; ""Using TKPROF""; ""TKPROF Arguments""; ""Interpreting TKPROF Output""; ""Using TVDXTAT""
- ""Why Is TKPROF Not Enough?""""Installation""; ""TVDXTAT Arguments""; ""Interpreting TVDXTAT Output""; ""Profiling PL/SQL Code""; ""Using DBMS_HPROF""; ""Installing the Output Tables""; ""Gathering the Profiling Data""; ""Manually Reporting the Profiling Data""; ""Using PLSHPROF""; ""Using a GUI""; ""Using DBMS_PROFILER""; ""Installing the Output Tables""; ""Gathering the Profiling Data""; ""Manually Reporting the Profiling Data""; ""Using a GUI""; ""Triggering the Profilers""; ""On to Chapter 4""; ""Chapter 4: Real-Time Analysis of Irreproducible Problems""; ""Analysis Roadmap""
- ""Dynamic Performance Views""
