OCP-1Z0-053-V13.02-516题_oracle 053 516-CSDN博客

在使用数据库重放技术时，首先捕获生产工作负载至关重要。此过程涉及记录所有外部客户端对Oracle数据库发出的请求。当启用工作负载捕获时，所有外部数据库调用都会被跟踪并存储在文件系统上的二进制文件中，称为捕获文件。这些捕获文件包含SQL文本、绑定变量值和事务信息等关键信息。

516.In a Database Replay workload capture, what client request information is gathered? (Choose all that

apply.)

A. SQL text

B. Shared server requests (Oracle MTS)

C. Bind variable values

D. Information about transactions

E. Remote DESCRIBE and COMMIT operations

Answer: ACD

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e41481/dbr_intro.htm#RATUG105

8.1 Workload Capture

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

When workload capture is enabled, all external client requests directed to Oracle Database are tracked and stored in binary files—called capture files—on the file system. You can specify the location where the capture files will be stored. 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. These capture files are platform independent and can be transported to another system.