My Oracle Support Banner

FAQ: Database Upgrade Using Real Application Testing (Doc ID 1600574.1)

Last updated on OCTOBER 30, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document addresses a number of Frequently Asked Questions related to Database Upgrades using Real Application Testing.

These Questions and Answers were generated from the Q&A Session for the "Foolproof Your Database Upgrade using Real Application Testing" Webcast. The recording for this webcast can be accessed in the following document:

<Document 1597373.1> Archive of Database Performance Related Webcasts

You can discuss this article as well as addressing any further questions in the Database Performance Community in this thread.

 

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 General Questions about SQL Performance Analyzer (SPA) and Database Replay (DB Replay)
 What is the difference between SPA and DB replay?
 When using both SPA and DB Replay together, what is the recommended order in which to use them?
 Can SPA/DB Replay be used when migrating from non-RAC to RAC or vice versa?
 Should a Test Database be an exact replica of the Production?
 SQL Performance Analyzer (SPA)
 How can I use SPA to deal with SQL that is already slow? 
 Does SPA make any changes to the database? For example, my STS may contain inserts and updates. Do these change the data?
 Can you suggest a good article for SPA implementation?
 Database Workload Capture and Replay
 Does the database need to be restarted before a workload capture tables place?
 How can I estimate the likely disk space requirements for capture?
 What overhead is likely from using workload capture?
 Can I capture workload from 2 different databases and replay it together?
 When Replay is taking place, are client connections replicated the same as they were applied in real time?
 How many clients are required for the replay?
 Can I use fewer clients than what the Workload Replay Calibrate function suggests?
 Can I use Database Replay with a Data Guard ?
 Can Database Replay test impact of middle tier changes?
 Can I Replay on an application server rather than a database server ?
 Can I Replay on a different platform to the capture platform ?
 Do the database initialisation parameters of the source and target database need to be the  same for Database Replay?
 How do I make a second replay consistent with the first if the database has moved forward in time?
 If my test system is not as powerful as my production system, how can I compare executions?
 Can I generate a SQL profile based upon the replay on the Test Database?
 Can you test character set changes with DB replay?
 How can I perform load testing using Database Replay?
 Real Application Testing (RAT) Licensing
 Is SPA/DB Replay/RAT part of the Enterprise Edition License?
 Enterprise Manager Support for RAT
 Are RAT features available in OEM 11g and 12c Cloud Control?
 The RAT Run AWR Compare Period Report button is not currently available in EM 12c, however this is available in 11g. Will this functionality be available in 12c?
 Performance
 Does capturing a workload affect the Performance of the database as a whole? Is it ok to do this at peak times on a production database. ?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.