http://www.itpub.net/showthread.php?threadid=853638&pagenumber=

今天,无意中发现shared pool很大,占到4G,不知道是什么问题?

show parameter shared

hi_shared_memory_address integer 0
max_shared_servers integer 20
shared_memory_address integer 0
shared_pool_reserved_size integer 4194304
shared_pool_size integer 83886080
shared_server_sessions integer 181
shared_servers integer 1

shared_pool_size大小仅仅80M.

select * from v$version

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for 32-bit Windows: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

5 rows selected.

SELECT *
FROM (SELECT *
FROM v$sgastat
WHERE pool = 'shared pool'
ORDER BY BYTES DESC)
WHERE ROWNUM <= 5

POOL NAME BYTES
----------- -------------------------- ----------
shared pool session param values 4293530440
shared pool free memory 67550256
shared pool miscellaneous 27355660
shared pool XDB Schema Cac 3889744
shared pool library cache 3709176

5 rows selected.

发现shared pool 的session param values占用很大,目前系统运行正常,是遇到什么BUG吗?