Which three statements are true about Automatic Workload Repository (AWR)?
A. All AWR tables belong to the SYSTEM schema.
B. The AWR data is stored in memory and in the database.
C. The snapshots collected by AWR are used by the self-tuning components in the database
D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
E. AWR contains system wide tracing and logging information.
Correct Answer: BCD
5.2 Overview of the Automatic Workload Repository
The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views. The statistics collected and processed by AWR include:
- Object statistics that determine both access and usage statistics of database segments
- Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views
References: http://docs.oracle.com/cd/B28359_01/server.111/b28274/autostat.htm#PFGRF02601
关于自动工作负载存储库(AWR),哪三条语句是正确的?
A.所有的AWR表都属于系统模式。
B. AWR数据存储在内存和数据库中。
C.AWR收集的快照被数据库中的自调优组件使用
D.在v$SYS time model和v$ SESS_TIME_MODEL视图中,AWR根据活动的时间使用情况计算时间模型统计。
E.AWR包含系统范围的跟踪和日志信息。
正确答案:BCD
5.2自动工作负载存储库概述
自动工作负载存储库(AWR)收集、处理和维护性能统计数据,用于问题检测和自调优。这些数据既存储在内存中,也存储在数据库中。收集的数据可以在报告和视图中显示。AWR收集和处理的统计数据包括:
—对象统计,确定数据库段的访问和使用统计
-时间模型统计基于活动的时间使用,显示在V$SYS_TIME_MODEL和V$SESS_TIME_MODEL视图
引用:http://docs.oracle.com/cd/B28359_01/server.111/b28274/autostat.htm # PFGRF02601