ITPub博客

实验】Oracle Enterprise Linux 5.3 32Bits 环境下安装 Oracle 11g 安装文档

DescriptionRemoves duplicates from sorted list of rows. Number of rows returned is restricted using the ROWNUM pseudo-columnSQL>   CREATE TABLE t1 (c1 NUMBER);Table created.SQL...

1  parameter _smu_debug_mode=10242  SMON event 10513

In this Document <a href='https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=HOWTO&id=1365511.1&addClickInfo=Goal <a href='https://support.oracle.com/CSP/main/article?cmd=...

http://www.oracle-developer.net/display.php?id=429

http://www.oracle-developer.net/display.php?id=503query result cache in oracle 11g

http://www.dbsnake.net/library-cache-lock-and-pin.htmllibrary cache lock和library cache pin到底是什么

专题之Undo工作原理剖析http://wenku.baidu.com/view/42467ed149649b6648d747c0.html

http://blog.chinaunix.net/space.php?uid=7249348&do=blog&id=95755一篇ORACLE在linux上用大页内存的好文章

http://www.oracleblog.org/useful-script/study-lock-in-dsi/DSI之lock学习

http://www.ltesting.net/ceshi/ruanjianceshikafajishu/rjcskfyy/sjk/2007/0607/19706.html彻底搞清楚library cache lock的成因和解决方法（三）

1 其实parse_call的过程是再获取游标的过程2 一旦游标被cache到pga，无须再重新获取，自然是不用re-parse了 这既是软软解析了3 而这游标是否在pga里共享，都会在v$open_cursor视图里展现的4 隐士和显示游...

http://www.eygle.com/archives/2009/08/oracle_ksl_latch.html

http://www.itpub.net/thread-739487-1-1.html  Steve Adams的书中的latch levels提到：It is very common for an Oracle process to need to hold a number of latchesconcurrently. Theref...

测试过程很清爽，学习了！不过结论我还是有些疑虑的，固然gdb和类似sola下的trace等工具是能探察oracle内核每个模块中的极个别c函数的部分功能，可是往往是内核实现一个调度和去支应相应功能是，其中调...

http://hi.baidu.com/lichangzai/blog/item/e7eec07ec4321a330dd7dadf.html关于open_cursors和session_cached_cursors的参数值

http://space.itpub.net/20542911/viewspace-624681正确设置open_cursors和'session_cached_cursors' 可以减少sql解析

Only DML cursors (selects, inserts, updates, and deletes) are shared. DDL cursors arebuilt in the PGA and therefore are not shared; to be more precise, they execute withintheir own parse pha...

Why DDL will not flush relative cursor out of shared pool in 11g

http://www.itpub.net/thread-699527-2-1.html