今天打开一个trace file 的时候,发现里面有大量的“AUTO SGA: Not free ”
于是,检查SGA/内存使用情况等等,没发现任何异常,最后
发现是个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/8710/viewspace-504604/
,如需转载,请注明出处,否则将追究法律责任。