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

CHAPTER

11

Database Workload Capture and Workload Intelligence

One of the most difficult questions for any Oracle DBA to answer—regardless of their years of experience or levels of certification attained—is exactly how a current production application workload will perform in a new production environment. Answering this question cogently is difficult because the scope of what new means may range from relatively small differences between source and target production environments to changes that are so massive that it will be virtually impossible to forecast performance accurately. For example, it should be relatively easy to predict how application ...