ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle10g_oracle11g_library cache_shared pool管理方面的小区别

oracle10g_oracle11g_library cache_shared pool管理方面的小区别

原创 Linux操作系统 作者:wisdomone1 时间:2013-04-24 20:27:39 0 删除 编辑

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> select addr,name from v$latch where name like '%library%';

ADDR     NAME
-------- --------------------------------------------------
03C4D3B8 library cache pin allocation
03C4D420 library cache lock allocation
03C4D4F0 library cache hash chains
03C4D2E8 library cache lock
03C4D280 library cache
03C4D350 library cache pin
03C4D488 library cache load lock

7 rows selected.

SQL> select addr,name from v$latch where name like '%shar%';

ADDR     NAME
-------- --------------------------------------------------
03C4D218 shared pool
03C4E3D0 shared server configuration
03C4E640 shared server info

 

 

 

 

 


SQL> select * from v$version;
 
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
 
SQL> select addr,name from v$latch where name like '%library%';
 
ADDR             NAME
---------------- ----------------------------------------------------------------
000000000823ACF0 library cache load lock

SQL> select addr,name from v$latch where name like '%shared%';
 
ADDR             NAME
---------------- ----------------------------------------------------------------
0000000008216F50 test shared non-parent l0
000000000821BFE0 ksxp shared latch
00000000082323E0 kcfis stats shared latch
000000000823AC50 shared pool
000000000823B650 shared pool simulator
000000000823B6F0 shared pool sim alloc
000000000823CED0 shared server configuration
000000000823D290 shared server info
 
8 rows selected

 

---可知10g和11g在library cache方面变化很大的
   在共享池管理方面也有很大的变化,11g更加细化了latch

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-759217/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb 工作经历: 中国普天 北京科蓝 北京云和恩墨 北京神州新桥

注册时间:2008-04-04

  • 博文量
    2189
  • 访问量
    12685658