多选题You work as a database administrator for Certkiller .com. 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 snapsh

题目内容(请给出正确答案)

多选题

You work as a database administrator for Certkiller .com. 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？（）

use enterprise manager

use DBMS_SQL package

use DBMS_AWR package

use PRVT_WORKLOAD package

query the AWR snapshot repository objects

use DBMS_WORKLOAD_REPOSITORY package

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

更多相关问题

第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题

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

点击查看答案
第3题

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

点击查看答案
第4题

Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future. What action would you take to achieve this task（）A、Insert finding directives for ADDM tasks in the future.B、Create a baseline on a pair of snapshots spanning the peak-load period.C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.

点击查看答案
第5题

Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task？（）A、Set the STATISTICS_LEVEL initialization parameter to ALL.B、Create a baseline on a pair of snapshots that have the statistics of the peakload period in the database.C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.

点击查看答案
第6题

You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）A、Memory AdvisorsB、Segment AdvisorsC、SQL Tuning and Access AdvisorsD、Automated Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）

点击查看答案
第7题

You plan to collect the Automatic Workload Repository （AWR） data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this？（） A、 Create and populate a SQL Tuning Set from the AWR on every Monday.B、 Change the RETENTION setting for the AWR snapshots to 7 days on Monday.C、 Create a repeating baseline template.D、 Insert a finding directive for future ADDM tasks.

点击查看答案

多选题You work as a database administrator for Certkiller .com. 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 snapsh

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容