You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which

题目

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）

A、It detects any configuration change that caused a performance difference in both time periods.
B、It identifies any workload change that caused a performance difference in both time periods.
C、It detects the top wait events causing performance degradation.
D、It shows the resource usage for CPU, memory, and I/O in both time periods.
E、It shows the difference in the size of memory pools in both time periods.
F、It gives information about statistics collection in both time periods.

参考答案和解析

正确答案:A,B,E

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

相似问题和答案

第1题：

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

第2题：

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?()

A. Compare Period ADDM report

B. AWR Compare Period report

C. Active Session History (ASH) report

D. Taking a new snapshot and comparing it with a preserved snapshot

参考答案：B

第3题：

You want to upgrade 100 computers from Windows 98 to Windows 2000 Professional. You use setup manager to create the unattended.txt file. The hardware on each computer is configured identically. You upgrade 10 of the computers. You notice that the monitors on the 10 computers go blank after Windows 2000 Professional loads. You restart one of the computers in Safe Mode, and find that the monitor appears to be working. Which change should you make to unattend.txt to configure your video settings correctly?

Click the appropriate line on the Unattend.txt Notepad screen.

正确答案：<m x1="7" x2="115" y1="290" y2="308"></m>
<m x1="7" x2="115" y1="290" y2="308"></m> 解析：Explanation: Click on theVrefresh=150
The video adapter's refresh rate defines the number of times that the screen must be rewritten per second. The higher the resolution, the larger the number of dots that have to be written within every refresh cycle. Video adapters and monitors have a default refresh rate of 60 Hz. This is the setting guaranteed to work on most modern video adapters and monitors, even with the standard video adapter driver installed. Not all video adapters and monitors support a refresh rate of above 80 Hz. When the refresh rate is not supported, the monitor goes blank or the image becomes distorted.

第4题：

You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

A、 redo log files
B、 password file
C、 control file
D、 change tracking file

正确答案:D

第5题：

You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Users report that it takes a long time to open shared files on Server1. Users do not report this performance problem when they open files on other servers.You notice the following performance statistics on Server1:You need to optimize the performance of Server1.What should you do?（）

A. Add more ram.

B. Upgrade the processor.

C. Increase the size of the PageFile.

D. Disable Data Execution Prevention (DEP).

参考答案：A

第6题：

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()

A. Change in the Oracle Database version

B. Change in your network infrastructure

C. Change in the hardware configuration of the database server

D. Migration of database storage from non-ASM to ASM storage

E. Database and operating system upgrade

参考答案：A, C, E

第7题：

You have a computer that runs Windows Vista Ultimate.You open the Windows System Performance Rating tool and receive a Windows Experience Index base score of 1.0. The subscores are as follows:·Processor: 4.7·Memory (RAM): 3.6·Graphics: 1.0·Gaming Graphics: 1.0·Primary Hard Disk: 3.0You upgrade your video adapter card with a new card that meets the minimum requirements for Windows Aero.You open the System Performance and Rating tool and notice the base score and subscores have not changed.You need to enable Windows Aero.What should you do?（）

A.A

B.B

C.C

D.D

参考答案：C

第8题：

The schedule is _________ to change without notice.

A、object

B、project

C、reject

D、subject

参考答案：D

第9题：

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
B、 the execution plan
C、 the execution context
D、 the execution frequency
E、 the system change number （SCN）

正确答案:A,C,D

第10题：

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）

A、Change in the Oracle Database version
B、Change in your network infrastructure
C、Change in the hardware configuration of the database server
D、Migration of database storage from non-ASM to ASM storage
E、Database and operating system upgrade

正确答案:A,C,E

You notice a performance change

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容