ITPub博客

首页 > 数据库 > Oracle > oracle10.2.0.2 bug "AUTO SGA: Not free

oracle10.2.0.2 bug "AUTO SGA: Not free

原创 Oracle 作者:zhulch 时间:2007-02-08 09:44:16 0 删除 编辑
.....[@more@]

今天随便打开一个trace file 的时候,发现里面有大量的“AUTO SGA: Not free ”
于是,检查SGA/内存使用情况等等,没发现任何异常,最后向METALINK 发TAR ,
发现是个BUG ,并不是因为SGA 真的不够了。


*** 2007-02-06 21:00:04.582
*** SERVICE NAME:(SYS$BACKGROUND) 2007-02-06 21:00:04.577
*** SESSION ID:(388.1) 2007-02-06 21:00:04.577
AUTO SGA: Not free 0x70000016df8dc18, 1, 1, 1
AUTO SGA: Not free 0x70000016df8dc18, 1, 1, 1
AUTO SGA: Not free 0x70000016df8dd18, 1, 1, 1
AUTO SGA: Not free 0x70000016df8de18, 1, 1, 1
AUTO SGA: Not free 0x70000016df8df18, 1, 1, 1
AUTO SGA: Not free 0x70000016df8e018, 1, 1, 1
AUTO SGA: Not free 0x70000016df8e118, 1, 1, 1
AUTO SGA: Not free 0x70000016df8e218, 1, 1, 1
AUTO SGA: Not free 0x70000016df8e318, 1, 1, 1
AUTO SGA: Not free 0x70000016df8e418, 1, 1, 1

This is due to Bug 5201883 - UNEXPLAINED MMAN TRACE FILE in 10.2.0.2 and 10.2.0.3

CAUSE JUSTIFICATION
===================
Bug 5201883 - UNEXPLAINED MMAN TRACE FILE in 10.2.0.2 and 10.2.0.3

PROPOSED SOLUTION(S)
====================
Please apply the patch for Bug 5201883 - UNEXPLAINED MMAN TRACE FILE in 10.2.0.2 and 10.2.0.3 by downloading it fro metalink.

PROPOSED SOLUTION JUSTIFICATION(S)
==================================
This is due to bug. This does not indicate that SGA is insufficient. As such these
errors can be ignored.

SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps::
Please apply the patch for Bug 5201883

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

请登录后发表评论 登录
全部评论
  • 博文量
    554
  • 访问量
    2318282