一篇简单的介绍shared pool 的文章..
http://narashimreddy.wordpress.com/2009/10/30/internals-of-shared-pool/
评论:
比较深入的介绍了PLSQL MCODE 与 PLSQL DIANA
Shared pool 内部内存分配的简要描述.
SQL/PLSQL 游标的使用与解析.以及其工作原理.
PL/SQL MPCODE
The “compiled” form a PL/SQL is called PCODE, which stands for pseudo code, and is interpreted at runtime by the PL/SQL engine. That is, it is not really compiled; it is just pre-compiled. There is also a [...]
11g and direct path reads
http://oracledoug.com/serendipity/index.php?/archives/1321-11g-and-direct-path-reads.html
一篇关于Adaptive direct path reads的基本介绍.
http://afatkulin.blogspot.com/2009/01/11g-adaptive-direct-path-reads-what-is.html
11G’s ability to do direct path reads during full table scans without utilizing PQ was covered in a number of places already (see this post by Doug Burns for example).
When direct path reads starts to happen?
It is known that somewhat reliable figure is your _small_table_threshold multiplied by 5 [...]
从今日时, 开始Blog..
记录关于Oracle数据库,关于系统架构的学习心得,记录生活阅读的变迁.
同志们,我也加入你们的行列了.
希望后面能够坚持下去, 能经常带来一点新东西, 给大家带来一点有价值的东西.
在此特别感谢大辉,帮助我创建了这个站点..^_^
最近评论