QUESTION 49-AWR

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值