obj stat mem leak when global temporary tables used [ID 6347725.8]

程序用到很多事务临时表,并在执行过程中导致综合入口miscellaneous快速增加,对照两个snap日志发现perm减少的大小和正好和miscellanoues增加的大小差不多,正好和
 Bug 6347725
 "obj stat mem" leak when global temporary tables used [ID 6347725.8]
的现象一致:
When using GLOBAL TEMPORARY TABLES the V$SEGSTAT entries are
not deleted by SMON due to an incorrect tablespace number
in the deletion message.
This leads to an accumulation of "obj stat memory" chunks
in the SGA which can eventually lead to an ORA-4031.
The leak shows as "obj stat mem" perm/miscellanoues space
use in the SGA.
解决办法是:
Disable object level statistics by setting either
  STATISTICS_LEVEL=BASIC
 or
  "_object_statistics"=false
 
请使用浏览器的分享功能分享到微信等