答案：关于shared pool的深入探讨(四)link:http://www.eygle.com/internal/shared_pool-4.htm我们进一步来讨论一下shared pool的处理:先进行相应查询，获得测试数据:代码:[oracle@jumper udump]$ sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.3.0 - Production on Thu Aug 26 10:21:54 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production SQL> connect eygle/eygle Connected. SQL> create table emp as select * from scott.emp; Table created. SQL> SQL> connect / as sysdba Connected. SQL> startup force; ORACLE instance started. Total System Global Area 47256168 bytes Fixed Size 451176 bytes Variable Size 29360128 bytes Database Buffers 16777216 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> set linesize 120 SQL> connect scott/tiger Connected. SQL> select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 17-DEC-80 800 20 8888 EYGLE MANAGER 11-AUG-04 9999 10 10 7566 JONES MANAGER 7839 02-APR-81 2975 20 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 10 11 rows selected. SQL> connect eygle/eygle Connected. SQL> select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 17-DEC-80 800 20 8888 EYGLE MANAGER 11-AUG-04 9999 10 10 7566 JONES MANAGER 7839 02-APR-81 2975 20 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 </pre><p>上一个：<a href="/show/1b7ba2379b3b4fe1.htm">将DW数据窗口导出为EXCEL文件的方法（整理）</a><br/>下一个：<a href="/show/8ee6129ad4d8d84a.htm">关于XML for Analysis Provider</a></p><div class="piclist">更多图片编程知识:<ul><li><a href="/show/0df69cb99c2164b5.htm"><img src='/upload/2013111613/2011012108543454.jpg' width=105 height=105><br/>PHP+MySQL+jQuery实现发布微博程序</a></li><li><a href="/show/ac4a4aca50821e59.htm"><img src='/upload/2013111619/20130529091923190.png' width=105 height=105><br/>SQL将datetime转化为字符串并截取字符串</a></li><li><a href="/show/fd74c01a41784d4e.htm"><img src='/upload/20121014/2012072709020611r2pwapxewz5.png' width=105 height=105><br/>SQL Server中使用Linkserver连接Oracle的方法</a></li><li><a href="/show/e84e3ff7ce18573c.htm"><img src='/upload/2013111619/20130121113039594.jpg' width=105 height=105><br/>PostgreSQL使用with一例</a></li><li><a href="/show/3b8a7e49b013b1f2.htm"><img src='/upload/20130915/20130316062727531.jpg' width=105 height=105><br/>MSSQL Sqlerver 2005的安装配置图解</a></li><li><a href="/show/4fdecb1713a6cd18.htm"><img src='/upload/2013111619/20130913115357409.jpg' width=105 height=105><br/>postgresql启动错误</a></li></ul></div></div> <div class="zykmore"><script type="text/javascript" src="/js/s4.js"></script></div><div class="more"><dl><dt>更多<a href="/list/17_1.htm">SQLServer</a>疑问解答：</dt><dd><a target="_blank" href="/show/cddfccc1916d8a6e.htm">配置MSSQL复制指定快照文件夹提示：不是有效的路径或文件名</a></dd><dd><a target="_blank" href="/show/06dd9b2b9f09810f.htm">详细解读varchar和Nvarchar区别</a></dd><dd><a target="_blank" href="/show/aa1d1257d4d974f5.htm">SQL SERVER 2005 同步复制技术</a></dd><dd><a target="_blank" href="/show/a31ee5a6b483a72d.htm">进程未能大容量复制到表 解决方法</a></dd><dd><a target="_blank" href="/show/c096f26db222cb32.htm">MSSql实例教程:MSSql数据库同步</a></dd><dd><a target="_blank" href="/show/1b344474e99cab59.htm">SQLServer2000同步复制技术实现（分发和订阅）</a></dd><dd><a target="_blank" href="/show/131c294eb21bd79f.htm">sqlserver</a></dd><dd><a target="_blank" href="/show/4960400c7f537198.htm">SQLSERVER</a></dd><dd><a target="_blank" href="/show/882bbb04ab3b2c1f.htm">测试 sqlserver 最大用户数连接</a></dd><dd><a target="_blank" href="/show/121218045cb7032e.htm">写出一条Sql语句：取出表A中第31到第40记录（SQLServer,以自动增长的ID作为主键,注意：ID可能不是连续的</a></dd><dd><a target="_blank" href="/show/32ab4f806431a48f.htm">sqlserver2008的安装问题。</a></dd><dd><a target="_blank" href="/show/138c6021b9e4a45e.htm">为什么安装的SQL server 2008我的没有MSSQLSERVER协议啊？</a></dd><dd><a target="_blank" href="/show/d9e60316fa715602.htm">怎样把exel表里的数据复制到sqlserver表里</a></dd><dd><a target="_blank" href="/show/e2b1a07ccc72645a.htm">sqlserver数据库主键和外键问题</a></dd><dd><a target="_blank" href="/show/761bfb7fd837d775.htm">sqlserver 中的左表连接查询和右表连接查询有啥不同？有什么用？</a></dd></dl></div> </div> <div id="zykleft"> <div class="leftm"> <div id="logo"><a href="http://www.zzzyk.com/">站长资源库</a> <div class="clear"></div><script type="text/javascript" src="/js/i7f.js"></script></div> <script type="text/javascript" src="/js/sharen.js"></script><div class="clear"></div> <dl class="list"><dd><a href="/list/14_1.htm">Oracle</a></dd><dd><a href="/list/15_1.htm">MySQL</a></dd><dd><a href="/list/16_1.htm">Access</a></dd><dd><a href="/list/17_1.htm">SQLServer</a></dd><dd><a href="/list/18_1.htm">DB2</a></dd><dd><a href="/list/19_1.htm">Excel</a></dd><dd><a href="/list/22_1.htm">SQLite</a></dd><dd><a href="/list/63_1.htm">SYBASE</a></dd><dd><a href="/list/68_1.htm">Postgres</a></dd></dl><dl class="notice">如果你遇到<a href="/database.htm">数据库</a>难题：<br/>请访问www.zzzyk.com 试试</dl> </div> <div class="leftm"><dl><dt><script type="text/javascript" src="/js/s5.js"></script></dt></dl></div> <div class="leftm"><dl><dt><script type="text/javascript" src="/js/s6.js"></script></dt></dl></div> </div></div> <div class="clear"></div> <div class="bdshare"> <script type="text/javascript" src="/js/share.js"></script> </div> <div class="clear"></div> <div class="foot">CopyRight © 2012 站长网 编程知识问答 <a href="http://www.zzzyk.com">www.zzzyk.com</a> All Rights Reserved<br/>部份技术文章来自网络，<script type="text/javascript" src="/images/my.js"></script> </div> </body> </html>
关于shared pool的深入探讨(四)
link:http://www.eygle.com/internal/shared_pool-4.htm我们进一步来讨论一下shared pool的处理:先进行相应查询，获得测试数据:代码:
[oracle@jumper udump]$ sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.3.0 - Production on Thu Aug 26 10:21:54 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production SQL> connect eygle/eygle Connected. SQL> create table emp as select * from scott.emp; Table created. SQL> SQL> connect / as sysdba Connected. SQL> startup force; ORACLE instance started. Total System Global Area 47256168 bytes Fixed Size 451176 bytes Variable Size 29360128 bytes Database Buffers 16777216 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> set linesize 120 SQL> connect scott/tiger Connected. SQL> select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 17-DEC-80 800 20 8888 EYGLE MANAGER 11-AUG-04 9999 10 10 7566 JONES MANAGER 7839 02-APR-81 2975 20 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 10 11 rows selected. SQL> connect eygle/eygle Connected. SQL> select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 17-DEC-80 800 20 8888 EYGLE MANAGER 11-AUG-04 9999 10 10 7566 JONES MANAGER 7839 02-APR-81 2975 20 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 </pre><p>上一个：<a href="/show/1b7ba2379b3b4fe1.htm">将DW数据窗口导出为EXCEL文件的方法（整理）</a><br/>下一个：<a href="/show/8ee6129ad4d8d84a.htm">关于XML for Analysis Provider</a></p><div class="piclist">更多图片编程知识:<ul><li><a href="/show/0df69cb99c2164b5.htm"><img src='/upload/2013111613/2011012108543454.jpg' width=105 height=105><br/>PHP+MySQL+jQuery实现发布微博程序</a></li><li><a href="/show/ac4a4aca50821e59.htm"><img src='/upload/2013111619/20130529091923190.png' width=105 height=105><br/>SQL将datetime转化为字符串并截取字符串</a></li><li><a href="/show/fd74c01a41784d4e.htm"><img src='/upload/20121014/2012072709020611r2pwapxewz5.png' width=105 height=105><br/>SQL Server中使用Linkserver连接Oracle的方法</a></li><li><a href="/show/e84e3ff7ce18573c.htm"><img src='/upload/2013111619/20130121113039594.jpg' width=105 height=105><br/>PostgreSQL使用with一例</a></li><li><a href="/show/3b8a7e49b013b1f2.htm"><img src='/upload/20130915/20130316062727531.jpg' width=105 height=105><br/>MSSQL Sqlerver 2005的安装配置图解</a></li><li><a href="/show/4fdecb1713a6cd18.htm"><img src='/upload/2013111619/20130913115357409.jpg' width=105 height=105><br/>postgresql启动错误</a></li></ul></div></div> <div class="zykmore"><script type="text/javascript" src="/js/s4.js"></script></div><div class="more"><dl><dt>更多<a href="/list/17_1.htm">SQLServer</a>疑问解答：</dt><dd><a target="_blank" href="/show/cddfccc1916d8a6e.htm">配置MSSQL复制指定快照文件夹提示：不是有效的路径或文件名</a></dd><dd><a target="_blank" href="/show/06dd9b2b9f09810f.htm">详细解读varchar和Nvarchar区别</a></dd><dd><a target="_blank" href="/show/aa1d1257d4d974f5.htm">SQL SERVER 2005 同步复制技术</a></dd><dd><a target="_blank" href="/show/a31ee5a6b483a72d.htm">进程未能大容量复制到表 解决方法</a></dd><dd><a target="_blank" href="/show/c096f26db222cb32.htm">MSSql实例教程:MSSql数据库同步</a></dd><dd><a target="_blank" href="/show/1b344474e99cab59.htm">SQLServer2000同步复制技术实现（分发和订阅）</a></dd><dd><a target="_blank" href="/show/131c294eb21bd79f.htm">sqlserver</a></dd><dd><a target="_blank" href="/show/4960400c7f537198.htm">SQLSERVER</a></dd><dd><a target="_blank" href="/show/882bbb04ab3b2c1f.htm">测试 sqlserver 最大用户数连接</a></dd><dd><a target="_blank" href="/show/121218045cb7032e.htm">写出一条Sql语句：取出表A中第31到第40记录（SQLServer,以自动增长的ID作为主键,注意：ID可能不是连续的</a></dd><dd><a target="_blank" href="/show/32ab4f806431a48f.htm">sqlserver2008的安装问题。</a></dd><dd><a target="_blank" href="/show/138c6021b9e4a45e.htm">为什么安装的SQL server 2008我的没有MSSQLSERVER协议啊？</a></dd><dd><a target="_blank" href="/show/d9e60316fa715602.htm">怎样把exel表里的数据复制到sqlserver表里</a></dd><dd><a target="_blank" href="/show/e2b1a07ccc72645a.htm">sqlserver数据库主键和外键问题</a></dd><dd><a target="_blank" href="/show/761bfb7fd837d775.htm">sqlserver 中的左表连接查询和右表连接查询有啥不同？有什么用？</a></dd></dl></div> </div> <div id="zykleft"> <div class="leftm"> <div id="logo"><a href="http://www.zzzyk.com/">站长资源库</a> <div class="clear"></div><script type="text/javascript" src="/js/i7f.js"></script></div> <script type="text/javascript" src="/js/sharen.js"></script><div class="clear"></div> <dl class="list"><dd><a href="/list/14_1.htm">Oracle</a></dd><dd><a href="/list/15_1.htm">MySQL</a></dd><dd><a href="/list/16_1.htm">Access</a></dd><dd><a href="/list/17_1.htm">SQLServer</a></dd><dd><a href="/list/18_1.htm">DB2</a></dd><dd><a href="/list/19_1.htm">Excel</a></dd><dd><a href="/list/22_1.htm">SQLite</a></dd><dd><a href="/list/63_1.htm">SYBASE</a></dd><dd><a href="/list/68_1.htm">Postgres</a></dd></dl><dl class="notice">如果你遇到<a href="/database.htm">数据库</a>难题：<br/>请访问www.zzzyk.com 试试</dl> </div> <div class="leftm"><dl><dt><script type="text/javascript" src="/js/s5.js"></script></dt></dl></div> <div class="leftm"><dl><dt><script type="text/javascript" src="/js/s6.js"></script></dt></dl></div> </div></div> <div class="clear"></div> <div class="bdshare"> <script type="text/javascript" src="/js/share.js"></script> </div> <div class="clear"></div> <div class="foot">CopyRight © 2012 站长网 编程知识问答 <a href="http://www.zzzyk.com">www.zzzyk.com</a> All Rights Reserved<br/>部份技术文章来自网络，<script type="text/javascript" src="/images/my.js"></script> </div> </body> </html>