Maclean Liu(刘相兵 发表于 2011-11-3 22:25:11

Oracle AWR (Automatic Workload Repository) Trending

T rending is very important for database performance
analysis. It exposes the performance profile of a
database in terms of IO, CPU usage, wait-event response
time, etc. Starting in Oracle Database 10g, AWR performance
data that is collected and stored out of the box is very helpful
in creating historical and comparative trend analysis to
gain insight into critical database performance issues. AWR
provides a rich history of Oracle performance statistics that
shows how an Oracle database system has been trending for
as long as the AWR data is retained.
So Where Do We Start?
Any statistic in AWR can be trended quite easily. The AWR report consists of
SQLs running against various “DBA_HIST_%” views taking the difference
between two snapshots at a time. This implies that we can develop and execute
similar SQL against those views to report the trend for any required statistic or
database wait event.

sky13and23 发表于 2011-11-8 15:14:55

不错，谢谢分享，学习了

alonedba 发表于 2011-12-4 12:56:56

支持免费分享……:lol

zhuqibs 发表于 2011-12-27 22:44:05

不错，钱不够啊，希望可以看一下啊

zhuqibs 发表于 2012-2-12 21:49:03

这个好像不要钱的，真不错啊

xteitxu 发表于 2012-3-8 15:42:45

maclean,太给力了。

shine 发表于 2012-4-5 11:12:34

钱不够啊，希望可以看一下啊

wzhihua 发表于 2012-4-19 22:37:43

下来学习下，感谢mac

shentianyun 发表于 2012-5-26 01:06:23

谢谢刘大分享好东西~

fsm 发表于 2012-6-1 11:03:21

这个不收钱啊！给力！

linyiyong 发表于 2012-7-26 07:27:33

好奇怪，不要钱的，我也下不了？

linyiyong 发表于 2012-7-26 07:33:22

下来了，对数据库巡检挺有帮助的一些脚本。

ybb896 发表于 2012-8-7 12:00:36

谢谢刘大,好东西,好好学习

aiirii 发表于 2012-8-7 15:33:45

一般，下载看了没有什么感觉

ybb896 发表于 2012-9-18 11:27:51

继续回复中啊....好文章

zhongwc 发表于 2013-2-19 09:10:12

无私奉献 哈哈

zhongwc 发表于 2013-2-25 14:42:55

支持一下

blitheliu 发表于 2013-3-4 21:47:51

支持一下，谢谢

linyiyong 发表于 2013-3-17 22:57:33

支持！！

kisswolf 发表于 2013-3-18 18:04:37

支持免费分享……:lol

bjchangxiao 发表于 2017-6-6 11:28:47

免费哈哈
页: [1]
查看完整版本: Oracle AWR (Automatic Workload Repository) Trending