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?()
第2题:
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?()
第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 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
第4题:
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?()
第5题:
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?()
第6题:
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()
第7题:
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?()
第8题:
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).
第9题:
You work as a database administrator for Certkiller .com. In your transaction application, you have scheduled a job to update the optimizer statistics at05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected?()
第10题:
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()