Compute the baseline statistics.
Take an immediate AWR snapshot.
Decrease the window size for the baseline.
Decrease the expiration time for the baseline.
第1题:
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()
第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题:
Which two statements are true about the Automatic Workload Repository (AWR)()
第4题:
In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
第5题:
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?()
第6题:
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()
第7题:
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task()
第8题:
The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?()
第9题:
AWR baselines are always created as repeating baselines.
AWR baselines can be created on the basis of two time values.
AWR baselines are always created with infinite expiration duration.
AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.
第10题:
Compute the baseline statistics.
Take an immediate AWR snapshot.
Decrease the window size for the baseline.
Decrease the expiration time for the baseline.
第11题:
The optimizer statistics are collected automatically.
Only the timed operating system (OS) statistics and plan execution statistics are collected.
The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
第12题:
Memory Advisor
Segment Advisor
SQL Access Advisor
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)
第13题:
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?()
第14题:
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?()
第15题:
Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?()
第16题:
Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?()
第17题:
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?()
第18题:
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?()
第19题:
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 thedatabase in the future. What action would you take to achieve this task?()
第20题:
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting()
第21题:
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
第22题:
AWR baselines are always created as repeating baselines.
AWR baselines can be created on the basis of two time values.
AWR baselines are always created with infinite expiration duration.
AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.
第23题:
Run Segment Advisor
Run the SQL Tuning Advisor (STA)
Run the Automatic Workload Repository (AWR) report
Run the SQL Access Advisor with a hypothetical workload