finelybook
Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability
by 作者: Jim Czuprynski - Deiby Gomez - Bert Scalzo
ISBN-10 书号: 1260025969
ISBN-13 书号: 9781260025965
Edition 版本: 1
Publisher Finelybook 出版日期: 2017-10-05
Pages: 432
Book Description
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
Contents
PART I Tools and Test Rigs
Chapter 1 Presenting Tools for Tuning
Chapter 2 Testing Methodology
PART II Digging Deeper: SQL Performance Management Tools
Chapter 3 SQL Tuning Sets and Tuning Advisor
Chapter 4 SQL Access Advisor
Chapter 5 SQL Plan Management
PART III It’s Running Slow: Database Performance Evaluation
Chapter 6 SQL Monitor
Chapter 7 Real-Time Operations Monitoring
Chapter 8 Real-Time ADDM and Emergency Monitoring
Chapter 9 ASH Analytics
PART IV Testing to Destruction: Real Application Testing
Chapter 10 SQL Performance Analyzer
Chapter 11 Database Workload Capture and Workload Intelligence
Chapter 12 Database Workload Replay
PART V A Brave New World: Database In-Memory
Chapter 13 Database In-Memory Advisor
Chapter 14 In-Memory Central
PART VI Appendixes
Appendix A Other Performance Tuning and Testing Tools
Appendix B Code Examples and Listings
Appendix C References
