itgle.com

多选题Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?（）AThe size of the shared pool is too small.BCursors are not being shared.CA larg

题目
多选题
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?（）
A

The size of the shared pool is too small.

B

Cursors are not being shared.

C

A large number COMMITS are being performed.

D

There are frequent logons and logoffs.

E

The buffers are being read into the buffer cache, but some other session is changing the buffers.

相似考题

1.You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A. The collection level for the AWR should be set to BASICB. The moving window size must be less than Undo RetentionC. The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

2.YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement：SQL>SELECTname，value，isdefault2FROMv$parameter3WHEREnameLIKE’%size%’；TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply？（）A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1GB.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1GC.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGAD.ThevaluesoftheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscannotbesetmanually.E.NominimumlimitsareimposedontheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameters.F.TheAutomaticSharedMemoryManagementfeaturecannotbedisabledunlessyouspecifyvaluesfortheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparametersintheinitializationparameterfile.

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

4.Which statements are true regarding the system－defined moving window baseline in Oracle Database 11g?()A. It does not allow you to change the moving window size.B. Adaptive threshold functionalities use it by default to compute statistics.C. It is created by default with the window size being equal to the AWR retention time.D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

更多“多选题Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?（）AThe size of the shared pool is too small.BCursors are not being shared.CA larg”相关问题

  • 第1题：

    You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.Identify three possible reasons for this.（）

    A. Missing or stale histogram statistics

    B. Undersized shared pool

    C. High clustering factor for the indexes

    D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

    E. Oversized buffer cache


    参考答案：A, C, D

  • 第2题：

    Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）

    • A、LOG_BUFFER
    • B、SORT_AREA_SIZE
    • C、JAVA_POOL_SIZE
    • D、STREAMS_POOL_SIZE
    • E、DB_16K_CACHE_SZIE
    • F、DB_KEEP_CACHE_SIZE

    正确答案:A,E,F

  • 第3题：

    Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g？（）

    • A、 It does not allow you to change the moving window size.
    • B、 Adaptive threshold functionalities use it by default to compute statistics.
    • C、 It is created by default with the window size being equal to the AWR retention time.
    • D、 It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.

    正确答案:B,C

  • 第4题：

    You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

    • A、run Segment Advisor
    • B、run SQL Tuning Advisor on top SQL statements
    • C、run the Automatic Workload Repository （AWR） report
    • D、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

    正确答案:B

  • 第5题：

    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

  • 第6题：

    多选题
    An Administrator notices a decrease in the performance of his site.  This is directly related to an increase in usage.  After further investigation he notices that users appear to be pooling up in the web server.  Which of the following would cause this to occur？（）
    A

    The web Server ThreadsPerChild directive could be set too low.

    B

    The Web Container Thread Pool Minimum Size could be set too high.

    C

    The Web Container Thread Pool Maximum Size could be set too high.

    D

    The growable thread pool setting could be disabled for the Web Container.


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

  • 第7题：

    多选题
    Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）
    A

    LOG_BUFFER

    B

    SORT_AREA_SIZE

    C

    JAVA_POOL_SIZE

    D

    STREAMS_POOL_SIZE

    E

    DB_16K_CACHE_SZIE

    F

    DB_KEEP_CACHE_SIZE


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

  • 第8题：

    单选题
    View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）
    A

    The database instance is running with manual PGA management.

    B

    The database instance is running with manual shared memory management.

    C

    The database instance has the MEMORY_TARGET value set to a nonzero value.

    D

    All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed


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

  • 第9题：

    多选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）
    A

    The optimizer statistics are collected automatically.

    B

    Only the timed operating system （OS） statistics and plan execution statistics are collected.

    C

    The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

    D

    The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 

    E

    Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.


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

  • 第11题：

    多选题
    The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）
    A

    LOG_BUFFER

    B

    DB_CACHE_SIZE

    C

    JAVA_POOL_SIZE

    D

    LARGE_POOL_SIZE

    E

    SHARED_POOL_SIZE

    F

    STREAMS_POOL_SIZE


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

  • 第12题：

    单选题
    You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）
    A

    The collection level for the AWR should be set to BASIC

    B

    The moving window size must be less than Undo Retention

    C

    The moving window size should be greater than the Automatic Workload Repository (AWR) retention period

    D

    The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period


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

  • 第13题：

    You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）

    • A、The collection level for the AWR should be set to BASIC
    • B、The moving window size must be less than Undo Retention
    • C、The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
    • D、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

    正确答案:D

  • 第14题：

    View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）

    • A、The database instance is running with manual PGA management.
    • B、The database instance is running with manual shared memory management.
    • C、The database instance has the MEMORY_TARGET value set to a nonzero value.
    • D、All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed

    正确答案:C

  • 第15题：

    You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this.（）

    • A、Missing or stale histogram statistics
    • B、Undersized shared pool
    • C、High clustering factor for the indexes
    • D、High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
    • E、Oversized buffer cache

    正确答案:A,C,D

  • 第16题：

    You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE://        SGA_TARGET = 512M        SHARED_POOL_SIZE = 256M   Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）

    • A、 Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.
    • B、 Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.
    • C、 Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.
    • D、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.
    • E、 Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool  component to the desired size by reallocating the additional memory from the auto-tuned memory components.
    • F、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.

    正确答案:D,E

  • 第17题：

    Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?（）

    • A、The size of the shared pool is too small.
    • B、Cursors are not being shared.
    • C、A large number COMMITS are being performed.
    • D、There are frequent logons and logoffs.
    • E、The buffers are being read into the buffer cache, but some other session is changing the buffers.

    正确答案:A,B,E

  • 第18题：

    多选题
    You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement：   SQL> SELECT name， value， isdefault  2 FROM v$parameter   3 WHERE name LIKE ’%size%’；   The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE，  LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value.  What does this imply？（）
    A

    The SGA_TARGET initialization parameter cannot be set to a value less than 1G

    B

    The SGA_TARGET initialization parameter cannot be set to a value greater than 1G

    C

    The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA

    D

    The values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.

    E

    No minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and  JAVA_POOL_SIZE initialization parameters.

    F

    The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the  DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.


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

  • 第19题：

    多选题
    You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE://        SGA_TARGET = 512M        SHARED_POOL_SIZE = 256M   Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）
    A

    Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.

    B

    Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.

    C

    Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.

    D

    Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.

    E

    Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool  component to the desired size by reallocating the additional memory from the auto-tuned memory components.

    F

    Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.


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

  • 第20题：

    多选题
    You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this.（）
    A

    Missing or stale histogram statistics

    B

    Undersized shared pool

    C

    High clustering factor for the indexes

    D

    High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

    E

    Oversized buffer cache


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

  • 第21题：

    多选题
    Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?（）
    A

    It does not allow you to change the moving window size.

    B

    Adaptive threshold functionalities use it by default to compute statistics.

    C

    It is created by default with the window size being equal to the AWR retention time.

    D

    It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).


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

  • 第22题：

    多选题
    Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）
    A

    LOG_BUFFER

    B

    SORT_AREA_SIZE

    C

    JAVA_POOL_SIZE

    D

    STREAMS_POOL_SIZE

    E

    DB_16K_CACHE_SZIE

    F

    DB_KEEP_CACHE_SIZE


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

  • 第23题：

    单选题
    In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）
    A

    The STATISTICS_LEVEL initialization parameter is set to BASIC

    B

    The PGA_AGGREGATE_TARGET initialization parameter is set to zero.

    C

    The SGA_MAX_SIZE initialization parameter is set to less than 20 GB

    D

    The DB_CACHE_SIZE initialization parameter is set to less than 5 GB

    E

    The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.


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

相关内容