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.
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
use in the SGA.
解决办法是：
Disable object level statistics by setting either
STATISTICS_LEVEL=BASIC
or
"_object_statistics"=false
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16158219/viewspace-662736/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ORA-01190或1189的处理过程
下一篇：
后台回滚的表是否能truncate
请登录后发表评论
登录
全部评论
最新文章
- 10.2和以上版本的pga动态工作区管理
- database records an archived log in the control file
- When RMAN Performs Control File Autobackups
- Planning an Incremental Backup Strategy
- Multiple Copies of RMAN Backups
- 关于flashback log
- maximum control file size？？
- Renaming a Datafile in the Primary Database
- Duplicate Database fails with Rman-5001 [ID 334588.1]
- Oracle backup fails with error RMAN-06056: could not access datafile
