oracle10g_oracle11g_library cache_shared pool管理方面的小區別

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