![](http://blog.csdn.net/Emoticons/what_smile.gif)
![](http://blog.csdn.net/Emoticons/regular_smile.gif)
很多地方这不是一个节日,如果在家的话,该吃汤圆了,所以中午点了一份儿粥和汤圆,结果还是坐在工作机前面吃完了。忙了一整天,不过很多匆忙的报表我还是提前搞定了,下班等女友一起去庆祝一下,结果她们公司人性化的四点半下班(提前一小时)加上加班两小时,变成我等半小时……心情不错,主要还是因为调整了一下以前每个月固定的存储过程,效率双倍还不止,大大减轻了我等待电脑的痛苦。
回到宿舍上上网,走进这里发现好久没啥技术长进了,今天把SG的AdminII看完了,宣布了SG的完结,不过很多东西只是停留在笔记上而已,备份、恢复依然没有做过
![](http://blog.csdn.net/Emoticons/red_smile.gif)
Speed is the word that defines the twenty-first century. The previous century’s saying, “He who dies with the most toys wins” is now “He who dies with the most high-speed toys wins.” We want speed in everything we do, be it in our personal lives or the business we conduct. You name it—fast cars, fast computers, fast lanes, fast Internet connections, fast weight loss, fast cures, fast food, and so on.
这是第一章开头,跑跑题先,呵呵。搞笑的是:
Since the beginning of Oracle RDBMS, Oracle DBAs were taught to tune the database and instance by watching a few ratio numbers. The idea was to keep all database elements operating within acceptable ranges or limits. Some of the memorable ratios are the buffer cache hit ratio, library cache hit/miss ratio (Oracle7.0), and latch get/miss ratio. Who can forget these commandments?
-
Thou shalt keep thy buffer cache hit ratio in the upper 90 percentile.
-
Thy data dictionary misses must be under 10 percent at all times, and thy library cache shall not covet thy data dictionary—it shall have its own ratios.
-
Thy SQL area gethitratio and pinhitratio must also be in the 90 percentile at all times. Furthermore, the ratio of reloads to pins must not be more than 1 percent. If thy ratios are bad, thou shalt increase the shared pool size but thou shalt not steal the memory from the buffer cache. And while you are adding memory to the shared pool, throw some memory at the buffer cache also. It will increase the cache-hit ratio.
-
Thy willing-to-wait latch hit ratios shalt be close to 1. If not, thou may increase the SPIN_COUNT but thou must be careful not to kill thy CPUs. And so on.
Lost yet? We are. Life can be much simpler, not to mention better.
注意用语,第一次在计算机书籍上看到上百年前的英语,哈哈,看来Oracle够常青树的。不知道有没有毅力把这本书看完,不过至少这里就足够吸引人了。看看Oracle的官方教材再看看这个,唉……