操作系统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很不好搞啊!
|