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.
相似考题

1.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.

2.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 SQLB. the execution planC. the execution contextD. the execution frequencyE. the system change number (SCN)

3.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 versionB. Change in your network infrastructureC. Change in the hardware configuration of the database serverD. Migration of database storage from non-ASM to ASM storageE. Database and operating system upgrade

4.The schedule is _________ to change without notice.A、objectB、projectC、rejectD、subject

更多“You notice a performance change”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （） 

    • A、You should use SQLServer:Buffer Manager
    • B、You should use SQLServer:Memory Manager 
    • C、You should use SQLServer:Databases 
    • D、You should use SQLServer:Access Methods

    正确答案:D

  • 第6题：

    单选题
    M: Excuse me, I'm sorry to bother you. ______ a 10 note?　　W: Sorry, I can't unless you buy something here.
    A

    Can you change me

    B

    Can you change it

    C

    Can't you change

    D

    Can't you change it


    正确答案： D
    解析：
    根据上下文，下文提到除非你买东西，所以上文应该是要求换零钱。

  • 第7题：

    单选题
    You have completed an OSPF implementation, and you are verifying OSPF operation. During this verification, you notice that the OSPF route of 172.16.10.0 is repeatedly appearing and disappearing from the routing table. Further investigation finds that the OSPF CPU utilization is very high and the routers are constantly performing SPF calculations. You determine that 172.16.20.2 is the source of the 172.16.10.0 route. Using the show ip ospf database router 172.16.20.1 command, you notice that when this show command is performed repeatedly, the contents of the LSA change every few seconds. What could be the cause of this problem?（）
    A

    OSPF authentication errors between some of the routers

    B

    Two routers have the same OSPF router ID

    C

    Issues with mistuned OSPF timers

    D

    OSPF LSA pacing issues between some of the routers

    E

    OSPF neighbor adjacency problems between some of the routers


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）
    A

    Java pool

    B

    Large pool

    C

    Shared pool

    D

    Streams pool

    E

    Library cache

    F

    Redo log buffer

    G

    Data dictionary cache

    H

    Database buffer cache


    正确答案： H
    解析： 暂无解析

  • 第9题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （）
    A

    You should use Dynamic Management Views 

    B

    You should use SQL Server Resource Governor 

    C

    You should use SQL Server Profiler 

    D

    You should use Windows System Monitor


    正确答案： D
    解析： 暂无解析

  • 第10题：

    多选题
    You are a network administrator for ExamSheet.net's Windows 2000 network.  A user named Sandra has a Windows 2000 Professional computer with a single hard disk with two partitions configured as drive C and D. A pagefile has been configured on Drive C:. Sandra reports that applications on her Windows 2000 Professional computer are running slowly. You notice that Sandra's computer has 64 MB of RAM. Her hard drive contains 70 MB of free disk space on drive C and 160 MB of free disk space on drive D.You want to improve the performance of Sandra's computer.  What should you do?（）
    A

    Move the paging file to drive D

    B

    Use Disk Cleanup to delete temporary files and unnecessary program files

    C

    Perform a disk analysis， and use the disk defragmenter if recommended

    D

    Ensure that the Performance Options window is optimized for applications

    E

    Ensure that the Performance Options services.


    正确答案： B,A
    解析： 暂无解析

  • 第11题：

    多选题
    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.


    正确答案： B,A
    解析： 暂无解析

  • 第12题：

    单选题
    Your Windows 2000 Professional computer contains a 166 MHz processor 64 MB of RAM and 750 MB of free disk space. You have installed a number of applications on your computer including a word processing program， a spreadsheet program， a third party scientific application and a multimedia player. You notice that when you have several of these applications open simultaneously the performance of your computer is noticeably slower. You run system monitor notice that the processor time and queue counters are showing high readings was blue and red line touching 100%. What should you do to solve this problem？（）
    A

    Use diskprode to modify existing disk sector values.

    B

    Upgrade your processor.

    C

    Increase the amount of free disk space.

    D

    Increase the amount of RAM.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

    • A、You should use Dynamic Management Views 
    • B、You should use SQL Server Resource Governor 
    • C、You should use SQL Server Profiler 
    • D、You should use Windows System Monitor

    正确答案:A

  • 第17题：

    多选题
    A user named Tom reports that an application on his Windows 2000 Professional computer is running slowly. You notice Tom’s computer has 64 MB of RAM and 100 MB of free disk space. What should you do to improve the performance of his system？ （）
    A

    Add Tom to the Power user group.

    B

    Set the total paging file to 75 % of physical memory.

    C

    Perform a disk analysis and use the disk defragmenter if recommended.

    D

    Use Disk cleanup to delete temporary files and unnecessary program files.

    E

    Ensure that the Performance Options windows is optimized for background services.


    正确答案： A,E
    解析： 暂无解析

  • 第18题：

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


    正确答案： A
    解析： 暂无解析

  • 第19题：

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


    正确答案： B
    解析： 暂无解析

  • 第20题：

    多选题
    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）


    正确答案： C,A
    解析： 暂无解析

  • 第21题：

    单选题
    You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）
    A

    Enable Memory Access Mode, which reads performance data from SGA.

    B

    Use emergency monitoring to fetch data directly from SGA analysis.

    C

    Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

    D

    Use Active Session History (ASH) data and hang analysis in regular performance monitoring.

    E

    Run ADDM in diagnostic mode.


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    You work as a network engineer at TestKing.com. TestKing users have noticed extremely slow network performance, intermittent connectivity, and connection loss. After entering the show interfaces command, you notice that the Ethernet interface is configured as 100 Mbps full-duplex and that there is evidence of late collisions. What could be the cause of this problem?（）
    A

    duplex mismatch

    B

    a routing loop

    C

    trunking mode mismatch

    D

    improperly configured root bridge

    E

    improperly configured static VLAN


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）
    A

     The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET

    B

     The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET

    C

     The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management

    D

     The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management


    正确答案： B
    解析： 暂无解析

相关内容