單項選擇題

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）

A.by using the SQL access advisor
B.by using the Automatic Workload Repository report
C.by running the Automatic Database Diagnostic Monitor （ADDM）
D.by using the Automatic Workload Repository Compare Period report
E.by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

你可能感興趣的試題

單項選擇題

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.

單項選擇題

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.

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

你可能感興趣的試題

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？（）

In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）

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？（）

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