052-231(新增70题2018)-优快云博客

本文探讨了如何在数据库性能达到最佳状态时创建基线指标，以便在性能下降10%时能及时收到通知。文章详细解释了基线的概念及其在解决性能问题时的重要性，并提供了几种创建和比较未来数据库统计数据的方法。

You find today's performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today's performance.

What is the first step that you would take to ensure this?

A. create baseline metrics for today's performance

B. write the current database metrics to a database table and create a trigger to compare with future database statistics

C. write the current database metrics to a flat file and create an operating script to compare with future database statistics

D. write the current database metrics to a database table and create a procedure to compare with future database statistics

E. write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistic

Answer: A

Baselines

A baseline contains performance data from a specific time period that is preserved for comparison with other similar workload periods when performance problems occur. The snapshots contained in a baseline are excluded from the automatic AWR purging process and are retained indefinitely.

转载于:https://www.cnblogs.com/Babylon/p/8621846.html