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/ ,如需转载,请注明出处,否则将追究法律责任。