ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0-053 Q516(Workload Capture)

Oracle OCP 1Z0-053 Q516(Workload Capture)

原创 Oracle 作者:abstractcyj 时间:2016-03-22 09:21:59 0 删除 编辑
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.


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2061510/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091626