My Oracle Support Banner

Database Testing: Best Practices (Doc ID 1535885.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Purpose

 Provides a list of Best Practices for Database Testing (formerly Real Application Testing (RAT))

Details

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
Details
 Apply Latest RAT Patches
 Avoid workload interference
 Filter out background monitoring activity
 Ensure there are no ongoing transactions during capture
 Understand application workload profile details and limitations
 Capture Workload and STS concurrently
 Fix issues identified by SPA prior to Database Replay
 Setup restore points to ensure a consistent replay start point
 Use Workload Analyzer prior to Replay
 Check basic replay works prior to full replay
 As far as possible, replicate production hardware and O/S in Test
 Replicate Production Schema(s) in Test
 Perform Workload Replay Analysis before performance analysis
 Use custom validation scripts to assess replay quality
 Review replay diagnostic steps
 Export AWR data for comparison
 Troubleshooting Guides
References

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