请问shared pool里面是什么关系？

显示全部楼层 · 2012-8-24 17:06:04

SQL> select * from v$sgastat where name = 'library cache';
POOL NAME
BYTES
------------ -------------------------- ----------
shared poollibrary cache
3848632
SQL> select * from v$sgastat where name = 'row cache';
POOL NAME
BYTES
------------ -------------------------- ----------
shared poolrow cache
3741868
SQL> select * from v$sgastat where pool = 'shared pool' and name = 'free memory';
POOL NAME
BYTES
------------ -------------------------- ----------
shared poolfree memory
8674196
SQL> select component,current_size from v$sga_dynamic_components;
COMPONENT
CURRENT_SIZE
---------------------------------------------------------------- ------------
shared pool
67108864
large pool
4194304
java pool
4194304
为什么library cache， row cache，free memory 这三部分的和不等于shared pool 的值呢？他们是什么关系？

千问 · 2012-8-24 17:06:04

select sum(bytes) from v$sgastat where pool = 'shared pool ';
这个就一样了

千问 · 2012-8-24 17:06:04

本帖最后由 gyj_hobby 于 2012-12-12 19:42 编辑
shared pool 包括了library cache， row cache，free memory ，还有其它一些组件。。。。这三个只是主要的三大块而已
SQL> select * from v$version where rownum=1;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
SQL> select count(*) from v$sgastat where pool='shared pool';
COUNT(*)
----------
887
11G版本有这么800多个组件

千问 · 2012-8-24 17:06:04

T-McGrady1 发表于 2012-12-12 16:58
select sum(bytes) from v$sgastat where pool = 'shared pool ';
这个就一样了
SQL> select component , current_size from v$sga_dynamic_components;

COMPONENT
CURRENT_SIZE
---------------------------------------------------------------- ------------
shared pool
528482304
SQL> select sum(bytes) from v$sgastat where pool = 'shared pool';

SUM(BYTES)
----------
426333916
这是另外一个应用系统，
数值还是没能相等，请问还有100多M内存用在了什么地方呢？