违法和不良信息举报 联系客服
免费注册 登录

Performance divergence indicated in the Workload Replay repo

题目
单选题
Performance divergence indicated in the Workload Replay report is most likely due to what？（）
A

 DML and SQL statement results that do not match between the capture and replay systems

B

 When errors that occur in the capture system dont occur in the replay system

C

 Top SQL statements

D

 Infrastructure or system-configuration differences

E

 Time-of-day differences between capture and replay systems

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?()

A. The COMMIT order in the captured workload is preserved during replay.

B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.

D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.


参考答案：A, C, D

第2题：

Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）

A. Database replay

B. SQL Tuning Advisor

C. SQL Access Advisor

D. SQL Performance Analyzer

E. Automatic Workload Repository compare reports


参考答案：E

第3题：

(ii) evaluates the relative performance of the four depots as indicated by the analysis in the summary table

prepared in (i); (5 marks)


正确答案：
(ii) The summary analysis in (a)(i) shows that using overall points gained, Michaelangelotown has achieved the best
performance with 12 points. Donatellotown and Leonardotown have achieved a reasonable level of performance with
eight points each. Raphaeltown has under performed, however, gaining only four out of the available 12 points.
Michaelangelotown is the only depot to have achieved both an increase in revenue over budget and an increased
profit:revenue percentage.
In the customer care and service delivery statistics, Michaelangelotown has achieved all six of the target standards,
Donatellotown four; Leonardotown three. The Raphaeltown statistic of achieving only one out of six targets indicates the
need for investigation.
With regard to the credit control and administrative efficiency statistics, Leonardotown and Michaelangelotown achieved
all four standards and Donatellotown achieved three of the four standards. Once again, Raphaeltown is the ‘poor
performer’ achieving only two of the four standards.

第4题：

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）

  • A、by using the SQL access advisor
  • B、by using the Automatic Workload Repository report
  • C、by running the Automatic Database Diagnostic Monitor （ADDM）
  • D、by using the Automatic Workload Repository Compare Period report
  • E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

正确答案:D

第5题：

What is the purpose of configuring Workload Manager on a server used for development and QA？（）  

  • A、To experiment with shared processor pools
  • B、To isolate physical hardware between workloads
  • C、To control resource utilization on an application-by-application basis
  • D、To leverage Workload Partition Manager for performance trending and analysis

正确答案:C

第6题：

Which two statements about workload capture and replay operations are true?()

A. The clients must be created manually on the test machines to perform more realistic testing.

B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.

D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.


参考答案：C, D

第7题：

Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）

A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.

B. Run the Automatic Workload Repository Monitor (ADDM).

C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.


参考答案：D

第8题：

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?()

A. the SQL text SQL

B. the execution plan

C. the execution context

D. the execution frequency

E. the system change number (SCN)


参考答案：A, C, D

第9题：

Which three statements about performance analysis by SQL Performance Analyzer are true? （）

  • A、It detects changes in SQL execution plans.
  • B、It produces results that can be used to create the SQL plan baseline.
  • C、The importance of SQL statements is based on the size of the objects accessed.
  • D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
  • E、It shows only the overall impact on workload and not the net SQL impact on workload.

正确答案:A,B,D

第10题：

In a Database Replay workload capture， what client request information is gathered？（）

  • A、 SQL text
  • B、 Shared server requests （Oracle MTS）
  • C、 Bind variable values
  • D、 Information about transactions
  • E、 Remote DESCRIBE and COMMIT operations

正确答案:A,C,D

更多相关问题
相关内容