, ,

Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability

Specificaties
Paperback, blz. | Engels
McGraw-Hill Education | e druk, 2017
ISBN13: 9781260025965
Rubricering
McGraw-Hill Education e druk, 2017 9781260025965
Verwachte levertijd ongeveer 11 werkdagen

Samenvatting

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Master Oracle Database 12c Release 2 testing and tuning

Seamlessly transition to Oracle Database 12c Release 2 and achieve peak performance using the step-by-step instruction and best practices contained in this Oracle Press guide. Written by a team of Oracle ACEs, Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability clearly explains how to identify, investigate, and resolve performance issues. You will discover how to use troubleshooting tools and test rigs, optimize code and queries, evaluate database performance, perform realistic application testing, capture and replay actual production workloads, and employ Oracle Database In-Memory. 

•Establish benchmarks and evaluate application workload performance 

•Configure and deploy SQL Tuning Advisor and SQL Access Advisor

•Maximize efficiency using Oracle Database In-Memory and In-Memory Advisor

•Identify and repair poorly running code with SQL Monitor

•Uncover database problems using Real-Time ADDM and Emergency Monitoring

•Work with database workload capture and replay

•Analyze third-party code with Workload Intelligence

•Identify database objects that will benefit most from In-Memory Column Store (IMCS)

•Monitor and manage IMCS objects with In-Memory Central

Specificaties

ISBN13:9781260025965
Taal:Engels
Bindwijze:paperback

Inhoudsopgave

<p><B>Part I: Tools and Test Rigs</B><BR><B>Chapter 1:</B> Presenting Tools for Tuning<BR><B>Chapter 2:</B> Testing Methodology<BR><BR><B>Part II: Digging Deeper: SQL Performance Management Tools</B><BR><B>Chapter 3:</B> SQL Tuning Advisor<BR><B>Chapter 4:</B> SQL Access Advisor<BR><B>Chapter 5:</B> SQL Plan Management<BR><BR><B>Part III: It's Running Slow: Database Performance Evaluation</B><BR><B>Chapter 6:</B> SQL Monitor<BR><B>Chapter 7:</B> Real-Time Operations Monitoring<BR><B>Chapter 8:</B> Real-Time ADDM & Emergency Monitoring<BR><B>Chapter 9:</B> ASH Analytics<BR><BR><B>Part IV: Testing to Destruction: Real Application Testing</B><BR><B>Chapter 10:</B> SQL Performance Analyzer<BR><B>Chapter 11:</B> Database Capture and Replay<BR><B>Chapter 12:</B> Database Workload Replay<BR><BR><B>Part V: A Brave New World: Database In-Memory</B><BR><B>Chapter 13:</B> Database In Memory Advisor<BR><B>Chapter 14:</B> In-Memory Central<BR><BR><B>Part VI: Conclusions and Best Practices<BR></B><B>Appendix A:</B> Other Performance Tuning and Testing Tools<BR><B>Appendix B:</B> Code Examples and Listings<BR><B>Appendix C:</B> References</P>

Rubrieken

    Personen

      Trefwoorden

        Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability