Thomas Zhang的杂货铺
18 05, 2008
遭遇memory leak bug
作者 tomszrp 17:30 | Permalink 静态链接网址 | Comments 最新回复 (0) | Trackback 引用 (0) | 磨刀石
操作系统aix 5305,Oracle 10.2.0.2

Bug: 5548510 
REPORTED: 10.2.0.2 
FIXED:10.2.0.4 and 11.x 
NOTES:Backports Available CBO leak. 
DETAILS: The allocation in the SGA for fix control will grow with each new session. 
         You will see this running: select * from v$sgastat where name like 'qksbg%'.

SQL> select * from v$sgastat where pool='shared pool' order by bytes;

POOL         NAME                            BYTES
------------ -------------------------- ----------
shared pool  kscdnfyglobalflags                  8
shared pool  qksbgsg                             8
shared pool  kscdnfyinitflags                    8
......
shared pool  KGLS heap                    36760288
shared pool  PCursor                      44117240
shared pool  library cache                48749632
shared pool  CCursor                      71147656
shared pool  sql area                    295314376
shared pool  free memory                 323258728
shared pool  qksbgCreateSessionEnv:qks  2422252024

590 rows selected.
SQL>

各种状态chunk的分布:

CLASS           NUM        SIZ AVG SIZE
-------- ---------- ---------- ------------
R-freea         410      19680         .05k
freeabl      203754  403504152        1.93k
recr         131365  143609304        1.07k
R-free          205  309804200    1,475.82k
perm          63556 2582330752       39.68k
free              3      43152       14.05k

其中perm一项不停的涨,最终会导致ORA-04031出现.
TNND,折磨死了,没有服务的Oracle Support很不好搞啊!

Comments
发表评论
标题:


称呼:


邮箱地址(可选):


个人主页(可选):


发表评论:
Bold Italic Link authimage




博客日历
« 七月 2008 »
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31      
搜索
最新发表
文章分类
文章归档
网站链接
新闻聚合