My Oracle Support Banner

Real Application Testing: Database Capture FAQ (Doc ID 1920275.1)

Last updated on OCTOBER 11, 2021

Applies to:

Oracle Database Backup Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Real Application Testing
Database Capture

Purpose

The purpose of this FAQ is to provide answers to commonly asked questions. Many of the answers are based upon real world customer experience.

The first step in using Database Replay is to capture a production workload. Capturing a workload involves recording all requests made by external clients to the Oracle Database.

When workload capture is enabled, all external client requests directed to Oracle Database are tracked and stored on the file system in binary files called capture files. The location where the capture files will be stored can be specified. Once workload capture begins, all external database calls are written to the capture files. The capture files contain all relevant information about the client request, such as SQL text, bind values, and transaction information. Background activities and database scheduler jobs are not captured. The capture files are platform independent and can be transported to another system for replay.

 

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
 How is the Capture feature implemented?
 What is the expected Capture overhead?
 How can I calculated the space required for database capture?
 What is the best duration for a capture?
 What kind of storage is recommended for capture directory?
 Should I do a capture when the IO is slow or database has a performance problem?
 What happens to database capture when capture directory is full in the middle of the capture? Will it impact the application?
 Is ACFS file system supported for database capture?
 Can I capture on ASM File system?
 Do we capture workload from dbms_jobs or scheduler job?
 Can I capture on Data Guard or standby database?
 Do I need to restart the database to start the capture?
 Where are the capture files written to?
 Do database capture any passwords?
 Is database capture RAC aware?
 Is a shared file system required to perform database capture on a RAC system?
 Are idle sessions captured when DBMS_WORKLOAD_CAPTURE.FINISH_CAPTURE is performed?
 What capture side patches are available?
 Does the Capture functionality support XML Types?
References

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