Workload capture generates a number of binary files—called capture files—that contain relevant information about the captured workload. The information stored in the capture files enables workload replay to realistically reproduce the captured workload at a later time. For each client request that is recorded by workload capture, the captured information includes SQL text, bind values, transaction information, timing data, identifiers of accessed objects, and other information about the request.
Workload Intelligence enables you to use the information stored in capture files in additional ways, including the following:
Analyze and model the workload
Discover significant patterns and trends within the workload
Visualize what was running on the production system during workload capture
This section describes Workload Intelligence and contains the following topics:
"Workload Capture" for information about workload capture
"Workload Replay" for information about workload replay