44.Your database is functional with a peak load for the last one hour. You want to preserve the perf
来源:互联网 发布:xmind8 mac破解序列号 编辑:程序博客网 时间:2024/06/05 20:44
44.Your database is functional with a peak load for the last one hour. You want to preserve the
performance statistics collected during this period to be used for comparison when you analyze the
performance of the database in the future.
What action would you take to achieve this task?
A.Insert finding directives for ADDM tasks in the future.
B.Create a baseline on a pair of snapshots spanning the peak-load period.
C.Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
D.Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.
答案:B
解析:题目的意思大概意思是想保留当前的执行统计,与将来做比较,应该怎么做
A:ADDM
B:创建一个awr基线
C:在高峰期在awr收集快照的时候减少间隔时间
D:设置awr快照的期限为0,避免被清除
一、AWR
awr(automatic workload repository) 自动工作负荷资料档案库,通过它可收集、维护和使用统计信息
用于问题检测和自动化维护,默认情况下数据库60分钟从sga中收集一次,并且通过mmon(manageability monitor,可管理性能监视器)
后台进程存储在磁盘上,11g会保留8天,10g为7天,awr的间隔和保留期都可以进行修改
SQL> select * from DBA_HIST_WR_CONTROL
DBID SNAP_INTERVAL RETENTION TOPNSQL
---------- -------------------- -------------------- ----------
3563246617 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT
--这里可以看出来保留8天,间隔为1小时
SQL> begin
2 DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(14400,60);
3 end;
4 /
SQL> select * from DBA_HIST_WR_CONTROL;
DBID SNAP_INTERVAL RETENTION TOPNSQL
---------- -------------------- -------------------- ----------
3563246617 +00000 01:00:00.0 +00010 00:00:00.0 DEFAULT
--修改为10天,设置的单位是分钟
如果设置为0的话,那么快照将会被永久保存,也就是D选项,但是题目中说的时这个高峰时期也就是一个时间段,而这个只是一个时间点的所以可以排除了
awr基线
1.基线相当于生活中的病例,创建一个参照点,可以作为比较,找出有问题的地方
2.基线通常是做了标记的并长期保存在awr中的一组重要时段的快照集,快照集以一对快照来定义
这些快照用快照序列号(snap_ids)或开始于结束时间来标识,每个快照集都有一个开始和结束
快照并且包含了这两个快照之间的所有快照
所以这里应该选择B
C与题中说的没有关系
ADDM:自动数据库诊断监视器
每个awr快照被记录后,addm就会自动运行,分析与最后两个快照对应的时段中的数据,addm会主动监视实例
多数情况下,addm会为检测到的问题提供解决方案,addm可以检测到一些常见问题如下
1.cpu瓶颈
2.oracle net 连接管理问题
3.锁的竞争
4.IO问题
5.一些数据库实例内存结构的大小不足
6.过载的sql语句
7.plsql和java运行时间过长
8.检查点负载过高及原因(如日志文件过小)
与题目中说的也没啥关系
performance statistics collected during this period to be used for comparison when you analyze the
performance of the database in the future.
What action would you take to achieve this task?
A.Insert finding directives for ADDM tasks in the future.
B.Create a baseline on a pair of snapshots spanning the peak-load period.
C.Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
D.Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.
答案:B
解析:题目的意思大概意思是想保留当前的执行统计,与将来做比较,应该怎么做
A:ADDM
B:创建一个awr基线
C:在高峰期在awr收集快照的时候减少间隔时间
D:设置awr快照的期限为0,避免被清除
一、AWR
awr(automatic workload repository) 自动工作负荷资料档案库,通过它可收集、维护和使用统计信息
用于问题检测和自动化维护,默认情况下数据库60分钟从sga中收集一次,并且通过mmon(manageability monitor,可管理性能监视器)
后台进程存储在磁盘上,11g会保留8天,10g为7天,awr的间隔和保留期都可以进行修改
SQL> select * from DBA_HIST_WR_CONTROL
DBID SNAP_INTERVAL RETENTION TOPNSQL
---------- -------------------- -------------------- ----------
3563246617 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT
--这里可以看出来保留8天,间隔为1小时
SQL> begin
2 DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(14400,60);
3 end;
4 /
SQL> select * from DBA_HIST_WR_CONTROL;
DBID SNAP_INTERVAL RETENTION TOPNSQL
---------- -------------------- -------------------- ----------
3563246617 +00000 01:00:00.0 +00010 00:00:00.0 DEFAULT
--修改为10天,设置的单位是分钟
如果设置为0的话,那么快照将会被永久保存,也就是D选项,但是题目中说的时这个高峰时期也就是一个时间段,而这个只是一个时间点的所以可以排除了
awr基线
1.基线相当于生活中的病例,创建一个参照点,可以作为比较,找出有问题的地方
2.基线通常是做了标记的并长期保存在awr中的一组重要时段的快照集,快照集以一对快照来定义
这些快照用快照序列号(snap_ids)或开始于结束时间来标识,每个快照集都有一个开始和结束
快照并且包含了这两个快照之间的所有快照
所以这里应该选择B
C与题中说的没有关系
ADDM:自动数据库诊断监视器
每个awr快照被记录后,addm就会自动运行,分析与最后两个快照对应的时段中的数据,addm会主动监视实例
多数情况下,addm会为检测到的问题提供解决方案,addm可以检测到一些常见问题如下
1.cpu瓶颈
2.oracle net 连接管理问题
3.锁的竞争
4.IO问题
5.一些数据库实例内存结构的大小不足
6.过载的sql语句
7.plsql和java运行时间过长
8.检查点负载过高及原因(如日志文件过小)
与题目中说的也没啥关系
0 0
- 44.Your database is functional with a peak load for the last one hour. You want to preserve the perf
- 47.Your database instance is functional for the past one month. The Automatic Workload Repository (A
- 72.You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG
- 70.You configured the Flash Recovery Area (FRA) for your database. The database instance is running
- 166 You are managing a 24*7 database. The backup strategy for the database is to perform user-manage
- 51 You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the
- 109 You want to take a complete database backup using RMAN. The backup should consist only the used
- Too often.things you want have the most is the one thing you can't have
- what should you be as a programmer?To be the last one and become experienced!
- So you want to program the web with FSharp?
- ArgumentException: The Thing You Want To Instantiate Is Null.
- Science Says This Is How to Make the Perfect First Impression You only get one chance for a first i
- 116.Your database instance is started using the server parameter file (SPFILE). You executed a comma
- The one who can give anything you want is only yourself. The rating is the only you should pursue.
- 68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database
- 160 You want to use the automatic management of backup and recovery operations features for your dat
- 158.You want to create a role to meet these requirements: 1: The role is to be protected from unauth
- 75.Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS
- JAVAFX开发出现的小bug
- 研究生生活点滴感想(2)
- SpringMVC学习(一)
- 汉诺塔(一 )解法集合 (主要用快速幂)
- 搭建git for windows服务器错误点及解决办法
- 44.Your database is functional with a peak load for the last one hour. You want to preserve the perf
- 数论基础 1008 LightOJ 1213
- BeanUtil工具类
- C++语言基础
- python csdn增加访问量
- 数论基础1009 LightOJ 1197
- hdu 5742 (2016 Multi-University Training Contest 2)
- android解析xml-用sax解析
- 设计模式学习笔记(五):工厂方法模式