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

The application workload on your database is same between 10

题目
单选题
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

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

第1题：

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

第2题：

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

第3题：

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

第4题：

A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）

  • A、The application server，firewall，and database server on the same VLAN
  • B、The application server and firewall on one VLAN，and the database server on a second VLAN
  • C、The application server on one VLAN，and the database server and firewall on a second VLAN
  • D、The application server and firewall on one VLAN，and the firewall and database server on a second VLAN

正确答案:D

第5题：

Company.com has a database application and a Web server application running on the same p5-570 server in a single partition. Recently there have been a number of instances where the increased load on the database server has impacted the performance of the Web server. What can the technical specialist recommend to keep the database application from impacting the performance of the Web server？（）

  • A、Create a VLAN between the web server and database server.
  • B、Purchase APV and install the VIOS.
  • C、Increase the priority of the Web server.
  • D、Create separate LPARs for Web and database workloads.

正确答案:D

第6题：

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

第7题：

You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

  • A、Database Control
  • B、Management Server
  • C、Management Repository
  • D、Application Server Control
  • E、Oracle Management Agent

正确答案:E

第8题：

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

第9题：

An enterprise has three nodes： -Node ’A’ is a production database， -Node ’B’ is a production  Application server， and -Node ’C’ is a test and development node. Node ’C’ is used by six programmers to develop and the production application as business critical and would like to make it highly available with HACMP. Application development and testing is not business critical.  Which of the following describes the best solution？（）  

  • A、 There is not an adequate solution because HACMP should not be configured in this environment without a dedicated standby node.
  • B、 Nodes ’A’ and ’B’ should be configured in a cluster with mutual fallover of two cascading resource groups to provide both nodes will deliver acceptable response time with both resource groups.
  • C、 Nodes ’A’ and ’C’ should be configured in one cluster， and Nodes ’B’ and ’C’ in another cluster to prevent both the database and application server from falling over to Node ’C’ at the same time.
  • D、 Nodes ’A’， ’B’， and ’C’ should be configured in a cluster with Node ’C’ the hot standby for both the database and application server resource groups. Workload Manager （WLM） must be configured on database and application developers from over utilizing the CPU resources.

正确答案:B

第10题：

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

更多相关问题
相关内容