Troubleshooting Oracle Performance
Covers Aracle Database 9iR2 through 11gR1
Gebonden Engels 2009 1e druk 9781590599174Samenvatting
What do you do when your database application isn't running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It's finding a solution that's difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance.
- Written for developers by an application developer who has learned by doing
- Gives a systematic approach to solving database application performance problems
- Helps you plan for performance as you would for any other application requirement
What you'll learn:
- See how to treat and plan for performance as a basic application requirement.
- Identify performance problems using a systematic and repeatable approach.
- Configure your query optimizer to meet your application performance goals.
- Optimize table accesses, joins, and physical table layout.
- Read and recognize inefficient SQL execution plans.
- Reduce inefficiencies from too much procedural code.
Who is this book for?
For application developers and database administrators involved in troubleshooting performance problems of Oracle-based applications
Specificaties
Lezersrecensies
Inhoudsopgave
About the Author
About the Technical Reviewers
Acknowledgments
Introduction
About the OakTable Network
PART 1: Foundations
1. Performance Problems
2. Key Concepts
PART 2: Identification
3. Identifying Performance Problems
PART 3: Query Optimizer
4. System and Object Statistics
5. Configuring the Query Optimizer
6. Execution Plans
7. SQL Tuning Techniques
PART 4: Optimization
8. Parsing
9. Optimizing Data Access
10. Optimizing Joins
11. Beyond Data Access and Join Optimization
12. Optimizing the Physical Design
PART 5: Appendixes
APPENDIX A: Downloadable Files
APPENDIX B: Bibliography
INDEX
Anderen die dit boek kochten, kochten ook
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan