单选题In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?()ADecreasing PCTUSEDBDecreasing PCTFREECIncreasing the number of DBWN processDUsing Automatic Segment Space Management (ASSM)EIncreasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

单选题
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?()
A

Decreasing PCTUSED

B

Decreasing PCTFREE

C

Increasing the number of DBWN process

D

Using Automatic Segment Space Management (ASSM)

E

Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation


参考解析

解析: 暂无解析

相关考题:

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

You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?() A. Compute the baseline statistics.B. Take an immediate AWR snapshot.C. Decrease the window size for the baseline.D. Decrease the expiration time for the baseline.

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.() A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshots

Which three statements are true about Automatic Workload Repository (AWR)?() A. All AWR tables belong to the SYSTEM schema.B. The AWR data is stored in memory and in the database.C. The snapshots collected by AWR are used by the self-tuning components in the databaseD. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.E. AWR contains system wide tracing and logging information.

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.On further investigation, you find that buffer busy waits is caused by contention on data blocks.Which option would you consider first to decrease the wait event immediately?()A. Decreasing PCTUSEDB. Decreasing PCTFREEC. Increasing the number of DBWN processD. Using Automatic Segment Space Management (ASSM)E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

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

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)()A、The ADDM requires at least four AWR snapshots for analysis.B、The ADDM runs after each AWR snapshot is collected automatically by MMON.C、The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR).D、The ADDM analysis provides only diagnostic information but does not provide recommendations.E、The ADDM calls other advisors if required, but does not provide recommendations about the advisors.

Which two statements are true about the Automatic Workload Repository (AWR)()A、All AWR tables belong to the SYSTEM schema.B、The AWR contains systemwide tracing and logging information.C、The snapshots collected by the AWR are accessible through data dictionary views.D、The snapshots collected by the AWR are used by self-tuning components in the database.

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?()A、AWR baselines are always created as repeating baselines.B、AWR baselines can be created on the basis of two time values.C、AWR baselines are always created with infinite expiration duration.D、AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expirationduration.

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.

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?()  A、 AWR baselines are always created as repeating baselines.B、 AWR baselines can be created on the basis of two time values.C、 AWR baselines are always created with infinite expiration duration.D、 AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance.  Which advisory component would you refer to, in order to determine the appropriate indexes?() A、Memory AdvisorB、Segment AdvisorC、SQL Access AdvisorD、Automatic Workload Repository (AWR)E、Automatic Database Diagnostic Monitor (ADDM)

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

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()A、Cursor cacheB、Stored outlineC、SQL Tuning SetD、Automatic Workload Repository (AWR) snapshots

The following command is executed to create the baseline template:   SQL EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME= TO_TIESTAMP(SYSDATE+2),  END_TIME=TO_TIMESTAMP(SYSDATE+10), BASELINE_NAME=’Mybase4’,  TEMPLATE_NAME=’Mytemp4’, EXPIRATION=NULL);   Which statement is true about the effect of the above command?()  A、 It creates a baseline template that never expires.B、 It produces an error because no snapshot information is provided to create the baseline.C、 It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.D、 It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

单选题Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?()A AWR baselines are always created as repeating baselines.B AWR baselines can be created on the basis of two time values.C AWR baselines are always created with infinite expiration duration.D AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

多选题You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic Repository (AWR) statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics?()Ause enterprise managerBuse DBMS_SQL packageCuse DBMS_AWR packageDuse PRVT_WORKLOAD packageEquery the AWR snapshot repository objectsFuse DBMS_WORKLOAD_REPOSITORY package

单选题You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance?()ARun the SQL Access Advisor.BRun the SQL Tuning Advisor (STA).CRun the Automatic Workload Repository (AWR) report.DRun the Automatic Database Diagnostic Monitor (ADDM).

多选题Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)()AThe ADDM requires at least four AWR snapshots for analysis.BThe ADDM runs after each AWR snapshot is collected automatically by MMON.CThe results of the ADDM analysis are stored in the Automatic Workload Repository (AWR).DThe ADDM analysis provides only diagnostic information but does not provide recommendations.EThe ADDM calls other advisors if required, but does not provide recommendations about the advisors.

单选题You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()A Compute the baseline statistics.B Take an immediate AWR snapshot.C Decrease the window size for the baseline.D Decrease the expiration time for the baseline.

单选题Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?()AAWR baselines are always created as repeating baselines.BAWR baselines can be created on the basis of two time values.CAWR baselines are always created with infinite expiration duration.DAWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expirationduration.

单选题The following command is executed to create the baseline template:   SQL EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME= TO_TIESTAMP(SYSDATE+2),  END_TIME=TO_TIMESTAMP(SYSDATE+10), BASELINE_NAME=’Mybase4’,  TEMPLATE_NAME=’Mytemp4’, EXPIRATION=NULL);   Which statement is true about the effect of the above command?()A It creates a baseline template that never expires.B It produces an error because no snapshot information is provided to create the baseline.C It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.D It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

单选题You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()ACompute the baseline statistics.BTake an immediate AWR snapshot.CDecrease the window size for the baseline.DDecrease the expiration time for the baseline.

多选题Your database instance is functional for the past one month. The Automatic Workload Repository(AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL.  You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day.  Choose two actions any of which can be referred to first to diagnose the problem. ()AUse the Active Session History report.BUse the AWR Compare Periods report.CUse an ADDM analysis between 7 PM and 9 PM of the previous day.DUse the AWR Compare Period report between 7 PM and 9 PM of the previous day.

多选题Which two statements are true about the Automatic Workload Repository (AWR)()AAll AWR tables belong to the SYSTEM schema.BThe AWR contains systemwide tracing and logging information.CThe snapshots collected by the AWR are accessible through data dictionary views.DThe snapshots collected by the AWR are used by self-tuning components in the database.

单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to, in order to determine the appropriate indexes?()A Memory AdvisorB Segment AdvisorC SQL Access AdvisorD Automatic Workload Repository (AWR)E Automatic Database Diagnostic Monitor (ADDM)

多选题Which three statements are true about Automatic Workload Repository (AWR)?()AAll AWR tables belong to the SYSTEM schema.BThe AWR data is stored in memory and in the database.CThe snapshots collected by AWR are used by the self-tuning components in the databaseDAWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.EAWR contains system wide tracing and logging information.