【疑问】关于ASH信息的保存的疑问

itpub110

这么说来，AWR里面有关active session wait的统计似乎不是很准确啊

Yong Huang

I can't find official document (database documentation or MyOracleSupport documents) that says sampling frequency is 1 row out of 10. It would be nice if we could find that.

Thanks for your research.

Yong Huang

[ 本帖最后由 Yong Huang 于 2010-3-11 13:37 编辑 ]

itpub110

写blog那小伙虽然工龄不大，好歹也是oracle内部人员，不会扯的太离谱，从他的文章里的其它信息可以得到证明。

Mem->Disk反正不是全量，具体比例是多少，可以用测试来验证。

Yong Huang

原帖由 itpub110 于 2010-3-10 20:34 发表
写blog那小伙虽然工龄不大，好歹也是oracle内部人员，不会扯的太离谱，从他的文章里的其它信息可以得到证明。

I found my discussion with him on Oracle-L last year:
http://www.freelists.org/post/or ... case-of-histogram,5

No wonder that name sounds familiar to me.

Yong Huang