|
|
> 黄版,系统参数默认就是typical 没改过,而且我试过好几个库都不行,只有10条SQL,有一个库设置好当时可以有30条,第二天再生成AWR就不行了
notmain may be able to help you. I don't know. But I tested it on my 10.2.0.1 database with topnsql set to 30. I got more than 60 SQLs for SQL ordered by Elapsed Time or for CPU Time, but much less in other parts of the "SQL Statistics". For example, "SQL ordered by Gets" has 11 SQLs. It has a comment "Captured SQL account for 39.6% of Total". Not sure from where it got that 39.6. AWR probably has some threshold, below which the SQLs are not considered significant in performance tuning.
Which section in AWR report are you talking about? What's your version of Oracle?
> 等我下个文档发上来时就会把前一个文档源文件公开，我这样做的目的是防止个别培训机构拿过去一改就成他们的写的文档了.等过段时间后网上已经流传开了,我就上传源文件
Perfectly understandable. I hate it when people grab your stuff without acknowledgement. It happens not just in China. Some of my work was copied and pasted into published articles by others (English speaking people) without mentioning my name.
Yong Huang
[ 本帖最后由 Yong Huang 于 2010-9-17 14:38 编辑 ] |
|
楼主: notmain
IP卡
狗仔卡
楼主
显身卡
发表于 2010-9-17 12:28
发表于 2010-9-18 04:34
