如何查询当前的OS IO Size

Yong Huang

If you don't want to use consistent gets as a metric and insist on elapsed time, that's fine. Just do the same test multiple times in mixed order and take average. If the difference is within, say, 10 percent, dismiss it as statitical error.

Yong Huang

willlxy

i am sorry to bother you again, i want to use consistent gets as a metric , but i don't know how, Can you give me some advice?Or  Recommend
some book about that?
Thank you!

Yong Huang

原帖由 willlxy 于 2009-4-19 18:22 发表
i am sorry to bother you again, i want to use consistent gets as a metric , but i don't know how, Can you give me some advice?Or  Recommend
some book about that?
Thank you!

No need to say sorry. This is a forum we get together to help each other.

You were already getting consistent gets values. Look at your set autottrace screen. That's one of several ways to get the numbers. Another way is to get it from v$sesstat if you need to "probe" another session. For your own session and if you didn't run set autotrace at the beginning, you can also get it from v$mystat. "consistent gets" has a statistic# you can find in v$statname; in 10g it's statistic# 50 and in 11g it's 51.

Yong Huang

willlxy

作为后辈，我想请教前辈关于学习oracle 方面的几个问题，想要利用oracle 开发自己的数据库，是否需要全面系统的了解oracle， 以便能把握oracle,我做过OCI的开发，对oracle 有大楖的了解，看过一些文档，我想请教一条学习oracle 的路径（开发+管理）。还请前辈指点迷津。  谢谢

Yong Huang

I'm not someone people can call 前辈. Not at all. But I do have strong interest in it and spend a great deal of time studying it. You ask "想要利用oracle 开发自己的数据库，是否需要全面系统的了解oracle". I personally don't think so. To that end, you only need to study enough to get your work done. But for other purposes, e.g. finding a job, being to able to solve unknown problems quickly in the future, or just for fun, 全面系统的了解oracle is important. I have an old note about Oracle study:
http://yong321.freeshell.org/oranotes/OracleStudy.txt

Yong Huang

willlxy

谢谢你的指点，前两天都很迷芒了，看到你的回答后，又有了新的动力，与学习激情。

封烨

thank you ~
一路看帖过来，学习了。

Coast_lichao

大家有什么好的截图工具 啊；