ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 9i2 ? shared pool 巨大?

oracle 9i2 ? shared pool 巨大?

原创 Linux操作系统 作者:lfree 时间:2007-09-16 00:00:00 0 删除 编辑

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吗?


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

上一篇: 函数lnnvl
请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    2284
  • 访问量
    6023352